all_in_one 포털(예제) 메인화면 눌르면 에러가 납니다.
- 작성자 :
- 조*준
- 작성일 :
- 2014-02-14 16:56:29
- 조회수 :
- 1,585
- 구분 :
- 실행환경
- 진행상태 :
- 완료
Q
2014-02-14 16:54:25,161 ERROR [egovframework.com.sym.mnu.mpm.service.impl.EgovMenuManageServiceImpl] SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/sym/mnu/mpm/EgovMainMenu_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the menuManageDAO.selectMainMenuHead-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/sym/mnu/mpm/EgovMainMenu_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the menuManageDAO.selectMainMenuHead-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
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)
at egovframework.rte.psl.dataaccess.EgovAbstractDAO.list(EgovAbstractDAO.java:124)
at egovframework.com.sym.mnu.mpm.service.impl.MenuManageDAO.selectMainMenuHead(MenuManageDAO.java:165)
at egovframework.com.sym.mnu.mpm.service.impl.EgovMenuManageServiceImpl.selectMainMenuHead(EgovMenuManageServiceImpl.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
처리방법좀 알려주세요
--- The error occurred in egovframework/sqlmap/com/sym/mnu/mpm/EgovMainMenu_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the menuManageDAO.selectMainMenuHead-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/sym/mnu/mpm/EgovMainMenu_SQL_Oracle.xml.
--- The error occurred while applying a parameter map.
--- Check the menuManageDAO.selectMainMenuHead-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
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)
at egovframework.rte.psl.dataaccess.EgovAbstractDAO.list(EgovAbstractDAO.java:124)
at egovframework.com.sym.mnu.mpm.service.impl.MenuManageDAO.selectMainMenuHead(MenuManageDAO.java:165)
at egovframework.com.sym.mnu.mpm.service.impl.EgovMenuManageServiceImpl.selectMainMenuHead(EgovMenuManageServiceImpl.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
처리방법좀 알려주세요
A
안녕하세요. 표준프레임워크센터입니다.
해당 에러 메시지로 보아
쿼리 안에서 서브쿼리가 단일행이 넘어와야하는데 다중 행이 넘어온 에러입니다.
데이터가 잘못 중복으로 들어간 듯 싶습니다.
데이터들을 날렸다가 다시 넣어보시면 됩니다.
감사합니다.
해당 에러 메시지로 보아
쿼리 안에서 서브쿼리가 단일행이 넘어와야하는데 다중 행이 넘어온 에러입니다.
데이터가 잘못 중복으로 들어간 듯 싶습니다.
데이터들을 날렸다가 다시 넣어보시면 됩니다.
감사합니다.
