#33 Don't destroy the connection plz!!

open-accepted
None
5
2007-03-16
2007-03-15
Afat
No

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?

Discussion

  • Bill Horsman
    Bill Horsman
    2007-03-16

    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

     
  • Bill Horsman
    Bill Horsman
    2007-03-16

    • assigned_to: nobody --> billhorsman
    • status: open --> open-accepted
     
  • Afat
    Afat
    2007-03-16

    proxool.xml

     
    Attachments
  • Afat
    Afat
    2007-03-16

    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

     
  • Afat
    Afat
    2007-03-16

    Logged In: YES
    user_id=1744167
    Originator: YES

    File Added: web.xml

     
  • Afat
    Afat
    2007-03-16

    web.xml

     
    Attachments
  • Bill Horsman
    Bill Horsman
    2007-03-16

    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.

     
  • Afat
    Afat
    2007-03-16

    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.

     
  • Bill Horsman
    Bill Horsman
    2007-03-16

    • status: open-accepted --> closed-works-for-me
     
  • Afat
    Afat
    2007-03-16

    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.

     
  • Afat
    Afat
    2007-03-16

    • status: closed-works-for-me --> open-accepted