On Wed, Mar 23, 2011 at 7:35 PM, sdavidr <david.ricoma@gmail.com> wrote:
> Hi,
>
> I have a problem with Hibernate's "single tables" and the last postgres
> jdbc driver. It seems that now it includes a returning * when there is an
> Insert, instead of a returning [identifier] that seems more cleaner and
> doesn't return all the fields. There is a reason for that? and there
> expectatives to change that?
>
> Because of the "returning *", crash when there is an Insert in a table with
> a String type discriminator, returning this :
>
> Caused by: org.postgresql.util.PSQLException: Bad value for type long :
> NACIONAL
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2019)
> at
> org.hibernate.id.IdentifierGeneratorHelper.get(IdentifierGeneratorHelper.java:114)
> at
> org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:86)
> at
> org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:98)
> at
> org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
>
> Thanks for any feedback!
I just had a look at the 8.4 driver and it returns * as well. Can you
give us a concrete example to see what is going on ?
Dave
www.credativ.ca