Urgent help required -- Birt report viewer --- missing plugins for hibernate DS

ganesh1984

Hi All, 
 
I want to use hibernate datasource for generating birt reports. I have followed the instructions given in <a class='bbc_url' href='https://jira.jboss.org/jira/browse/JBIDE-2220'>https://jira.jboss.org/jira/browse/JBIDE-2220</a>. I am able to create the report and also to preview it. so every thing is woking fine in eclipse. 
 
But when i tried to deploy this report into WebViewerExample i am getting the following exception. 
 
I think i am missing some plugins and jars. 
 
org.jboss.tools.birt.oda.impl.HibernateConnection.open class - where it looks for hibernate.jar. 
 
org.eclipse.birt.report.service.api.ReportServiceException: null; nested exception is: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:164) at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81) at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:57) at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:53) 
.................................................................. 
 
Caused by: java.lang.NoClassDefFoundError: org/hibernate/Session at org.jboss.tools.birt.oda.impl.HibernateConnection.open(HibernateConnection.java:43) at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235) at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157) at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:210) at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:197) at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209) 
 
....................................................... 
 
Caused by: java.lang.ClassNotFoundException: org.hibernate.Session at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:481) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:397) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:385)

This is just a pieces of each exception. So the stack ends with java.lang.ClassNotFoundException: org.hibernate.Session. one of the plugin is not finding the hibernate3.jar . where should i put this jar ?. 
 
I have added all these plugins and jars required for hibernate : 
 
1) org.jboss.tools.birt.core_1.0.0.jar 
2) org.jboss.tools.birt.oda.ui_1.0.0.jar 
3) org.jboss.tools.birt.oda_1.0.0.jar 
4) org.eclipse.birt.report.data.oda.hibernate 
5) org.eclipse.birt.report.data.oda.hibernate.ui 
 
Its working for normal jdbc drivers. But for hibernate datasource i am getting the above issues. please help to solve this. 
 
thanx, 
ganesh

Find more posts tagged with

Comments

fcdradio

I want to share my results dealing with this same issue. I work on a web application running on JBoss and have been working to integrate BIRT reports using the Hibernate ODA. Everything worked fine while doing the design in Eclipse, but when it came down to deploying it I had several problems. The first was that the
org.jboss.tools.birt.oda.ui_1.0.0.jar and org.jboss.tools.birt.oda_1.0.0.jar files needed to be included in the platformplugins folder. After that, I started getting the exception that Ganesh mentions.

The problem for me was that we don't package the hibernate jars with the application, we keep them in JBoss' server/default/lib directory. When I attempted to move them to various places I would get different exceptions, basically resulting from having the jars duplicated. The solution I found was to include the setting:

osgi.parentClassloader=fwk

in my platformconfigurationconfig.ini file. As I understand it, this tells OSGi to use the framework-level classloader, thus allowing it to find the hibernate jars in the jboss server lib directory.

I hope this helps anyone out there dealing with this problem, because I spent several days trying to figure it out myself.
Phill