• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Stale Connection Exception

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

The below exception is comming from both Oralce and AS40. My Application run fine if it is restarted. Currently the application is running on AIX, WAS4.0 and Java 1.2 is used to develop.
After a few days, suddely the Application gets hung and stops functioning and when I see the Log Files I get the below error. Iam not able to figure it out.
Please let e know why this error comes and how to fix and What is the reason for this error.
Can Anybody Please help me.

From Oracle Connectivity log file
Wed Jun 14 18:03:30 MST 2006: ConnectionPool: connectionReaper: checking if connection is stale
Wed Jun 14 18:03:30 MST 2006: ConnectionPool: is connection stale
Wed Jun 14 18:03:30 MST 2006: ConnectionPool: isConnectionStale: connectionStalenessTime returning true
Wed Jun 14 18:03:30 MST 2006: ConnectionPool: isConnectionPool: stale = true
Wed Jun 14 18:03:30 MST 2006: ConnectionPool: connectionReaper: connection is stale
Wed Jun 14 18:03:30 MST 2006: ConnectionPool: removeFromPool: jdbcracle:thin:@199.64.106.75:1521:BNDXPRDNo ::0
Wed Jun 14 18:03:48 MST 2006: Refreshing connection: Initial Size: = 1
Wed Jun 14 18:03:48 MST 2006: ConnectionPool: i=0 con=com.honeywell.connectionmanager.JDBCConnection@35d44bbc
Wed Jun 14 18:03:48 MST 2006: ConnectionPool: removed element 0 from conn vector
Wed Jun 14 18:03:48 MST 2006: ConnectionPool: close of 0 completed: jdbc:oracle:thin:@199.64.106.75:1521:BNDXPRDConn.size()0
Wed Jun 14 18:03:48 MST 2006: Refreshing connection: size = 0
Wed Jun 14 18:03:48 MST 2006: ConnectionPool: addConnectionToPool: maxPoolSize = 25
Wed Jun 14 18:03:48 MST 2006: ConnectionPool: addConnectionToPool: minRequiredPoolSize = 0
Wed Jun 14 18:03:48 MST 2006: ConnectionPool: addConnectionToPool: additional connection to the pool
Wed Jun 14 18:03:48 MST 2006: ConnectionPool: addConnectionToPool(): additional connection to the pool:jdbc:oracle:thin:@199.64.106.75:1521:BNDXPRD Vector size=1
Wed Jun 14 18:03:48 MST 2006: Refreshing connection: After adding new con, size = 1
Wed Jun 14 18:06:01 MST 2006: ConnectionPool: removeFromPool: SQLException : java.sql.SQLException: Io exception: A remote host did not respond within the timeout period.: A remote host did not respond within the timeout period.


Error from the AS400 Connection Logs

ue Jun 13 19:03:31 MST 2006: Refreshing connection: After adding new con, size = 1
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: connectionReaper: minpoolsize=0 conn.size()=1
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: connectionReaper: checking if connection is stale
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: is connection stale
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: isConnectionStale: connectionStalenessTime returning true
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: isConnectionPool: stale = true
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: connectionReaper: connection is stale
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: removeFromPool: jdbc:as400://131.127.225.94;libraries=APIYLIBRNo ::0
Tue Jun 13 19:33:29 MST 2006: ConnectionPool: connectionReaper: all the connections are closed.
Tue Jun 13 19:33:31 MST 2006: Refreshing connection: Initial Size: = 0
Tue Jun 13 19:33:31 MST 2006: Refreshing connection: size = 0
Tue Jun 13 19:33:31 MST 2006: ConnectionPool: addConnectionToPool: maxPoolSize = 25
Tue Jun 13 19:33:31 MST 2006: ConnectionPool: addConnectionToPool: minRequiredPoolSize = 0
Tue Jun 13 19:33:31 MST 2006: ConnectionPool: addConnectionToPool: additional connection to the pool
Tue Jun 13 19:33:31 MST 2006: ConnectionPool: addConnectionToPool: SQLException : java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)jdbc:as400://131.127.225.94;libraries=APIYLIBR
Tue Jun 13 19:52:56 MST 2006: JDBCConnection: getConnection: pooling a new connection.
Tue Jun 13 19:52:56 MST 2006: ConnectionPool: getConnection: SQLException: java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)
Tue Jun 13 19:57:24 MST 2006: JDBCConnection: getConnection: pooling a new connection.
Tue Jun 13 19:57:24 MST 2006: JDBCConnection: getConnection: using new connection #: jdbc:as400://131.127.225.94;libraries=API
YLIBRNo:0
Tue Jun 13 19:57:24 MST 2006: JDBCConnection: getConnection: Size of the pool=1
Tue Jun 13 19:57:26 MST 2006: JDBCConnection: getConnection: reusing connection #0
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: connectionReaper: minpoolsize=0 conn.size()=1
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: connectionReaper: checking if connection is stale
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: is connection stale
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: isConnectionStale: connectionStalenessTime returning true
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: isConnectionPool: stale = true
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: connectionReaper: connection is stale
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: removeFromPool: jdbc:as400://131.127.225.94;libraries=APIYLIBRNo ::0
Tue Jun 13 20:03:29 MST 2006: ConnectionPool: connectionReaper: all the connections are closed.


Another Problem I have is I also find this error in one of the Log File
Here is the error details below. I would like to know when and y this error comes ad how to Fix it.
6/16/06 19:10:21:992 MST] 12b22d3 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)
[6/16/06 19:20:21:956 MST] 78a22f1 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)
[6/16/06 19:30:22:471 MST] 204de123 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)
[6/16/06 19:40:23:937 MST] 12b22d3 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)
[6/16/06 19:50:24:214 MST] 320da13f StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)
[6/16/06 20:00:24:258 MST] 204de123 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: The application requester cannot establish the connection.(A remote host refused an attempted connect operation.)
 
Ranch Hand
Posts: 81
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The reason why stale connections occur is explained in the following URL:
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/ae/udat_was4poolset.html

to get around them, refer the following URL:
http://wsdj.sys-con.com/read/43087.htm

I do not have a WAS 4.0 to verify but I do remember having a check box option to automatically clean up stale connections. From the logs it appears that this is already occuring.

You cannot completely avoid StaleConnections, you can however develop application code to handle it.
 
Mariam Vinod
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Very much
 
reply
    Bookmark Topic Watch Topic
  • New Topic