Problem in connecting to a Oracle driver data source.

Hi, 
 
I have used the BIRT designer and created a report that connects to Oracle database. It works fine in the designer. i dropped the same in tomcat and the report is generator properly.But when I try to do the same using a standalone java application I am getting a java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver . I have ojdbc14.jar in the classpath. But still I am getting this error. Please check the stack trace below and let me know If I am missing something. 
 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions 
INFO: Found JDBC driverinfo extension: driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions 
INFO: Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver, connectionFactory=org.eclipse.birt.report.data.oda.sampledb.SampleDBJDBCConnectionFactory 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadAndRegisterDriver 
INFO: Loading JDBC driver class: oracle.jdbc.driver.OracleDriver 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver 
INFO: Driver class not in class path: oracle.jdbc.driver.OracleDriver. Trying to locate driver in drivers directory 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver 
SEVERE: DriverClassLoader failed to load class: oracle.jdbc.driver.OracleDriver 
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver 
at org.eclipse.birt.core.framework.URLClassLoader.findClass1(URLClassLoader.java:185) 
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:154) 
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:1) 
at java.security.AccessController.doPrivileged(Native Method) 
at org.eclipse.birt.core.framework.URLClassLoader.findClass(URLClassLoader.java:149) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:306) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:251) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadExtraDriver(JDBCDriverManager.java:919) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:738) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.registerDriver(JDBCDriverManager.java:879) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:862) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:246) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:212) 
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:234) 
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:160) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:238) 
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:180) 
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:193) 
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:181) 
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:396) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:315) 
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:448) 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190) 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178) 
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:144) 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:511) 
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:139) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:254) 
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205) 
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65) 
at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62) 
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) 
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) 
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) 
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:137) 
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111) 
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160) 
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) 
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:137) 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70) 
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) 
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132) 
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:137) 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70) 
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) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75) 
at test.birt.ExecuteReport.executeReport(ExecuteReport.java:86) 
at test.birt.ExecuteReport.main(ExecuteReport.java:26) 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver 
SEVERE: refreshUrlsWhenFail: true 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver 
SEVERE: driverClassPath: null 
17-Feb-2010 17:25:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver 
SEVERE: Registered URLs: 
17-Feb-2010 17:25:09 org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec 
INFO: Ignoring the UnsupportedOperationException thrown by ODA driver (org.eclipse.birt.report.data.oda.jdbc) on IQuery#setSpecification. 
 
Regards 
VK

Find more posts tagged with

Comments

karthick3d

I even tried to put this logic in the code and It works fine.
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
}catch(Exception e) {e.printStackTrace();}

karthick3d

Guys,

I was getting this error continuously, but when I checked the output directory, I was able to find the report being generated.
I was puzzled by the same.
As of now I am going to ignore those error messages.

-VK