Re: Problem with updateRow()

From: "David Hooker" <dhooker(at)bTrade(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Problem with updateRow()
Date: 2003-03-20 00:58:43
Message-ID: DD840B0E9362D411978200508BD898E0017C81F0@btcorp2.corp.btrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-03-20 01:19:26 Re: Problem with updateRow()
Previous Message David Hooker 2003-03-20 00:54:50 Problem with updateRow()