Boolean mapping

Florian206 · **Joined:** Thu Aug 25, 2005 8:04 am **Posts:** 3

Hibernate version: 3.05

Name and version of the database you are using: SQL-Server but should run anywhere

Hi all,

I am new to hibernate.
Have a table with a column 'is_user' of type SMALLINT, is there any way to map this to a java boolean/Boolean?

Thanks for answer or link (didn't find one so far)

sven · **Posted:** Thu Aug 25, 2005 8:44 am

Try this:

Code:

<property name="isUser" type="boolean">
    <column name="is_user" sql-type="smallint"/>
</property>

See the documentation for more information about sql-type.
http://www.hibernate.org/hib_docs/v3/re ... guide-s1-2

Best regards
Sven

mjstein6300 · **Joined:** Tue Jun 28, 2005 4:33 pm **Posts:** 21

I had a similar situation where our objects had Booleans, but the database was expecting a single character. We wrote a custom UserType and it solved the problem.

Sorry I don't have the exact link right now, but if you search the forum you should find some good examples on writing one.

Rilux · **Posted:** Thu Aug 25, 2005 9:04 am

Depending on your DBMS you want something like this in your Hibernate config file (MySQL example):

Code:

<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>