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]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
