What is a Broken pipe SQLException?

Solution Verified - Updated -

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 4.x
    • 5.x
    • 6.x

Issue

  • What does sql.SQLException: Io exception: Broken pipe mean?
  • Following error found in logs :
[Thread-10] ERROR jta.AppServerJDBCXARecovery - AppServerJDBCXARecovery.createConnection got exception java.sql.SQLException: Io exception: Broken pipe
  • In EAP 6, Connection with Oracle gets broken up and Following error message in logs. 
ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/XYZ].[XYZ]] (ajp-/xx.xx.xx.xx:4009-181) Servlet.service() for servlet XYZ threw exception: java.sql.SQLException: Io exception: Broken pipe
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) [ojdbc14.jar:"Oracle JDBC Driver version - 9.0.2.0.0"]
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) [ojdbc14.jar:"Oracle JDBC Driver version - 9.0.2.0.0"]
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) [ojdbc14.jar:"Oracle JDBC Driver version - 9.0.2.0.0"]
    at oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:1260) [ojdbc14.jar:"Oracle JDBC Driver version - 9.0.2.0.0"]
    at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371) [commons-dbcp-1.4.jar:1.4]
    at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328) [commons-dbcp-1.4.jar:1.4]

. . . .

Resolution

  • The java.sql.SQLException: Io exception: Broken pipe message is due to an external interruption in the communication between the application server and the service it is communicating with. Availability of the service at the time of the interruption needs to be determined as well as checking for network and/or firewall issues.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.