<datasource jta="true" jndi-name="java:/jdbc/sicoop" pool-name="sicoop" enabled="true" use-ccm="false"> <connection-url>jdbc:oracle:thin:@x.x.x.x:xxxx:sicoop</connection-url> <driver>oracle</driver> <pool> <min-pool-size>20</min-pool-size> <max-pool-size>100</max-pool-size> <use-strict-min>false</use-strict-min> <flush-strategy>FailingConnectionOnly</flush-strategy> </pool> <security> <user-name>DIMO_SICOOP</user-name> <password>dimo</password> </security> <validation> <check-valid-connection-sql>select * from dual</check-valid-connection-sql> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> <use-fast-fail>false</use-fast-fail> <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter" /> </validation> <timeout> <set-tx-query-timeout>true</set-tx-query-timeout> <blocking-timeout-millis>5000</blocking-timeout-millis> <idle-timeout-minutes>5</idle-timeout-minutes> </timeout> <statement> <track-statements>false</track-statements> <prepared-statement-cache-size>0</prepared-statement-cache-size> </statement> </datasource> |