the probem is when the connection opens a long time the pool conection that used hibernate for work dont close the broken conections.
What is the parameter of dbcp for close this connections.

When i start a application the console show:

AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@a84b47)
LogAbandoned: true
RemoveAbandoned: true
RemoveAbandonedTimeout: 60


The configuration of hibernate.cfg.xml is:

<property name="hibernate.connection.datasource">java:comp/env/jdbc/xxx</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.pool_size">100</property>
<property name="hibernate.statement_cache.size">100</property>
<property name="hibernate.dbcp.maxActive">100</property>
<property name="hibernate.dbcp.whenExhaustedAction">1</property>
<property name="hibernate.dbcp.maxWait">500</property>
<property name="hibernate.dbcp.maxIdle">10</property>
<property name="hibernate.dbcp.ps.maxActive">100</property>
<property name="hibernate.dbcp.ps.whenExhaustedAction">1</property>
<property name="hibernate.dbcp.ps.maxWait">500</property>
<property name="hibernate.dbcp.ps.maxIdle">100</property>



Hibernate version: 3.0


[b]Full stack trace of any exception that occurs:

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:66
)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)



[b]Name and version of the database you are using: mysql 4.1.1