Re: Error while retrieving generated keys - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Error while retrieving generated keys
Date
Msg-id 84E14102-5D12-4A77-8FAF-05AD74992DF1@fastcrypt.com
Whole thread Raw
In response to Error while retrieving generated keys  ("Gary Greenberg" <gary@icontrol.com>)
List pgsql-jdbc
Gary,

Check the list archives please, we have just had this discussion at length very recently.

The short version is that it is not currently implemented.

Dave
On 8-Mar-07, at 10:49 PM, Gary Greenberg wrote:

My application trew the following exception:

 

org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.

        at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:352)

        at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:394)

        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:370)

 

I am using 8.2-504.jdbc3 driver with the PostgreSql 8.0.8 on SUSE Linux.

I have not seen anywhere in the documentation that this standard JDBC3 feature is not supported.

Can anyone explain it to me, please.



pgsql-jdbc by date:

Previous
From: Giuseppe Sacco
Date:
Subject: [OT] Re: Transaction atomicity
Next
From: "Gary Greenberg"
Date:
Subject: Re: Error while retrieving generated keys