Re: Error while retrieving generated keys

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Gary Greenberg <gary(at)icontrol(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Error while retrieving generated keys
Date: 2007-03-09 12:00:55
Message-ID: 84E14102-5D12-4A77-8FAF-05AD74992DF1@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gary Greenberg 2007-03-09 18:36:35 Re: Error while retrieving generated keys
Previous Message QuanZongliang 2007-03-09 04:48:08 Re: Error while retrieving generated keys