2 Replies Latest reply on Jun 30, 2004 8:32 PM by Adrian Brock

    How do you reset all connections following Database Outage

    neil mitchell Newbie

      Hi All

      Is there a way to reset all database connections if there has been an outage.

      I know I could use <check-valid-connection-sql/> in the ds file which will reset them individually but we cannot afford the overhead to run a simple query for every connection request even if its super lightweight.

      Obviously our database's are monitored so we will know of an outage when it occurs but is there a way to programmitically cleanup all the connections.

      Any help would be welcomed even if its to point me in the direction of the right documentation to read.


      Cheers




      Neil