Postgres Pro
Downloads
Home   >   mailing lists

Error while retrieving generated keys - Mailing list pgsql-jdbc

From Gary Greenberg
Subject Error while retrieving generated keys
Date
Msg-id 029901c761fd$feb196e0$740a3c0a@D9GKB4C1
Whole thread Raw
Responses Re: Error while retrieving generated keys  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view

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: Dave Cramer
Date:
Subject: Re: Inserting "null" not working (Sun App Server, Postgres, EJB3)?
Next
From: QuanZongliang
Date:
Subject: Re: Error while retrieving generated keys