This is what documentation says...
<Quote>
StaleConnectionException
This exception (com.ibm.websphere.ce.cm.StaleConnectionException) indicates that the connection currently being held is no longer valid. This
can occur for numerous reasons, including:
The application fails to get a connectionbecause of a problem such as the database not being started. l
A connection is no longer usable because of a database failure. When an application tries to use a connection it previously obtained, the
connection is no longer valid. In this case, all connections currently in use by the application may prompt this exception.
l
The application using the connection has already called close() and then tries to use the connection again. l
The connection has been orphaned, andthe application tries to use the orphaned connection. l
The application tries to use a
JDBC resource, such as Statement, obtained on a now-stale connection. l
When application code catches StaleConnectionException, it should take explicit steps to handle the exception. StaleConnectionException extends
SQLException, so it can be thrown from any method that is declared to throw SQLException. The most common occasion for a
StaleConnectionException to be thrown is the first time a connection is used, just after it has been retrieved. Because connections are pooled, a
database failure is not detected until the operation immediately following its retrieval from the pool, which is the first time communication with the
database is attempted. It is only when a failure is detected thatthe connection is marked stale. StaleConnectionException occurs less often if each
method that accesses the database gets a new connection from the pool. Typically, this occurs because all connections currently allocatedto an
application are marked stale; the more connections the application has, the more connections can be stale.
Generally,when a StaleConnectionException is caught, the transaction in which the connection was involvedneeds to be rolled back and a new
transaction begun with a new connection.
</QUOTE>