Thread: CachedRowSet insertion problem with serial PK

hi,

I'm tring postgresql-8.1-407.jdbc3.jar (with PG 7.4.3 srv) and
CachedRowSet (Sun implementation).

I have a small test table: it has two fields:
1) id  SERIAL NOT NULL PRIMARY KEY
2) info VARCHAR(100)


I try this java code:

    CachedRowSet rs;
    ...
    rs.setCommand("select id,info from a WHERE id<?");
    rs.setInt(1, 10);
    ...
    rs.moveToInsertRow();
    rs.setString(2, "zzzz2");
    rs.insertRow();

but I obtain this error:
"SQLException: Failed on insert row" (generated from the insertRow()
line).

I sniffed the network-connection betweend DB-srv and JDBC-client, and
I noted that
the INSERT instruction isn't fired against the DB.  If I ask if
"isAutoIncrement(<id_idx>)"
I obtain a true reply.

Any idea?

TIA
Roberto Colmegna






La gara più entusiasmante dell'anno!

Gioca e corri alla velocità della luce sui 18 circuiti di Intel Speed Contest 2006!

I più bravi vincono Notebook Sony VAIO, iPod da 60 GB e altro ancora...

Sfida gli amici!

http://intelspeedcontest2006.tiscali.it/

rcolmegna@tiscali.it wrote:

>     CachedRowSet rs;
>     ...
>     rs.setCommand("select id,info from a WHERE id<?");
>     rs.setInt(1, 10);
>     ...
>     rs.moveToInsertRow();
>     rs.setString(2, "zzzz2");
>     rs.insertRow();
>
> but I obtain this error:
> "SQLException: Failed on insert row" (generated from the insertRow()
> line).

Can you work out what the real exception thrown by the driver is? It is
hard to diagnose this without knowing what is happening at the low-level
JDBC API level.

-O