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 [email protected]
Whole thread Raw
In response to CachedRowSet insertion problem with serial PK  ("[email protected]" <[email protected]>)
List pgsql-jdbc
[email protected] 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: "[email protected]"
Date:
Subject: CachedRowSet insertion problem with serial PK
Next
From: Marc Herbert
Date:
Subject: Re: UTF8