Hi,
I map a Oracle NUMBER(1) column to a Java long field with

<property name="inactivityNotificationSend" type="long">
<column name="INACTIVITY_NOTIFICATION_SEND" />
</property>

If INACTIVITY_NOTIFICATION_SEND has a value in the database, everything works okay.

If the column is null in the database, the following execption appears.

org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of Users.setInactivityNotificationSend
at org.hibernate.tuple.PojoTuplizer.setPropertyValuesWithOptimizer(PojoTuplizer.java:203)
at org.hibernate.tuple.PojoTuplizer.setPropertyValues(PojoTuplizer.java:173)

Is there a solution for this problem ?

Regards

yes, use Long in your java class.

hibernate tries to call you setter method with a Null as an argument:

setInactivityNotificationSend( long val );

This certainly does not work.
You can map it like this:



Or you can write a property accessor which does it.
Look at org.hibernate.property.BasicPropertyAccessor.

Another possibility are UserTypes.

fyi: long or java.lang.Long in the mapping files does not make any runtime difference - hibernate treat it equally. The only thing that can prevent it is if you property is actually a long and not a java.lang.Long.

Thanks for the quick response.

Changing type="long" to type="java.lang.Long" fixed the problem.

By the way ; I used the myeclipse tool for Eclipse to generate the Hibernate mappings. After switching from "Hibernate types" to "Java types" everything works fine.

Regards

yes, the myeclipse tools is using an (older) version of hibernate tools so this is the expected behavior.