can not load jdbc driver

Hi, I publish the file on the iserver express but it can not load the jdbc as400 driver. Where should I put the jdbc jt400.jar file? 
 
The error I get in the log file name : jsrvr9.exe.5124.d0942.2008Nov14_17_33_46_Singapore_Time.0.log 
 
In the log file, I can see the jt400.jar have been loaded into classpath. 
<pre class='_prettyXprint _lang-auto _linenums:0'>
....
SEVERE: Adding jar file to class path: d:reportingActuate9iServerJavaReportAPIenginesesslibjt400.jar
[Thread-10] Nov 14, 2008 5:34:06 PM com.actuate.reportapi.enginemanager.ReportEngineManager addJarFiles
....
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.ibm.as400.access.AS400JDBCDriver
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:623)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:731)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:192)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:158)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:158)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:115)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:145)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:134)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:121)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:214)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:265)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:210)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:500)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:161)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:142)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:445)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:149)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:111)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:182)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1685)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:76)
at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:74)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:189)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:224)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:113)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
at com.actuate.reportapi.engine.Task.execute(Unknown Source)
at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
[Thread-11, RequestID-d0942--2008-11-14 17:34:39--1] Nov 14, 2008 5:34:40 PM org.eclipse.birt.report.engine.data.dte.DataGenerationEngine doExecuteQuery
SEVERE: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: com.ibm.as400.access.AS400JDBCDriver
[Thread-11, RequestID-d0942--2008-11-14 17:34:39--1] Nov 14, 2008 5:34:40 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver
WARNING: Failed to load JDBC driver class: com.ibm.as400.access.AS400JDBCDriver
[Thread-11, RequestID-d0942--2008-11-14 17:34:39--1] Nov 14, 2008 5:34:40 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Cannot open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.ibm.as400.access.AS400JDBCDriver
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:623)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:731)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:192)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:158)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:158)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:115)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:145)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:134)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:121)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:214)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:265)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:210)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:500)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:161)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:142)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:445)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:149)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:111)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:182)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1685)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:76)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:61)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:189)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:224)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:113)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
at com.actuate.reportapi.engine.Task.execute(Unknown Source)
at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
[Thread-11, RequestID-d0942--2008-11-14 17:34:39--1] Nov 14, 2008 5:34:40 PM org.eclipse.birt.report.engine.data.dte.DataGenerationEngine doExecuteQuery
SEVERE: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: com.ibm.as400.access.AS400JDBCDriver
</pre>
 
thanks for help

Find more posts tagged with

Comments

JasonW

Are you using iServerExpress?

If so can you try placing the JDBC driver here:

install_location/jar/BIRT/Platform/plugins/org.eclipse.birt.report.data.oda.jdbc_version/drivers

Jason

JasonW

I should have posted this directory:

install_location/jar/BIRT/Platform/plugins/com.actuate.data.oda.jdbc.drivers_version/lib

cch

JarBIRTplatformpluginsorg.eclipse.birt.report.data.oda.jdbc_2.2.2.v20080718-1613drivers 
 
 
The locaiton should be here. But I wonder why this page receommend we put the jar file into so many places. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/deploying-birt-reports/169-placing-jdbc-drivers-for-birt-and-e-spreadsheet-reports/#description'>Placing JDBC drivers for BIRT and e.Spreadsheet Reports - Tips & Tricks - BIRT Exchange</a> 
 
Thanks for the reply!

rmurphy

<blockquote class='ipsBlockquote' data-author="cch">JarBIRTplatformpluginsorg.eclipse.birt.report.data.oda.jdbc_2.2.2.v20080718-1613drivers 
 
 
The locaiton should be here. But I wonder why this page receommend we put the jar file into so many places. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/deploying-birt-reports/169-placing-jdbc-drivers-for-birt-and-e-spreadsheet-reports/#description'>Placing JDBC drivers for BIRT and e.Spreadsheet Reports - Tips & Tricks - BIRT Exchange</a> 
 
Thanks for the reply!</blockquote>
 
The DevShare post lists where you would place the Jar files for all of the various products. The post was not intened to imply that you place the drivers in all these locations, but rather in the location specific to the product you are using. 
 
I hope this clears things up. 
 
Rob