[Proxool-user] Connection automatically removed

[Ezio P. <Ezi...@at...>]

Hi,
I use proxool-0.9.1.jar and in my case I open a connection that needs to
make a lot of insert statement.
But after 5-6 minutes I receive this exception:

1-set-2009 16.15.55 org.logicalcobwebs.proxool.HouseKeeper sweep

AVVERTENZA: #0006 was active for 318203 milliseconds and has been
removed automaticaly. The Thread responsible was named 'Processor
iGLFRE.insertDB', but the last SQL it performed is unknown because the
trace property is not enabled.         
2009-09-01 16:15:55,141 | ERROR | ProcessorContextImpl | Error in
processor "iGLFRE.insertDB"

Error message: "Unmanaged Exception thrown."

 

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
link failure

 

Last packet sent to the server was 0 ms ago.

 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)

 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)

 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)

 at java.lang.reflect.Constructor.newInstance(Unknown Source)

 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

 at
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074
)

 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2873)

 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2763)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3299)

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

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

 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)

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

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:20
22)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:19
40)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:19
25)

 at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

 at java.lang.reflect.Method.invoke(Unknown Source)

 at
org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100
)

 at
org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:
57)

And every other statement, raise this exception:
java.sql.SQLException: Couldn't perform the operation prepareStatement:
You can't perform any operations on this connection. It has been
automatically closed by Proxool for some reason (see logs).
 
When I register my connection pool, I set only
proxool.maximum-connection-count, but I don't think that these configs
can affect it.
maximum-connection-lifetime must be 4 hour, right?
 
Thank you for any help,
Ezio