By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,611 Members | 1,642 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,611 IT Pros & Developers. It's quick & easy.

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N communication error on DB2/POrtal on AIX

P: n/a
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)

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Praveen wrote:
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


78 is ETIMEDOUT. Are you attempting to connect through a firewall?

Look in /usr/include/sys/errno.h for all of the error numbers that will
be displayed in the DB2 error response.

79 is another common one.

-Chris

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.