Skip site navigation (1) Skip section navigation (2)

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

From: Jeff Hubbach <Jeff(dot)Hubbach(at)cha(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Date: 2010-10-01 22:30:34
Message-ID: 7AF25C2B-8ED4-4204-BC31-CE0C9DBB72EC@cha.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
You might want to check ANSI SQL 99 and update your rant regarding there being no boolean in ANSI SQL.

Where do you get the impression that boolean is treated as a char? Just because it doesn't handle an implicit cast from a shortint?

You have been given some very good suggestions as to how your application can support the way PostgreSQL and the jdbc driver work. The other option that has been given to you is to patch the jdbc driver code to handle the implicit cast you desire. One of the beauties of open source is that if you want the code to do something it doesn't currently do, you can make that modification yourself.

I humbly recommend you take some of these potential suggestions to your engineers who are actually writing the code. They might understand the complexity or simplicity of each suggestion on a level which you do not.

-- Jeff Hubbach

pgsql-jdbc by date

Next:From: Jeff HubbachDate: 2010-10-01 22:31:17
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous:From: stagirusDate: 2010-10-01 22:17:19
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group