Java Database Connectivity (JDBC)

Hi All

Any thoughts on the following stacktrace ???

I am using Connection pooling to obtain connections, also I am checking if connection is not closed and not null before allocating the connection from the pool.

The problem disappeared when Tomcat container was restarted. Also if Tomcat was restarted using the Manager App. the problem persisted.


java.sql.SQLException: Io exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:184)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:226)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:339)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:509)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:524)
at
oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:211)
at
oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:873)

at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:767)
at
com.lexmark.dashboard.ShipmentDataSource.populate(ShipmentDataSource.java:48)
at
com.lexmark.dashboard.ShipmentChartServlet.writeOutput(ShipmentChartServlet.java:117)

at
com.lexmark.dashboard.ShipmentChartServlet.doGet(ShipmentChartServlet.java:43)
at
com.lexmark.dashboard.ShipmentChartServlet.doPost(ShipmentChartServlet.java:35)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)

at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:431)

at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:355)

at com.lexmark.dashboard.ShipmentServlet.doPost(ShipmentServlet.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)

at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)

at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:518)

at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)

at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)

at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequestHandler.java:215)

at
org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:194)
at java.lang.Thread.run(Thread.java:484)

Sincerely


Samson