MQSeries.net :: View topic - URGENT HELP US:Handling 2-phase commit in java

rk400

Hi ,

In MQ System Administration manual chapter 14 following is the list of XA complaint relational databases.

Table 12. XA-compliant relational databases

MQSeries product DB2 Oracle Sybase

MQSeries for Windows NT Yes No Yes

We have win2k server with MQ server 5.2, Oracle server 8.1.7 environment. Our application is written in java and we are using mq classes for java version 5.2.2.

We downloaded mqdb2log.java sample and changed it to work for oracle.

oracle.jdbc.xa.client.OracleXADataSource myDataSource =
new oracle.jdbc.xa.client.OracleXADataSource();
myDataSource.setUser("TEST");
myDataSource.setPassword("TEST");
myDataSource.setURL("jdbc:oracle:thin:@172.0.7.41:1521:"+dbName);
jdbcConn = qMgr.getJDBCConnection(myDataSource);
try
{qMgr.begin(); }
catch(MQException me)
{
if((me.completionCode == me.MQCC_WARNING)||(me.reasonCode == me.MQRC_NO_EXTERNAL_PARTICIPANTS ))
{}
else{ throw me;}
}
MQPutMessageOptions pmo = new MQPutMessageOptions();
pmo.options = pmo.options | MQC.MQPMO_SYNCPOINT;
myQueue.put(myMessage, pmo);
Statement stmt = jdbcConn.createStatement();
try { int rowsUpdated = stmt.executeUpdate(runShow);
} catch (java.lang.Exception ex) {
validStatement = false;
}
stmt.close();
qMgr.commit();}
else {
qMgr.backout();}

We have configured oralce as per the system administration manual. During testing we found that the database is commited in case of backout.

Now we have two questions:

1. Is 2-phase commit supported on win2k server and oracle 8i.(MQ as XA)
(Referring to the chapter 14 of the manual).

2. Did we miss out anything in the program.

Please Please help us in this.

Thanx a lot.
RK