java用c3p0所遇到的问题 error signalled a Connection er ror is still in use

来源：http://qinyingqin.blog.163.com/blog/static/20089207520122202317668/


1、2012-3-20 13:54:20 org.apache.catalina.core.StandardWrapperValve invoke


严重: Servlet.service() for servlet jsp threw exception
java.sql.SQLException: Io 异常: Connection reset by peer: socket write error


2012-03-20 01:54:58 WARN [http-6666-5] (NewPooledConnection.java:486) - [c3p0] A PooledConnection that has already signalled a Connection er
ror is still in use!
2、2012-03-20 01:54:58 WARN [http-6666-5] (NewPooledConnection.java:487) - [c3p0] Another error has occurred [ java.sql.SQLException: 关闭的连接 ] w
hich will not be reported to listeners!
java.sql.SQLException: 关闭的连接


在项目运行中遇到此种错误，可能的一个原因就是网络断了，项目无法连接远程的数据库，所以并不是代码的问题。




可能的一个原因就是网络断了，项目无法连接远程的数据库，所以并不是代码的问题。


my我的错误：


2012-05-30 13:15:04,340 INFO [com.mytea.logquery.baseinfo.UserInfoService@1
40b8fd] - <Success load UserInfo [time=4.326s,user=1464]>
2012-05-30 13:21:53,507 WARN [com.mchange.v2.c3p0.impl.NewPooledConnection] - <[
c3p0] A PooledConnection that has already signalled a Connection error is still
in use!>
2012-05-30 13:21:53,508 WARN [com.mchange.v2.c3p0.impl.NewPooledConnection] - <[
c3p0] Another error has occurred [ java.sql.SQLException: 关闭的连接 ] which wil
l not be reported to listeners!>
java.sql.SQLException: 关闭的连接
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:208)
        at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnectio
n.java:1029)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyCon
nection.java:881)
        at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCl
eanupAfterCompletion(DataSourceTransactionManager.java:304)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.cleanupAfterCompletion(AbstractPlatformTransactionManager.java:919)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:712)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:632)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:314)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:116)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:631)
        at com.mytea.logquery.puburl.dao.PubUrlDao$$EnhancerByCGLIB$$f80352
03.find(<generated>)
        at com.mytea.logquery.logclear.OldLogClear.clearOldResultLogs(OldLo
gClear.java:45)
        at com.mytea.logquery.logclear.OldLogClear.clearOldLogs(OldLogClear
.java:33)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:283)


        at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryB
ean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:27
2)
        at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJob
Bean.java:86)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:520)
2012-05-30 13:21:53,509 WARN [org.springframework.scheduling.quartz.MethodInvoki
ngJobDetailFactoryBean$MethodInvokingJob] - <Invocation of method 'clearOldLogs'
 on target class [class com.mytea.logquery.logclear.OldLogClear] failed>
org.springframework.transaction.TransactionSystemException: Could not commit JDB
C transaction; nested exception is java.sql.SQLException: Io 异常: Connection re
set by peer: socket write error
Caused by:
java.sql.SQLException: Io 异常: Connection reset by peer: socket write error
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:255)
        at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:533)
        at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:
1119)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection
.java:803)
        at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCo
mmit(DataSourceTransactionManager.java:262)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:662)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:632)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:314)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:116)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:631)
        at com.mytea.logquery.puburl.dao.PubUrlDao$$EnhancerByCGLIB$$f80352
03.find(<generated>)
        at com.mytea.logquery.logclear.OldLogClear.clearOldResultLogs(OldLo
gClear.java:45)
        at com.mytea.logquery.logclear.OldLogClear.clearOldLogs(OldLogClear
.java:33)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:283)


        at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryB
ean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:27
2)
        at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJob
Bean.java:86)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:520)