com.sds.acube.bpm.framework.api
Class DBConnectionProcessor
java.lang.Object
com.sds.acube.bpm.framework.api.DBConnectionProcessor
public class DBConnectionProcessor
- extends java.lang.Object
DB Ä¿³Ø¼Ç °ü·Ã API
DBConnectionProcessor.java
2008. 12. 16.
¿ÜºÎ ÇÁ·ÎÁ§Æ® °³¹ßÀÚÇÑÅ× Á¦°øµÊ
- Version:
- 1.0.0.0
Copyright 2001 Samsung SDS Co., Ltd. All rights reserved.
- Author:
- LEE IL YONG
Method Summary |
static java.sql.Connection |
getBpmConsoleConnection()
¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ BPMÂÊ ÀÚü Ä¿³Ø¼ÇÇ®°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ. |
static java.sql.Connection |
getBpmJDBCConnection()
¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ BPMÂÊ JDBC ¼³Á¤°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ. |
static java.sql.Connection |
getBpmWasConnection()
¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ BPMÂÊ dataSource°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ. |
static java.sql.Connection |
getConnectionByDS(java.lang.String datasourceName)
JNDI datasource¸íÀ» ¹Þ¾Æ¼ WAS Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ(BPMÀÌ¿ÜÀÇ WAS¿¡ ºÙÀ» ¶§ »ç¿ë°¡´É)
[Âü°í] ÀÌ ÇÔ¼ö´Â was¿¡ Á¢±ÙÇÒ ¼ö Àִ ȯ°æ¿¡¼¸¸ »ç¿ëÇØ¾ß ÇÔ. |
static java.sql.Connection |
getIdirConsoleConnection()
¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ idirÂÊ ÀÚü Ä¿³Ø¼ÇÇ®°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ. |
static java.sql.Connection |
getIdirJDBCConnection()
¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ idirÂÊ JDBC ¼³Á¤°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ. |
static java.sql.Connection |
getIdirWasConnection()
¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ idirÂÊ dataSource°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ. |
static boolean |
isValidBpmConsoleConnection()
ÇöÀç DBÄ¿³Ø¼ÇÀÌ À¯È¿ÇÑÁö °Ë»çÇÔ. |
static boolean |
isValidBpmWasConnection()
ÇöÀç DBÄ¿³Ø¼ÇÀÌ À¯È¿ÇÑÁö °Ë»çÇÔ. |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
DBConnectionProcessor
public DBConnectionProcessor()
getBpmWasConnection
public static java.sql.Connection getBpmWasConnection()
throws java.lang.Exception
- ¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ BPMÂÊ dataSource°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ.
[Âü°í] ÀÌ ÇÔ¼ö´Â was¿¡ Á¢±ÙÇÒ ¼ö Àִ ȯ°æ¿¡¼¸¸ »ç¿ëÇØ¾ß ÇÔ. ÀÏ¹Ý java consoleÇÁ·Î±×·¥¿¡¼ È£ÃâÇÏ¸é ¾ÈµÊ.
[Âü°í] autoCommitÀº µðÆúÆ® falseÀ̹ǷΠ¿ÜºÎ¿¡¼ commitÇØÁà¾ß ÇÔ.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö·Î »ý¼ºÇÑ Ä¿³Ø¼ÇÀº DB Ä¿³Ø¼Ç ´©¼ö°¡ »ý±âÁö ¾Ê°Ô È£ÃâÇÏ´Â ÂÊ¿¡¼ ¹Ýµå½Ã finally¿¡¼ Á÷Á¢ closeÇØÁà¾ß ÇÔ.
- Returns:
- conn - Connection
- Throws:
com.sds.acube.bpm.framework.api.ProcessorException
java.lang.Exception
getBpmConsoleConnection
public static java.sql.Connection getBpmConsoleConnection()
throws java.lang.Exception
- ¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ BPMÂÊ ÀÚü Ä¿³Ø¼ÇÇ®°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ.
[Âü°í] ÀÌ ÇÔ¼ö´Â ÀÏ¹Ý java consoleÇÁ·Î±×·¥À̳ª was ¾çÂÊ¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÁö¸¸ ¼º´ÉÀÌ Áß¿äÇÒ °æ¿ì was poolÀ» »ç¿ëÇÒ °Í.
[Âü°í] autoCommitÀº µðÆúÆ® falseÀ̹ǷΠ¿ÜºÎ¿¡¼ commitÇØÁà¾ß ÇÔ.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö·Î »ý¼ºÇÑ Ä¿³Ø¼ÇÀº DB Ä¿³Ø¼Ç ´©¼ö°¡ »ý±âÁö ¾Ê°Ô È£ÃâÇÏ´Â ÂÊ¿¡¼ ¹Ýµå½Ã finally¿¡¼ Á÷Á¢ closeÇØÁà¾ß ÇÔ.
- Returns:
- conn - Connection
- Throws:
com.sds.acube.bpm.framework.api.ProcessorException
java.lang.Exception
getBpmJDBCConnection
public static java.sql.Connection getBpmJDBCConnection()
throws java.lang.Exception
- ¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ BPMÂÊ JDBC ¼³Á¤°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ.
[Âü°í] ÀÌ ÇÔ¼ö´Â ÀÏ¹Ý java consoleÇÁ·Î±×·¥À̳ª was ¾çÂÊ¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÁö¸¸ pool±â´ÉÀÌ ¾øÀ¸¹Ç·Î °¡±ÞÀû »ç¿ëÇÏÁö ¸» °Í.
[Âü°í] autoCommitÀº µðÆúÆ® falseÀ̹ǷΠ¿ÜºÎ¿¡¼ commitÇØÁà¾ß ÇÔ.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö·Î »ý¼ºÇÑ Ä¿³Ø¼ÇÀº DB Ä¿³Ø¼Ç ´©¼ö°¡ »ý±âÁö ¾Ê°Ô È£ÃâÇÏ´Â ÂÊ¿¡¼ ¹Ýµå½Ã finally¿¡¼ Á÷Á¢ closeÇØÁà¾ß ÇÔ.
- Returns:
- conn - Connection
- Throws:
com.sds.acube.bpm.framework.api.ProcessorException
java.lang.Exception
isValidBpmWasConnection
public static boolean isValidBpmWasConnection()
throws java.lang.Exception
- ÇöÀç DBÄ¿³Ø¼ÇÀÌ À¯È¿ÇÑÁö °Ë»çÇÔ. ½ÇÁ¦ DB¿¡ Äõ¸®¸¦ ´øÁ® º¸°í ¿À·ù½Ã ExceptionÀ» ´øÁü.
DB¸¦ ³»·È´Ù ¿Ã¸° ÈÄ BPMÀ» Àç±âµ¿ÇÏÁö ¾ÊÀ¸¸é JDBC ¼ÒÄÏÀÌ ²÷¾îÁö¹Ç·Î ¸ÕÀú ÀÌ ÇÔ¼ö¸¦ È£ÃâÇÒ °Í.
[Âü°í]ÇöÀç BPMÀÇ DAOµéÀº ¿À·ù°¡ ³ªµµ ExceptionÀ» ´øÁöÁö ¾ÊÀ¸¹Ç·Î À̸¦ ¾Ë¾Æ³»±â ¾î·Æ±â¶§¹®¿¡ ÀÌ ÇÔ¼ö·Î Âü°íÇÒ °Í.
- Returns:
- boolean
- Throws:
java.lang.Exception
- Since:
- 2011.09.07 LEE IL YONG
isValidBpmConsoleConnection
public static boolean isValidBpmConsoleConnection()
throws java.lang.Exception
- ÇöÀç DBÄ¿³Ø¼ÇÀÌ À¯È¿ÇÑÁö °Ë»çÇÔ. ½ÇÁ¦ DB¿¡ Äõ¸®¸¦ ´øÁ® º¸°í ¿À·ù½Ã ExceptionÀ» ´øÁü.
DB¸¦ ³»·È´Ù ¿Ã¸° ÈÄ BPMÀ» Àç±âµ¿ÇÏÁö ¾ÊÀ¸¸é JDBC ¼ÒÄÏÀÌ ²÷¾îÁö¹Ç·Î ¸ÕÀú ÀÌ ÇÔ¼ö¸¦ È£ÃâÇÒ °Í.
[Âü°í]ÇöÀç BPMÀÇ DAOµéÀº ¿À·ù°¡ ³ªµµ ExceptionÀ» ´øÁöÁö ¾ÊÀ¸¹Ç·Î À̸¦ ¾Ë¾Æ³»±â ¾î·Æ±â¶§¹®¿¡ ÀÌ ÇÔ¼ö·Î Âü°íÇÒ °Í.
- Returns:
- boolean
- Throws:
java.lang.Exception
- Since:
- 2011.09.07 LEE IL YONG
getIdirWasConnection
public static java.sql.Connection getIdirWasConnection()
throws java.lang.Exception
- ¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ idirÂÊ dataSource°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ.
[Âü°í] ÀÌ ÇÔ¼ö´Â was¿¡ Á¢±ÙÇÒ ¼ö Àִ ȯ°æ¿¡¼¸¸ »ç¿ëÇØ¾ß ÇÔ. ÀÏ¹Ý java consoleÇÁ·Î±×·¥¿¡¼ È£ÃâÇÏ¸é ¾ÈµÊ.
[Âü°í] autoCommitÀº µðÆúÆ® falseÀ̹ǷΠ¿ÜºÎ¿¡¼ commitÇØÁà¾ß ÇÔ.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö·Î »ý¼ºÇÑ Ä¿³Ø¼ÇÀº DB Ä¿³Ø¼Ç ´©¼ö°¡ »ý±âÁö ¾Ê°Ô È£ÃâÇÏ´Â ÂÊ¿¡¼ ¹Ýµå½Ã finally¿¡¼ Á÷Á¢ closeÇØÁà¾ß ÇÔ.
- Returns:
- conn - Connection
- Throws:
com.sds.acube.bpm.framework.api.ProcessorException
java.lang.Exception
getIdirConsoleConnection
public static java.sql.Connection getIdirConsoleConnection()
throws java.lang.Exception
- ¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ idirÂÊ ÀÚü Ä¿³Ø¼ÇÇ®°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ.
[Âü°í] ÀÌ ÇÔ¼ö´Â ÀÏ¹Ý java consoleÇÁ·Î±×·¥À̳ª was ¾çÂÊ¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÁö¸¸ ¼º´ÉÀÌ Áß¿äÇÒ °æ¿ì was poolÀ» »ç¿ëÇÒ °Í.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö¸¦ »ç¿ëÇÏ·Á¸é idir/web/WEB-INF/classes¿¡ OrgConnection.properties ÆÄÀÏÀÌ ÀÖ¾î¾ß ÇÏ¸ç ¼³Á¤°ªÀÌ ¸Â¾Æ¾ßÇÔ. È®ÀÎ ÈÄ »ç¿ëÇÒ °Í.
[Âü°í] autoCommitÀº µðÆúÆ® falseÀ̹ǷΠ¿ÜºÎ¿¡¼ commitÇØÁà¾ß ÇÔ.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö·Î »ý¼ºÇÑ Ä¿³Ø¼ÇÀº DB Ä¿³Ø¼Ç ´©¼ö°¡ »ý±âÁö ¾Ê°Ô È£ÃâÇÏ´Â ÂÊ¿¡¼ ¹Ýµå½Ã finally¿¡¼ Á÷Á¢ closeÇØÁà¾ß ÇÔ.
- Returns:
- conn - Connection
- Throws:
com.sds.acube.bpm.framework.api.ProcessorException
java.lang.Exception
getIdirJDBCConnection
public static java.sql.Connection getIdirJDBCConnection()
throws java.lang.Exception
- ¼¹öÀÇ bpm/web/WEB-INF/config/BPM.properties ÆÄÀÏ¿¡ ¼³Á¤µÈ idirÂÊ JDBC ¼³Á¤°ªÀ» Àоî Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ.
[Âü°í] ÀÌ ÇÔ¼ö´Â ÀÏ¹Ý java consoleÇÁ·Î±×·¥À̳ª was ¾çÂÊ¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÁö¸¸ pool±â´ÉÀÌ ¾øÀ¸¹Ç·Î °¡±ÞÀû »ç¿ëÇÏÁö ¸» °Í.
[Âü°í] autoCommitÀº µðÆúÆ® falseÀ̹ǷΠ¿ÜºÎ¿¡¼ commitÇØÁà¾ß ÇÔ.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö·Î »ý¼ºÇÑ Ä¿³Ø¼ÇÀº DB Ä¿³Ø¼Ç ´©¼ö°¡ »ý±âÁö ¾Ê°Ô È£ÃâÇÏ´Â ÂÊ¿¡¼ ¹Ýµå½Ã finally¿¡¼ Á÷Á¢ closeÇØÁà¾ß ÇÔ.
- Returns:
- conn - Connection
- Throws:
com.sds.acube.bpm.framework.api.ProcessorException
java.lang.Exception
getConnectionByDS
public static java.sql.Connection getConnectionByDS(java.lang.String datasourceName)
throws java.lang.Exception
- JNDI datasource¸íÀ» ¹Þ¾Æ¼ WAS Ä¿³Ø¼ÇÀ» »ý¼ºÇÔ(BPMÀÌ¿ÜÀÇ WAS¿¡ ºÙÀ» ¶§ »ç¿ë°¡´É)
[Âü°í] ÀÌ ÇÔ¼ö´Â was¿¡ Á¢±ÙÇÒ ¼ö Àִ ȯ°æ¿¡¼¸¸ »ç¿ëÇØ¾ß ÇÔ. ÀÏ¹Ý java consoleÇÁ·Î±×·¥¿¡¼ È£ÃâÇÏ¸é ¾ÈµÊ.
[Âü°í] autoCommitÀº µðÆúÆ® falseÀ̹ǷΠ¿ÜºÎ¿¡¼ commitÇØÁà¾ß ÇÔ.
[ÁÖÀÇ!] ÀÌ ÇÔ¼ö·Î »ý¼ºÇÑ Ä¿³Ø¼ÇÀº DB Ä¿³Ø¼Ç ´©¼ö°¡ »ý±âÁö ¾Ê°Ô È£ÃâÇÏ´Â ÂÊ¿¡¼ ¹Ýµå½Ã finally¿¡¼ Á÷Á¢ closeÇØÁà¾ß ÇÔ.
- Returns:
- conn - Connection
- Throws:
java.lang.Exception