SAPDB: mapping boolean values

aldan · **Joined:** Tue Nov 07, 2006 5:29 pm **Posts:** 3

Hello!

I am using hibernate3 and Spring 2.0 for a webapplication. The Database used for ORM purposes is MAXDB / SAPDB 7.6.0

I have one big problem when I try to retrieve objects with HQL. All boolean values are converted to 1 (true) and 0 (false) when I try to execute a hql statement - Finder-Method e.g.:

Code:

from User where active = true

Hibernate transforms this to:

Code:

SELECT * FROM user where active = 1

The Version of MAXDB / SAPDB runs in the internal mode (not oracle mode or something else). MAXDB requires true and false but not 1 and 0.

I tried to add the following (in several variations) to my hibernate-config:

Code:

<prop key="hibernate.query.substitutions">true=true,false=false</prop>

It didn`t help. Has anybody had the same problem and found a solution?

Thank`s a lot.

Greetings

Alex

scarface · **Joined:** Sun Jun 04, 2006 1:58 am **Posts:** 136

try creating your own dialect

may be subclassing
http://www.hibernate.org/hib_docs/v3/api/org/hibernate/dialect/SAPDBDialect.html

and override toBooleanValueString