어플리케이션-DB 연결(Tomcat Spring-JDK)

기본적으로 톰캣을 구동할 때, 1tire 구성이든, 2tire 구성이든 3tire 구성이든

WAS와 DB 를 서로 연결해줘야 할 필요가 있다.

 

이럴땐 어떻게 구성을 해야할까

[test@server classes]$ pwd
/data/test/application/WEB-INF/classes

WEB-INF 라는 경로가 있다. 이 내부에는 classes를 선언하게 되는데 이를 좀 보려고 한다.

[test@server classes]$ ls
log4j2.xml               
log4jdbc.log4j2.properties 
resource_db.properties
resource_system.properties
resource_proc.properties

기본적으로 이런 구성을 가지고 있다.

resource_db.properties

resource_system.properties

resource_proc.proterites

 

이중 resource_db.properties를 보도록 하자

##############################################################
# MARIA DB
##############################################################
DB.DRIVER=org.mariadb.jdbc.Driver
DB.URL=jdbc:mariadb://1.1.1.1:3306/test
DB.USERNAME=test
DB.PASSWORD=Test#123
DB.V_QUERY=SELECT now()


##############################################################
# ORACLE DB
##############################################################
DB.DRIVER=oracle.jdbc.driver.OracleDriver
DB.URL=jdbc:oracle:thin:@1.1.1.1:1521:test
DB.USERNAME=TEST
DB.PASSWORD=Test#123
DB.V_QUERY = SELECT SYSDATE FROM DUAL

##############################################################
# TIBERO DB
##############################################################
DB.DRIVER=com.tmax.tibero.jdbc.TbDriver
DB.URL=jdbc:tibero:thin:@1.1.1.1:8629:tibero
DB.USERNAME=TEST
DB.PASSWORD=Test#123
DB.V_QUERY = SELECT SYSDATE FROM DUAL

##############################################################
# MS-SQL DB
##############################################################
DB.DRIVER=oracle.jdbc.driver.OracleDriver
DB.URL=jdbc:jtds:sqlserver://1.1.1.1:1433/test
DB.USERNAME=TEST
DB.PASSWORD=Test#123
DB.V_QUERY=SELECT GETDATE()

 

V_QUERY는 데이터베이스 연결이 정상인지 체크하는 헬스체크용 쿼리(커넥션 풀 확인용도)

필요하다면 넣도록 하자.