• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WebLogic & Informix Broken Pipe Exception

 
Luis Eduardo Salgado
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author
Ranch Hand
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 5384
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic