[Hsqldb-user] Hibernate & Boolean type issue

[Mike R. <mre...@gm...>]

Fred,

I just pulled from svn trunk and built an hsqldb.jar (I was having an issue
with RC4 getting the initial connection).

It looks like the JDBCPreparedStatement.setParameter function allows the
Boolean type to pass through, but the BitType.convertToDefaultType doesn't
handle Booleans.  Your thoughts?

org.hsqldb.HsqlException: value cannot be converted to target type
	org.hsqldb.Error.error(Error.java:111)
	org.hsqldb.Error.error(Error.java:81)
	org.hsqldb.types.BitType.convertToDefaultType(BitType.java:374)
	org.hsqldb.jdbc.JDBCPreparedStatement.setParameter(JDBCPreparedStatement.java:3871)
	org.hsqldb.jdbc.JDBCPreparedStatement.setBoolean(JDBCPreparedStatement.java:365)
	org.hibernate.type.BooleanType.set(BooleanType.java:59)
	org.hibernate.type.NullableType.nullSafeSet(NullableType.java:154)
	org.hibernate.type.NullableType.nullSafeSet(NullableType.java:131)
	org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2025)
	org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2002)
	org.hibernate.persister.entity.AbstractEntityPersister$3.bindValues(AbstractEntityPersister.java:2180)
	org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:56)
	org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)
	org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)
	org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
	org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
	org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)
	org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
	org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
	org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
	org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
	org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117)
	org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
	org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:534)
	org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:526)
	org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:522)

Mike Ressler