| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | stagirus <mamasa(at)stagirus(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Mapping Hibernate boolean to smallint(Postgresql) |
| Date: | 2010-09-25 06:58:34 |
| Message-ID: | AANLkTi=QK==bmA9CMFztrXMT=1YEYB06YezzckKcS+7k@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
>> Now comes the "religious" discussion. The above design works well for
>> Oracle, DB2 and MySQL, etc. But PostgresQL seems to choke. It complains
>> about the data type mismatch. By reading various discussions on your
>> forum,
>> there seems to some issues with the data type mapping at the JDBC driver.
>> JDBC driver does not convert boolean value (false/true) to integers (0/1).
>
There isn't really enough information here to diagnose the problem,
but here's another guess - if it's just a problem with HQL generated
queries, perhaps you could try adding the following to your Hibernate
configuration:
<property name="hibernate.query.substitutions">true 1, false 0</property>
Regards,
Dean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | r d | 2010-09-25 10:21:39 | Postgres 9 Installation problems |
| Previous Message | Craig Ringer | 2010-09-25 06:48:34 | Re: BUG #5661: The character encoding in logfile is confusing. |