DB연결하기

Servers > context.xml

<Resource

     name = "dbcp/xe"

     auth = "Container"

     type = "javax.sql.DataSource"

     driverClassName = "oracle.jdbc.OracleDriver"

     url = "jdbc:oracle:thin:@192.168.10.130:1521:XE"

     username = "scott"

     password = "tiger"

     maxActive="100"

     maxIdle = "30"

     maxWait = "10000"/>

WEB-INF > web.xml

<resource-ref>   

<description>Oracle Connection Pool</description>

      <res-ref-name>dbcp/xe</res-ref-name>

      <res-type>javax.sql.DataSource</res-type>

      <res-auth>Container</res-auth>

</resource-ref>