Boolean Data Type Problem
Posted 24 August 2009 - 04:40 PM
I used Hibernate ODA Data Source, one of my field (amberWarning) is Boolean data type.
But, i had and exception like below:
A BIRT exception occurred.
Plug-in Name:BIRT Data Engine
Error Message:Failed to prepare the following query for the data set type org.jboss.tools.birt.oda.dataSet.
'boolean' is not a valid type.
Posted 25 August 2009 - 12:57 PM
I have not seen this issue before. Also, I have no way of testing this as I don't have hibernate and the sample db does not have a boolean field. What is the data in your boolean field like? 'true/false', 't/f', or '0/1'?
Posted 04 May 2012 - 07:00 AM
Now 2.5 years after the original post, Hibernate ODA driver (version 1.2.0 stable, 1.3.0 milestone/nightly) still doesn't support Boolean data type. Quite sad, isn't it?
Fix is definately possible and quite simple by patching Hibernate ODA driver (sources available from JBoss vendor).
Posted 04 May 2012 - 07:27 AM
I agree that it might be easier to use your domain model to navigate through the report structure but it normally introduces performance issues because you have to know a lot about the underlying hibernate mapping to avoid such kind of problems.
Have a look at: http://www.xing.com/...-group-mannheim or write me an email