From: | "Mathias Laurent" <e1lauren(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | [JDBC] InsertRow problem with Serial |
Date: | 2006-05-18 16:43:39 |
Message-ID: | BAY112-F20F370AA8DD7A2EDF7BB09AA60@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I have a problem with the driver JDBC3,
MyTable(col1(SERIAL), col2(VARCHAR), Col3(VARCHAR))
When i do
>rs.moveToInsertRow();
>rs.updateString("col2",col2);
>rs.updateString("col3",col3);
>rs.insertRow();
>con.commit();
>rs.next();
>rs.refreshRow();
The ResulSet is not refreshed for the first column, the value for col1 is 0.
Although insertion in the base worked and the serial have the good value
!!! And this code works perfectly for MySql :(
If somebody knows when that can come from ?
Thank you,
Mathias Laurent
_________________________________________________________________
Retrouvez tout en un clin d'oeil avec la barre d'outil MSN Search !
http://desktop.msn.fr/
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2006-05-18 17:22:50 | lock a database from new connections, without modifying pg_hba.conf |
Previous Message | Warren Little | 2006-05-18 16:43:36 | Re: query optimization - mysql vs postgresql |