DB2 StaleConnectionException

[Girish Patil]

Hi All,

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)