JBOSS DATASOURCE 설정

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

<local-tx-datasource>

<jndi-name>JNDI명</jndi-name>

<connection-url>jdbc:oracle:thin:@아이피:1521:sidorcl</connection-url>

<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

<connection-property name="testOnBorrow">true</connection-property>

<connection-property name="testWhileIdle">true</connection-property>

<connection-property name="timeBetweenEvictionRunsMillis">60000</connection-property>

<connection-property name="removeAbandoned">true</connection-property>

<connection-property name="validationQuery">select 1 from dual</connection-property>

<connection-property name="validationQueryTimeout">30000</connection-property>

 

<user-name>아이디</user-name>

<password>패스워드</password>

 

<min-pool-size>10</min-pool-size>

<max-pool-size>20</max-pool-size>

 

<track-statements>nowarn</track-statements>

<blocking-timeout-millis>50000</blocking-timeout-millis>

<idle-timeout-minutes>10</idle-timeout-minutes>

<prepared-statement-cache-size>100</prepared-statement-cache-size>

 

<background-validation-millis>60000</background-validation-millis>

<new-connection-sql>select 1 from dual</new-connection-sql>

<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>

 

<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>

 

<metadata>

 <type-mapping>Oracle9i</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>