Broken Pipe Exception
355214Aug 25 2004 — edited Sep 2 2004I have an intranet web application that is currently being evaluated for production use. This servlet/JSP application uses Toplink for persistence and the Oracle thin driver. Toplink manages the connection pool.
I am seeing Broken Pipe exceptiops which seem to indicate that the connection pool cache is not being managed (ie connections lapse but are still being used by Toplink).
The error looks like:
Exception Description: java.sql.SQLException: Io exception: Broken pipe
Internal Exception: java.sql.SQLException: Io exception: Broken pipe
Error Code: 17002
at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseExce
ption.java:226)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.rollbackTrans
action(DatabaseAccessor.java:1398)
This is something we do not want to occur in production. Is there a standard Oracle and/or Toplink best practice to make sure that connections are valid? If I manually restart the application, the problem disappears. For a while.
Thanks,
Brad