I'm new to hibernate and I have got a problem with mapping (actually creating) a boolean class attribute to a boolean database attribute.

Class Attribute looks like:



corrsponding mapping property is:



Hibernate creates this attribute as a "bit" type in my Postgres database and so I get an error message if I want to set the value to false or true.

I already tried to set but it still creates a bit type.

Any ideas howto create a bool type?

1) What version of Hibernate are you using?
2) Why do you name your property isAdmin? Name it admin and provide an appropriate getter and setter - javabean style:



3) Your mapping should look something like:



4) Please post you hibernate.cfg.xml file if the problem persists

1.) Im using Hibernate 2.1.7
2.) Why not naming it like that? However ... I have getters and setters for that attribute

3.) mapping looks the same except the optional settings

4.) Im using Spring

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName"><value>org.postgresql.Driver</value></property>
<property name="url"><value>jdbc:postgresql://centrino/testapp</value></property>
<property name="username"><value>admin</value></property>
<property name="password"><value>xxx</value></property>
</bean>

<!-- Hibernate SessionFactory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
<property name="dataSource"><ref local="dataSource"/></property>
<property name="mappingResources">
<list>
<value>testapp/model/User.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">net.sf.hibernate.dialect.HSQLDialect</prop>
<prop key="hibernate.hbm2ddl.auto">create</prop>
</props>
</property>
</bean>

Why are you using HSQL dialect with Postgres?

Your dialect in your config file should be: