[08] 데이터베이스 커넥션 풀 - ②

 

[DataBase Connection Pool]

 

사용DB : 오라클 XE

 

>>>>>>>>>>>>>>데이터베이스 커넥션 풀 작성>>>>>>>>>>>>>>>

 

-------------------------------------------라이브러리 3개파일 다운 및 압축 풀기
http://commons.apache.org/collections/download_collections.cgi
commons-collections-3.2.1-bin.zip

http://commons.apache.org/dbcp/download_dbcp.cgi
commons-dbcp-1.4-bin.zip

http://commons.apache.org/pool/download_pool.cgi
commons-pool-1.6-bin.zip

-------------------------------------------------------------/WEB-INF/lib/ 복사
commons-collections-3.2.1.jar
commons-dbcp-1.4.jar
commons-pool-1.6.jar

--------------------------------------------------------톰캣서버/conf/server.xml
46행 추가
        <Resource auth="Container"
                  driverClassName="oracle.jdbc.driver.OracleDriver"
                  factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
                  name="jdbc/oracle"
                  username="hr"
                  password="hr"
                  type="javax.sql.DataSource"
                  url="jdbc:oracle:thin://@127.0.0.1:1521:xe"
                  maxActive="20"
                  maxIdle="2"
                  removeAbandoned="true"/>

 

</GlobalNamingResources>

 

마지막 줄 </Host> 앞에  추가
   <Context path="" docBase="D:\JAVA_Green\workspace" reloadable="true" debug="0"/>
   <Context path="/mvc2bbs" docBase="D:\JAVA_Green\workspace\mvc2bbs"
                                                      reloadable="true" debug="0"/>

---------------------------------------------------------톰캣서버/conf/context.xml
34행 추가
       <Resource  auth="Container"
                  driverClassName="oracle.jdbc.driver.OracleDriver"
                  factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
           name="jdbc/oracle"
           username="hr"
           password="hr"
           type="javax.sql.DataSource"
           url="jdbc:oracle:thin://@127.0.0.1:1521:xe"
           maxActive="20"
                  maxIdle="2"
                  removeAbandoned="true"/>

----------------------------------------------------------------/WEB-INF/web.xml
  <resource-ref>
      <description>Connection</description>
      <res-ref-name>jdbc/oracle</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>

-------------------------------------------------------my.board.BoardDBBean.java
package my.board;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class BoardDBBean{

    private BoardDBBean(){}
    private static BoardDBBean instance=new BoardDBBean();
    public static BoardDBBean getInstance(){
        return instance;
    }
   
    private Connection getConnection() throws Exception{
        Context initCtx=new InitialContext();
        DataSource ds  =(DataSource)initCtx.lookup("java:comp/env/jdbc/oracle");
        return ds.getConnection();
    }

 
       //아래 영역에 DB관련 메소드 작성

}

>>>>>>>>>>>>>DB연결 끝>>>>>>>>>>>>>>>>>>>>>