Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within JDBC and Relational Databases
Search Coderanch
Advance search
Google search
Register / Login
Post Reply
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Campbell Ritchie
Paul Clapham
Ron McLeod
Jeanne Boyarsky
Tim Cooke
Sheriffs:
Liutauras Vilda
paul wheaton
Henry Wong
Saloon Keepers:
Tim Moores
Tim Holloway
Stephan van Hulst
Carey Brown
Frits Walraven
Bartenders:
Piet Souris
Himai Minh
Forum:
JDBC and Relational Databases
fail to get XA DataSource connection using DB2
Anil Kumar Saha
Ranch Hand
Posts: 111
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
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:
Regards,
Anil Kumar Saha
SCJP 1.4
http://www.agilej.blogspot.com/
It's just a flesh wound! Or a tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
reply
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
WSAD 5.1.2 - DB2 DSRA8100E: Unable to get a XAConnection from the DataSource
Connection error with WAS 5.1 and DB2 z/OS 8.2
java.lang.outofmemory
Connection Wait Timeout Exception:
Hide log error
More...