MQSeries.net :: View topic - MQSeries 5.3/Oracle 9i/XA/Java (Error 2121)

anand1

I am using MQSeries 5.3 with Oracle9i on WIndows 2000. Everything is on the same machine. The configuration information is already set in the "Resource" tabpage of MQ Series Queue Manager/Properties dialog box. The Queue Manager starts OK without any error. It is able to make the initial connection to the oracle db.

When I run my java program to read a message, I get error on the "qMgr.begin()" statement. I have already searched on the IBM support site and found nothing. The other Topics in mqseries.net forums also are not very clear on this error.

MQJE001: Completion Code 0, Reason 2121
com.ibm.mq.MQException: MQJE001: Completion Code 0, Reason 2121
at com.ibm.mq.MQQueueManager.begin(MQQueueManager.java:1004)
at com.logica.imfplus.gateway.admin.TestXA.<init>(TestXA.java:39)
at com.logica.imfplus.gateway.admin.TestXA.main(TestXA.java:77)

Here is the java source:
###########################################
OracleXADataSource iDS = new oracle.jdbc.xa.client.OracleXADataSource();
iDS.setUser("wms");
iDS.setPassword("wms");
iDS.setURL("jdbc:oracle:thin:@127.0.0.1:1521:ORCL");

FileOutputStream traceFile =new FileOutputStream("./xatrace.txt");
MQEnvironment.enableTracing(5, traceFile);

java.util.Hashtable prop = new Hashtable();
prop.put(MQC.THREAD_AFFINITY, new Boolean(true));

MQQueueManager qMgr = new MQQueueManager("QM_TEST", prop);
Connection conn = qMgr.getJDBCConnection(iDS);
System.out.println("Here");

qMgr.begin(); // Error comes here

#############################################

