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
|