f



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

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_SQLException(SQLExceptionGenerator.java(Compiled
Code))
	at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled
Code))
	at
COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java(Compiled
Code))
	at
COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.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>(DB2XAConnection.java(Compiled
Code))
	at
COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(DB2XADataSource.java(Compiled
Code))
	at
COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(DB2XADataSource.java:79)
	at
com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:851)
	at java.security.AccessController.doPrivileged(Native Method)
	at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java(Compiled
Code))
	at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java(Compiled
Code))
	at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled
Code))
	at
com.ibm.wps.services.datastore.DataStoreServiceImpl.getConnectionInternal(DataStoreServiceImpl.java(Inlined
Compiled Code))
	at
com.ibm.wps.services.datastore.DataStoreServiceImpl.getConnection(DataStoreServiceImpl.java(Compiled
Code))
	at
com.ibm.wps.services.datastore.DataStore.getConnection(DataStore.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.DataStoreContext.init(DataStoreContext.java(Compiled
Code))
	at
com.ibm.wps.datastore.core.DataStoreContext.init(DataStoreContext.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.BasePersister.findInternal(BasePersister.java(Compiled
Code))
	at
com.ibm.wps.datastore.core.BasePersister.findInternal(BasePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.BasePersister.findAllInternal(BasePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.PageInstancePersister.findAll(PageInstancePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.PageInstance.findAll(PageInstance.java(Compiled
Code))
	at java.lang.reflect.Method.invoke(Native Method)
	at
com.ibm.wps.services.registry.ReloadableBucket.reloadInternal(ReloadableBucket.java(Compiled
Code))
	at
com.ibm.wps.services.registry.ReloadableBucket.reload(ReloadableBucket.java(Compiled
Code))
	at
com.ibm.wps.services.registry.RegistryServiceImpl.reload(RegistryServiceImpl.java(Compiled
Code))
	at com.ibm.wps.util.UpdateTrigger.run(UpdateTrigger.java: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.createManagedConnectionWithMCWrapper(FreePool.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java(Compiled
Code))
	at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java(Compiled
Code))
	at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled
Code))
	at
com.ibm.wps.services.datastore.DataStoreServiceImpl.getConnectionInternal(DataStoreServiceImpl.java(Inlined
Compiled Code))
	at
com.ibm.wps.services.datastore.DataStoreServiceImpl.getConnection(DataStoreServiceImpl.java(Compiled
Code))
	at
com.ibm.wps.services.datastore.DataStore.getConnection(DataStore.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.DataStoreContext.init(DataStoreContext.java(Compiled
Code))
	at
com.ibm.wps.datastore.core.DataStoreContext.init(DataStoreContext.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.BasePersister.findInternal(BasePersister.java(Compiled
Code))
	at
com.ibm.wps.datastore.core.BasePersister.findInternal(BasePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.BasePersister.findAllInternal(BasePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.PageInstancePersister.findAll(PageInstancePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.PageInstance.findAll(PageInstance.java(Compiled
Code))
	at java.lang.reflect.Method.invoke(Native Method)
	at
com.ibm.wps.services.registry.ReloadableBucket.reloadInternal(ReloadableBucket.java(Compiled
Code))
	at
com.ibm.wps.services.registry.ReloadableBucket.reload(ReloadableBucket.java(Compiled
Code))
	at
com.ibm.wps.services.registry.RegistryServiceImpl.reload(RegistryServiceImpl.java(Compiled
Code))
	at com.ibm.wps.util.UpdateTrigger.run(UpdateTrigger.java: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.DataStoreAdapterException.<init>(DataStoreAdapterException.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java(Compiled
Code))
	at
com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java(Compiled
Code))
	at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java(Compiled
Code))
	at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled
Code))
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled
Code))
	at
com.ibm.wps.services.datastore.DataStoreServiceImpl.getConnectionInternal(DataStoreServiceImpl.java(Inlined
Compiled Code))
	at
com.ibm.wps.services.datastore.DataStoreServiceImpl.getConnection(DataStoreServiceImpl.java(Compiled
Code))
	at
com.ibm.wps.services.datastore.DataStore.getConnection(DataStore.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.DataStoreContext.init(DataStoreContext.java(Compiled
Code))
	at
com.ibm.wps.datastore.core.DataStoreContext.init(DataStoreContext.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.BasePersister.findInternal(BasePersister.java(Compiled
Code))
	at
com.ibm.wps.datastore.core.BasePersister.findInternal(BasePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.core.BasePersister.findAllInternal(BasePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.PageInstancePersister.findAll(PageInstancePersister.java(Inlined
Compiled Code))
	at
com.ibm.wps.datastore.PageInstance.findAll(PageInstance.java(Compiled
Code))
	at java.lang.reflect.Method.invoke(Native Method)
	at
com.ibm.wps.services.registry.ReloadableBucket.reloadInternal(ReloadableBucket.java(Compiled
Code))
	at
com.ibm.wps.services.registry.ReloadableBucket.reload(ReloadableBucket.java(Compiled
Code))
	at
com.ibm.wps.services.registry.RegistryServiceImpl.reload(RegistryServiceImpl.java(Compiled
Code))
	at com.ibm.wps.util.UpdateTrigger.run(UpdateTrigger.java:85)

0
Praveen
9/21/2005 8:01:28 AM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

1 Replies
1584 Views

Similar Articles

[PageSpeed] 16

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

0
chrisg
9/21/2005 1:13:46 PM
Reply: