on 06-27-2011 5:16 PM
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
Hi,
Can someone please help me?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can anyone please help with the solution?
Regards,
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.