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

    check-valid-connection-sql with Oracle

      Hi,

      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                                           -->
      <!-- ==================================================================== -->

       

      <datasources>
        <local-tx-datasource>
          <jndi-name>jdbc/PassMarkDB</jndi-name>
      <connection-url> jdbc:oracle:thin:@1.11.111.111:1111:rsadev</connection-url>

              <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
            <user-name>xxxx</user-name>
      <password>xxxx</password>

      <min-pool-size>5</min-pool-size>
              <max-pool-size>200</max-pool-size>
              <metadata>
                <type-mapping>Oracle10g</type-mapping>
              </metadata>
        </local-tx-datasource>
      </datasources>