BUG #8389: JDBC Driver assumes first column to be an integer - Mailing list pgsql-bugs

From ivan.pli@solidit.cl
Subject BUG #8389: JDBC Driver assumes first column to be an integer
Date
Msg-id E1VBa9T-0004Wt-AG@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8389: JDBC Driver assumes first column to be an integer
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8389
Logged by:          Ivan Pliouchtchai
Email address:      ivan.pli@solidit.cl
PostgreSQL version: 9.2.4
Operating system:   Windows 7
Description:

PRECONDITION:
When having a table with the next columns:
content varchar(10)
idcontent int primary key


ACTION:
Persisting a row using the JDBC driver (I used JBoss and hibernate to
persist a bean)




RESULT:
The JDBC driver throws an exception while trying to parse the first column
content (a string) as an integer.


Anyway the content gets saved to the database.


TEMPORARY SOLUTION:
Recreating the table with the integer key column as the first column solved
the problem.

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG 5199:ERROR: cannot override frame clause of window xx
Next
From: nitishsaurabh
Date:
Subject: Re: BUG #8387: Error while make of the source code