wqx2006 发表于 2017-03-17 11:54

websphere的错误日志,大神帮忙看看是什么问题导致的

17-3-16 15:25:46:186 CST] 00000040 SystemErr   R         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
00000040 SystemErr   R         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
00000040 SystemErr   R         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
00000040 SystemErr   R         at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
00000040 SystemErr   R         at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:368)
00000040 SystemErr   R         at com.sun.proxy.$Proxy25.selectOne(Unknown Source)
00000040 SystemErr   R         at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
00000040 SystemErr   R         at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
00000040 SystemErr   R         at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
00000040 SystemErr   R         at com.sun.proxy.$Proxy121.getDataFromDatabase(Unknown Source)
00000040 SystemErr   R         at com.jiayu.xtggzy.service.impl.TPwDictServiceImpl.getDataFromDatabase(TPwDictServiceImpl.java:146)
00000040 SystemErr   R         at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
00000040 SystemErr   R         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00000040 SystemErr   R         at java.lang.reflect.Method.invoke(Method.java:600)
00000040 SystemErr   R         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
00000040 SystemErr   R         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
00000040 SystemErr   R         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
00000040 SystemErr   R         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
00000040 SystemErr   R         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
00000040 SystemErr   R         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
00000040 SystemErr   R         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
00000040 SystemErr   R         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
00000040 SystemErr   R         at com.sun.proxy.$Proxy165.getDataFromDatabase(Unknown Source)
00000040 SystemErr   R         at com.jiayu.util.GetDataFromDatabase.queryDateString(GetDataFromDatabase.java:45)
00000040 SystemErr   R         at com.jiayu.util.GetDataFromDatabase.getDateTime(GetDataFromDatabase.java:29)
00000040 SystemErr   R         at com.jiayu.interceptor.RightsHandlerInterceptor.preHandle(RightsHandlerInterceptor.java:28)
00000040 SystemErr   R         at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:914)
00000040 SystemErr   R         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
00000040 SystemErr   R         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
00000040 SystemErr   R         at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
00000040 SystemErr   R         at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
00000040 SystemErr   R         at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)
00000040 SystemErr   R         at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
00000040 SystemErr   R         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
00000040 SystemErr   R         at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
00000040 SystemErr   R         at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
00000040 SystemErr   R         at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
00000040 SystemErr   R         at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
00000040 SystemErr   R         at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
00000040 SystemErr   R         at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
00000040 SystemErr   R         at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
00000040 SystemErr   R         at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
00000040 SystemErr   R         at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
00000040 SystemErr   R         at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
00000040 SystemErr   R         at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
00000040 SystemErr   R         at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
00000040 SystemErr   R         at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656)
00000040 SystemErr   R Caused by: java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform a prepareStatement operation after the connection has been closed
00000040 SystemErr   R         at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
00000040 SystemErr   R         at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)
00000040 SystemErr   R         at com.ibm.db2.jcc.a.fb$$EnhancerByProxool$$8e31c218.prepareStatement(<generated>)
00000040 SystemErr   R         at sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)
00000040 SystemErr   R         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00000040 SystemErr   R         at java.lang.reflect.Method.invoke(Method.java:600)
00000040 SystemErr   R         at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:53)
00000040 SystemErr   R         at com.sun.proxy.$Proxy363.prepareStatement(Unknown Source)
00000040 SystemErr   R         at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:72)
00000040 SystemErr   R         at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:82)
00000040 SystemErr   R         at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:54)
00000040 SystemErr   R         at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
00000040 SystemErr   R         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00000040 SystemErr   R         at java.lang.reflect.Method.invoke(Method.java:600)
00000040 SystemErr   R         at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:46)
00000040 SystemErr   R         at com.jiayu.plugin.PagePlugin.intercept(PagePlugin.java:141)
00000040 SystemErr   R         at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:57)
00000040 SystemErr   R         at com.sun.proxy.$Proxy362.prepare(Unknown Source)
00000040 SystemErr   R         at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:70)
00000040 SystemErr   R         at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
00000040 SystemErr   R         at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
00000040 SystemErr   R         at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
00000040 SystemErr   R         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:98)
00000040 SystemErr   R         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:73)
00000040 SystemErr   R         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
00000040 SystemErr   R         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
00000040 SystemErr   R         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)
00000040 SystemErr   R         at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
00000040 SystemErr   R         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00000040 SystemErr   R         at java.lang.reflect.Method.invoke(Method.java:600)
00000040 SystemErr   R         at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
00000040 SystemErr   R         ... 55 more
00000040 SystemErr   R org.springframework.jdbc.UncategorizedSQLException:
### Error querying database.Cause: java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform a prepareStatement operation after the connection has been closed
### The error may exist in resources/mybatis/xtggzy/TPwDict.xml
### The error may involve com.jiayu.xtggzy.mapper.DictMapper.getDataFromDatabase
### The error occurred while executing a query
### SQL: SELECT to_char( CURRENT TIMESTAMP,'yyyy-MM-dd HH24:mi:ss') FROM SYSIBM.SYSDUMMY1
### Cause: java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform a prepareStatement operation after the connection has been closed
; uncategorized SQLException for SQL []; SQL state ; error code ; Couldn't perform the operation prepareStatement: You can't perform a prepareStatement operation after the connection has been closed; nested exception is java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform a prepareStatement operation after the connection has been closed
00000040 SystemErr   R         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
00000040 SystemErr   R         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
00000040 SystemErr   R         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
00000040 SystemErr   R         at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
00000040 SystemErr   R         at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:368)
00000040 SystemErr   R         at com.sun.proxy.$Proxy25.selectOne(Unknown Source)
00000040 SystemErr   R         at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
00000040 SystemErr   R         at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
00000040 SystemErr   R         at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
00000040 SystemErr   R         at com.sun.proxy.$Proxy121.getDataFromDatabase(Unknown Source)
00000040 SystemErr   R         at com.jiayu.xtggzy.service.impl.TPwDictServiceImpl.getDataFromDatabase(TPwDictServiceImpl.java:146)
00000040 SystemErr   R         at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
00000040 SystemErr   R         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00000040 SystemErr   R         at java.lang.reflect.Method.invoke(Method.java:600)
00000040 SystemErr   R         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)


wqx2006 发表于 2017-03-17 11:56

这个问题老是导致web 界面报应用异常的错误。刷新几次就自己恢复了。实在是不知道怎么处理了
页: [1]
查看完整版本: websphere的错误日志,大神帮忙看看是什么问题导致的