472,352 Members | 1,505 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

home > topics > db2 database > questions > com.ibm.db2.jdbc.db2exception: [ibm][cli driver] sql30081n communication error on db2/portal on aix

Join Bytes to post your question to a community of 472,352 software developers and data experts.

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_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
1 8852

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
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
Severe Problem using JDBC PreparedStatement with IBM DB2 Universal JDBC Driver as Type 4
by: Dani | last post by:
Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When...
DB2 Database
0
DB2 v 8.1 universal JDBC Driver Weird behavior in WSAD 5.1.x and WAS 5.0.2
by: Bing | last post by:
Hi, I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x...
DB2 Database
2
DB2 Universal JDBC Driver and {fn CURDATE()}
by: charl | last post by:
Hi, My apologies in advance if my terminology is slightly confused, I am new to all this. We have previously been running some SQL on DB2 (v7)...
DB2 Database
10
[IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001
by: joel.brewster | last post by:
We have a VB6 application using ADO version 2.5 and I am receiving a " CLI0109E String data right truncation. SQLSTATE=22001" error when I execute...
DB2 Database
2
Error: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010 while using ADO
by: PA | last post by:
Hi All, Thanks for your attention..I appreciate that. -----Problem description -----------Start---------------------- Database : DB2 UDB 8.2...
DB2 Database
9
[IBM][JDBC Driver] CLI0601E
by: Roger | last post by:
Hi ! My dev team is getting this error when they run big load program : COM.ibm.db2.jdbc.DB2Exception: CLI0601E Invalid statement handle or...
DB2 Database
1
Cannot create JDBC driver of class 'COM.ibm.db2.jdbc.app.DB2Driver'
by: rpm45tech | last post by:
Hi everyone. I'm deveolping in Java with DB2 running on Win XP and everything was working ok but then I installed Vista Ultimate and the application...
Java
7
IBM DB2 JDBC Driver CallableStatement update count
by: Otto Carl Marte | last post by:
Hi, When using a CallableStatement with the IBM DB2 Universal JDBC Driver the executeUpdate and getUpdateCount() methods on CallableStatement...
DB2 Database
8
DB2 JDBC driver problem
by: cwhankey | last post by:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC driver, but I'm getting this error: com.ibm.db2.jcc.b.DisconnectException:...
DB2 Database
1
Benefits of Blockchain App Development for Enterprise Businesses
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
General
0
jalbright99669
https redirect with reverse proxy
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
IIS / Internet Information Server
2
How to use http requests (Get function) to get variable value?
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
Python
0
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
General
0
How do I view Redshift db tables in Alteryx
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
General
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
General
0
PHP Curl Not wanting to connect to localhost.
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
PHP
0
BLUEPANDA
Join our open community on Discord to learn programming, SEO, and marketing
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
General
0
Mastering Python: A Versatile Programming Language for All
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...
General

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2023
About Bytes
Advertise
Terms Of Use
Privacy Policy

Sitemap

Follow us! Get the Latest Bytes Updates