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

From Kevin Grittner
Subject Re: BUG #8389: JDBC Driver assumes first column to be an integer
Date
Msg-id 1377025343.62060.YahooMailNeo@web162901.mail.bf1.yahoo.com
Whole thread Raw
In response to BUG #8389: JDBC Driver assumes first column to be an integer  (ivan.pli@solidit.cl)
List pgsql-bugs
"ivan.pli@solidit.cl" <ivan.pli@solidit.cl> wrote:=0A=0A> When having a tab=
le with the next columns:=0A> content varchar(10)=0A> idcontent int primary=
 key=0A=0A> Persisting a row using the JDBC driver (I used JBoss and=0A> hi=
bernate to persist a bean)=0A=0A> The JDBC driver throws an exception while=
 trying to parse the=0A> first column content (a string) as an integer.=0A=
=0AI think the behavior you are seeing is due to JBoss or Hibernate. =0AI'v=
e used many tables with no integer columns through PostgreSQL=0AJDBC.=A0 Hi=
bernate, by default, seems to want every table to have a=0Aprimary key of a=
 single integer column, it but can be coerced to=0Awork with a properly nor=
malized relational database with a little=0Aeffort.=A0 In my experience it'=
s worth the effort.=0A=0A--=0AKevin Grittner=0AEDB: http://www.enterprisedb=
.com=0AThe Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: nitishsaurabh
Date:
Subject: Re: BUG #8387: Error while make of the source code
Next
From: Fernando Ewald
Date:
Subject: Dúvida