프레임워크3.2 - CUBRID 연동 오류 관련의 건
- 작성자 :
- 고*필
- 작성일 :
- 2015-03-31 17:25:32
- 조회수 :
- 1,890
- 구분 :
- 개발환경
- 진행상태 :
- 완료
Q
프레임워크 3.2 - cubrid 연동하여, 구동시 아래와 같은 오류가 발생합니다.
찍힌 쿼리를 참조하니, method 가 예약어여서 발생하는 문제로 보입니다. (불확실함)
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource' defined in file [C:\work\projects\egov\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\egovframework\WEB-INF\classes\egovframework\spring\com\context-common.xml]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'methodSecurityMetadataSourceAdvisor' defined in URL
중략...
[jar:file:/C:/work/projects/egov/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/egovframework/WEB-INF/lib/egovframework.rte.fdl.security-3.1.0.jar!/META-INF/spring/security/method-config.xml]: Cannot resolve reference to bean 'methodMap' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'methodMap' defined in URL [jar:file:/C:/work/projects/egov/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/egovframework/WEB-INF/lib/egovframework.rte.fdl.security-3.1.0.jar!/META-INF/spring/security/method-config.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ SELECT a.ROLE_PTTRN method, b.AUTHOR_CODE authority FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'method' ORDER BY a.ROLE_SORT]; nested exception is cubrid.jdbc.driver.CUBRIDException: Syntax: In line 1, column 25 before ', b.AUTHOR_CODE authority FROM COMTNROLEINFO a, COMTNAUTHOR...'
오류수행쿼리
SELECT a.ROLE_PTTRN method, b.AUTHOR_CODE authority FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'method' ORDER BY a.ROLE_SORT
위의 사항 확인부탁드리겠습니다.
찍힌 쿼리를 참조하니, method 가 예약어여서 발생하는 문제로 보입니다. (불확실함)
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource' defined in file [C:\work\projects\egov\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\egovframework\WEB-INF\classes\egovframework\spring\com\context-common.xml]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'methodSecurityMetadataSourceAdvisor' defined in URL
중략...
[jar:file:/C:/work/projects/egov/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/egovframework/WEB-INF/lib/egovframework.rte.fdl.security-3.1.0.jar!/META-INF/spring/security/method-config.xml]: Cannot resolve reference to bean 'methodMap' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'methodMap' defined in URL [jar:file:/C:/work/projects/egov/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/egovframework/WEB-INF/lib/egovframework.rte.fdl.security-3.1.0.jar!/META-INF/spring/security/method-config.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ SELECT a.ROLE_PTTRN method, b.AUTHOR_CODE authority FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'method' ORDER BY a.ROLE_SORT]; nested exception is cubrid.jdbc.driver.CUBRIDException: Syntax: In line 1, column 25 before ', b.AUTHOR_CODE authority FROM COMTNROLEINFO a, COMTNAUTHOR...'
오류수행쿼리
SELECT a.ROLE_PTTRN method, b.AUTHOR_CODE authority FROM COMTNROLEINFO a, COMTNAUTHORROLERELATE b WHERE a.ROLE_CODE = b.ROLE_CODE AND a.ROLE_TY = 'method' ORDER BY a.ROLE_SORT
위의 사항 확인부탁드리겠습니다.
A
안녕하세요. 고재필님.
cubrid의 경우 확인 결과 예약어에 대하여 큰따옴표나 대괄호로 식별자로 사용할 수 있다고 합니다.
a.ROLE_PTTRN \"method\" 또는 a.ROLE_PTTRN [method]
이렇게 적용하시면 되실 것 같습니다.
그럼, 즐거운 하루되십시오.
cubrid의 경우 확인 결과 예약어에 대하여 큰따옴표나 대괄호로 식별자로 사용할 수 있다고 합니다.
a.ROLE_PTTRN \"method\" 또는 a.ROLE_PTTRN [method]
이렇게 적용하시면 되실 것 같습니다.
그럼, 즐거운 하루되십시오.