[Tomcat] DataSource 설정

server.xml 

<context path=....>

<!-- Logger ENV -->

<Logger className="org.apache.catalina.logger.FileLogger"

directory="logs/paint"  prefix="log." suffix=".txt"

timestamp="true"/> 

<!-- Access Log ENV -->

<Valve className="org.apache.catalina.valves.AccessLogValve" 

                     directory="logs/paint"  

                     prefix="access." 

                     suffix=".log" 

                     pattern="common" 

                     fileDateFormat="yyyy-MM-dd"

                     resolveHosts="false"/>

<!-- MySQL -->

<Resource name="jdbc/my" auth="Container"

                        type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"

                        url="jdbc:mysql://[IP]:[PORT]/[database명]?zeroDateTimeBehavior=convertToNull"

                        username="[username]" password="[password]"

                        loginTimeout="10" maxActive="50"

                        maxIdle="10" maxWait="-1" />

<!-- Oracle -->

<Resource name="jdbc/ora" auth="Container"

                        type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

                        url="jdbc:oracle:thin:@[IP]:[PORT]:[SID]"

                        username="[username]" password="[password]" maxActive="10" maxIdle="10"

                        maxWait="-1"/>

<!-- Oracle RAC -->

<Resource name="jdbc/orarac" auth="Container"

                        type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

                        url="jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(LOAD_BALANCE=OFF)(ADDRESS=(PROTOCOL=TCP)(HOST=[IP_1])(PORT=[PORT]))(ADDRESS= (PROTOCOL=TCP)(HOST=[IP_2])(PORT=[PORT]))(CONNECT_DATA=(SERVICE_NAME=[SID])))"

                        username="[password]" password="[password]" maxActive="10" maxIdle="10"

                        maxWait="-1"/>

</context>