Database Connection Problem (Broken Pipe)
Hello!
We're in the middle of Registration and our custom Java channel keeps losing the connection to our old ERP (Informix database). The connections to Banner and our SQL Server databases are just fine. We've been getting this error in catalina.out:
08/01/10 01:38:50
java.sql.SQLException: System or internal error java.net.SocketException: Broken pipe
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:424)
at com.informix.jdbc.IfxSqli.sendPrepare(IfxSqli.java:1162)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1078)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1820)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
at edu.biola.uportal.util.EasyQuery.runQueryWithException(EasyQuery.java:528)
at edu.biola.uportal.util.EasyQuery.runQuery(EasyQuery.java:611)
at edu.biola.uportal.channels.Register.Register.dbConnectionsOK(Register.java:156)
at edu.biola.uportal.channels.Register.Register.generateChannelHTML(Register.java:84)
at edu.biola.uportal.channels.Register.Register.createContent(Register.java:36)
at edu.biola.uportal.util.BiolaBaseChannel.renderXML(BiolaBaseChannel.java:97)
at campuspipeline.uportal.ScheduledChannelRenderer$ScheduledWorker.run(ScheduledChannelRenderer.java:974)
at com.pipeline.uportal.ChannelRendererTaskInterceptor$1.run(ChannelRendererTaskInterceptor.java:154)
at java.security.AccessController.doPrivileged(Native Method)
at com.pipeline.uportal.ChannelRendererTaskInterceptor.run(ChannelRendererTaskInterceptor.java:138)
at campuspipeline.uportal.ScheduledChannelRenderer$ScheduledWorker.execute(ScheduledChannelRenderer.java:1108)
at campuspipeline.util.concurrent.ThreadPoolExecutor$ThreadPoolTask.execute(ThreadPoolExecutor.java:422)
at campuspipeline.util.concurrent.ThreadPoolExecutor$LimitedExecutorTask.run(ThreadPoolExecutor.java:493)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Has anyone encountered this error before? Does anyone know of a solution? Thanks in advance!
Yi
Connection issues
Have you tried restarting your tiers? There may be a stale connection.
Hello!
Yes, we have restarted our portal tiers. We also have them set to restart every morning. That does clear up the problem, but it keeps reoccurring intermittently throughout the day. I'm not sure how to prevent it from reoccurring.