#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

     
  • 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

     
  • 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
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks