Error while retrieving generated keys

From: "Gary Greenberg" <gary(at)icontrol(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Error while retrieving generated keys
Date: 2007-03-09 03:49:52
Message-ID: 029901c761fd$feb196e0$740a3c0a@D9GKB4C1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

My application trew the following exception:

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

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

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

at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepare
Statement(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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message QuanZongliang 2007-03-09 04:48:08 Re: Error while retrieving generated keys
Previous Message Dave Cramer 2007-03-08 17:39:29 Re: Inserting "null" not working (Sun App Server, Postgres, EJB3)?