WebLogic & Informix Broken Pipe Exception

[Luis Eduardo Salgado]

Hello everybody:

I have a problem with my application wich uses a JWS and make a connection to a JNDI context wich is on WebLogic 8 to get a Data Source.

An exception is thrown while trying to open a Data Source from the Informix ACE database and show next:

####<Jan 31, 2008 12:45:44 PM EST> <Error> <ACECredentials.jws> <testls62.icallinc.com> <testls62> <ExecuteThread: '3' for queue: 'weblogic.kernel.Default'> <<anonymous>> <BEA1-5B1B05D7AE4C> <000000> <System or internal error java.net.SocketException: Broken pipe>

Informix Drivers are next: IBM Informix Dynamic Server Version 10.00.FC4

Somebody told me it could be that drivers are not be found and cut conecction, but it only happends a few times.

Can somebody give me a clue about this?

I'm stock and any help could be great.

Thank you in advance....

[Masoud Kalali]

Hi
It might be because the host OS close the socket when your connections which resides in connection pool are not aware of this.
If you could post a complete stack trace, it could be easier to provide you with a more accurate answer.

Thanks.

[Luis Eduardo Salgado]

Well this happened today and shows this stack trace:


java.sql.SQLException: System or internal error java.net.SocketException: Write failed: Broken pipe
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:421)
at com.informix.jdbc.IfxSqli.sendPrepare(IfxSqli.java:1099)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1236)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1210)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:226)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:758)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:141)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)

[R K Singh]

check following:

http://albertguo.blogspot.com/2005/09/troubleshooing-bea-101083_112658492367851075.html

http://forums.bea.com/thread.jspa?messageID=200058769

It is harmless message.

[Rob Rutherford]

Luis Eduardo Salgado wrote:Well this happened today and shows this stack trace:


java.sql.SQLException: System or internal error java.net.SocketException: Write failed: Broken pipe
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:421)
at com.informix.jdbc.IfxSqli.sendPrepare(IfxSqli.java:1099)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1236)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1210)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:226)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:758)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:141)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)

It happens when there is a schema change on the database side.

Solution: bounce WebLogic.