MQSeries.net :: View topic

pete91z · Posted: Fri Apr 19, 2013 4:56 am Post subject:

Hi,

I am fairly new to the world of Websphere, and am trying to connect ODI to MQ using JMS and JNDI. I've been struggling to get the the connection working, and just wondered if anyone here had any advice?

my set up is:

Linux machine running ODI Studio and Oracle DB (LINUX1). I have installed the MQ client/runtime rpms

Windows 2008 Server running Websphere MQ 7.5 (WINAPP)

Windows 2008 server running AD (WINDC)

I have created two queue managers, one which uses LDAP for JNDI and one which uses file based JNDI.

I have been able to create the JNDI elements in AD, and I can see these when I browse AD.

I have successfully used IVTRun in client mode to connect to the queue using nojndi from both LINUX1 and WINAPP. Similarly, I have been able to use IVTRun from WINAPP to connect using LDAP and to a file based JNDI. When I run IVTRun -url from LINUX1, it is able to connect to the JNDI, but fails when connecting to the queue (I think it is looking for the queue on localhost) so as far as I can tell, this is successfully establishing a connection to the JNDI and the Connection Factory (I had to temporarily enable anonymous bind for it to work).

I have also successfully tested using the amqsputc and getc utils from LINUX1.

I have tried to set up a JMS XML Queue data server in ODI using the following parameters:

JNDI Authentication : Simple

JNDI User : DN=MyUser,OU=MyOu,DC=domain,DC=com

Password: <password>

JNDI Protocol: LDAP

JNDI Driver: com.sun.jndi.ldap.ldapctxfactory

JNDI URL: windc:389.....

JNDI Resource: MyLdapCF

However, when attempting to test the connection I get the error below.

I have checked in the WINDC event logs and can see a succesful connection being made using the JNDI user.

I have installed the MQ Client on the Linux machine and copied over the jar files to the ODI drivers and library directories as per instructions. I have also copied these to the drivers directory of the agents.

I have tried installing an ODI agent on the WINAPP server and registering the jar files and tried using the file based JNDI, but this also fails.

Does anyone have any thoughts on what might be going wrong, or any steps I might've missed?

The ODI error is as follows:

java.sql.SQLException: Cannot load connection class because of underlying
exception: 'java.sql.SQLException: Cannot load connection class because of
underlying exception.'.
at
oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
at
oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
(truncated)

I've had a look on the Oracle and IBM forums, but not found anything that works yet. Unfortunately, the Oracle error isn't particularly descriptive. Any advice or thoughts would be greatly appreciated.

Kind regards,
Pete