| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ Series 5.3/Oracle 9i/XA/Java (Error 2121) |
« View previous topic :: View next topic » |
| Author |
Message
|
| anand1 |
 Posted: Thu Feb 19, 2004 7:43 am Post subject: MQ Series 5.3/Oracle 9i/XA/Java (Error 2121) |
 |
|
Newbie
Joined: 19 Feb 2004
Posts: 3
|
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 |
|
| Back to top |
|
 |
| EddieA |
| Posted: Thu Feb 19, 2004 9:18 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Do NOT ask the same question in multiple forums. 
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| anand1 |
| Posted: Thu Feb 19, 2004 4:54 pm Post subject: |
|
|
Newbie
Joined: 19 Feb 2004
Posts: 3
|
| Never mind. I got it working. |
|
| Back to top |
|
|
| murali_bestha |
| Posted: Mon Mar 08, 2004 7:31 pm Post subject: |
|
|
Novice
Joined: 12 Feb 2004
Posts: 17
|
Hi anand
Could you please let me know the following?
Ours system environment is :
Oracle9i on Solaris
Websphere MQ 5.3 on Windows 2K
JRE : 1.3.1_10
JDBC Driver : classes12.jar from Oracle
But this is giving an ArrayIndexOutOfBoundsException when try to get a connection using QManager's getJDBCConnection method.
Is this a compatibility problem? Doesnt jdbcora9.dll work with JRE 1.3.1_10 ?
Thanks in advance
Murali |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
