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>