실행환경 가이드 프로그램 런 에러
- 작성자 :
- 홍*성
- 작성일 :
- 2010-02-17 16:12:12
- 조회수 :
- 5,155
- 구분 :
- 실행환경
- 진행상태 :
- 완료
Q
1.설치후 민원 목록을 조회하면 아래와 같이 에러 납니다.
1-1. 이상한 것은 /egovframework.guideprogram.civilappeal.services/src/main/resources/sqlmap/rte/egov-cvpl-cnslt.mapping_Hsql.xml 을 전부 주석처리하고 해도 똑같은 에러가 나옵니다.
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in sqlmap/rte/egov-cvpl-cnslt.mapping_Hsql.xml. --- The error occurred while executing query. --- Check the SELECT A.CVPL_NO , A.CVPL_SJ , A.CVPL_CONTENTS , A.CVPL_ATCH1 , A.CVPL_ATCH2 , A.CVPL_OTHBC_CODE , B.CODE_VALUE AS CVPL_OTHBC_NAME , to_char(to_date(A.RECEIPT_TIME, 'yyyyMMddHHmmss'), 'yyyy-MM-dd HH:mm:ss') AS RECEIPT_TIME , A.RECEIPT_TIME AS ORG_RECEIPT_TIME , A.USER_ID , C.USER_NAME , C.DEPT_CODE , D.CODE_VALUE AS DEPT_NAME , C.RSPOFC_CODE , E.CODE_VALUE AS RSPOFC_NAME , A.ANSWER_CONTENTS , A.ANSWER_ATCH1 , A.ANSWER_ATCH2 , to_char(to_date(A.ANSWER_TIME, 'yyyyMMddHHmmss'), 'yyyy-MM-dd HH:mm:ss') AS ANSWER_TIME , A.ANSWER_TIME AS ORG_ANSWER_TIME , A.ANSWER_USER_ID , F.USER_NAME AS ANSWER_USER_NAME , F.DEPT_CODE AS ANSWER_DEPT_CODE , G.CODE_VALUE AS ANSWER_DEPT_NAME , F.RSPOFC_CODE AS ANSWER_RSPOFC_CODE , H.CODE_VALUE AS ANSWER_RSPOFC_NAME , A.EMAIL_YN , A.ADMNSTMACH_CODE , Z.CODE_VALUE AS ADMNSTMACH_NAME , A.BEST_YN FROM RTETNCVPL A INNER JOIN RTETCCMMCODE Z ON Z.MAIN_CODE = '004' AND A.ADMNSTMACH_CODE = Z.SUB_CODE INNER JOIN RTETCCMMCODE B ON B.MAIN_CODE = '001' AND A.CVPL_OTHBC_CODE = B.SUB_CODE INNER JOIN RTETNUSER C ON A.USER_ID = C.USER_ID LEFT OUTER JOIN RTETCCMMCODE D ON D.MAIN_CODE = '002' AND C.DEPT_CODE = D.SUB_CODE LEFT OUTER JOIN RTETCCMMCODE E ON E.MAIN_CODE = '003' AND C.RSPOFC_CODE = E.SUB_CODE LEFT OUTER JOIN RTETNUSER F ON A.ANSWER_USER_ID = F.USER_ID LEFT OUTER JOIN RTETCCMMCODE G ON G.MAIN_CODE = '002' AND F.DEPT_CODE = G.SUB_CODE LEFT OUTER JOIN RTETCCMMCODE H ON H.MAIN_CODE = '003' AND F.RSPOFC_CODE = H.SUB_CODE WHERE 1 = 1 ORDER BY A.RECEIPT_TIME DESC LIMIT ? OFFSET ? . --- Check the SQL Statement (preparation failed). --- Cause: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlmap/rte/egov-cvpl-cnslt.mapping_Hsql.xml. --- The error occurred while executing query. --- Check the
----------이하 생략--------------
그리고 처음 시작하면
java.lang.NoClassDefFoundError: javax/xml/ws/soap/MTOM
이 나옵니다.
1-1. 이상한 것은 /egovframework.guideprogram.civilappeal.services/src/main/resources/sqlmap/rte/egov-cvpl-cnslt.mapping_Hsql.xml 을 전부 주석처리하고 해도 똑같은 에러가 나옵니다.
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in sqlmap/rte/egov-cvpl-cnslt.mapping_Hsql.xml. --- The error occurred while executing query. --- Check the SELECT A.CVPL_NO , A.CVPL_SJ , A.CVPL_CONTENTS , A.CVPL_ATCH1 , A.CVPL_ATCH2 , A.CVPL_OTHBC_CODE , B.CODE_VALUE AS CVPL_OTHBC_NAME , to_char(to_date(A.RECEIPT_TIME, 'yyyyMMddHHmmss'), 'yyyy-MM-dd HH:mm:ss') AS RECEIPT_TIME , A.RECEIPT_TIME AS ORG_RECEIPT_TIME , A.USER_ID , C.USER_NAME , C.DEPT_CODE , D.CODE_VALUE AS DEPT_NAME , C.RSPOFC_CODE , E.CODE_VALUE AS RSPOFC_NAME , A.ANSWER_CONTENTS , A.ANSWER_ATCH1 , A.ANSWER_ATCH2 , to_char(to_date(A.ANSWER_TIME, 'yyyyMMddHHmmss'), 'yyyy-MM-dd HH:mm:ss') AS ANSWER_TIME , A.ANSWER_TIME AS ORG_ANSWER_TIME , A.ANSWER_USER_ID , F.USER_NAME AS ANSWER_USER_NAME , F.DEPT_CODE AS ANSWER_DEPT_CODE , G.CODE_VALUE AS ANSWER_DEPT_NAME , F.RSPOFC_CODE AS ANSWER_RSPOFC_CODE , H.CODE_VALUE AS ANSWER_RSPOFC_NAME , A.EMAIL_YN , A.ADMNSTMACH_CODE , Z.CODE_VALUE AS ADMNSTMACH_NAME , A.BEST_YN FROM RTETNCVPL A INNER JOIN RTETCCMMCODE Z ON Z.MAIN_CODE = '004' AND A.ADMNSTMACH_CODE = Z.SUB_CODE INNER JOIN RTETCCMMCODE B ON B.MAIN_CODE = '001' AND A.CVPL_OTHBC_CODE = B.SUB_CODE INNER JOIN RTETNUSER C ON A.USER_ID = C.USER_ID LEFT OUTER JOIN RTETCCMMCODE D ON D.MAIN_CODE = '002' AND C.DEPT_CODE = D.SUB_CODE LEFT OUTER JOIN RTETCCMMCODE E ON E.MAIN_CODE = '003' AND C.RSPOFC_CODE = E.SUB_CODE LEFT OUTER JOIN RTETNUSER F ON A.ANSWER_USER_ID = F.USER_ID LEFT OUTER JOIN RTETCCMMCODE G ON G.MAIN_CODE = '002' AND F.DEPT_CODE = G.SUB_CODE LEFT OUTER JOIN RTETCCMMCODE H ON H.MAIN_CODE = '003' AND F.RSPOFC_CODE = H.SUB_CODE WHERE 1 = 1 ORDER BY A.RECEIPT_TIME DESC LIMIT ? OFFSET ? . --- Check the SQL Statement (preparation failed). --- Cause: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlmap/rte/egov-cvpl-cnslt.mapping_Hsql.xml. --- The error occurred while executing query. --- Check the
----------이하 생략--------------
그리고 처음 시작하면
java.lang.NoClassDefFoundError: javax/xml/ws/soap/MTOM
이 나옵니다.
A
안녕하세요.. 홍오성님..
해당 오류는 egovframework.rte.cvpl.util.EgovHsqlFunction 클래스가 없어서 발생한 오류입니다.
가이드 프로그램에 대한 변경으로 인하여 발생한 문제로 보입니다.
변경 작업에 대한 내용을 확인하시면 될 것 같습니다.
혹.. 해당 클래스의 삭제 등의 문제이면..
처음 배포본을 다시 import 하시기 바랍니다.
그럼.. 즐거운 하루되십시오.
감사합니다.
해당 오류는 egovframework.rte.cvpl.util.EgovHsqlFunction 클래스가 없어서 발생한 오류입니다.
가이드 프로그램에 대한 변경으로 인하여 발생한 문제로 보입니다.
변경 작업에 대한 내용을 확인하시면 될 것 같습니다.
혹.. 해당 클래스의 삭제 등의 문제이면..
처음 배포본을 다시 import 하시기 바랍니다.
그럼.. 즐거운 하루되십시오.
감사합니다.
