fail to get XA DataSource connection using DB2

[Anil Kumar Saha]

Using Wepsphere RAD to create XA Dasource
com.ibm.db2.jcc.DB2XADataSource

  
DataSource objDataSource=null;
Connection objConn = null;
Properties objProp=null;
try
{
objProp = new Properties();
objProp.put(javax.naming.Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
InitialContext ctx = new InitialContext(objProp);
objDataSource = (javax.sql.DataSource)ctx.lookup("jdbc/XADatasource");
objConn = objDataSource.getConnection();
 
}
 

But gerring the below exception. Any help will be appreciated.

 
 
[11/27/07 19:36:34:387 SGT] 00000036 FreePool      E   J2CA0046E: Method createManagedConnectionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/XADatasource, throwing ResourceAllocationException.  Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a XAConnection from the DataSource. with SQL State : null SQL Code : -99999
at com.ibm.db2.jcc.c.jc.n(jc.java:165)
at com.ibm.db2.jcc.c.jc.b(jc.java:145)
at com.ibm.db2.jcc.DB2XADataSource.setInDoubtCreatedTime(DB2XADataSource.java:139)
at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:82)
at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:55)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:948)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:943)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:949)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:936)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1502)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1294)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:2000)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:769)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:569)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:328)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:297)
at com.citi.dao.XAConnection.getDB2Connection(XAConnection.java:38)
at com.ibm._jsp._Test._jspService(_Test.java:71)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:171)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: java.sql.SQLException: Cannot get the created time of the SYSIBM.INDOUBT table. This might be caused by the SYSIBM.INDOUBT table does not exist in the DB2 system. The SYSIBM.INDOUBT table can be created by invoking the JCC In-Doubt utility from command line as follow: java com.ibm.db2.jcc.DB2T4XAIndoubtUtil. Please note it is a prerequisite to manually run this utility as a user having SYSADM privileges against the DB2 FOR OS/390 AND Z/OS V7 location in order to accomplish XA(global/distributed) transactions.DSRA0010E: SQL State = null, Error Code = -99,999DSRA0010E: SQL State = null, Error Code = -99,999
... 38 more
Next Linked Exception: