Re: [Proxool-user] Connection automatically removed

[Bill H. <bi...@lo...>]

Hi Ezio,

You'll need to change the *maximum-active-time* to something greater than
the default 300 seconds. (Note: the doc says default is 5 minutes but fails
to mention that the unit is seconds).

See http://proxool.sourceforge.net/properties.html

-
Bill

2009/9/1 Ezio Pontiggia <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:2022)
>
>  at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
>
>  at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
>
>  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
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Proxool-user mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-user
>
>