0 0

应用部署后不定时报Closed Connection!请教什么原因?5

//不定时报 Closed Connection


2014-07-29 08:20:00.039 ERROR java.sql.Connection - Error calling Connection.prepareStatement:
java.sql.SQLException: Closed Connection
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.6.0-Production+"]
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.6.0-Production+"]
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.6.0-Production+"]
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.6.0-Production+"]
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.6.0-Production+"]
	at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3046) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.6.0-Production+"]
	at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:2961) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.6.0-Production+"]
	at weblogic.jdbc.common.internal.ConnectionEnv.makeStatement(ConnectionEnv.java:1338) ~[com.bea.core.datasource6_1.4.0.0.jar:1.4.0.0]
	at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1081) ~[com.bea.core.datasource6_1.4.0.0.jar:1.4.0.0]
	at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:995) ~[com.bea.core.datasource6_1.4.0.0.jar:1.4.0.0]
	at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:988) ~[com.bea.core.datasource6_1.4.0.0.jar:1.4.0.0]
	at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:487) ~[com.bea.core.datasource6_1.4.0.0.jar:1.4.0.0]
	at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:na]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[na:na]
	at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:35) ~[mybatis-3.0.5.jar:3.0.5]
	at $Proxy90.prepareStatement(Unknown Source) [na:na]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:50) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:64) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:39) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:55) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:238) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:112) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:78) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:72) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38) [mybatis-3.0.5.jar:3.0.5]
	at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:na]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338) [mybatis-spring-1.0.1.jar:1.0.1]
	at $Proxy64.selectOne(Unknown Source) [na:na]
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154) [mybatis-spring-1.0.1.jar:1.0.1]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75) [mybatis-3.0.5.jar:3.0.5]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:38) [mybatis-3.0.5.jar:3.0.5]
	at $Proxy81.selectJobLogByID(Unknown Source) [na:na]
	at com.minsheng.eservice.esales.job.log.JobLogServiceImpl.findJobLogByID(JobLogServiceImpl.java:46) [JobLogServiceImpl.class:na]
	at com.minsheng.eservice.esales.job.log.JobAspect.printException(JobAspect.java:103) [JobAspect.class:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:na]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[na:na]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:603) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:59) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at com.minsheng.eservice.esales.job.PushSysMessageJob$$EnhancerByCGLIB$$7468e2e7.run(<generated>) [cglib-2.1_3.jar:na]
	at sun.reflect.GeneratedMethodAccessor628.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:na]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[na:na]
	at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273) [spring-core-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264) [spring-context-support-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) [spring-context-support-3.0.5.RELEASE.jar:3.0.5.RELEASE]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:203) [quartz-1.5.2.jar:1.5.2]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) [quartz-1.5.2.jar:1.5.2]
2014年7月29日 11:12

3个答案 按时间排序 按投票排序

0 0

我昨天是java.sql.SQLException:Connection closed,后来查到是和一个数据源配置的事物挂起的问题,检查下配置的事物

2014年8月03日 22:10
0 0

此类问题多事防火墙的问题,你和数据库之间是不是有防火墙?  改一下设置,不然长时间没有数据传输的链接会被防火墙给干掉。

2014年7月29日 13:34
0 0

quertz 调度的工作里面的sql有问题  好好看看  是不是有连接关闭了  仍有查询的操作。

2014年7月29日 11:16

相关推荐

Global site tag (gtag.js) - Google Analytics