Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

From: stagirus <mamasa(at)stagirus(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Date: 2010-09-27 17:08:52
Message-ID: 1285607332343-2855614.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc


Kevin's response above seems to be very promising.
>From your comments/observations, are you saying that there could be some
coding issues regarding these conversions between boolean and integers?

Reg your question of "What kinds of values do you see in the SMALLINT column
when you set a TRUE into a SMALLINT column? 1? -1?"
: Nothing. Because it fails before any inserts or updates happen. We
discussed the error above.

Because I have not worked with the internals of Hibernate/JDBC drivers, I
cannot definitively state if Hibernate is calling setters and getters
(setBoolean) using prepared statements or directly executes INSERT/UPDATE
statements. Anything is possible.

Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Re-BUGS-Mapping-Hibernate-boolean-to-smallint-Postgresql-tp2855367p2855614.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2010-09-27 17:11:09 Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous Message Robert Haas 2010-09-27 17:08:45 Re: BUG #5650: Postgres service showing as stopped when in fact it is running

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kevin Grittner 2010-09-27 17:11:09 Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous Message Kevin Grittner 2010-09-27 16:30:35 Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)