| 
| Tomcat, BIRT< and Oracle [message #146511] | Tue, 21 March 2006 10:01 |  | 
| Eclipse User  |  |  |  |  | Originally posted by: douglasknudsen.gmail.com 
 Ok, spent the day yesterday with BIRT.  We were friends for a bit, now its
 a bitter moment.  I can't get a simple BIRT report to work under Tomcat
 with Oracle.  I have the BIRT viewr installed and working under Tomcat.
 The default test rptdesign works, the more advanced test sample works, and
 I can create simple reports against a MYSql database too.  But I can't get
 the Oracle based report to work.  The report works in Eclipse BIRT
 designer tool in preview mode, but not under Tomcat. The below is the
 error from the Tomcat logs.  No errors at all in the BIRT viewr app log.
 Any ideas?
 
 using: BIRT 2.0.1
 Tomcat 5.5
 Oracle JDBC drivers ojdbc14.jar or Classes12.zip, both fail.
 
 java.lang.NullPointerException
 at oracle.jdbc.ttc7.Oclose.init(Oclose.java:77)
 at  oracle.jdbc.ttc7.TTC7Protocol.closeQuery(TTC7Protocol.java:5 24)
 at
 oracle.jdbc.driver.OracleResultSetImpl.internal_close(Oracle ResultSetImpl.java:676)
 at
 oracle.jdbc.driver.OracleStatement.prepare_for_new_result(Or acleStatement.java:2966)
 at
 oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Ora clePreparedStatement.java:450)
 at
 oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:382)
 at
 org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:338)
 at
 org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
 at
 org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:387)
 at
 org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:355)
 at
 org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
 at
 org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
 at
 org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
 at
 org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:315)
 at
 org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
 at
 org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
 at
 org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
 at
 org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
 at
 org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
 at
 org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
 at
 org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
 at
 org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:122)
 at
 org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:187)
 at
 org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
 at
 org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
 at
 org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
 at
 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
 at
 org.eclipse.birt.report.services.ReportEngineService.runAndR enderReport(Unknown
 Source)
 at
 org.eclipse.birt.report.viewer.aggregation.layout.EngineFrag ment.doService(Unknown
 Source)
 at
 org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown
 Source)
 at  org.eclipse.birt.report.viewer.servlet.ViewerServlet.doGet(U nknown
 Source)
 at  javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
 at
 org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
 at  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at
 org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
 at
 org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
 at
 org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
 at
 org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
 at
 org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
 at
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
 at
 org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
 at
 org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
 at
 org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:868)
 at
 org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:663)
 at
 org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
 at
 org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
 at
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
 at java.lang.Thread.run(Unknown Source)
 |  |  |  | 
Powered by 
FUDForum. Page generated in 0.07445 seconds