BIRT doesn't support joda-time api !!!!!!!!!!

ganesh1984

Hi All,

I am using eclipse for generating BIRT reports(all in one). version of Birt is 2.3.2.

I am using Hibernate data source for my reports generation. every thing was working fine till last week. i have created many reports using Hibernate queries.

Today i had changed the data type of 'date' fields from java.util.date to org.joda.time.DateTime. Now I am using joda-time api for date fields since its more useful than java.util.date provided by jdk.

now i am getting exception if i try to fetch these 'date' fields in the query. This was working fine when i was using java.util.Date.

Exception :

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.2.r232_v20090211
Error Code:odaconsumer.CannotPrepareStatement
Error Message:Failed to prepare the following query for the data set type org.jboss.tools.birt.oda.dataSet.
[select la.statusHistory.startTime, count(la.statusHistory.startTime) , sum(la.amount),
avg(la.amount) from LoanApplication la where la.statusHistory.startTime
between '2009-04-01' and '2009-09-01']
'org.joda.time.contrib.hibernate.PersistentDateTime' is not a valid type.


Its saying 'org.joda.time.contrib.hibernate.PersistentDateTime' is not a valid type.

Do i need to use any extra plugins in Eclipse for supporting joda-time?.

These queries are working in java class. But in BIRT data set if i try to see the preview results it throws the above exception.

any kind of help is appreciated.

regards,
ganesh

JasonW

BIRT does not currently support
org.joda.time.DateTime
Type. It would be good if you could log a bug for this. Also if you are using the JBOSS hibernate oda, log a bug at their site to investigate converting the Date in the ODA.

Jason