Problem with updateRow() - Mailing list pgsql-jdbc

From David Hooker
Subject Problem with updateRow()
Date
Msg-id DD840B0E9362D411978200508BD898E0017C81EF@btcorp2.corp.btrade.com
Whole thread Raw
List pgsql-jdbc
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?


pgsql-jdbc by date:

Previous
From: Daniel Bruce Lynes
Date:
Subject: Re: JDBC driver, PGSQL 7.3.2 and accents characters
Next
From: "David Hooker"
Date:
Subject: Re: Problem with updateRow()