java.net.SocketException: Broken pipe

[Bharat Nagwani <bn...@juniper.net>]

Hi Guys,

 

I am using mysql-connector-java-3.1.12-bin.jar and mysql 4.

 

database.properties

url=....... ?autoReconnect=true

 

SQLMapConfig.xml

  <transactionManager type="JDBC">

    <dataSource type="SIMPLE">

      <property value="${driver}" name="JDBC.Driver"/>

      <property value="${url}" name="JDBC.ConnectionURL"/>

      <property value="${username}" name="JDBC.Username"/>

      <property value="${password}" name="JDBC.Password"/>

      <property name="JDBC.DefaultAutoCommit" value="true" />

      <property name="Pool.TimeToWait" value="500"/>

     <property name="Pool.PingQuery" value="select @@VERSION"/>

     <property name="Pool.PingEnabled" value="true"/>

<property name="Pool.PingConnectionsOlderThan"  value="3600000"/>

<property name="Pool.PingConnectionsNotUsedFor" value="3600000"/>

 

      <property name="Pool.MaximumActiveConnections" value="10"/>

    <property name="Pool.MaximumIdleConnections"   value="5"/>

    </dataSource>

  </transactionManager>

 

I am getting this exception every day and I have to restart the server.

 

java.net.SocketException

MESSAGE: Broken pipe

 

STACKTRACE:

 

java.net.SocketException: Broken pipe

        at java.net.SocketOutputStream.socketWrite0(Native Method)

        at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

        at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)

        at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)

        at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)

        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)

        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)

        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
936)

        at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)

        at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.
java:180)

        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQu
ery(GeneralStatement.java:205)

        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:173)

        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForObject(GeneralStatement.java:104)

        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlM
apExecutorDelegate.java:561)

        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlM
apExecutorDelegate.java:536)

        at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSes
sionImpl.java:93)

        at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClie
ntImpl.java:70)