JDBC Time out setting

JDBC Driver를 통해 DB 연결시 timeout 설정은 다음과 같다.

 

Oracle

url=jdbc:oracle:thin@{DESCRIPTION=(ADDRESS~~~);connectionProperties={includeSynonyms=true,oracle.net.CONNECTION_TIMEOUT=5000,oracle.net.ReadTimeout=900000}

 

MSSQL

driverType=thin;connectionProperties={includeSynonyms=true,logintimeout=5000,queryTimeout=600000,socketTimeout=600000}

 

Tibero

driverType=thin;connectionProperties={includeSynonyms=true,login_timeout=5000,read_timeout=900000}