eclipse tomcat dbcp 셋팅 (connection pool)

Tomcat ROOT/lib/tomcat-dbcp.jar

 

• /WebContent/META-INF/context.xml 수정

<?xml version="1.0" encoding="UTF-8"?>
<Context>

    <Resource
        name="jdbc/testdb"
        auth="Container"
        type="javax.sql.DataSource"
        factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
        username="DB_USERNAME"
        password="DB_PASSWORD"
        driverClassName="oracle.jdbc.driver.OracleDriver"
        url="jdbc:oracle:thin:@127.0.0.1:1521:DB_NAME"
        maxActive="10"
        maxIdle="4"
    />

</Context>

 

• server project - context.xml 수정

<Context>

    <Resource
        name="jdbc/testdb"
        auth="Container"
        type="javax.sql.DataSource"
        username="DB_USERNAME"
        password="DB_PASSWORD"
        driverClassName="oracle.jdbc.driver.OracleDriver"
        url="jdbc:oracle:thin:@127.0.0.1:1521:DB_NAME"
        maxActive="10"
        maxIdle="4"
    />

</Context>

 

• JNDI 리소스 가져오기

Context initCtx = new InitialContext();
Context envCtx = (Context)initCtx.lookup("java:/comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/testdb");
Connection conn = ds.getConnection();
System.out.println("conn : " + conn);