cancel
Showing results for 
Search instead for 
Did you mean: 

CR4E throws NULL Pointer Exception in Oracle Application Server

Former Member
0 Kudos

Hi,<br><br>

We are using Crystal report 2008 CR4E API to implement the crystal report in our application. We are setting the database connection from the application to the report through initial context approach. When we deploy our application in Oracle Application server (10g) it throws the NULL pointer exception while trying to set the JNDI for the report. It will be of great help if some one could help us in resolving this issue.<br><br>

Note: The same report works fine in Tomcat 6.0 server. It throws error only in Oracle Application server. <br>

Below is the log file<br><br>

Exception:<br><br>

Connection logon:Database DLL=s(crdb_jdbc.dll);Trusted_Connection=s(true);PreQEServerType=s(JDBC (JNDI));Server <br>Type=s(JDBC (JNDI));Use JDBC=s(true);Database Class Name=s();JNDI Datasource Name=s(jdbc/1495);Connection URL=s();User ID=s(myapp);Password=<br>

detected an exception: java.lang.NullPointerException<br>

at com.crystaldecisions.reports.queryengine.driverImpl.jdbc.JDBCConnection.Open(Unknown Source)<br>

at com.crystaldecisions.reports.queryengine.JDBConnectionWrapper.Open(SourceFile:123)<br>

at com.crystaldecisions.reports.queryengine.Connection.br(SourceFile:1771)<br>

at com.crystaldecisions.reports.queryengine.Connection.bs(SourceFile:491)<br>

at com.crystaldecisions.reports.queryengine.Connection.t1(SourceFile:2978)<br>

at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.a(SourceFile:696)<br>

at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.for(SourceFile:706)<br>

at com.crystaldecisions.reports.reportdefinition.ReportHelper.a(SourceFile:198)<br>

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.long(SourceFile:957)<br>

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:635)<br>

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:672)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1944)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:661)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)<br>

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)<br>

at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)<br>

at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)<br>

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)<br>

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)<br>

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)<br>

at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186)<br>

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558)<br>

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337)<br>

at com.crystaldecisions.sdk.occa.report.application.ReportSource.export(SourceFile:286)<br>

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.export(SourceFile:209)<br>

at com.mysystems.myapp.common.CrystalRpt.print(CrystalRpt.java:387)<br>

at regular.ShowReport._jspService(_ShowReport.java:277)<br>

at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)<br>

at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:350)<br>

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)<br>

at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)<br>

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<br>

at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)<br>

at com.mysystems.myapp.common.ServletFilter.doFilter(ServletFilter.java:107)<br>

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)<br>

at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)<br>

at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)<br>

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:224)<br>

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)<br>

at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)<br>

at java.lang.Thread.run(Thread.java:662)<br>

2011-06-27 10:42:03.598 09041510myappt myapp ShowReport.jspService(277) Error while generating crystal report

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: java.lang.NullPointerException---- Error code:-2147467259 Error code name:failed<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:741)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)<br>

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)<br>

at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)<br>

at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)<br>

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)<br>

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)<br>

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)<br>

at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186)<br>

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558)<br>

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337)<br>

at com.crystaldecisions.sdk.occa.report.application.ReportSource.export(SourceFile:286)<br>

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.export(SourceFile:209)<br>

at com.mysystems.myapp.common.CrystalRpt.print(CrystalRpt.java:387)<br>

at regular.ShowReport._jspService(_ShowReport.java:277)<br>

at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)<br>

at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:350)<br>

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)<br>

at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)<br>

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<br>

at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)<br>

at com.mysystems.myapp.common.ServletFilter.doFilter(ServletFilter.java:107)<br>

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)<br>

at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)<br>

at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)<br>

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:224)<br>

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)<br>

at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)<br>

at java.lang.Thread.run(Thread.java:662)<br>

Caused by: java.lang.NullPointerException<br>

at com.crystaldecisions.reports.queryengine.driverImpl.jdbc.JDBCConnection.Open(Unknown Source)<br>

at com.crystaldecisions.reports.queryengine.JDBConnectionWrapper.Open(SourceFile:123)<br>

at com.crystaldecisions.reports.queryengine.Connection.br(SourceFile:1771)<br>

at com.crystaldecisions.reports.queryengine.Connection.bs(SourceFile:491)<br>

at com.crystaldecisions.reports.queryengine.Connection.t1(SourceFile:2978)<br>

at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.a(SourceFile:696)<br>

at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.for(SourceFile:706)<br>

at com.crystaldecisions.reports.reportdefinition.ReportHelper.a(SourceFile:198)<br>

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.long(SourceFile:957)<br>

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:635)<br>

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:672)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1944)<br>

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:661)<br>

... 33 more<br>

Edited by: Karthikeyanb on Jun 27, 2011 6:21 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Can someone please help me?

Former Member
0 Kudos

Hi,

Can anyone please help with the solution?

Regards,

Karthik