BUG #8389: JDBC Driver assumes first column to be an integer

From: ivan(dot)pli(at)solidit(dot)cl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8389: JDBC Driver assumes first column to be an integer
Date: 2013-08-20 00:50:27
Message-ID: E1VBa9T-0004Wt-AG@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8389
Logged by: Ivan Pliouchtchai
Email address: ivan(dot)pli(at)solidit(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergey Konoplev 2013-08-20 05:48:39 Re: Completely broken replica after PANIC: WAL contains references to invalid pages
Previous Message Alvaro Herrera 2013-08-19 16:57:44 Re: [BUGS] 9.3beta2: Failure to pg_upgrade