커넥션풀을 이용한 db연결순서

1.server.xml수정(가운데쯤)

 <GlobalNamingResources>
    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users
    -->
    <Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" loginTimeout="10" maxWait="5000" name="jdbc/jsp" username="아이디" password="비밀번호" testonBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@127.0.0.1:1521:디비명"/>   </GlobalNamingResources>

2.server.xml수정(아래쪽)

      <Context docBase="Classtest" path="/Classtest" reloadable="true" source="org.eclipse.jst.jee.server:Classtest">
      <Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" loginTimeout="10" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jsp" password="비밀번호" testonBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@127.0.0.1:1521:SA" username="아이디"/>
      </Context>

 

3.프로젝트->web-inf->web.xml수정

    <resource-ref>
    <description>프로젝트명</description>
    <res-ref-name>jdbc/jsp</res-ref-name> //->server.xml에 설정해놓은 resource의 이름과 같아야함!
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>