This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Stale Connection Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stale Connection Exception" Watch "Stale Connection Exception" New topic
Author

Stale Connection Exception

Mariam Vinod
Greenhorn

Joined: Jun 21, 2006
Posts: 2
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: jdbcracle: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:jdbcracle: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.)
Vinay Raj
Ranch Hand

Joined: Jun 19, 2006
Posts: 81
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

Joined: Jun 21, 2006
Posts: 2
Thanks Very much
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stale Connection Exception
 
Similar Threads
WSAD and data source
WSAD datasource connection problem to AS400
Jar file
Help-can seem to connect to an AS400 datasource from WSAD test environment
2 Dimensional Arrays / Loop problem....