[Java] DBCP 풀 설정(by Eclipse.)

@ 오라클

 

<GlobalNamingResources>

   <Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver"                                                                 factory="oracle.jdbc.pool.OracleDataSourceFactory" maxActive="20" maxIdle="10" maxWait="-1"

   name="jdbc/oracle" password="비밀번호" type="oracle.jdbc.pool.OracleDataSource"

   url="jdbc:oracle:thin:@아이피:1521:orcl" user="유저명"/>

</GlobalNamingResources>

 

<context ...............>

   <ResourceLink name="jdbc/oracle"
                         type="oracle.jdbc.pool.OracleDataSource"
                         global="jdbc/oracle"
    />

</context>

 

 

 

@ MYSQL

 

<Resource auth="Container" name="jdbc/db" type="javax.sql.DataSource"
     driverClassName="com.mysql.jdbc.Driver" password="비밀번호"
     maxIdle="2" maxWait="5000" username="유저명"
     url="jdbc:mysql://localhost:3306/디비명"
     maxActive="4"/>

 

<ResourceLink name="jdbc/db"
                     type="javax.sql.DataSource"
                    global="jdbc/db"
/>