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

相关推荐

    vnc连接The connection closed unexpectedly

    kvm创建windows虚拟机,vnc连接报错.The connection closed unexpectedly 解决方法

    ABB机器人网络服务器端代码.rar

    ???? WHILE TRUE DO str_datab := "[1,1000.1,0.2,300.03,0,90,0]"; TRAN; SocketSend client_socketb\str:=str; !????,??????P19???,???????? Receivedatab; !????,???????,?????? Moveitb; ENDWHILE ...

    connection 和 preparedstatement 的关闭问题

    ### Connection 和 PreparedStatement 的关闭问题 在Java编程语言中,处理数据库连接及执行SQL语句时,合理地管理和释放资源是非常重要的。本文将详细介绍`Connection`和`PreparedStatement`的使用时机与关闭策略,...

    cp30报错No operations allowed after connection closed

    使用mysql+cp30连接池时,报错No operations allowed after connection closed。从报错信息来看,是connection断开导致的错误。在网上搜索后发现,较新版本的mysql配置了connection的默认时间,默认时间一般为8个...

    vnc连接不上原因

    ### VNC连接不上原因分析及解决方法 #### 一、VNC基础知识介绍 VNC(Virtual Network Computing)是一种显示桌面共享系统,它能够通过网络在一台计算机上展示另一台计算机的桌面环境。VNC适用于远程控制场景,尤其...

    connection属性例子

    在.NET编程环境中,尤其是使用C#语言时,`Connection`对象是数据库操作的核心部分,它代表了应用程序与数据库之间的连接。本示例将深入探讨`Connection`属性的使用,帮助你更好地理解和应用这些属性。 首先,`...

    IIS6.0应用程序池回收设置分析

    问题如下: 1.... 2.windows事件查看器-应用程序Log The state server has closed an expired TCP/IP connection. The IP address of the client is 127.0.0.1. The expired Read operation began at

    描述Connection、Statement、ResultSet接口的作用

    标题和描述均聚焦于解释Java Database Connectivity (JDBC)中三个核心接口——`Connection`、`Statement`和`ResultSet`的作用。这三个接口是JDBC API的核心组成部分,它们共同协作,使得Java应用程序能够与各种关系...

    java.sql.connection.pdf

    Java.sql.Connection 接口是Java数据库连接(JDBC)的一部分,它是应用程序与数据库之间建立通信的桥梁。在Java编程中,当你需要执行SQL语句、管理事务或者获取数据库元数据时,都会用到Connection对象。以下是对...

    错误 101 (net--ERR_CONNECTION_RESET).docx

    错误 101 (net--ERR_CONNECTION_RESET).docx

    CloseGraph Mining Closed Frequent Graph Patterns

    根据提供的文件信息,下面是对“CloseGraph: Mining Closed Frequent Graph Patterns”一文的详细知识点解读。 文章标题《CloseGraph: Mining Closed Frequent Graph Patterns》指明了研究的主题,即在图挖掘领域中...

    Closed_Power_Cycles

    关于“Closed Power Cycles”这一标题,首先应当了解什么是能量循环。能量循环(Power Cycles)指的是能量转换过程中形成的一个闭环,是一种将能量从一种形式转换为另一种形式,再转换回原始形式的系统。在物理学和...

    最简单的线刷方式sideload

    - **执行更新**:在设备的恢复模式界面,用户需选择“apply update from ADB”或类似选项,等待脚本完成ZIP文件的传输后,设备会自动开始安装过程。 3. **相关文件详解** - **fastboot-windows.exe**:这是...

    This resource should be closed

    【标题】:“This resource should be closed”提示的可能含义及处理方法 在IT行业中,"This resource should be closed"这样的信息通常指的是某个网络资源、服务器连接、程序实例或数据库连接等不再需要继续运行,...

    No operations allowed after statement closed.

    解决:com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.

    基于Closed Loop RRT*的路径规划算法(Python实现)

    基于Closed Loop RRT的路径规划算法是一种高效的路径规划方法,它结合了Rapidly-exploring Random Tree (RRT)和RRT算法的优点。该算法的核心原理是通过随机采样和树结构的构建来搜索可行路径,并通过迭代优化来提高...

    Closed_Captions_Plugin__v0.18b_Windows_OBS_

    《OBS封闭字幕插件v0.18b for Windows详解及应用指南》 OBS(Open Broadcaster Software)是一款流行的开源直播软件,广泛应用于游戏直播、在线教育、会议录制等多个领域。为了提高视频内容的可访问性,尤其是帮助...

    Open Last Closed Tab--IE撤销关闭窗口插件

    With Open Last Closed Tab, you can re-open those closed tabs by hitting Alt-X or by selecting the page in the toolbar list of previously closed tabs. The newly added Quick Tab Style View, displayed ...

    closed~~~closed~~~closed

    很抱歉,根据您提供的信息,标题、描述以及标签均显示为"closed",这表明这些内容可能不适用于公开讨论或知识分享。压缩包子文件的名称是"海驾智能约车",这似乎与一个智能约车系统或者可能是某个驾校的智能预约平台...

Global site tag (gtag.js) - Google Analytics