bug in jdbc

From: luvar(at)plaintext(dot)sk
To: pgsql-jdbc(at)postgresql(dot)org
Subject: bug in jdbc
Date: 2011-09-03 17:16:30
Message-ID: 381613887.6661315070190151.JavaMail.root@shiva
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi, I have executed some update query and I have requested to return generated id...

statement.executeUpdate(query, Statement.RETURN_GENERATED_KEYS);
ResultSet ids = statement.getGeneratedKeys();
ids.next();
ids.getInt(1);

It will fail with this exception:

19:03:50,300 WARN ObjectBrowser:254 - Bad value for type int : /home/luvar/output.svg
org.postgresql.util.PSQLException: Bad value for type int : /home/luvar/output.svg
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2759)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2003)
.....

I am using maven. Used jdbc version:

<dependency>
<groupId>postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>9.0-801.jdbc4</version>
</dependency>

I have table constructed in such way, that id (bigserial typed) column is NOT first column. It is second and first column of my table is "url" column to which I try insert "/home/luvar/output.svg" value.

Can you have a look and confirm this bug to me, or there is no bug and something I am doing bad?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message dmp 2011-09-04 16:31:00 Re: bug in jdbc
Previous Message ml-tb 2011-09-03 13:47:42 Re: Problem with sql ant task