반응형

<database>
                <vendor>oracle</vendor>
                <export-name>VIIMS</export-name>
                <data-source-class-name>oracle.jdbc.pool.OracleConnectionPoolDataSource</data-source-class-name>
                <data-source-type>ConnectionPoolDataSource</data-source-type>
                <database-name>BILNS30</database-name>
                <data-source-name>oracle.jdbc.pool.OracleConnectionPoolDataSource</data-source-name>
                <description>ICIS_NSBL_DB</description>
                <user>vimis</user>
                <password>votmdnjem</password>
                <property>
                   <name>URL</name>
                   <type>java.lang.String</type>
                   <value>jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=200.182.154.51)(Port=1523))(ADDRESS=(PROTOCOL=TCP)(Host=200.182.154.52)(Port=1523))(FAILOVER = o
n)(LOAD_BALANCE =off))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=VIMIS)))</value>
                </property>
                <driver-type>thin</driver-type>
                <connection-pool>
                   <pooling>
                        <min>30</min>
                        <max>40</max>
                        <step>5</step>
                        <period>3600000</period>
                   </pooling>
                   <wait-free-connection>
                      <enable-wait>true</enable-wait>
                      <wait-time>2000</wait-time>
                   </wait-free-connection>
                   <check-query>select 1 from dual</check-query>
                   <check-query-period>300000</check-query-period>
                </connection-pool>
        </database>
반응형

+ Recent posts