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

"ivan(dot)pli(at)solidit(dot)cl" <ivan(dot)pli(at)solidit(dot)cl> wrote:

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

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

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

I think the behavior you are seeing is due to JBoss or Hibernate.
I've used many tables with no integer columns through PostgreSQL
JDBC.  Hibernate, by default, seems to want every table to have a
primary key of a single integer column, it but can be coerced to
work with a properly normalized relational database with a little
effort.  In my experience it's worth the effort.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company