| 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: | Whole Thread | Raw Message | 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?
| 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 |