FishEye: Tag 84e1c82407103a9e26b421f2efa3af8931ddf7a5 refers to a dead (removed) revision in file `src/main/resources/rebel.xml'. FishEye: No comparison available. Pass `N' to diff? Index: web-module/pom.xml =================================================================== diff -u -r663837047ab042c4bd3cd245e17ad41e525caa2e -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/pom.xml (.../pom.xml) (revision 663837047ab042c4bd3cd245e17ad41e525caa2e) +++ web-module/pom.xml (.../pom.xml) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -17,7 +17,7 @@ Web Project by 313 DEV GRP - 22.12.10 + 22.12.13 Index: web-module/src/main/java/egovframework/api/arms/module_pdservice/controller/UserPdServiceController.java =================================================================== diff -u -r9acfa51a82d6eae6c7e1738728fd414f77b8be94 -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/src/main/java/egovframework/api/arms/module_pdservice/controller/UserPdServiceController.java (.../UserPdServiceController.java) (revision 9acfa51a82d6eae6c7e1738728fd414f77b8be94) +++ web-module/src/main/java/egovframework/api/arms/module_pdservice/controller/UserPdServiceController.java (.../UserPdServiceController.java) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -147,53 +147,53 @@ Connection connection = dataSource.getConnection(); Statement statement = connection.createStatement(); String sql = - "CREATE OR REPLACE TRIGGER \"TRIG_" + reqAddSqlMaaperDTO.getC_title() + "\"\n" + - "BEFORE DELETE OR INSERT OR UPDATE\n" + - "ON " + reqAddSqlMaaperDTO.getC_title() + " REFERENCING NEW AS NEW OLD AS OLD\n" + - "FOR EACH ROW\n" + - "DECLARE\n" + - "tmpVar NUMBER;\n" + - "/******************************************************************************\n" + - " NAME: TRIGGER_COMPREHENSIVETREE\n" + - " PURPOSE: \n" + - " \n" + - " REVISIONS:\n" + - " Ver Date Author Description\n" + - " --------- ---------- --------------- ------------------------------------\n" + - " 1.0 2012-08-29 1. Created this trigger.\n" + - " \n" + - " NOTES:\n" + - " \n" + - " Automatically available Auto Replace Keywords:\n" + - " Object Name: TRIGGER_COMPREHENSIVETREE\n" + - " Sysdate: 2012-08-29\n" + - " Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44\n" + - " Username: (set in TOAD Options, Proc Templates)\n" + - " Table Name: T_ARMS_REQADD (set in the \"New PL/SQL Object\" dialog)\n" + - " Trigger Options: (set in the \"New PL/SQL Object\" dialog)\n" + - "******************************************************************************/\n" + - "BEGIN\n" + - " tmpVar := 0;\n" + - " IF UPDATING THEN \n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE)\n" + - " values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate); \n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE)\n" + - " values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate); \n" + - " END IF;\n" + - " IF DELETING THEN\n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE)\n" + - " values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate);\n" + - " END IF; \n" + - " IF INSERTING THEN\n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE)\n" + - " values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate);\n" + - " END IF;\n" + - " \n" + - " EXCEPTION\n" + - " WHEN OTHERS THEN\n" + - " -- Consider logging the error and then re-raise\n" + - " RAISE;\n" + - "END TRIG_" + reqAddSqlMaaperDTO.getC_title() + ";"; + "CREATE OR REPLACE TRIGGER \"TRIG_" + reqAddSqlMaaperDTO.getC_title() + "\"\n" + + "BEFORE DELETE OR INSERT OR UPDATE\n" + + "ON " + reqAddSqlMaaperDTO.getC_title() + " REFERENCING NEW AS NEW OLD AS OLD\n" + + "FOR EACH ROW\n" + + "DECLARE\n" + + "tmpVar NUMBER;\n" + + "/******************************************************************************\n" + + " NAME: TRIGGER_COMPREHENSIVETREE\n" + + " PURPOSE: \n" + + " \n" + + " REVISIONS:\n" + + " Ver Date Author Description\n" + + " --------- ---------- --------------- ------------------------------------\n" + + " 1.0 2012-08-29 1. Created this trigger.\n" + + " \n" + + " NOTES:\n" + + " \n" + + " Automatically available Auto Replace Keywords:\n" + + " Object Name: TRIGGER_COMPREHENSIVETREE\n" + + " Sysdate: 2012-08-29\n" + + " Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44\n" + + " Username: (set in TOAD Options, Proc Templates)\n" + + " Table Name: T_ARMS_REQADD (set in the \"New PL/SQL Object\" dialog)\n" + + " Trigger Options: (set in the \"New PL/SQL Object\" dialog)\n" + + "******************************************************************************/\n" + + "BEGIN\n" + + " tmpVar := 0;\n" + + " IF UPDATING THEN \n" + + " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + + " values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate,:old.C_PDSERVICE_LINK,:old.C_VERSION_LINK,:old.C_REVIEWER01,:old.C_REVIEWER02,:old.C_REVIEWER03,:old.C_REVIEWER04,:old.C_REVIEWER05,:old.C_WRITER_NAME,:old.C_WRITER_CN,:old.C_WRITER_DATE,:old.C_PRIORITY,:old.C_CONTENTS,:old.C_REQ_STATUS);\n" + + " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + + " values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate,:new.C_PDSERVICE_LINK,:new.C_VERSION_LINK,:new.C_REVIEWER01,:new.C_REVIEWER02,:new.C_REVIEWER03,:new.C_REVIEWER04,:new.C_REVIEWER05,:new.C_WRITER_NAME,:new.C_WRITER_CN,:new.C_WRITER_DATE,:new.C_PRIORITY,:new.C_CONTENTS,:new.C_REQ_STATUS);\n" + + " END IF;\n" + + " IF DELETING THEN\n" + + " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + + " values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate,:old.C_PDSERVICE_LINK,:old.C_VERSION_LINK,:old.C_REVIEWER01,:old.C_REVIEWER02,:old.C_REVIEWER03,:old.C_REVIEWER04,:old.C_REVIEWER05,:old.C_WRITER_NAME,:old.C_WRITER_CN,:old.C_WRITER_DATE,:old.C_PRIORITY,:old.C_CONTENTS,:old.C_REQ_STATUS);\n" + + " END IF; \n" + + " IF INSERTING THEN\n" + + " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + + " values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate,:new.C_PDSERVICE_LINK,:new.C_VERSION_LINK,:new.C_REVIEWER01,:new.C_REVIEWER02,:new.C_REVIEWER03,:new.C_REVIEWER04,:new.C_REVIEWER05,:new.C_WRITER_NAME,:new.C_WRITER_CN,:new.C_WRITER_DATE,:new.C_PRIORITY,:new.C_CONTENTS,:new.C_REQ_STATUS);\n" + + " END IF;\n" + + " \n" + + " EXCEPTION\n" + + " WHEN OTHERS THEN\n" + + " -- Consider logging the error and then re-raise\n" + + " RAISE;\n" + + "END TRIG_" + reqAddSqlMaaperDTO.getC_title() + ";"; statement.execute(sql); } Index: web-module/src/main/java/egovframework/api/arms/module_reqadd/controller/UserReqAddController.java =================================================================== diff -u -r65935b3dc595866abbde4f429990c3a1f6ad37ae -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/src/main/java/egovframework/api/arms/module_reqadd/controller/UserReqAddController.java (.../UserReqAddController.java) (revision 65935b3dc595866abbde4f429990c3a1f6ad37ae) +++ web-module/src/main/java/egovframework/api/arms/module_reqadd/controller/UserReqAddController.java (.../UserReqAddController.java) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -333,93 +333,4 @@ return modelAndView; } - @Resource(name = "egov.dataSource") - DataSource dataSource; - - @ResponseBody - @RequestMapping( - value = {"/makeDB.do"}, - method = {RequestMethod.GET} - ) - public ModelAndView makeDefaultDB(ReqAddSqlMaaperDTO reqAddSqlMaaperDTO, HttpServletRequest request) throws Exception { - - logger.info("UserReqAddController :: getTest :: tableName = " + reqAddSqlMaaperDTO.getC_title()); - - if(reqAddSqlMapper.isExistTable(reqAddSqlMaaperDTO) == 1){ - logger.error("already exist JSTF table : " + reqAddSqlMaaperDTO.getC_title()); - }else{ - reqAddSqlMapper.ddlExecuteToReqAdd(reqAddSqlMaaperDTO); - reqAddSqlMapper.ddlSequenceExecuteToReqAdd(reqAddSqlMaaperDTO); - reqAddSqlMapper.dmlExecuteToReqAdd(reqAddSqlMaaperDTO); - } - - String C_title_org = reqAddSqlMaaperDTO.getC_title(); - reqAddSqlMaaperDTO.setC_title(reqAddSqlMaaperDTO.getC_title() + "_LOG"); - if(reqAddSqlMapper.isExistTable(reqAddSqlMaaperDTO) == 1){ - logger.error("already exist log table : " + reqAddSqlMaaperDTO.getC_title()); - }else{ - reqAddSqlMaaperDTO.setC_title(C_title_org); - reqAddSqlMapper.ddlLogExecuteToReqAdd(reqAddSqlMaaperDTO); - makeTrigger(reqAddSqlMaaperDTO); - } - - ModelAndView modelAndView = new ModelAndView("jsonView"); - modelAndView.addObject("result", "good"); - return modelAndView; - } - - private void makeTrigger(ReqAddSqlMaaperDTO reqAddSqlMaaperDTO) throws SQLException { - Connection connection = dataSource.getConnection(); - Statement statement = connection.createStatement(); - String sql = - "CREATE OR REPLACE TRIGGER \"TRIG_" + reqAddSqlMaaperDTO.getC_title() + "\"\n" + - "BEFORE DELETE OR INSERT OR UPDATE\n" + - "ON " + reqAddSqlMaaperDTO.getC_title() + " REFERENCING NEW AS NEW OLD AS OLD\n" + - "FOR EACH ROW\n" + - "DECLARE\n" + - "tmpVar NUMBER;\n" + - "/******************************************************************************\n" + - " NAME: TRIGGER_COMPREHENSIVETREE\n" + - " PURPOSE: \n" + - " \n" + - " REVISIONS:\n" + - " Ver Date Author Description\n" + - " --------- ---------- --------------- ------------------------------------\n" + - " 1.0 2012-08-29 1. Created this trigger.\n" + - " \n" + - " NOTES:\n" + - " \n" + - " Automatically available Auto Replace Keywords:\n" + - " Object Name: TRIGGER_COMPREHENSIVETREE\n" + - " Sysdate: 2012-08-29\n" + - " Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44\n" + - " Username: (set in TOAD Options, Proc Templates)\n" + - " Table Name: T_ARMS_REQADD (set in the \"New PL/SQL Object\" dialog)\n" + - " Trigger Options: (set in the \"New PL/SQL Object\" dialog)\n" + - "******************************************************************************/\n" + - "BEGIN\n" + - " tmpVar := 0;\n" + - " IF UPDATING THEN \n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + - " values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate,old.C_PDSERVICE_LINK,old.C_VERSION_LINK,old.C_REVIEWER01,old.C_REVIEWER02,old.C_REVIEWER03,old.C_REVIEWER04,old.C_REVIEWER05,old.C_WRITER_NAME,old.C_WRITER_CN,old.C_WRITER_DATE,old.C_PRIORITY,old.C_CONTENTS,old.C_REQ_STATUS);\n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + - " values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate,new.C_PDSERVICE_LINK,new.C_VERSION_LINK,new.C_REVIEWER01,new.C_REVIEWER02,new.C_REVIEWER03,new.C_REVIEWER04,new.C_REVIEWER05,new.C_WRITER_NAME,new.C_WRITER_CN,new.C_WRITER_DATE,new.C_PRIORITY,new.C_CONTENTS,new.C_REQ_STATUS);\n" + - " END IF;\n" + - " IF DELETING THEN\n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + - " values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate,old.C_PDSERVICE_LINK,old.C_VERSION_LINK,old.C_REVIEWER01,old.C_REVIEWER02,old.C_REVIEWER03,old.C_REVIEWER04,old.C_REVIEWER05,old.C_WRITER_NAME,old.C_WRITER_CN,old.C_WRITER_DATE,old.C_PRIORITY,old.C_CONTENTS,old.C_REQ_STATUS);\n" + - " END IF; \n" + - " IF INSERTING THEN\n" + - " insert into " + reqAddSqlMaaperDTO.getC_title() + "_LOG (C_ID,C_PARENTID,C_POSITION,C_LEFT,C_RIGHT,C_LEVEL,C_TITLE,C_TYPE,C_METHOD,C_STATE,C_DATE,C_PDSERVICE_LINK,C_VERSION_LINK,C_REVIEWER01,C_REVIEWER02,C_REVIEWER03,C_REVIEWER04,C_REVIEWER05,C_WRITER_NAME,C_WRITER_CN,C_WRITER_DATE,C_PRIORITY,C_CONTENTS,C_REQ_STATUS)\n" + - " values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate,new.C_PDSERVICE_LINK,new.C_VERSION_LINK,new.C_REVIEWER01,new.C_REVIEWER02,new.C_REVIEWER03,new.C_REVIEWER04,new.C_REVIEWER05,new.C_WRITER_NAME,new.C_WRITER_CN,new.C_WRITER_DATE,new.C_PRIORITY,new.C_CONTENTS,new.C_REQ_STATUS);\n" + - " END IF;\n" + - " \n" + - " EXCEPTION\n" + - " WHEN OTHERS THEN\n" + - " -- Consider logging the error and then re-raise\n" + - " RAISE;\n" + - "END TRIG_" + reqAddSqlMaaperDTO.getC_title() + ";"; - statement.execute(sql); - } - } Index: web-module/src/main/java/egovframework/api/arms/module_reqadd/dao/ReqAddSqlMapperDao.java =================================================================== diff -u -r47623bd6475cdd605786389e3566657d25021224 -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/src/main/java/egovframework/api/arms/module_reqadd/dao/ReqAddSqlMapperDao.java (.../ReqAddSqlMapperDao.java) (revision 47623bd6475cdd605786389e3566657d25021224) +++ web-module/src/main/java/egovframework/api/arms/module_reqadd/dao/ReqAddSqlMapperDao.java (.../ReqAddSqlMapperDao.java) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -9,7 +9,5 @@ public void ddlSequenceExecute(T comprehensiveTree) throws Exception; public void dmlSqlExecute(T comprehensiveTree) throws Exception; public void ddlLogExecute(T comprehensiveTree) throws Exception; - public void ddlTriggerLogExecute(T comprehensiveTree) throws Exception; - public int isExistTable(T comprehensiveTree) throws Exception; } Index: web-module/src/main/java/egovframework/api/arms/module_reqadd/dao/ReqAddSqlMapperDaoImpl.java =================================================================== diff -u -r47623bd6475cdd605786389e3566657d25021224 -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/src/main/java/egovframework/api/arms/module_reqadd/dao/ReqAddSqlMapperDaoImpl.java (.../ReqAddSqlMapperDaoImpl.java) (revision 47623bd6475cdd605786389e3566657d25021224) +++ web-module/src/main/java/egovframework/api/arms/module_reqadd/dao/ReqAddSqlMapperDaoImpl.java (.../ReqAddSqlMapperDaoImpl.java) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -50,11 +50,6 @@ update(comprehensiveTree.getSqlMapSelector() + "." + "ddlLogSqlExecute_comment_9", comprehensiveTree); } - @Override - public void ddlTriggerLogExecute(T comprehensiveTree) throws Exception { - update(comprehensiveTree.getSqlMapSelector() + "." + "ddlTriggerLogSqlExecute", comprehensiveTree); - } - public int isExistTable( T comprehensiveTree ) throws Exception{ return (int) getSqlMapClientTemplate().queryForObject( comprehensiveTree.getSqlMapSelector() + ".isExistTable", comprehensiveTree); Index: web-module/src/main/java/egovframework/api/arms/module_reqadd/service/ReqAddSqlMapper.java =================================================================== diff -u -r47623bd6475cdd605786389e3566657d25021224 -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/src/main/java/egovframework/api/arms/module_reqadd/service/ReqAddSqlMapper.java (.../ReqAddSqlMapper.java) (revision 47623bd6475cdd605786389e3566657d25021224) +++ web-module/src/main/java/egovframework/api/arms/module_reqadd/service/ReqAddSqlMapper.java (.../ReqAddSqlMapper.java) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -13,7 +13,5 @@ public void ddlLogExecuteToReqAdd(T comprehensiveTree) throws Exception; - public void ddlTriggerLogSqlExecuteToReqAdd(T comprehensiveTree) throws Exception; - public int isExistTable(T comprehensiveTree) throws Exception; } Index: web-module/src/main/java/egovframework/api/arms/module_reqadd/service/ReqAddSqlMapperImpl.java =================================================================== diff -u -r47623bd6475cdd605786389e3566657d25021224 -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/src/main/java/egovframework/api/arms/module_reqadd/service/ReqAddSqlMapperImpl.java (.../ReqAddSqlMapperImpl.java) (revision 47623bd6475cdd605786389e3566657d25021224) +++ web-module/src/main/java/egovframework/api/arms/module_reqadd/service/ReqAddSqlMapperImpl.java (.../ReqAddSqlMapperImpl.java) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -43,11 +43,6 @@ } @Override - public void ddlTriggerLogSqlExecuteToReqAdd(T comprehensiveTree) throws Exception { - reqAddSqlMapperDao.ddlTriggerLogExecute(comprehensiveTree); - } - - @Override public int isExistTable(T comprehensiveTree) throws Exception { return reqAddSqlMapperDao.isExistTable(comprehensiveTree); } Index: web-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/moduleJSTF_SQL_Oracle_iBatis.xml =================================================================== diff -u -r79901aa92959daf45ca73114c064a91cbbb9f91e -r84e1c82407103a9e26b421f2efa3af8931ddf7a5 --- web-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/moduleJSTF_SQL_Oracle_iBatis.xml (.../moduleJSTF_SQL_Oracle_iBatis.xml) (revision 79901aa92959daf45ca73114c064a91cbbb9f91e) +++ web-module/src/main/resources/egovframework/sqlmap/com/ext/jstree/springiBatis/moduleJSTF_SQL_Oracle_iBatis.xml (.../moduleJSTF_SQL_Oracle_iBatis.xml) (revision 84e1c82407103a9e26b421f2efa3af8931ddf7a5) @@ -163,35 +163,6 @@ COMMENT ON COLUMN $c_title$_LOG.C_DATE IS '노드 변경 시' - - - -