Here is the Trace file segment:
************************************************************
09:30:18 [1077204618009] Thread: main, Object: com.ibm.mq.MQQueueManager@6ed786 <== MQQueueManager constructor (String, Hashtable)() exit
09:30:18 [1077204618009] Thread: main, Object: com.ibm.mq.MQQueueManager@6ed786 ==> getJDBCConnection() entry
09:30:18 [1077204618009] Thread: main, Object: com.ibm.mq.MQQueueManager@6ed786 ==> getJDBCConnection(u,p)() entry
09:30:18 [1077204618019] Thread: main ==> XAtoJTA::helpGetConnection() entry
09:30:18 [1077204618480] Thread: main, Object: com.ibm.mq.server.MQSESSION@1efb05 ==> XAREGISTER() entry
09:30:18 [1077204618480] Thread: main ==> MQSESSION::getLibraryPath() entry
09:30:18 [1077204618480] Thread: main Class: MQSESSION path ''
09:30:18 [1077204618480] Thread: main <== MQSESSION::getLibraryPath() exit
09:30:18 [1077204618480] Thread: main ==> MQSESSION::loadLib() entry
09:30:18 [1077204618480] Thread: main Class: MQSESSION Load this library: 'MQXAi02'
09:30:18 [1077204618480] Thread: main <== MQSESSION::loadLib() exit
09:30:18 [1077204618480] Thread: MQBindingsQMThread0 ==> XAtoJTA::registerResource() entry
09:30:18 [1077204618480] Thread: MQBindingsQMThread0 ==> XAtoJTA::getInstance() entry
09:30:18 [1077204618480] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 ==> constructor() entry
09:30:18 [1077204618480] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 common/javabase/com/ibm/mq/XAtoJTA.java, java, j530, j530-L021003 02/10/02 12:36:01 @(#) 1.9.2.2
09:30:18 [1077204618480] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 <== constructor() exit
09:30:18 [1077204618480] Thread: MQBindingsQMThread0 <== XAtoJTA::getInstance() exit
09:30:18 [1077204618480] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 ==> _registerResource() entry
09:30:18 [1077204618490] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 not in transaction, adding to spare conns
09:30:18 [1077204618490] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 <== _registerResource() exit
09:30:18 [1077204618490] Thread: MQBindingsQMThread0 <== XAtoJTA::registerResource() exit
09:30:18 [1077204618490] Thread: main, Object: com.ibm.mq.server.MQSESSION@1efb05 <== XAREGISTER() exit
09:30:18 [1077204618490] Thread: main <== XAtoJTA::helpGetConnection() exit
09:30:18 [1077204618490] Thread: main, Object: com.ibm.mq.MQQueueManager@6ed786 <== getJDBCConnection(u,p)() exit
09:30:18 [1077204618490] Thread: main, Object: com.ibm.mq.MQQueueManager@6ed786 <== getJDBCConnection() exit
09:30:18 [1077204618490] Thread: main, Object: com.ibm.mq.MQQueueManager@6ed786 ==> begin() entry
09:30:18 [1077204618490] Thread: main, Object: com.ibm.mq.server.MQSESSION@1efb05 ==> MQBEGIN() entry
09:30:18 [1077204618490] Thread: main, Object: com.ibm.mq.server.MQSESSION@1efb05 Conn Handle = 145059296
09:30:18 [1077204618490] Thread: MQBindingsQMThread0 ==> XAtoJTA::resetRC() entry
09:30:18 [1077204618490] Thread: MQBindingsQMThread0 ==> XAtoJTA::getInstance() entry
09:30:18 [1077204618490] Thread: MQBindingsQMThread0 <== XAtoJTA::getInstance() exit
09:30:18 [1077204618490] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 resetting beginRC
09:30:18 [1077204618490] Thread: MQBindingsQMThread0 <== XAtoJTA::resetRC() exit
09:30:18 [1077204618490] Thread: MQBindingsQMThread0 ==> F:/build/j5304_D/src/native/mqi.c:1162::_MQBEGIN() entry
09:30:19 [1077204619201] Thread: MQBindingsQMThread0 Class: F:/build/j5304_D/src/native/mqi.c:1190: : MQBEGIN call returned CC=0, RC=0
09:30:19 [1077204619201] Thread: MQBindingsQMThread0 <== F:/build/j5304_D/src/native/mqi.c:1196::_MQBEGIN() exit
09:30:19 [1077204619201] Thread: MQBindingsQMThread0 ==> XAtoJTA::getRC() entry
09:30:19 [1077204619201] Thread: MQBindingsQMThread0 ==> XAtoJTA::getInstance() entry
09:30:19 [1077204619201] Thread: MQBindingsQMThread0 <== XAtoJTA::getInstance() exit
09:30:19 [1077204619201] Thread: MQBindingsQMThread0, Object: com.ibm.mq.XAtoJTA@261164 returning beginRC=2121
09:30:19 [1077204619201] Thread: MQBindingsQMThread0 <== XAtoJTA::getRC() exit
09:30:19 [1077204619201] Thread: MQBindingsQMThread0 Class: MQSESSION overriding reason code from 0 to 2121
09:30:19 [1077204619201] Thread: main, Object: com.ibm.mq.server.MQSESSION@1efb05 CC,RC = 0,2121
09:30:19 [1077204619201] Thread: main, Object: com.ibm.mq.server.MQSESSION@1efb05 <== MQBEGIN() exit
09:30:19 [1077204619211] Thread: main, Object: com.ibm.mq.MQException: MQJE001: Completion Code 0, Reason 2121 ==> MQException constructor(cc, rc, source)() entry
09:30:19 [1077204619221] Thread: main, Object: com.ibm.mq.MQException: MQJE001: Completion Code 0, Reason 2121 common/javabase/com/ibm/mq/MQException.java, java, j530, j530-L020820 02/08/09 13:29:42 @(#) 1.39
09:30:19 [1077204619221] Thread: main, Object: com.ibm.mq.MQException: MQJE001: Completion Code 0, Reason 2121 cc = 0
09:30:19 [1077204619221] Thread: main, Object: com.ibm.mq.MQException: MQJE001: Completion Code 0, Reason 2121 rc = 2121
09:30:19 [1077204619221] Thread: main, Object: com.ibm.mq.MQException: MQJE001: Completion Code 0, Reason 2121 source = com.ibm.mq.MQQueueManager@6ed786
09:30:19 [1077204619221] Thread: main, Object: com.ibm.mq.MQException: MQJE001: Completion Code 0, Reason 2121 <== MQException constructor() exit
09:30:19 [1077204619221] Thread: main, Object: com.ibm.mq.MQQueueManager@6ed786 <== begin (via exception)() exit
***************************************************

Thanks
Anand