세미나 메일연동 인터페이스 활용법 질문좀
- 작성자 :
- 조*준
- 작성일 :
- 2013-03-04 14:33:34
- 조회수 :
- 1,350
- 구분 :
- 공통컴포넌트
- 진행상태 :
- 완료
Q
메일 연동 인터페이스에서 첨부파일 미사용
<!-- 메일 연동 인터페이스에서 첨부파일 사용 -->
<bean id="egovMultiPartEmail"
class="egovframework.com.cop.ems.service.EgovMultiPartEmail"
p:host="smtp.gmail.com"
p:port="587"
p:id="cyj0213"
p:password="######" <-비밀번호입력
p:senderName="System"
p:emailAddress="xxx@xxx.xxx" />
자료입력하면 실패하였습니다 하고!
콘솔에서 에러는안나는데.. 고쳐야되는부분이
context-mail.xml 말거또있나요?
2013-03-04 14:29:00,971 ERROR [egovframework.com.cop.ems.service.impl.EgovSndngMailRegistServiceImpl] SqlMapClient operation; SQL [];
--- The error occurred in egovframework/sqlmap/com/cop/ems/EgovSndngMailRegist_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the sndngMailRegistDAO.insertSndngMail-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02291: integrity constraint (KIKUM.COMTHEMAILDSPTCHMANAGE_FK1) violated - parent key not found
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/cop/ems/EgovSndngMailRegist_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the sndngMailRegistDAO.insertSndngMail-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02291: integrity constraint (KIKUM.COMTHEMAILDSPTCHMANAGE_FK1) violated - parent key not found
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/cop/ems/EgovSndngMailRegist_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the sndngMailRegistDAO.insertSndngMail-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02291: integrity constraint (KIKUM.COMTHEMAILDSPTCHMANAGE_FK1) violated - parent key not found
<!-- 메일 연동 인터페이스에서 첨부파일 사용 -->
<bean id="egovMultiPartEmail"
class="egovframework.com.cop.ems.service.EgovMultiPartEmail"
p:host="smtp.gmail.com"
p:port="587"
p:id="cyj0213"
p:password="######" <-비밀번호입력
p:senderName="System"
p:emailAddress="xxx@xxx.xxx" />
자료입력하면 실패하였습니다 하고!
콘솔에서 에러는안나는데.. 고쳐야되는부분이
context-mail.xml 말거또있나요?
2013-03-04 14:29:00,971 ERROR [egovframework.com.cop.ems.service.impl.EgovSndngMailRegistServiceImpl] SqlMapClient operation; SQL [];
--- The error occurred in egovframework/sqlmap/com/cop/ems/EgovSndngMailRegist_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the sndngMailRegistDAO.insertSndngMail-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02291: integrity constraint (KIKUM.COMTHEMAILDSPTCHMANAGE_FK1) violated - parent key not found
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/cop/ems/EgovSndngMailRegist_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the sndngMailRegistDAO.insertSndngMail-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02291: integrity constraint (KIKUM.COMTHEMAILDSPTCHMANAGE_FK1) violated - parent key not found
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/cop/ems/EgovSndngMailRegist_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the sndngMailRegistDAO.insertSndngMail-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02291: integrity constraint (KIKUM.COMTHEMAILDSPTCHMANAGE_FK1) violated - parent key not found
A
안녕하세요.. 조용준님..
전송 시에 사용한 ID (COMTHEMAILDSPTCHMANAGE 테이블의 SNDR 컬럼)이 COMTNEMPLYRINFO(EMPLYR_ID)에 없어서 발생된 FK 오류입니다..
전송 시에 사용자 ID를 실제 사용자 ID를 지정하시거나.. FK 정의를 해당 테이블(COMTHEMAILDSPTCHMANAGE)에서 삭제하시면 되실 것 같습니다.
그럼.. 즐거운 하루되십시오.
감사합니다.
전송 시에 사용한 ID (COMTHEMAILDSPTCHMANAGE 테이블의 SNDR 컬럼)이 COMTNEMPLYRINFO(EMPLYR_ID)에 없어서 발생된 FK 오류입니다..
전송 시에 사용자 ID를 실제 사용자 ID를 지정하시거나.. FK 정의를 해당 테이블(COMTHEMAILDSPTCHMANAGE)에서 삭제하시면 되실 것 같습니다.
그럼.. 즐거운 하루되십시오.
감사합니다.
