This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WSAD DatastoreAdapterException

 
Rajasangeetha Rajakantham
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I am using WSAD 5.1 with SQL 2000 backend. In server setup I have configured data source with driver name, server name, IP address and port number. All details are same with my SQL server. Application server started successfully. But while executing any java code which is getting connection from the database server I am getting the following exception.



[1/26/06 15:53:43:854 IST] 1e52c14a WebGroup I SRVE0180I: [SafeSend] [/SafeSend] [Servlet.LOG]: SafeSendBatchServlet: init
[1/26/06 15:53:44:746 IST] 72ae4148 SystemOut O Fornoon
[1/26/06 15:53:45:310 IST] 72ae4148 ConnectionFac I J2CA0122I: Resource reference jdbc/safeSendDS could not be located, so default values of the following are used: [Resource-ref settings]

res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[Other attributes]

isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)

[1/26/06 15:53:45:404 IST] 72ae4148 ConnectionMan W J2CA0075W: An active transaction should be present while processing method allocateMCWrapper.
[1/26/06 15:53:46:171 IST] 72ae4148 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/safeSendDS, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection 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:191)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:694)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:440)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:566)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1244)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1030)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:658)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
at com.ba.ss.db.Query.getConnection(Query.java:82)
at com.ba.ss.db.Query.fetchHoliday(Query.java:4728)
at com.ba.ss.bser.LM.validater(LM.java:752)
at com.ba.ss.bser.LM.exec(LM.java:229)
at com.ba.ss.servlet.BT.run(BT.java:126)
at java.lang.Thread.run(Thread.java:513)
---- Begin backtrace for nested exception
java.sql.SQLException: [IBM][SQLServer JDBC Driver]Error establishing socket. Cannot assign requested address: connect
at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ibm.websphere.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.ibm.websphere.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.open(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseDataSource.getBaseConnection(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseDataSource.getPooledConnection(Unknown Source)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:676)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:671)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:440)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:566)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1244)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1030)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:658)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
at com.ba.ss.db.Query.getConnection(Query.java:82)
at com.ba.ss.db.Query.fetchHoliday(Query.java:4728)
at com.ba.ss.bser.LM.validate(LM.java:752)
at com.ba.ss.bser.LM.execute(LM.java:229)
at com.ba.ss.servlet.BT.run(BT.java:126)
at java.lang.Thread.run(Thread.java:513)
Next Linked Exception:
java.sql.SQLException: [IBM][SQLServer JDBC Driver]Error establishing socket. Cannot assign requested address: connect
at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ibm.websphere.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.ibm.websphere.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.open(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseDataSource.getBaseConnection(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseDataSource.getPooledConnection(Unknown Source)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:676)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:671)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:440)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:566)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1244)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1030)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:658)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
at com.ba.ss.db.Query.getConnection(Query.java:82)
at com.ba.ss.db.Query.fetchHoliday(Query.java:4728)
at com.ba.ss.bser.LM.validate(LM.java:752)
at com.ba.ss.bser.LM.execute(LM.java:229)
at com.ba.ss.servlet.BT.run(BT.java:126)
at java.lang.Thread.run(Thread.java:513)

[1/26/06 15:53:46:452 IST] 72ae4148 ConnectionMan E J2CA0020E: The Connection Pool Manager could not allocate a Managed Connection: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource.
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1282)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1030)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:658)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
at com.ba.ss.db.Query.getConnection(Query.java:82)
at com.ba.ss.db.Query.fetchHoliday(Query.java:4728)
at com.ba.ss.bser.LM.validate(LM.java:752)
at com.ba.ss.bser.LM.execute(LM.java:229)
at com.ba.ss.servlet.BT.run(BT.java:126)
at java.lang.Thread.run(Thread.java:513)
---- Begin backtrace for Nested Throwables
java.sql.SQLException: [IBM][SQLServer JDBC Driver]Error establishing socket. Cannot assign requested address: connect
at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ibm.websphere.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.ibm.websphere.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.ibm.websphere.jdbc.base.BaseConnection.open(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseDataSource.getBaseConnection(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseDataSource.getPooledConnection(Unknown Source)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:676)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:671)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:440)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:566)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1244)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1030)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:658)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
at com.ba.ss.db.Query.getConnection(Query.java:82)
at com.ba.ss.db.Query.fetchHoliday(Query.java:4728)
at com.ba.ss.bser.LM.validate(LM.java:752)
at com.ba.ss.bser.LM.execute(LM.java:229)
at com.ba.ss.servlet.BT.run(BT.java:126)
at java.lang.Thread.run(Thread.java:513)


If anybody knows the solution please reply.


Regards,
Sangeetha
 
Scott Selikoff
author
Saloon Keeper
Posts: 4010
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First question, have you tested the database connection in the application server using the test connection function? Second, is this an XA datasource? Other than that, you might have a configuration error in your pool manager of your admin console.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic