Re: Problem with updateRow() - Mailing list pgsql-jdbc

From David Hooker
Subject Re: Problem with updateRow()
Date
Msg-id DD840B0E9362D411978200508BD898E0017C81F0@btcorp2.corp.btrade.com
Whole thread Raw
In response to Problem with updateRow()  ("David Hooker" <dhooker@bTrade.com>)
Responses Re: Problem with updateRow()
List 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@postgresql.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

pgsql-jdbc by date:

Previous
From: "David Hooker"
Date:
Subject: Problem with updateRow()
Next
From: Dave Cramer
Date:
Subject: Re: Problem with updateRow()