Hi all,

I have a column in a table which can have values Y, N or null. I tried to map it to a Hibernate yes_no type, but I am getting an exception when reading a null value. Does anybody know if it is possible for a yes_no property to be mapped by default to false in its corresponding POJO field when reading a null value for the column?

The exception is:

exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.vinoteca.concilia.Cuenta.setIndPrimaria; nested exception is org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.vinoteca.concilia.Cuenta.setIndPrimaria

Thanks!

First, I would recommend that you take the error's advice and set hibernate.cglib.use_reflection_optimizer=false so that you can see what the actual error is. Most likely the problem is that you have a not-null="false" field (since the database supports null on the column) mapped to a primitive boolean. If this is the case, you really only have two good options.

• Switch your Java type to a java.lang.Boolean
• or set all the null fields in the database to be false (which is what you are suggesting is your default) and set the database field to default to false with a not null restriction.

I just posted a NullSafeNumericUserType class for use with possible <NULL> numeric database column values. This could be enhanced to handle your needs.