Menu
▾
▴
#33 Don't destroy the connection plz!!
When I set maximum-connection-lifetime to 4 hours and minimum-connection-count to 10, we should have 10 connections keep available.
It is true!! But why all the connections are always destroyed and created after 30 seconds(house-keeping-sleep-time) when we do not use the connections.
It should be just keep connection, not yet?
Logged In: YES
user_id=91747
Originator: NO
Can you show me your configuration? Better still, the log output showing it being configured and it destroying the connections. And which version are you using?
You are right, Proxool shouldn't (and doesn't I believe) destroy connections every 30 seconds.
-
Bill
proxool.xml
Logged In: YES
user_id=1744167
Originator: YES
Dear Bill:
Thanks for your response~
My Version: 0.9.0RC2
My configuration as files attached.
And I can monitor from Database and Proxool Admin.
Both they show me that Proxool destroys connectoins every 30 seconds.
This is select v$session from database, and we can see LOGON_TIME changed every 30 seconds.
LOGON_TIME STATUS SID SERIAL# USERNAME MACHINE PROGRAM MODULE
1 2007/3/16 am 08:31:53 INACTIVE 58 7962 test test JDBC Thin Client
Regards,
Afat
File Added: proxool.xml
Logged In: YES
user_id=1744167
Originator: YES
File Added: web.xml
web.xml
Logged In: YES
user_id=91747
Originator: NO
Your configuration looks fine - you leave the maximum-connection-lifetime at its default of 4 hours. You have defined a house-keeping-test-sql though. If that fails then it would destroy every connection on each sweep. Can you confirm that the SQL is correct? You should see a log event saying why each connection is being destroyed and I suspect it is because the test SQL is failing.
Logged In: YES
user_id=1744167
Originator: YES
You are so smart!!
The SQL really fails at my database, and this should be the problem.
I will configure again. I will post after testing.
Logged In: YES
user_id=1744167
Originator: YES
Thanks a lot!!
It's really what the problem is.
I replace the default house-keeping-test-sql with "select sysdate from dual".
The default house-keeping-test-sql doesn't fit the Oracle database.
Maybe we could have some comments at Proxool pages-http://proxool.sourceforge.net/properties.html.