Re: WSAD 5.1.2 - DB2 DSRA8100E: Unable to get a XAConnection from the DataSource
BoomerangThree
This typically indicates that your data source in the servers *.wsi file is
incorrect or missing something.
In an application that I have, I have, in the JDBC Provider List I have an
entry that uses the com.ibm.db2j.jdbc.DB2jXADataSource.
Associated with the JDBC entry is an entry in the Data Source that
references the JNDI name. The parms in this entry are for the most part
self explanatory, make sure you have the JAAS Authentication Entry created
so you can select it.
Then associated with JDBC entry is a Resource Properties entries, such as
sever, ect...
Also be sure to create a JAAS Authentication Entry in the servers *.wsi
file, Security tab.
Perhaps this will at least get you to the next step.
"Per" <perlov...@hotmail.com> wrote in message
news:c2fe9d18.0503...@posting.google.com...
> WSAD 5.1.2 - DB2 DSRA8100E: Unable to get a XAConnection from the
> DataSource
> ============================================================================
> When trying to retrive a XA-connection using a datasource version, I
> get an exception. See below
> (I have DB2 Connect installed)
>
>
> Info:
> ----
> Operating system = Windows 2000
> IDE = WSAD 5.1.2
> Database type = Ibm DB2
> Jdbc provider type = DB2 Legacy CLI-based Type 2 JDBC Driver (XA)
> Implementation class name = COM.ibm.db2.jdbc.DB2XADataSource
> Jdbc driver = db2java.zip
> datasource version = 5
>
> Exception:
> 2005-03-30 23:55:39:059 CEST] 387c0a6d SystemOut O
> TestDataSource:dataSource
> com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource@6a64ca4e
> [2005-03-30 23:55:40:532 CEST] 387c0a6d FreePool E J2CA0046E:
> Method createManagedConnctionWithMCWrapper caught an exception during
> creation of the ManagedConnection for resource sid/sidDB_XA, throwing
> ResourceAllocationException. Original exception:
> com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a
> XAConnection from the DataSource.
> at
> com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:244)
> at
> com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:171)
> at
> com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:208)
> at
> com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:777)
> at
> com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:641)
> at
> com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:726)
> at
> com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1281)
> at
> com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1065)
> at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1603)
> at
> com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:677)
> at
> com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:461)
> at
> com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:217)
> at
> com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:192)
> at TestDataSource.doSelect(TestDataSource.java:60)
> at TestDataSource.doGet(TestDataSource.java:26)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
> at
> com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
> at
> com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
> at
> com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
> at
> com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
> at
> com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
> at
> com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
> at
> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
> at
> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
> at
> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
> at
> com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
> at
> com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
> at
> com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
> at
> com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
> at
> com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
> at
> com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
> at
> com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
> Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1032N
> Inget kommando för att starta databasen har getts. SQLSTATE=57019
>
> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown
> Source)
> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown
> Source)
> at COM.ibm.db2.jdbc.app.DB2Connection.connect(Unknown Source)
> at COM.ibm.db2.jdbc.app.DB2Connection.<init>(Unknown Source)
> at COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>(Unknown Source)
> at COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(Unknown Source)
> at COM.ibm.db2.jdbc.DB2XAConnection.<init>(Unknown Source)
> at COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(Unknown Source)
> at COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(Unknown Source)
> at
> com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:759)
> at
> com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:111)
> at
> com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:754)
> ... 32 more
> ---- Begin backtrace for nested exception
> COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1032N Inget
> kommando för att starta databasen har getts. SQLSTATE=57019
>
> at CO
