加上以下标注红线的内容就是加上自动重连功能!
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>flhis</jndi-name>
<connection-url>jdbc:oracle:thin:@flsys:1521:flhis</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>flhis</user-name>
<password>flhis_123456</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!--<new-connection-sql>select 1 from dual</new-connection-sql>-->
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
</local-tx-datasource>
</datasources>