mybatis 쿼리 실행시 에러
- 작성자 :
- 손*민
- 작성일 :
- 2013-09-06 13:47:16
- 조회수 :
- 2,441
- 구분 :
- 개발환경
- 진행상태 :
- 완료
Q
쿼리 실행시 에러가 발생합니다.
원인을 모르겠네요..
2013-09-06 13:43:58,999 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] RuntimeException case :: RuntimeException
2013-09-06 13:43:59,003 ERROR [egovframework.rte.sample.service.impl.EgovSampleServiceImpl] SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/rte/sample/Baseinfo_Account_SQL.xml.
--- The error occurred while applying a parameter map.
--- Check the sampleDAO.selectAccountList_D-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/rte/sample/Baseinfo_Account_SQL.xml.
--- The error occurred while applying a parameter map.
--- Check the sampleDAO.selectAccountList_D-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:295)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:1)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)
원인을 모르겠네요..
2013-09-06 13:43:58,999 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] RuntimeException case :: RuntimeException
2013-09-06 13:43:59,003 ERROR [egovframework.rte.sample.service.impl.EgovSampleServiceImpl] SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/rte/sample/Baseinfo_Account_SQL.xml.
--- The error occurred while applying a parameter map.
--- Check the sampleDAO.selectAccountList_D-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/rte/sample/Baseinfo_Account_SQL.xml.
--- The error occurred while applying a parameter map.
--- Check the sampleDAO.selectAccountList_D-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:295)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:1)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)
A
안녕하세요. 손상민님
해당 오류는 명령어가 잘못되어 있을 때 발생하는 오류입니다.
해당 쿼리문을 직접 DB에서 실행해서 쿼리문에 대한 오류가 없는 지 점검하시고,
이상이 없으시면 mybatis 구문에 대한 오류가 없는 지 확인해 보시기 바랍니다.
고맙습니다.
해당 오류는 명령어가 잘못되어 있을 때 발생하는 오류입니다.
해당 쿼리문을 직접 DB에서 실행해서 쿼리문에 대한 오류가 없는 지 점검하시고,
이상이 없으시면 mybatis 구문에 대한 오류가 없는 지 확인해 보시기 바랍니다.
고맙습니다.
