R: Re: CachedRowSet insertion problem with serial PK

Hi,

I noticed that I have committed an error: the excpetion isn't raised
from JDBC
driver but from CacheRowSetImpl. I will send a post to sun-maillist.

Exception in thread "main" java.sql.SQLException: Failed on insert row
at com.sun.rowset.CachedRowSetImpl.insertRow(CachedRowSetImpl.
java:5440)
at CachedRowSetDemo.test(CachedRowSetDemo.java:78)
at CachedRowSetDemo.main(CachedRowSetDemo.java:90)

TIA
Roberto Colmegna

---- Messaggio originale ----
Data: Fri Jun 02 17:47:10 CEST 2006
Da: Oliver Jowett<oliver(at)opencloud(dot)com>
A: rcolmegna(at)tiscali(dot)it<rcolmegna(at)tiscali(dot)it>
Cc: pgsql-jdbc(at)postgresql(dot)org
Ccn:
Ogg.: Re: [JDBC] CachedRowSet insertion problem with serial PK

rcolmegna(at)tiscali(dot)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

---------------------------(end of broadcast)
---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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/