Possible bug / regression from generated keys

From: Peter Cooner <petriborg(at)gmail(dot)com>
To: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Possible bug / regression from generated keys
Date: 2012-11-07 15:19:02
Message-ID: CAHVZnpFRa2qp8s_=42MV8s6p1=3W6A-K0bv+XgO=JtfmTHrAzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Summary:
I'm getting an exception from the ResultSet returned from
getGeneratedKey() from a batch insert PreparedStatement. When I use
any of the postgresql-9.2-100X.jdbc4.jar drivers I get exceptions, but
when I use postgresql-9.1-902.jdbc4.jar it works.

Has anyone seen anything like this? How can I debug this problem
further? How should I go about determining if this is a bug?

Exception:
java.lang.ArrayIndexOutOfBoundsException: 4
at org.postgresql.util.ByteConverter.int8(ByteConverter.java:29)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2150)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.internalGetObject(AbstractJdbc2ResultSet.java:142)
at org.postgresql.jdbc3.AbstractJdbc3ResultSet.internalGetObject(AbstractJdbc3ResultSet.java:36)
at org.postgresql.jdbc4.AbstractJdbc4ResultSet.internalGetObject(AbstractJdbc4ResultSet.java:296)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:2703)
...

Usually followed later by this exception:
org.postgresql.util.PSQLException: Bad value for type long : ,
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2971)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2163)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.internalGetObject(AbstractJdbc2ResultSet.java:142)
at org.postgresql.jdbc3.AbstractJdbc3ResultSet.internalGetObject(AbstractJdbc3ResultSet.java:36)
at org.postgresql.jdbc4.AbstractJdbc4ResultSet.internalGetObject(AbstractJdbc4ResultSet.java:296)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:2703)
...

Setup:
OS: Ubuntu 10.04
PG: 9.2
JDBC: postgresql-9.2-1001.jdbc4.jar

I'm also using PostGIS 2.0.1 jar, Apache Commons DBUtils, and DBCP.

I *believe* that it must have something to do with concurrent database
connections or connection reuse, but I haven't been successful at
creating a test case, despite trying for several days now.

Suggestions? I've got a mountain of data - if anyone needs more details.

--
Pete

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message dmp 2012-11-07 16:58:02 Re: Possible bug / regression from generated keys
Previous Message Craig Ringer 2012-11-05 03:34:00 Re: Misspelling in error message