Praveen
Hi,
I have installed WebSphere Portal on AIX and connected to DB2 on a
remote machine, Getting the followin errors when trying to get the
values from database thru applications installed on Portal.
Any Help Appreciated.
Thanks in advance.
Praveen Singh
IBM Workplace, India
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N A
communication error has been detected. Communication protocol being
used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "9.33.12.221". Communication function
detecting the error: "connect". Protocol specific error code(s): "78",
"*", "*". SQLSTATE=08001
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java(Compiled
Code))
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java(Compiled
Code))
at
COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Conn ection.java(Compiled
Code))
at
COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Conne ction.java(Compiled
Code))
at
COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>( DB2ReusableConnection.java(Inlined
Compiled Code))
at
COM.ibm.db2.jdbc.DB2PooledConnection.getConnection (DB2PooledConnection.java(Compiled
Code))
at
COM.ibm.db2.jdbc.DB2XAConnection.<init>(DB2XAConne ction.java(Compiled
Code))
at
COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(D B2XADataSource.java(Compiled
Code))
at
COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(D B2XADataSource.java:79)
at
com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(D SConfigurationHelper.java:851)
at java.security.AccessController.doPrivileged(Native Method)
at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPool edConnection(DSConfigurationHelper.java(Compiled
Code))
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooled Connection(WSRdbDataSource.java(Compiled
Code))
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.FreePool.createManaged ConnectionWithMCWrapper(FreePool.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitF orConnection(FreePool.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(Po olManager.java(Compiled
Code))
at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java(Compiled
Code))
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled
Code))
at
com.ibm.wps.services.datastore.DataStoreServiceImp l.getConnectionInternal(DataStoreServiceImpl.java( Inlined
Compiled Code))
at
com.ibm.wps.services.datastore.DataStoreServiceImp l.getConnection(DataStoreServiceImpl.java(Compiled
Code))
at
com.ibm.wps.services.datastore.DataStore.getConnec tion(DataStore.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.DataStoreContext.init(D ataStoreContext.java(Compiled
Code))
at
com.ibm.wps.datastore.core.DataStoreContext.init(D ataStoreContext.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.BasePersister.findInter nal(BasePersister.java(Compiled
Code))
at
com.ibm.wps.datastore.core.BasePersister.findInter nal(BasePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.BasePersister.findAllIn ternal(BasePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.PageInstancePersister.findAl l(PageInstancePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.PageInstance.findAll(PageIns tance.java(Compiled
Code))
at java.lang.reflect.Method.invoke(Native Method)
at
com.ibm.wps.services.registry.ReloadableBucket.rel oadInternal(ReloadableBucket.java(Compiled
Code))
at
com.ibm.wps.services.registry.ReloadableBucket.rel oad(ReloadableBucket.java(Compiled
Code))
at
com.ibm.wps.services.registry.RegistryServiceImpl. reload(RegistryServiceImpl.java(Compiled
Code))
at com.ibm.wps.util.UpdateTrigger.run(UpdateTrigger.j ava:85)
[9/20/05 13:54:32:257 CDT] 824547c ConnectionMan E J2CA0020E: The
Connection Pool Manager could not allocate a Managed Connection:
javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to
get a {0} from the DataSource.
at
com.ibm.ejs.j2c.poolmanager.FreePool.createManaged ConnectionWithMCWrapper(FreePool.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitF orConnection(FreePool.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(Po olManager.java(Compiled
Code))
at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java(Compiled
Code))
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled
Code))
at
com.ibm.wps.services.datastore.DataStoreServiceImp l.getConnectionInternal(DataStoreServiceImpl.java( Inlined
Compiled Code))
at
com.ibm.wps.services.datastore.DataStoreServiceImp l.getConnection(DataStoreServiceImpl.java(Compiled
Code))
at
com.ibm.wps.services.datastore.DataStore.getConnec tion(DataStore.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.DataStoreContext.init(D ataStoreContext.java(Compiled
Code))
at
com.ibm.wps.datastore.core.DataStoreContext.init(D ataStoreContext.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.BasePersister.findInter nal(BasePersister.java(Compiled
Code))
at
com.ibm.wps.datastore.core.BasePersister.findInter nal(BasePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.BasePersister.findAllIn ternal(BasePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.PageInstancePersister.findAl l(PageInstancePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.PageInstance.findAll(PageIns tance.java(Compiled
Code))
at java.lang.reflect.Method.invoke(Native Method)
at
com.ibm.wps.services.registry.ReloadableBucket.rel oadInternal(ReloadableBucket.java(Compiled
Code))
at
com.ibm.wps.services.registry.ReloadableBucket.rel oad(ReloadableBucket.java(Compiled
Code))
at
com.ibm.wps.services.registry.RegistryServiceImpl. reload(RegistryServiceImpl.java(Compiled
Code))
at com.ibm.wps.util.UpdateTrigger.run(UpdateTrigger.j ava:85)
---- Begin backtrace for Nested Throwables
com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a {0} from
the DataSource.
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.<init>(DataStoreAdapterException.java(Comp iled
Code))
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.<init>(DataStoreAdapterException.java(Comp iled
Code))
at
com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAd apterException(AdapterUtil.java(Compiled
Code))
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooled Connection(WSRdbDataSource.java(Compiled
Code))
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.FreePool.createManaged ConnectionWithMCWrapper(FreePool.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitF orConnection(FreePool.java(Compiled
Code))
at
com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(Po olManager.java(Compiled
Code))
at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java(Compiled
Code))
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled
Code))
at
com.ibm.wps.services.datastore.DataStoreServiceImp l.getConnectionInternal(DataStoreServiceImpl.java( Inlined
Compiled Code))
at
com.ibm.wps.services.datastore.DataStoreServiceImp l.getConnection(DataStoreServiceImpl.java(Compiled
Code))
at
com.ibm.wps.services.datastore.DataStore.getConnec tion(DataStore.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.DataStoreContext.init(D ataStoreContext.java(Compiled
Code))
at
com.ibm.wps.datastore.core.DataStoreContext.init(D ataStoreContext.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.BasePersister.findInter nal(BasePersister.java(Compiled
Code))
at
com.ibm.wps.datastore.core.BasePersister.findInter nal(BasePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.core.BasePersister.findAllIn ternal(BasePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.PageInstancePersister.findAl l(PageInstancePersister.java(Inlined
Compiled Code))
at
com.ibm.wps.datastore.PageInstance.findAll(PageIns tance.java(Compiled
Code))
at java.lang.reflect.Method.invoke(Native Method)
at
com.ibm.wps.services.registry.ReloadableBucket.rel oadInternal(ReloadableBucket.java(Compiled
Code))
at
com.ibm.wps.services.registry.ReloadableBucket.rel oad(ReloadableBucket.java(Compiled
Code))
at
com.ibm.wps.services.registry.RegistryServiceImpl. reload(RegistryServiceImpl.java(Compiled
Code))
at com.ibm.wps.util.UpdateTrigger.run(UpdateTrigger.j ava:85)
| 
