My Oracle Support Banner

"Cannot find the Connection Factory (myQCF) in JNDI' Message When Testing Connection To IBM Websphere MQ In ODI (Doc ID 424047.1)

Last updated on DECEMBER 31, 2019

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.

Symptoms

Before configuring Oracle Data Integrator (ODI) with Websphere MQ, verification of MQ features indicate correct behavior.

However, when testing the Data Server created using Sun's file based FSContext in ODI, the following message is signaled -Where (myQCF) is the MQ Connection Factory:

java.sql.SQLException: Cannot load connection class because of underlying exception:
'javax.jms.JMSException: Can not find the Connection Factory (myQCF) in JNDI'.
     at com.sunopsis.jdbc.driver.JMSDriverQueue.connect(JMSDriverQueue.java)
     at java.sql.DriverManager.getConnection(DriverManager.java:512)

 or:

java.sql.SQLException: javax.jms.JMSException: ODI-40203: Cannot find the Connection Factory (myQCF) in JNDI
     at com.sunopsis.jdbc.driver.SnpsDriverStatement.executeQuery(SnpsDriverStatement.java:110)
     at com.sunopsis.jdbc.driver.SnpsDriverPreparedStatement.executeQuery(SnpsDriverPreparedStatement.java:139)
     at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
     at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:89)

When testing with the Websphere JMSAdmin tool, the QueueConnectionFactory appears to be available.
 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 ODI 11g
 For the standalone Agent...
 For ODI Studio...
 ODI 10g
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.