0 Replies Latest reply on May 7, 2010 11:40 AM by Arati Chavan

    check-valid-connection-sql with Oracle

    Arati Chavan Newbie


      We are using the JNDI for connecting to Oracle DB. Everytime Database goes down, we hae to restart Jboss to establish a new connection. I want to implement  check-valid-connection-sql in the below ds file. Can someone shade some light on any potential problems or performance issues that we might encounter with this ? Below is my current ds file


      <?xml version="1.0" encoding="UTF-8"?>

      <!-- ===================================================================== -->
      <!--                                                                       -->
      <!--  JBoss Server Configuration                                           -->
      <!-- ==================================================================== -->


      <connection-url> jdbc:oracle:thin:@</connection-url>