********DB Connection Pool********
<db-connection-pool> <pool-name>OraclePool</pool-name> <pool-type>shared</pool-type> <connection-url>jdbc:oracle:thin:@211.56.251.203:1521:ora9i</connection-url> <driver-class-name>oracle.jdbc.driver.OracleDriver</driver-class-name> <connection-argument>user=scott;password=tiger</connection-argument> <dynamic-increment>true</dynamic-increment> <get-connection-timeout>30000</get-connection-timeout> <close-long-active-connection>true</close-long-active-connection> <max-active-time>300000</max-active-time> <max-use-count>30</max-use-count> <db-pool-control> <min>1</min> <max>2</max> <step>1</step> <max-idle-time>300000</max-idle-time> <max-alive-time>600000</max-alive-time> </db-pool-control> </db-connection-pool>
******** Datasource ************* <jeus-system>
........
<resource> <data-source> <database> <vendor>oracle</vendor> <export-name>dbsource</export-name> <data-source-class-name>oracle.jdbc.pool.OracleConnectionPoolDataSource</data-source-class-name> <data-source-type>ConnectionPoolDataSource</data-source-type> <database-name>ora9i</database-name> <data-source-name>oracle.jdbc.pool.OracleDataSource</data-source-name> <service-name>ora9i</service-name> <password>tiger</password> <port-number>1521</port-number> <server-name>192.168.20.213</server-name> <user>scott</user> <driver-type>thin</driver-type> <connection-pool> <pooling> <min>2</min> <max>5</max> <step>1</step> <period>5</period> </pooling> <wait-free-connection> <enable-wait>true</enable-wait> <wait-time>60000</wait-time> </wait-free-connection> <operation-to>30000</operation-to> <max-use-count>30</max-use-count> </connection-pool> </database> </data-source> </resource> </jeus-system>
|