JNB
rss

skin by 이글루스

JEUS

JEUS-DB 연동설정 07.07.03 8:56

********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>211.56.251.203</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>


        

    
Copyright 1999-2018 Zeroboard / skin by JY