광고 한 번씩 클릭해 주시면 글 쓰는데 큰 힘이 됩니다 (제발~)

IT/Server

tomcat server.xml에서 oracle과 mssql 설정부분~

BradKim81 2021. 5. 12. 10:20
728x90

<GlobalNamingResources>

 

 

ORACLE

<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" maxActive="100" maxIdle="10" maxWait="-1" name="jdbc/test" password="test" type="javax.sql.DataSource" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=000.000.000.000)(PORT=1521))(LOAD_BALANCE=on))(CONNECT_DATA=(SERVICE_NAME=TEST)(SRVR = DEDICATED)))" username="test"/>

 

320x100

 

MSSQL

<Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="100" maxIdle="10" maxWait="-1" name="jdbc/test" password="test" type="javax.sql.DataSource" url="jdbc:sqlserver://000.000.000.000:1433;DatabaseName=test;charset=euc-kr;TDS=7.0" username="test"/> 

 

 

  </GlobalNamingResources>

320x100