[JDBC] InsertRow problem with Serial

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/

In response to

Browse pgsql-admin by date

  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