File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Joined: Apr 24, 2007
Nov 04, 2008 01:08:00
I am getting following exception when I am trying to connect to DB2 database.
I have created a datasource on WAS 6.0. Its showing me connection successful from WAS admin console. But when I am running the application, its giving following exception :
11/4/08 10:31:06:018 IST] 0000002c StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -30081 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: [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: "". Communication function detecting the error: "gethostbyname". Protocol specific error code(s): "*", "11004", "*". SQLSTATE=08001 DSRA0010E: SQL State = 08001, Error Code = -30,081 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Connection.connect(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Connection.<init>(Unknown Source) at COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>(Unknown Source) at COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(Unknown Source)
I agree. Here's the link:
subject: DB2 StaleConnectionException
StaleConnectionException -WebSphere Connection Pool
DB2 Setup in Weblogic5.1/6.1
Connect to DB2 using WAS Datasource- StaleConnection,ErrorCode -30,081,SQLState40003
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015