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

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-10-01 22:17:19
Message-ID: 1285971439496-3073409.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-jdbc
>>I still don't understand why you won't fix your application code to use
Hibernate how it's designed to be used. You're using half of Hibernate's..

If it was a simple thing on our application side, why would I be wasting my
time and your time this much!

Our product is developed based on certain architectural principles. It was
all developed for the past four years. Unfortunately, your suggestions are
too invasive and not even feasible. Per our architecture, Hibernate is
simply an ORM tool. Period. Not any sort of database administration tool.
There are better tools for that job.

Your argument of boolean is not same as short in Java. Agreed. Do you
believe programing languages are same as RDBMS engines? I do not think so.

We all know there is no universal definition or support for boolean columns
(storage class as it is called) in RDBMS except in Postgresql. Check ANSI
SQL. Sorry no boolean!

So the real question to the JDBC experts as you all - how is this difference
between boolean in programming language(Java) and RDBMS/JDBC should be
resolved? I like the way other RDBMS have resolved this difference. 

Why wouldn't you (Postgresql)? 

If you observe the discussions on this topic, unfortunately Postgresql has
created the biggest incompatibility for boolean fields. You know the reasons
- you treat boolean as chars unlike everybody else (0, 1 or -1). PLEASE
LISTEN TO THE CRIES OF THE WORLD!





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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-10-02 00:07:20
Subject: Re: BUG #5688: ALTER TABLE ALTER col TYPE newtype fails if col is named in an UPDATE OF col trigger
Previous:From: Daniel GraceDate: 2010-10-01 21:47:19
Subject: BUG #5688: ALTER TABLE ALTER col TYPE newtype fails if col is named in an UPDATE OF col trigger

pgsql-jdbc by date

Next:From: Jeff HubbachDate: 2010-10-01 22:30:34
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous:From: Albert KuruczDate: 2010-10-01 20:04:39
Subject: Re: Upgrade to 9 questions

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