Re: CachedRowSet insertion problem with serial PK - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: CachedRowSet insertion problem with serial PK
Date
Msg-id 44805D7E.4010706@opencloud.com
Whole thread Raw
In response to CachedRowSet insertion problem with serial PK  ("rcolmegna@tiscali.it" <rcolmegna@tiscali.it>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: "rcolmegna@tiscali.it"
Date:
Subject: CachedRowSet insertion problem with serial PK
Next
From: Marc Herbert
Date:
Subject: Re: UTF8