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

2010-09-25 Thread stagirus
As a fundamental protocol, I prefer to keep any "attitudes" and "finger-pointing" off the table. Let us just focus on the real problem-solving. Though I am very versatile in speaking languages like C, C++ and Java, I assumed we all can speak and understand "English." You can also clearly see the

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

2010-09-24 Thread Dean Rasheed
>> 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

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

2010-09-24 Thread Craig Ringer
On 09/25/2010 05:33 AM, stagirus wrote: > Good afternoon. I am the Chief Architect, with 19 years of experience > in the software industry Without meaning to sound excessively grumpy, I'm surprised that those 19 years didn't teach you to provide detailed error messages, in-depth description, a

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

2010-09-24 Thread Kevin Grittner
[Moving the discussion to the PostgreSQL JDBC list, with a blind copy to bugs. This doesn't sound to me like a bug, per se, but an extension to the JDBC driver which may be a convenience to some users. We're more likely to get the attention of the right group of people on the JDBC list.] stagir

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

2010-09-24 Thread stagirus
Thank you for your quick response. As I stated above, we directly do not call any JDBC API, not any more. It is all done by Hibernate OR mapping. The above solution (Hibernate mapping) worked fine with Oracle JDBC drivers, for a long time. I believe Hibernate might be mapping, or calling the appro

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

2010-09-24 Thread Kevin Grittner
stagirus wrote: > JDBC driver does not convert boolean value (false/true) to > integers (0/1). Can you mention which methods of which classes you would expect to do this? -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www

[BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-24 Thread stagirus
Good afternoon. I am the Chief Architect, with 19 years of experience in the software industry, for an enterprise software product. I am requesting your help to better understand or resolve the following issue. Our architecture is based on Spring and Hibernate. The product is required to support