当数据库和JBoss之间断开连接时,是否有任何版本的JBoss支持自动重新连接数据库?我尝试使用以下配置
<?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>
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>
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)