I'm having a problem mapping a boolean type to a CHAR(1) field in an Oracle database. The mapping file was taken from an old MySQL based application, I reckon the problem might be the type of the column in the DDL, but wouldn't the substitution in the hibernate.cfg.xml solve that?

Any help would be greatly appreciated

TIA,



Hibernate version = 2.1.4

Mapping <property column="VISIBLE" length="1" name="visible" not-null="false" type="boolean"/>

From hibernate.cfg.xml = <property name="query.substitutions">true 1, false 0</property>


Full stack trace of any exception that occurs:

common.dao.DAOException: net.sf.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of xxxxxx.ElementCore.setVisible
at common.dao.HibernateDAO.handleException(HibernateDAO.java:269)
at common.dao.HibernateDAO.load(HibernateDAO.java:537)
at common.dao.HibernateDAO.load(HibernateDAO.java:521)
at common.delegate.GenericDelegate.load(GenericDelegate.java:28)
at common.taglib.LoadTag.doStartTag(LoadTag.java:95)

Name and version of the database you are using: Oracle 8.1.6

Debug level Hibernate log excerpt: info

can any even point me in the right direction in terms of the documentation?

http://www.hibernate.org/189.html
may help you