OpenEdge JDBC connection problems

[stevej]

Hi,

We're getting intermittent connection errors using a Linux client to connect to a Windows OpenEdge 10.1A server. The client is running a web application in Tomcat, and maybe one in every 30-40 connections drops out part way throught with either of the messages:

java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Broken pipe
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Connection reset

It sounds like a network problem between the client and server, but it only seems to affect the OpenEdge connections. Other connections between client and server work fine.

Has anyone ever seen this issue? Does anyone know of a way to turn on more logging to try and track down the cause?

Here's the relevant part of a stacktrace:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Connection reset
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.describeProcessReply(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.describe(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.execute(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
...

 

[stevej]

We had a custom cache of PreparedStatement objects that would be reused throughout the application. Removing this seems to have fixed the issues. This is a bit strange since:
1 - the same code worked in Progress 9.1D, and
2 - the errors were not confined to PreparedStatement calls.

- steve