* °³¿ä
WAS Pool À» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º ¿¬°áÇϱâ
¿ÀÁî ¼¹ö¿¡¼ RDBMS¸¦ ¿¬°áÇÒ ¶§ ÀÚü Ä¿³Ø¼ÇÇ®À» »ç¿ëÇÒ¼öµµ ÀÖÁö¸¸ WAS¿¡¼ ¼³Á¤ÇÑ Ä¿³Ø¼Ç Ç®À» °¡Áö°í °øÀ¯Çؼ »ç¿ëÇϴ°͵µ °¡´ÉÇÕ´Ï´Ù.
* »ó¼¼ ¼³¸í
¿ÀÁî ¼¹ö´Â WAS¿¡¼ Á¦°øÇÏ´Â Ä¿³Ø¼Ç Ç®À» DataSource ¹æ½ÄÀ¸·Î °¡Á®´Ù ¾µ ¼ö ÀÖ½À´Ï´Ù.
°¢ WAS¿¡ ´ëÇÑ ¼³Á¤ ¹æ¹ýÀº ¾Æ·¡ÀÇ ³»¿ëÀ» ÂüÁ¶Çϼ¼¿ä
(ds_exampleÀº Äõ¸®µðÀÚÀ̳ʿ¡¼ Á¤ÀÇÇÑ alias ¸íÀ¸·Î ¼öÁ¤Çؼ »ç¿ëÇϼ¼¿ä. DataSource NameÀº ÇØ´ç WAS¿¡¼ Á¦°øÇÏ´Â JNDI ¸íÀ» »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.)
*** WebLogic example
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:weblogic.jndi.WLInitialContextFactory:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** WebSphere Version 3.0.x, 3.5.x example
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:com.ibm.ejs.ns.jndi.CNInitialContextFactory:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** WebSphere over Version 4.0 example
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:com.ibm.websphere.naming.WsnInitialContextFactory:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** WebSphere over Version 5.x, 6.x example1 (global binding)
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:com.ibm.websphere.naming.WsnInitialContextFactory:jdbc/datasource_name ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** WebSphere over Version 5.x, 6.x example2 (local binding)
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:com.ibm.websphere.naming.WsnInitialContextFactory:java:comp/env/jdbc/datasource_name ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** WebSphere over Version 5.x, 6.x example3 (local binding)
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:com.forcs.jndi.ContextFatory:java:comp/env/jdbc/datasource_name ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** Jeus example
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:jeus.jndi.JEUSContextFactory:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** iPlanet example
# Notice : DataSource Name include "jdbc/" in case of iPlanet # ex) jdbc/ecfcDS
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:com.netscape.server.jndi.RootContextFactory:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** JRUN example
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:jrun.naming.JRunContextFactory:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** Tomcat example
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:tomcat:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
*** In case not exist ContextFactory Example (Interstage, Oracle Application Server etc...)
ds_example.vendor=user ds_example.driver=com.forcs.jdbc.JNDIJDBCDriver ds_example.url=forcs:com.forcs.jndi.ContextFatory:<DataSource Name> ds_example.maxconns=0 ds_example.initconns=0 ds_example.timeout=5
* Âü°í »çÇ×
- WASÀÇ µ¥ÀÌÅͼҽº¸¦ »ç¿ëÇÒ °æ¿ì¿¡´Â doConnectionCheck ¿É¼ÇÀ» ÁÙ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.
WAS´Ü¿¡¼ º°µµ·Î ¾Ë¾Æ¼ ¿¬°áüũ¸¦ Çϱ⠶§¹®¿¡ ¿ÀÁîdb.properties¿¡¼ doConnectionCheck ¿É¼ÇÀ» ÁÖ¸é ¿ÀÈ÷·Á ¼º´ÉÀÌ ¾ÈÁÁÀ» ¼ö ÀÖ½À´Ï´Ù.
- maxconns, initconns °ªÀº 0À¸·Î ¼³Á¤ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
|