This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes WebLogic & Informix Broken Pipe Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "WebLogic & Informix Broken Pipe Exception" Watch "WebLogic & Informix Broken Pipe Exception" New topic
Author

WebLogic & Informix Broken Pipe Exception

Luis Eduardo Salgado
Greenhorn

Joined: Feb 01, 2008
Posts: 2
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

Joined: Jul 08, 2004
Posts: 531

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.


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Luis Eduardo Salgado
Greenhorn

Joined: Feb 01, 2008
Posts: 2
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

Joined: Oct 15, 2001
Posts: 5371
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.


"Thanks to Indian media who has over the period of time swiped out intellectual taste from mass Indian population." - Chetan Parekh
Rob Rutherford
Greenhorn

Joined: Jan 13, 2004
Posts: 1
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.


Rob Rutherford<br /> <br />SCJP, SCBCD, SCWCD, ICED
 
jQuery in Action, 2nd edition
 
subject: WebLogic & Informix Broken Pipe Exception
 
Similar Threads
RMI and broken pipe exception
java.net.SocketException: Broken pipe
Issue with WeblogicServer
PipedInputStream connection to PipedOutputStream problem!
Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web