* °³¿ä
¿ÀÁî¿¡¼ oracle¿¡ ¿¬°áÇÒ ¶§ shared / dedicated ¹æ½ÄÀ¸·Î ¼³Á¤ÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.
* »ó¼¼ ¼³¸í
¿À¶óŬ¿¡ ¿¬°áÇÒ ¶§ shared¹æ½ÄÀ¸·Î ÇÒÁö dedicated ¹æ½ÄÀ¸·Î ÇÒ °ÍÀÎÁö´Â jdbc url ¿É¼Ç¿¡ ÁöÁ¤¿¡ µû¶ó ´Þ¶óÁý´Ï´Ù.
1. OZ ver 3.5 ÀÌÇÏ
¾Æ·¡¿Í °°ÀÌ "¿ÀÁî¼¹öȨ/conf/db.properties" ÆÄÀÏ¿¡ ÇØ´ç ¹æ½ÄÀ» url¿¡ ³Ö¾îÁÖ½Ã¸é µË´Ï´Ù.
(dedicated ¹æ½Ä)
alias¸í.vendor=user alias¸í.driver=oracle.jdbc.driver.OracleDriver alias¸í.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 218.xxx.xxx.xxx)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ORCL))) alias¸í.user=admin alias¸í.password=***** alias¸í.maxconns=5 alias¸í.initconns=1 alias¸í.timeout=5 alias¸í.doConnectionCheck=true
alias¸í.testQueryString=select 1 from dual |
(shared ¹æ½Ä)
alias¸í.vendor=user alias¸í.driver=oracle.jdbc.driver.OracleDriver alias¸í.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 218.xxx.xxx.xxx)(PORT = 1521))) (CONNECT_DATA = (SERVER = SHARED) (SID = ORCL))) alias¸í.user=admin alias¸í.password=***** alias¸í.maxconns=5 alias¸í.initconns=1 alias¸í.timeout=5 alias¸í.doConnectionCheck=true
alias¸í.testQueryString=select 1 from dual |
2. OZ ver 4.0 ÀÌ»ó
4.0 ÀÌ»ó ¹öÁ¯¿¡¼´Â "¿ÀÁî¼¹öȨ/conf/dbconfig.xml" ÆÄÀÏ¿¡ oracle º¥´õÀÇ ±âº» URLÀÇ °ªÀÌ ¾Æ·¡¿Í °°Àº ÇüÅ·ΠµÇ¾î ÀÖ½À´Ï´Ù.
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST={serverAddress})(PROTOCOL=tcp)(PORT={portNo}))(CONNECT_DATA=(SID={sid}))) |
ÀÌ °ªÀ» ¾Æ·¡¿Í °°ÀÌ ¿øÇϽô ÇüÅ·Πº¯°æ ÇÏ½Ã¸é µË´Ï´Ù.
(dedicated ¹æ½Ä)
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST={serverAddress})(PROTOCOL=tcp)(PORT={portNo}))(CONNECT_DATA=(SERVER=DEDICATED) (SID={sid}))) |
(shared ¹æ½Ä)
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST={serverAddress})(PROTOCOL=tcp)(PORT={portNo}))(CONNECT_DATA=(SERVER=SHARED)(SID={sid}))) |
¾Æ´Ï¸é db.properties¿¡ 1¹ø ¹æ½Äó·³ vendor¸¦ Ãß°¡Çؼ Çϼŵµ µË´Ï´Ù.
°ªÀ» ¾È³Ö¾úÀ»¶§ ±âº» µ¿ÀÛÀº ¿À¶óŬ jdbc½ºÆåÀ» µû¶ó °©´Ï´Ù. (shared¹æ½Ä)
|