operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];

문제점해결

operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];

예쁜꽃이피었으면 2015. 12. 11. 13:15

하..이 에러로 온 소스를 다 보고 ..

삼일째만에 문제점 찾음..

수정 쿼리문 마지막 칼럼에 , 붙어있었음..

2015-12-10 18:28:34,275 ERROR [egovframework.com.cop.bbs.service.impl.EgovBBSManageServiceImpl] SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];

--- The error occurred in egovframework/sqlmap/com/cop/bbs/EgovBoard_SQL_Oracle.xml.

--- The error occurred while applying a parameter map.

--- Check the BBSManageDAO.updateAwardArticle-InlineParameterMap.

--- Check the statement (update failed).

--- Cause: java.lang.reflect.UndeclaredThrowableException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in egovframework/sqlmap/com/cop/bbs/EgovBoard_SQL_Oracle.xml.

--- The error occurred while applying a parameter map.

--- Check the BBSManageDAO.updateAwardArticle-InlineParameterMap.

--- Check the statement (update failed).

--- Cause: java.lang.reflect.UndeclaredThrowableException

com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in egovframework/sqlmap/com/cop/bbs/EgovBoard_SQL_Oracle.xml.

--- The error occurred while applying a parameter map.

--- Check the BBSManageDAO.updateAwardArticle-InlineParameterMap.

--- Check the statement (update failed).

--- Cause: java.lang.reflect.UndeclaredThrowableException

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:110)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)

at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:380)

at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:1)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)

at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:378)

at egovframework.rte.psl.dataaccess.EgovAbstractDAO.update(EgovAbstractDAO.java:101)

at egovframework.com.cop.bbs.service.impl.BBSManageDAO.updateAwardArticle(BBSManageDAO.java:390)

at egovframework.com.cop.bbs.service.impl.EgovBBSManageServiceImpl.updateAwardArticle(EgovBBSManageServiceImpl.java:416)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:55)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at com.sun.proxy.$Proxy14.updateAwardArticle(Unknown Source)

at egovframework.com.cop.award.web.EgovAwardManageController.updateAnonymousAwardArticle(EgovAwardManageController.java:1070)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at egovframework.com.cmm.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:35)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Unknown Source)

Caused by: java.lang.reflect.UndeclaredThrowableException

at com.sun.proxy.$Proxy29.execute(Unknown Source)

at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)

at com.sun.proxy.$Proxy30.execute(Unknown Source)

at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)

... 57 more

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at core.log.aop.handler.DaoInfo.doAround(DaoInfo.java:95)

at core.log.aop.reflection.profiler.AroundProfiler.invoke(AroundProfiler.java:19)

... 68 more

Caused by: java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)

at core.log.impl.PreparedStatementLoggable.execute(PreparedStatementLoggable.java:109)

... 73 more

2015-12-10 18:28:34,275 DEBUG [egovframework.rte.fdl.cmmn.exception.manager.DefaultExceptionHandleManager] DefaultExceptionHandleManager.run()

2015-12-10 18:28:34,275 DEBUG [egovframework.rte.fdl.cmmn.exception.manager.DefaultExceptionHandleManager] pattern = **service.impl.*, thisPackageName = egovframework.com.cop.bbs.service.impl.EgovBBSManageServiceImpl.updateAwardArticle

2015-12-10 18:28:34,275 DEBUG [egovframework.rte.fdl.cmmn.exception.manager.DefaultExceptionHandleManager] pm.match(pattern, thisPackageName) =true

2015-12-10 18:28:34,275 ERROR [egovframework.com.cmm.EgovComExcepHndlr] egovframework.com.cop.bbs.service.impl.EgovBBSManageServiceImpl.updateAwardArticle

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];

--- The error occurred in egovframework/sqlmap/com/cop/bbs/EgovBoard_SQL_Oracle.xml.

--- The error occurred while applying a parameter map.

--- Check the BBSManageDAO.updateAwardArticle-InlineParameterMap.

--- Check the statement (update failed).

--- Cause: java.lang.reflect.UndeclaredThrowableException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in egovframework/sqlmap/com/cop/bbs/EgovBoard_SQL_Oracle.xml.

--- The error occurred while applying a parameter map.

--- Check the BBSManageDAO.updateAwardArticle-InlineParameterMap.

--- Check the statement (update failed).

--- Cause: java.lang.reflect.UndeclaredThrowableException

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)