Re: CachedRowSet insertion problem with serial PK

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