type Exception report
message Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: ### Error querying database. Cause: java.sql.SQLException: ORA-01722: invalid number ### The error may exist in com/mc/web/sqlmap/carallbaro.xml ### The error may involve carallbaro.list-Inline ### The error occurred while setting parameters ### SQL: SELECT PT1.* FROM ( SELECT PT1_SUB.*, ROW_NUMBER() OVER(ORDER BY PT1_SUB.SEQ DESC) RN FROM ( SELECT T1.SEQ, T1.TITLE, T1.CONTENT, T1.CARMAKERSEQ, T1.SIDO_CD, T1.SIGUNGU_CD, T1.REG_NM, T1.REG_SEQ, T1.TEL, T1.PASSWORD, T1.MEMBER_YN, T1.SET_TYPE, T1.TYPE_STATE, T1.INSURANCE_YN, T1.RENT_YN, T1.PICKUP_YN, TO_CHAR(T1.TOW_DATE,'yyyy-mm-dd') AS TOW_DATE, T1.TOW_TIME, T1.TOW_TYPE, TO_CHAR(T1.REG_DT,'yyyy-mm-dd') AS REG_DT, T1.DEL_YN, T1.STATE, TO_CHAR(T1.RESERV_DT,'yyyy-mm-dd') AS RESERV_DT, T1.THUMB, T1.CARINFO, T2.MAKERNM, T4.DONG_NM AS SIDO_NM, T5.DONG_NM AS SIGUNGU_NM, CASE WHEN T6.CNT IS NOT NULL THEN T6.CNT ELSE 0 END AS COMMENT_CNT, CASE WHEN T3.UUID IS NOT NULL THEN '/upload/board/' || T3.YYYY || '/' || T3.MM || '/' || T3.UUID ELSE '' END AS FILE_THUMB FROM NSH_CARALLBARO T1 LEFT OUTER JOIN V_IS_CARMAKER T2 ON T2.CARMAKERSEQ = T1.CARMAKERSEQ LEFT OUTER JOIN NSH_ATTACH T3 ON T3.TABLE_NM = 'NSH_CARALLBARO' AND T3.TABLE_SEQ = T1.SEQ AND T3.ORDER_SEQ = 1 LEFT OUTER JOIN ( SELECT SIDO, DONG_NM FROM NSH_DONG WHERE USE_YN='Y' AND ( (SIDO = '36' and SIGUNGU='110' AND DONG='000') OR (SIGUNGU='000' AND DONG='000') ) ) T4 ON T4.SIDO = T1.SIDO_CD LEFT OUTER JOIN ( SELECT SIDO, SIGUNGU, CASE WHEN length(DONG_NM) -length(replace(DONG_NM, ' ', ''))=0 THEN DONG_NM ELSE TRIM(FN_GET_SPLIT(DONG_NM, 2, ' ', '')) || ' ' || FN_GET_SPLIT(DONG_NM, 3, ' ', '') END AS DONG_NM FROM NSH_DONG WHERE USE_YN='Y' AND SIGUNGU != '000' AND DONG='000' ) T5 ON T5.SIGUNGU = T1.SIGUNGU_CD AND T5.SIDO = T1.SIDO_CD LEFT OUTER JOIN( SELECT DISTINCT ARTICLE_SEQ, COUNT(COMMENT_SEQ) AS CNT FROM NSH_COMMENT WHERE DEL_YN='N' GROUP BY ARTICLE_SEQ ) T6 ON T6.ARTICLE_SEQ = T1.SEQ WHERE T1.DEL_YN='N' AND T1.SET_TYPE IN (2) AND T1.TYPE_STATE = ? ) PT1_SUB WHERE DEL_YN = 'N' ) PT1 WHERE CEIL(RN/NVL(?,10))=NVL(?,1) ORDER BY RN ASC ### Cause: java.sql.SQLException: ORA-01722: invalid number ; SQL []; ORA-01722: invalid number ; nested exception is java.sql.SQLException: ORA-01722: invalid number org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857) javax.servlet.http.HttpServlet.service(HttpServlet.java:620) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) javax.servlet.http.HttpServlet.service(HttpServlet.java:727) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause
org.springframework.dao.DataIntegrityViolationException: ### Error querying database. Cause: java.sql.SQLException: ORA-01722: invalid number ### The error may exist in com/mc/web/sqlmap/carallbaro.xml ### The error may involve carallbaro.list-Inline ### The error occurred while setting parameters ### SQL: SELECT PT1.* FROM ( SELECT PT1_SUB.*, ROW_NUMBER() OVER(ORDER BY PT1_SUB.SEQ DESC) RN FROM ( SELECT T1.SEQ, T1.TITLE, T1.CONTENT, T1.CARMAKERSEQ, T1.SIDO_CD, T1.SIGUNGU_CD, T1.REG_NM, T1.REG_SEQ, T1.TEL, T1.PASSWORD, T1.MEMBER_YN, T1.SET_TYPE, T1.TYPE_STATE, T1.INSURANCE_YN, T1.RENT_YN, T1.PICKUP_YN, TO_CHAR(T1.TOW_DATE,'yyyy-mm-dd') AS TOW_DATE, T1.TOW_TIME, T1.TOW_TYPE, TO_CHAR(T1.REG_DT,'yyyy-mm-dd') AS REG_DT, T1.DEL_YN, T1.STATE, TO_CHAR(T1.RESERV_DT,'yyyy-mm-dd') AS RESERV_DT, T1.THUMB, T1.CARINFO, T2.MAKERNM, T4.DONG_NM AS SIDO_NM, T5.DONG_NM AS SIGUNGU_NM, CASE WHEN T6.CNT IS NOT NULL THEN T6.CNT ELSE 0 END AS COMMENT_CNT, CASE WHEN T3.UUID IS NOT NULL THEN '/upload/board/' || T3.YYYY || '/' || T3.MM || '/' || T3.UUID ELSE '' END AS FILE_THUMB FROM NSH_CARALLBARO T1 LEFT OUTER JOIN V_IS_CARMAKER T2 ON T2.CARMAKERSEQ = T1.CARMAKERSEQ LEFT OUTER JOIN NSH_ATTACH T3 ON T3.TABLE_NM = 'NSH_CARALLBARO' AND T3.TABLE_SEQ = T1.SEQ AND T3.ORDER_SEQ = 1 LEFT OUTER JOIN ( SELECT SIDO, DONG_NM FROM NSH_DONG WHERE USE_YN='Y' AND ( (SIDO = '36' and SIGUNGU='110' AND DONG='000') OR (SIGUNGU='000' AND DONG='000') ) ) T4 ON T4.SIDO = T1.SIDO_CD LEFT OUTER JOIN ( SELECT SIDO, SIGUNGU, CASE WHEN length(DONG_NM) -length(replace(DONG_NM, ' ', ''))=0 THEN DONG_NM ELSE TRIM(FN_GET_SPLIT(DONG_NM, 2, ' ', '')) || ' ' || FN_GET_SPLIT(DONG_NM, 3, ' ', '') END AS DONG_NM FROM NSH_DONG WHERE USE_YN='Y' AND SIGUNGU != '000' AND DONG='000' ) T5 ON T5.SIGUNGU = T1.SIGUNGU_CD AND T5.SIDO = T1.SIDO_CD LEFT OUTER JOIN( SELECT DISTINCT ARTICLE_SEQ, COUNT(COMMENT_SEQ) AS CNT FROM NSH_COMMENT WHERE DEL_YN='N' GROUP BY ARTICLE_SEQ ) T6 ON T6.ARTICLE_SEQ = T1.SEQ WHERE T1.DEL_YN='N' AND T1.SET_TYPE IN (2) AND T1.TYPE_STATE = ? ) PT1_SUB WHERE DEL_YN = 'N' ) PT1 WHERE CEIL(RN/NVL(?,10))=NVL(?,1) ORDER BY RN ASC ### Cause: java.sql.SQLException: ORA-01722: invalid number ; SQL []; ORA-01722: invalid number ; nested exception is java.sql.SQLException: ORA-01722: invalid number org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371) com.sun.proxy.$Proxy52.selectList(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198) egovframework.rte.psl.dataaccess.EgovAbstractMapper.list(EgovAbstractMapper.java:92) com.mc.web.carallbaro.CarallbaroDAO.getList(CarallbaroDAO.java:17) com.mc.web.carallbaro.UserCarallbaroService.carallbaro_list(UserCarallbaroService.java:56) com.mc.web.carallbaro.UserCarallbaorController.carallbaro_list(UserCarallbaorController.java:31) sun.reflect.GeneratedMethodAccessor271.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721) org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857) javax.servlet.http.HttpServlet.service(HttpServlet.java:620) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) javax.servlet.http.HttpServlet.service(HttpServlet.java:727) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause
java.sql.SQLException: ORA-01722: invalid number oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213) oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952) oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1054) oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1116) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390) org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62) com.sun.proxy.$Proxy163.execute(Unknown Source) org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:59) org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:73) org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:60) org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102) sun.reflect.GeneratedMethodAccessor134.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358) com.sun.proxy.$Proxy52.selectList(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198) egovframework.rte.psl.dataaccess.EgovAbstractMapper.list(EgovAbstractMapper.java:92) com.mc.web.carallbaro.CarallbaroDAO.getList(CarallbaroDAO.java:17) com.mc.web.carallbaro.UserCarallbaroService.carallbaro_list(UserCarallbaroService.java:56) com.mc.web.carallbaro.UserCarallbaorController.carallbaro_list(UserCarallbaorController.java:31) sun.reflect.GeneratedMethodAccessor271.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721) org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857) javax.servlet.http.HttpServlet.service(HttpServlet.java:620) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) javax.servlet.http.HttpServlet.service(HttpServlet.java:727) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.59 logs.