Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: CR2011 - Failed to open JDBC/JNDI connection Post Reply Post New Topic
Author Message
baidu
Newbie
Newbie
Avatar

Joined: 07 Aug 2012
Location: United Kingdom
Online Status: Offline
Posts: 1
Quote baidu Replybullet Topic: CR2011 - Failed to open JDBC/JNDI connection
    Posted: 07 Aug 2012 at 1:14am
I've setup datasources in WAS6. When I try to connect, I would get the following error:

--> Failed to open the connection. Details: Exception: [Error Message] Failed to initialize the ORB

In CRConfig.xml, I have the following settings:

<JavaDir>C:\IBM\WebSphere\AppServer\java\bin</JavaDir>
<Classpath>
...the standard CR stuff...;
C:\websphere_lib\was\com.ibm.ws.admin.client_6.1.0.jar;
C:\websphere_lib\was\com.ibm.ws.runtime_6.1.0.jar;
C:\websphere_lib\was\com.ibm.ws.sib.server_2.0.0.jar;
C:\websphere_lib\was\com.ibm.ws.webservices.thinclient_6.1.0.jar;
C:\websphere_lib\was\com.ibm.ws.emf_2.1.0.jar;
C:\websphere_lib\was\ibmorb.jar;
C:\websphere_lib\was\rsadbutils.jar;
C:\websphere_lib\was\rsahelpers.jar;
C:\Oracle_lib\ojdbc14_10.2.0.3.0.jar;
${CLASSPATH}
</Classpath>
<IORFileLocation>C:\CR_temp</IORFileLocation>
<JDBCURL>jdbc:oracle:thin:@ORACLEDB13:1521:SCHEMA13</JDBCURL>
<JDBCClassName>oracle.jdbc.driver.OracleDriver</JDBCClassName>
<JNDIURL>corbaloc:iiop:localhost:2809</JNDIURL>
<JNDIConnectionFactory>com.ibm.websphere.naming.WsnInitialContextFactory</JNDIConnectionFactory>
<JNDIInitContext>jdbc</JNDIInitContext>

I wrote a little thin client java app using the parameters above and that works. I can connect and fetch data successfully so it's clear that the problem lies with CR configuration. Unfortunately (and stupidly), CR does not keep any logging at all so it's hard to work out the underlying cause for the connection failure.

I also tested the same with CRXI and that worked fine. So it's something odd with CR 2011.

Has anyone experienced this problem before? I presume it's a classpath issue, may be someone can kindly advise what other jars I need to include in the class path.

Thanks in advance
--------------------------------------------------------
Windows XP (64-bit)
Crystal Report 2011
Websphere Application Server 6
Oracle Database

Edited by baidu - 15 Aug 2012 at 10:53pm
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.