tomcat DB Connection Pool 구성 (DB2, Oracle, MSSQL)

 

tomcat DB Connection Pool 구성 (DB2, Oracle, MSSQL)

 

 

Tomcat에서 DB에 접근을 하기 위해 server.xml에 DB Connection Pool을 세팅해야 합니다.

이 때, Database마다 구성하는 옵션이 조금씩 다르기 때문에 이를 정리해보려고 합니다.

 

1. DB2 Connection Pool

DB2 Connection Pool

## DB2 Connecation Pool 구성 <Resource name="DBPOOLNAME" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" username="USERID" password="PASSWORD" driverClassName="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://IP:PORT/DB" maxActive="200"                                                                       #이중화로 maxIdle의 2배 maxIdle="100" maxWait="10000" minIdle="10" testOnBorrow="true" validationQuery="select 1 from sysibm.sysdummy1" />       #db connection 유지를 위해 주기적으로 validationquery를 날림

 

​2. Oracle Connection Pool

Oracle Connection Pool

## Oracle Connection Pool 구성 <Resource name="DBPOOLNAME" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" username="USERID" password="PASSWORD" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@IP:PORT:SID" maxActive="200" maxIdle="100" maxWait="10000" minIdle="10" testWhileIdle="true" validationQuery="select 1 from dual" />

 

​3. MSSQL Connection Pool

MSSQL Connection Pool

## MSSQL Connection Pool 구성 <Resource name="DBPOOLNAME" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" username="USERID" password="PASSWORD" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://IP:PORT" maxActive="40" maxIdle="20" maxWait="10000" minIdle="10" removeAbandonedTimeout="60" removeAbandoned="true" validationQuery="select 1" validationInterval="30000" />

​