2 linihan linihan 于 2014.03.07 11:43 提问

在做数据导出的时候,WAS报sql错误(springMVC、mybatis、DB2) 急 急急

请帮忙看看究竟是报什么错呀,,,急急急

[14-3-7 10:27:37:460 GMT+08:00] 000001fc SystemErr R org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: com.ibm.db2.jcc.b.SqlException

The error may involve com.rainbow.db.query.personalissue.addresslist.PerAddrListQueryMapper.selectByPerAddrListQuery-Inline

### The error occurred while setting parameters

Cause: com.ibm.db2.jcc.b.SqlException

; uncategorized SQLException for SQL []; SQL state [null]; error code [-99999]; null; nested exception is com.ibm.db2.jcc.b.SqlException
[14-3-7 10:27:37:461 GMT+08:00] 000001fc SystemErr R at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
[14-3-7 10:27:37:461 GMT+08:00] 000001fc SystemErr R at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at $Proxy272.selectList(Unknown Source)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at com.rainbow.db.query.personalissue.addresslist.PerAddrListQueryMapperImpl.selectByPerAddrListQuery(PerAddrListQueryMapperImpl.java:22)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at com.rainbow.bl.personalissue.impl.PerAddrListServiceImpl.selectByPerAddrListQuery(PerAddrListServiceImpl.java:120)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at com.rainbow.bl.personalissue.impl.PerAddrListServiceImpl$$FastClassByCGLIB$$bbc37323.invoke()
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at com.rainbow.bl.personalissue.impl.PerAddrListServiceImpl$$EnhancerByCGLIB$$d8b9d10c.selectByPerAddrListQuery()
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at com.rainbow.view.personalissue.PerAddrListController.preAddrlistInfoExport(PerAddrListController.java:617)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1214)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:125)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:62)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:167)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:93)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:110)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:926)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1023)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:522)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:311)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1783)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R Caused by: com.ibm.db2.jcc.b.SqlException
[14-3-7 10:27:37:473 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.s.a(s.java:1517)
[14-3-7 10:27:37:473 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.s.m(s.java:465)
[14-3-7 10:27:37:473 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.s.M(s.java:1102)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.kf.getString(kf.java:903)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.kf.getString(kf.java:1234)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:17)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:8)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:29)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:267)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:250)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:224)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:173)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:146)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:112)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:243)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:117)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:79)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at sun.reflect.GeneratedMethodAccessor1232.invoke(Unknown Source)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R ... 68 more

Csdn user default icon
上传中...
上传图片
插入图片