Re: Problem with updateRow()

Oh, I forgot to mention that I AM creating my Statement correctly I
think:

Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);

-----Original Message-----
From: David Hooker
Sent: Wednesday, March 19, 2003 6:55 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Problem with updateRow()

I'm using PostgreSQL 7.3.1 server, and the pg73jdbc2.jar file from the
website (file dated 2/13/2003 on my machine).

I have in my code a select statement like this:

String sql = "SELECT FILENAME, BOUNDARY FROM " + tableName + "
WHERE NAME = '" + name + "' AND CONTEXT = '" + context + "'";
logger.finest("SQL: " + sql);
ResultSet result = stmt.executeQuery(sql);

Later in my code I have this:

while (result.next())
{
// ...
result.updateString("BOUNDARY", event.getBoundary());
result.updateRow();
updated = true;
}

Here's the error I get:

java.sql.SQLException: No Primary Keys

Here's what the tables look like in psql:

simpletest=# \d lfs_mappings_559
Table "lfs_mappings_559"
Attribute | Type | Modifier
----------------+------------------------+----------
name | character varying(40) | not null
context | character varying(80) | not null
filename | character varying(300) | not null
boundary | character varying(50) |
insertion_time | real | not null
can_purge | character varying(8) |
Index: lfs_mappings_559_pkey

simpletest=# \d lfs_mappings_559_pkey
Index "lfs_mappings_559_pkey"
Attribute | Type
-----------+-----------------------
name | character varying(40)
context | character varying(80)
unique btree (primary key)

simpletest=#

Why is this happening? Are updateable resultSets not supported?

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org