[jboss-user] [Datasource Configuration] - check-valid-connection-sql with Oracle

[Arati Chavan]

Arati Chavan [http://community.jboss.org/people/AratiChavan] created the discussion

"check-valid-connection-sql with Oracle"

To view the discussion, visit: http://community.jboss.org/message/541828#541828

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

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/541828#541828]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100507/3de05b1a/attachment-0001.html