Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] need help of getting PK after insertRow in JDBC

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Chen, Dongdong (GE Healthcare, consultant)" <Dongdong(dot)Chen(at)ge(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] need help of getting PK after insertRow in JDBC
Date: 2008-09-26 05:39:50
Message-ID: Pine.BSO.4.64.0809260134130.24419@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc

On Fri, 26 Sep 2008, Chen, Dongdong (GE Healthcare, consultant) wrote:

>    I am a software engineer from GE. I am using JDBC to operate
> PostgreSQL8.3 in Ubuntu8.04. The develop environment is Eclipse3.2 My
> problem is:
>    There is a PostgreSQL table XX containing 5 fields: AA, BB, CC, DD,
> EE, AA is primary key and auto-generated type, BB, CC, DD and EE is
> string type.
>    I want to get the value of AA immediately after insert a row into
> the table. the code is like this:
>
>    Statement st = db.creatStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_UPDATABLE);

The JDBC driver does not implement true SCROLL_SENSITIVE cursors.  The 
driver copies the values you provide into its ResultSet and sends the 
query to the backend.  On the server the auto-generated values are filled 
in, but the JDBC driver doesn't get any notification of that.   Perhaps 
with newer server versions we can make it issue a INSERT ... RETURNING ... 
so that we get that data.

> I am not sure it is proper to send this mail to this mail list. Sorry if
> bring you any inconvenience.

Generally cross posting should be avoided and JDBC/Java questions should 
be directed to the -jdbc list, but this is a very good question and one 
that does prompt further investigation about what can be done in the JDBC 
driver to make this better.

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Amit AggarwalDate: 2008-09-29 08:32:26
Subject: Postgres Giving Errors Incomplete Startup Packet
Previous:From: Kris JurkaDate: 2008-09-26 05:15:20
Subject: Re: Newby Question - accessing refcursor.

pgsql-general by date

Next:From: Joey K.Date: 2008-09-26 06:46:00
Subject: ]OT] Database structure question
Previous:From: AndrewDate: 2008-09-26 02:18:19
Subject: Re: Oracle and Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group