BIRT 2.5 + Hibernate Jars Compatibility + JBoss server

ganesh1984

Hi all,

First , i had created reports using BIRT 2.3.2. I am using hibernate data source ( oda-data-source ) for firing queries. Each report contains a table and chart. It was working fine when result set returns more than zero records. It was throwing exception (odaException - i had posted two threads regarding this, but didn't get any answers) when result set returns none or zero records. It was throwing exception because of chart. BIRT2.3.2 doesn't know how to render chart when result set is zero. I were getting this exception both in eclipse and runtime(server).

Since i coudn't find solution for this in any forums or tutorials, i tried to go for latest version. I come to know that BIRT 2.5 has a feature to render chart when result set is empty. We can hide the chart when result set is empty.

So after using BIRT 2.5 , i am not getting any exceptions when result set is empty. Its working fine in Eclipse. But in Server i am getting the following exception

Exception:

SEVERE: Error happened while running the report.
java.lang.NoClassDefFoundError: org/hibernate/Session
at org.jboss.tools.birt.oda.impl.HibernateDriver.getConnection(HibernateDriver.java:37)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.getConnection(OdaDriver.java:574)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:156)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:192)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:180)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:437)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:476)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:117)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1825)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:64)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)..................................................
....................................................................................................
21:17:12,343 ERROR [STDERR] java:447)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: org.hibernate.Session
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:489)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:405)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:393)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:105)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
... 87 more

I am using JBoss 5.0.0 server. By default Jboss using hibernate-core.jar of version 3.3.1 (common/lib). Eclipse is using hibernate3.jar( version - 3.2.5).

i tried to use hibernate jar of eclipse in Jboss server, Still i am getting same exception. Just for making sure the jar incompatibility , i had put the hibernate jar (3.3.1) of Jboss into eclipse and tried to run reports. I got the same exception what i got in Jboss server.

So, please tell me which version of hibernate jar should be used in JBoss when using BIRT 2.5

regards,
ganesh

Find more posts tagged with

Comments

mwilliams

Hi ganesh,

Where are you placing your jar file?

ganesh1984

Hi williams,

I am placing hibernate related inside jboss-5.0.0.GAcommonlib .

regards,
ganesh