cancel
Showing results for 
Search instead for 
Did you mean: 

Unsupported JNDI Object while trying to render Crystal Report in a JSP

Former Member
0 Kudos

Hi,

We are trying to run a crystal report using the database connection defined in Tomcat's JNDI resources. (Using JDK 1.6 & Tomact 6.0)

Here is the error in log file:

-


2009-10-30 06:38:05,879 INFO [com.crystaldecisions.reports.queryengine.driverImpl] - Logon: Connecting to database using local JNDI server ...

2009-10-30 06:38:05,888 DEBUG [com.crystaldecisions.reports.reportdefinition.datainterface] - Failed to open connection (Connection: databaseType=JDBC (JNDI) serverName=jdbc:oracle:thin:@10.76.85.68:1521:dtv state=closed databaseDriverName=crdb_jdbc.dll).

com.crystaldecisions.reports.queryengine.al: Unsupported JNDI Object (remedy)

at com.crystaldecisions.reports.queryengine.driverImpl.o.if(Unknown Source)

at com.crystaldecisions.reports.queryengine.av.new(Unknown Source)

at com.crystaldecisions.reports.queryengine.av.byte(Unknown Source)

at com.crystaldecisions.reports.reportdefinition.datainterface.b.a(Unknown Source)

at com.crystaldecisions.reports.reportdefinition.datainterface.b.a(Unknown Source)

at com.crystaldecisions.reports.reportdefinition.datainterface.b.a(Unknown Source)

at com.crystaldecisions.reports.reportdefinition.datainterface.b.if(Unknown Source)

at com.crystaldecisions.reports.reportdefinition.datainterface.j.a(Unknown Source)

-


at java.lang.Thread.run(Unknown Source)

2009-10-30 06:38:05,890 DEBUG [com.crystaldecisions.reports.reportdefinition.datainterface] - com.crystaldecisions.reports.reportdefinition.datainterface.h: Unsupported JNDI Object (remedy)

2009-10-30 06:38:05,891 ERROR [com.businessobjects.reports.sdk.JRCCommunicationAdapter] - JRCAgent1 detected an exception: Unsupported JNDI Object (remedy)

at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(Unknown Source)

at com.businessobjects.reports.sdk.b.i.if(Unknown Source)

at com.businessobjects.reports.sdk.b.i.a(Unknown Source)

at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

-


context.xml configuraiton:

" <Context>

<Resource name="jdbc/remedy" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@10.76.85.68:1521:dtv" maxActive="20" maxIdle="10" maxWait="-1" />

</Context> "

web.xml configuration:

"

<resource-ref>

<description>DB Connection</description>

<res-ref-name>jdbc/remedy</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

"

Accepted Solutions (1)

Accepted Solutions (1)

ted_ueda
Active Contributor
0 Kudos

First take Crystal Reports out of the picture.

You're exposing a javax.sql.DataSource in Tomcat configuration.

Retrieve that DataSource using JNDI in code, and try to invoke dataSource.getConnection() - this will lead to the underlying exception that Crystal is complaining about.

Crystal is stating it can't connect to the DataSource you've exposed.

Sincerely,

Ted Ueda

Answers (1)

Answers (1)

0 Kudos

I am getting same Error while connecting to Postgres

Please suggest ?

RROR - Exception while processing export request: Unsupported JNDI Object () ERROR - Default printer was not valid, switching to 'GetUnPrinter'. ERROR - Failed to open connection (Connection: databaseType=JDBC (JNDI) serverName=jdbc:postgresql://10.161.88.45:5432/m1_rpt?user=rpt_user&password=rpt_user state=closed databaseDriverName=crdb_jdbc.dll). com.crystaldecisions.reports.queryengine.al: Unsupported JNDI Object () at com.crystaldecisions.reports.queryengine.driver.l.if(Unknown Source) at com.crystaldecisions.reports.queryengine.av.new(Unknown Source) at com.crystaldecisions.reports.queryengine.av.byte(Unknown Source) at com.crystaldecisions.reports.reportdefinition.datainterface.b.a(Unknown Source) at com.crystaldecisions.reports.reportdefinition.datainterface.b.a(Unknown Source) at com.crystaldecisions.reports.reportdefinition.datainterface.b.a(Unknown Source) at com.crystaldecisions.reports.reportdefinition.datainterface.b.if(Unknown Source) at com.crystaldecisions.reports.reportdefinition.datainterface.j.a(Unknown Source) at com.crystaldecisions.reports.reportengineinterface.g.if(Unknown Source) at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.export(Unknown Source) at com.crystaldecisions.report.web.event.bn.a(Unknown Source) at com.crystaldecisions.report.web.event.u.a(Unknown Source) at com.crystaldecisions.report.web.event.b1.broadcast(Unknown Source) at com.crystaldecisions.report.web.event.as.a(Unknown Source) at com.crystaldecisions.report.web.WorkflowController.if(Unknown Source) at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source) at com.crystaldecisions.report.web.ServerControl.a(Unknown Source) at com.crystaldecisions.report.web.viewer.ReportExportControl.a(Unknown Source) at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source) at org.apache.jsp.GenDailyRpt_jsp._jspService(GenDailyRpt_jsp.java:305) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) ERROR - com.crystaldecisions.reports.reportdefinition.datainterface.h: Unsupported JNDI Object () ERROR - Exception while processing export request: Unsupported JNDI Object ()