重新启动/断开数据库连接后，JBoss自动与数据库重新连接 [英] JBoss auto reconnect with database when database is restarted/disconnect

问题描述

当数据库和JBoss之间断开连接时，是否有任何版本的JBoss支持与数据库自动重新连接?我尝试使用

Does any version of JBoss supports auto reconnect with database when there is disconnect between database and JBoss?. I tried with the below configuration in

 <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
   <datasources>    
    <local-tx-datasource>
   <jndi-name>sampleDS</jndi-name>
   <min-pool-size>1</min-pool-size>
    <max-pool-size>5</max-pool-size>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <connection-url>jdbc:oracle:thin:@<ip>:<databaseport>:<sip></connection-url>
    <user-name>username</user-name>
    <password>password</password>
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
    <check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
<failOverReadOnly>false</failOverReadOnly>
<autoReconnect>true</autoReconnect>
     <maxReconnects>50</maxReconnects>
     <initialTimeout>15</initialTimeout>
     </local-tx-datasource>

推荐答案

我正在使用jboss-eap-6.1及其完美的工作方式.修改jboss-eap-6.1/standalone/configuration/standalone.xml文件，并在每个<xa-datasource>标记内添加以下行.

I am using jboss-eap-6.1 and its working perfectly. Modify jboss-eap-6.1/standalone/configuration/standalone.xml file and add the following lines inside each <xa-datasource> tag.

                <validation>
                    <check-valid-connection-sql>select 1</check-valid-connection-sql>
                    <background-validation>true</background-validation>
                    <background-validation-millis>15000</background-validation-millis>
                </validation>

这篇关于重新启动/断开数据库连接后，JBoss自动与数据库重新连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！