jdbc.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE dataSources[
    <!ELEMENT dataSource ( property+ ) >
    <!ATTLIST dataSource id NMTOKEN #REQUIRED >
    <!ATTLIST dataSource type NMTOKEN #REQUIRED >
    <!ELEMENT dataSources ( dataSource+ ) >
    <!ELEMENT property EMPTY >
    <!ATTLIST property name NMTOKEN #REQUIRED >
    <!ATTLIST property value CDATA #REQUIRED >
]>
<dataSources>

    <!-- 
    <dataSource id="srmDS" type="POOLED">
        <property name="driver" value="oracle.jdbc.driver.OracleDriver" />
        <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:SMARTX" />
        <property name="username" value="smartx" />
        <property name="password" value="smartx" />
        <property name="poolMaximumActiveConnections"  value="2"/>
        <property name="poolMaximumIdleConnections" value="2"/>
        <property name="poolMaximumCheckoutTime" value="20000"/>
        <property name="poolTimeToWait" value="20000"/>
        <property name="poolPingQuery" value="select 1 from DUAL"/>
        <property name="poolPingEnabled" value="false"/>
        <property name="poolPingConnectionsNotUsedFor" value="0"/>
    </dataSource>
    -->
    
    <!-- Tomcat 설정 -->
    <dataSource id="srmDS" type="JNDI">
        <property name="initial_context" value="java:comp/env/" />
        <property name="data_source" value="srmDS" />
    </dataSource>
    
    <dataSource id="qmsDS" type="JNDI">
        <property name="initial_context" value="java:comp/env/" />
        <property name="data_source" value="qmsDS" />
    </dataSource>
    
    <!--  
       <dataSource id="srmDS" type="POOLED">
        <property name="driver" value="oracle.jdbc.driver.OracleDriver" />
        <property name="url" value="jdbc:oracle:thin:@192.168.12.118:1521:PHGMM" />
        <property name="username" value="eprouser" />
        <property name="password" value="userepro" />
        <property name="poolMaximumActiveConnections"  value="200"/>
        <property name="poolMaximumIdleConnections" value="50"/>
        <property name="poolMaximumCheckoutTime" value="20000"/>
        <property name="poolTimeToWait" value="20000"/>
        <property name="poolPingQuery" value="select 1 from DUAL"/>
        <property name="poolPingEnabled" value="false"/>
        <property name="poolPingConnectionsNotUsedFor" value="0"/>
    </dataSource>
    -->
     
</dataSources>