티스토리 뷰

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: SqlMapClient operation; SQL [];  
--- The error occurred in xxx.xml. 
--- The error occurred while applying a parameter map. 
--- Check the reserve.addReserveuser-InlineParameterMap. 
--- Check the statement (update failed). 
--- Cause: java.sql.SQLException: ORA-01401: 열에 입력한 값이 너무 큽니다
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in xxx.xml. 
--- The error occurred while applying a parameter map. 
--- Check the xxx.xxx-InlineParameterMap. 
--- Check the statement (update failed). 
--- Cause: java.sql.SQLException: ORA-01401: 열에 입력한 값이 너무 큽니다

 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:488)
 at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
 at jeus.servlet.engine.ServletWrapper.executeServlet(ServletWrapper.java:313)
 at jeus.servlet.filter2.FilterChainImpl.internalDoFilter(FilterChainImpl.java:139)
 at jeus.servlet.filter2.FilterChainImpl.doFilter(FilterChainImpl.java:91)
 at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
 at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
 at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
 at jeus.servlet.filter2.FilterChainImpl.internalDoFilter(FilterChainImpl.java:122)
 at jeus.servlet.filter2.FilterChainImpl.doFilter(FilterChainImpl.java:91)
 at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:65)
 at jeus.servlet.filter2.FilterChainImpl.internalDoFilter(FilterChainImpl.java:122)
 at jeus.servlet.filter2.FilterChainImpl.doFilter(FilterChainImpl.java:91)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
 at com.icross.site.filter.Satisfaction.doFilter(Satisfaction.java:84)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
 at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
 at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
 at jeus.servlet.filter2.FilterChainImpl.internalDoFilter(FilterChainImpl.java:122)
 at jeus.servlet.filter2.FilterChainImpl.doFilter(FilterChainImpl.java:91)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
 at jeus.servlet.filter2.FilterChainImpl.internalDoFilter(FilterChainImpl.java:122)
 at jeus.servlet.filter2.FilterChainImpl.doFilter(FilterChainImpl.java:91)
 at jeus.servlet.engine.ServletWrapper.execute(ServletWrapper.java:195)
 at jeus.servlet.engine.WebtobRequestProcessor.run(WebtobRequestProcessor.java:183)
Caused by: org.springframework.dao.DataIntegrityViolationException: SqlMapClient operation; SQL [];  
--- The error occurred in xxx.xml. 
--- The error occurred while applying a parameter map. 
--- Check the xxx.xxx-InlineParameterMap. 
--- Check the statement (update failed). 
--- Cause: java.sql.SQLException: ORA-01401: 열에 입력한 값이 너무 큽니다
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in xxx.xml. 
--- The error occurred while applying a parameter map. 
--- Check the xxx.xxx-InlineParameterMap. 
--- Check the statement (update failed). 
--- Cause: java.sql.SQLException: ORA-01401: 열에 입력한 값이 너무 큽니다

 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:111)
 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
 at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
 at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
 at xxx.xxx(xxx.java:43)
 at xxx.xxx(xxx.java:43)
 at sun.reflect.GeneratedMethodAccessor1398.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
 at $Proxy74.xxx(Unknown Source)
 at xxx.xxx(xxx.java:301)
 at sun.reflect.GeneratedMethodAccessor1395.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)
 at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)
 at com.icross.pms.util.AbstractMultiActionController.handleRequestInternal(AbstractMultiActionController.java:121)
 at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
 at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
 at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
 at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
 ... 28 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in xxx.xml. 
--- The error occurred while applying a parameter map. 
--- Check the xxx.xxx-InlineParameterMap. 
--- Check the statement (update failed). 
--- Cause: java.sql.SQLException: ORA-01401: 열에 입력한 값이 너무 큽니다

 at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
 at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
 at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
 at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:399)
 at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
 ... 55 more
Caused by: java.sql.SQLException: ORA-01401: 열에 입력한 값이 너무 큽니다

 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:745)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
 at com.javaservice.jennifer.trace.sql.PreparedStatement.execute(Unknown Source)
 at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
 at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
 at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
 ... 59 more

컬럼의 크기가 너무 작았나보다 varchar2(50)이라니... 크기를 좀 넉넉히 늘려주면된다 varchar2(250)정도 ?

댓글
댓글쓰기 폼