c3p0 oracle clob查询时报错

0 0

c3p0 oracle clob查询时报错5

系统启动的时候初始化一些数据。前面几个查询没有问题，但是在遇到查询clob的时候报错。奇怪的是，我在公司的时候好好的，在服务器上是好好的。只是查询的时间稍微长一点儿。在公司大概五到十秒左右。而我在家里就会报错。可能是家里的网络环境稍微差一点儿。用的驱动是ojdbc14 试着换成ojdbc6问题依旧。

补充一句，在家里偶尔会启动成功，可能启动十次有一次到两次成功。

报错信息如下

 - ==>  Executing: select t.* from diag_error_symptom t 
2012-06-30 02:22:42,296 DEBUG [java.sql.PreparedStatement] - ==> Parameters: 
2012-06-30 02:22:42,328 DEBUG [org.mybatis.spring.SqlSessionUtils] - Closing no transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@14c6cdb]
2012-06-30 02:22:42,328 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - Returning JDBC Connection to DataSource
2012-06-30 02:22:42,328 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@1186df7 [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1ab74bd)
2012-06-30 02:22:42,328 DEBUG [com.zznode.iptvs.core.intercept.OperationLogsInterceptor] - getSymptomByXML已经执行完毕
2012-06-30 02:22:42,328 INFO [com.zznode.iptvs.core.GlobalSysInfo] - ------IPTV Initializing parallelInterface config success !
2012-06-30 02:22:42,328 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'ticketService'
2012-06-30 02:22:42,328 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating instance of bean 'ticketService'
2012-06-30 02:22:42,328 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Eagerly caching bean 'ticketService' to allow for resolving potential circular references
2012-06-30 02:22:42,328 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - No bean named 'iptvToDhcpService' found in org.springframework.beans.factory.support.DefaultListableBeanFactory@183c44d: defining beans [cacheManager,methodCache,methodCacheInterceptor,methodCachePointCut,ticketService,exceptionHandler,exceptionHandlereAdvisor,passwordEncoder,broadbandUserFlex,linkFlex,broadbandUserServiceImpl,lineQualityServiceImpl,thresholdDetailServiceImpl,systemFlex,areaCodeUtil,thresholdUtil,deviceInfoQueryFlex,diagnosisFlex,lineFlex,stbFlex,diagnosisServiceImpl,lineInfoServiceImpl,synscNetworkServiceImpl,userResourceLinkeDevInfoImpl,DHCPImpl,DSLImpl,bureauDataDiagnosisServiceImpl,macoroOrderDiagnosisServiceImpl,ipNet,iptvImpl,linkDiagnosisServiceImpl,ADSLBandwidthServiceImpl,pon112Impl,ponUtil,iqasServiceImpl,sqmServiceImpl,diagnosisTreeImpl,videoSorceImpl,deviceAlertInfoServiceimpl,devicePerformanceServiceImpl,deviceServiceImpl,bureauDataServiceImpl,devicePfsVi
ewServiceImpl,networkPerformaceServiceImpl,performaceServiceImpl,iqasChannelInfoServiceImpl,iqasChannelPageServiceImpl,iqasViewServiceImpl,onuToOltMessageServiceImpl,ponFilberServiceImpl,mediaServiceImpl,userInfoServiceImpl,iptvWebServiceImpl,iptvToDhcpServiceImpl,dslAllServiceImpl,dslLineServiceImpl,auditServiceImpl,ipNetWorkServiceImpl,hwIptvServiceImpl,zxIptvServiceImpl,itmsCepStaServiceImpl,iptvToPerceptionServiceImpl,ponDbServiceImpl,ponLinkQualityServiceImpl,setTopBoxServiceImpl,iptvToSqmServiceImpl,sqmDbUtilServiceImpl,callIptvIntfServiceImpl,interfaceJobImpl,toDoIntfImpl,customModeFlex,diagSymptomFlex,customModeServiceImpl,diagSymptomServiceImpl,isRelatedServiceImpl,channelFlex,interfaceLogFlex,interfaceMonitor,noticeManageFlex,sysPrivilegeFlex,sysRoleFlex,sysUserFlex,thresholdConfigFlex,operationLogFlex,operationsLogServiceImpl,channelInfoConfigServiceImpl,interfaceLogServiceImpl,noticeServiceImpl,sysPrivilegeServiceImpl,sysRoleServiceImpl,sysUserServiceImpl,alarmFlex,areaInit
Flex,diagnosisTreeFlex,findDeviceFlex,funFlex,ivtAlarmFlex,specialTestFlex,areaFlex,userQueryFlex,videoSourceFlex,alarmSearchServiceImpl,areaInitServiceImpl,chanIpInfoServiceImpl,dhcpAlarmServiceImpl,funSearchServiceImpl,macroOrderServiceImpl,snmpAlarmServiceImpl,subareaInfoServiceImpl,testLanMessageServiceImpl,testOltInfoServiceImpl,testOnuInfoServicreImpl,topologyManageFlex,topologyServiceImpl,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,rightsInterceptor,loggin
gAutoProxy,operationLogsInterceptor,operationLogsAutoProxy,exceptionConvert,videoJobDetail,videoJobDetailMethod,cronTrigger,org.springframework.scheduling.quartz.SchedulerFactoryBean#0,dataSource,dataSource_1,dynamicDataSource,transactionManager,sqlSessionFactory,scan,transactionInterceptor,org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator#0,thresholdDetailMapper,operationLogMapper,interfaceLogsMapper,noticeMapper,sysPrivilegeMapper,sysRoleMapper,sysUserMapper,channelIpMapMapper,opLogMapper,videoSourceQualityMapper,areaMapper,chanIpInfoMapper,channelAlarmMapper,channelBasicMapper,hwSnmpAlarmMapper,netWorkAlarmMapper,netWorkFunMapper,proAlarmMapper,proFunMapper,stbAlarmDetailInfoMapper,stbAlarmInfoMapper,stbFunMapper,subareaInfoMapper,zteSnmpAlarmMapper,iqasChannelInfoMapper,iqasChannelQualityMapper,iqasVodInfoMapper,topologyMapper,deviceAlertMapper,deviceInfoMapper,deviceLinkMapper,devicePerfromaceMapper,devicePortMapper,routeInfoMapper,terminalBizInfoMapper,testArea
Mapper,authenResultMapper,dhcpAlarmMapper,dslLineAnormalInfoMapper,dslLineQualityMapper,ipNetWorkDevPerMapper,ipNetWorkMacroMapper,ipNetWorkPortPFDetailMapper,ipNetWorkPortPFMapper,ipNetWorkQualityDetailMapper,ipNetWorkQualityMapper,ipNetWorkSeqMapper,juDataCheckMapper,juEqupCheckDiffMapper,juEqupCheckMapper,juEqupCheckResultDescMapper,TBInfoMapper,itmsCpeStaMapper,perceptionMapper,testActiveDslMapper,testAdslPortInfoMapper,testAdslPortPerfMapper,testAdslPortStatMapper,testBoardInfoMapper,testDeltMapper,testFtthMapper,testLanPortInfoMapper,testLanPortPerfMapper,testMacaddrMapper,testNeAlarmMapper,testNeInfoMapper,testOnuInfoMapper,testOnuInvalidAlarmHisMapper,testOnuOfflineAlarmHisMapper,testOnuOnlineMapper,testOnuOutsideLineMapper,testOnuPoweroffMapper,testOnuStateMapper,testPingIpMapper,testPonInfoMapper,testPonLogMapper,testResourceDeviceMapper,testResourceMapper,testSeltMapper,testTestResultMapper,sqmUser5QueryMapper,sqmUser5ResponseMapper,userCertificationMapper,userInfoMapper,use
rSubsMapper,zteServiceQlistMapper,zteServiceQlogMapper,zteUserQlistMapper,zteUserQlogMapper,diagCustomModeMapper,diagSymptomMapper,isRelatedMapper,jobInterfaceResultMapper,mediaInfoMapper]; root of factory hierarchy
2012-06-30 02:22:42,328 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Ignoring bean creation exception on FactoryBean type check: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ticketService' defined in file [E:\zznodeworkspace\.metadata\.me_tcat\webapps\IPTV\WEB-INF\classes\applicationContext-cache.xml]: Cannot resolve reference to bean 'iptvToDhcpService' while setting bean property 'target'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'iptvToDhcpService' is defined
2012-06-30 02:22:42,328 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'customModeServiceImpl'
2012-06-30 02:22:42,328 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] - Don't need to create transaction for [$Proxy196.getDiagCustomModeAll]: This method isn't transactional.
2012-06-30 02:22:42,328 DEBUG [org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor] - Found exception handler method: public void com.zznode.iptvs.core.intercept.OperationLogsInterceptor.afterThrowing(java.lang.reflect.Method,java.lang.Object[],java.lang.Object,java.lang.Throwable) throws java.lang.Throwable
2012-06-30 02:22:42,328 DEBUG [org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor] - Found exception handler method: public void com.zznode.iptvs.core.exception.AopExceptionHandler.afterThrowing(java.lang.reflect.Method,java.lang.Object[],java.lang.Object,java.lang.Throwable) throws java.lang.Throwable
2012-06-30 02:22:42,328 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - Fetching JDBC Connection from DataSource
2012-06-30 02:22:42,328 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@1186df7 [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1ab74bd)
2012-06-30 02:22:42,328 DEBUG [org.mybatis.spring.SqlSessionUtils] - Creating SqlSession with JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@193f85a]
2012-06-30 02:22:42,328 DEBUG [java.sql.Connection] - ooo Connection Opened
2012-06-30 02:22:42,328 DEBUG [org.mybatis.spring.transaction.SpringManagedTransaction] - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@193f85a] will not be managed by Spring
2012-06-30 02:22:42,328 DEBUG [org.mybatis.spring.SqlSessionUtils] - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@195df92] was not registered for synchronization because synchronization is not active
2012-06-30 02:22:42,343 DEBUG [java.sql.PreparedStatement] - ==>  Executing: select j.ERROR_ID,t.MODE_XMLSTR from DIAG_CUSTOM_MODE t, DIAG_MODE_CUSTOM j where j.MODE_ID = t.id 
2012-06-30 02:22:42,343 DEBUG [java.sql.PreparedStatement] - ==> Parameters: 
2012-06-30 02:22:44,171 DEBUG [org.mybatis.spring.SqlSessionUtils] - Closing no transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@195df92]
2012-06-30 02:22:44,171 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - Returning JDBC Connection to DataSource
2012-06-30 02:22:44,171 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@1186df7 [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1ab74bd)
2012-06-30 02:22:44,171 DEBUG [com.zznode.iptvs.core.intercept.OperationLogsInterceptor] - getDiagCustomModeAll已经执行完毕
2012-06-30 02:22:44,171 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'ticketService'
2012-06-30 02:22:44,171 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating instance of bean 'ticketService'
2012-06-30 02:22:44,171 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Eagerly caching bean 'ticketService' to allow for resolving potential circular references
2012-06-30 02:22:44,171 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - No bean named 'iptvToDhcpService' found in org.springframework.beans.factory.support.DefaultListableBeanFactory@183c44d: defining beans [cacheManager,methodCache,methodCacheInterceptor,methodCachePointCut,ticketService,exceptionHandler,exceptionHandlereAdvisor,passwordEncoder,broadbandUserFlex,linkFlex,broadbandUserServiceImpl,lineQualityServiceImpl,thresholdDetailServiceImpl,systemFlex,areaCodeUtil,thresholdUtil,deviceInfoQueryFlex,diagnosisFlex,lineFlex,stbFlex,diagnosisServiceImpl,lineInfoServiceImpl,synscNetworkServiceImpl,userResourceLinkeDevInfoImpl,DHCPImpl,DSLImpl,bureauDataDiagnosisServiceImpl,macoroOrderDiagnosisServiceImpl,ipNet,iptvImpl,linkDiagnosisServiceImpl,ADSLBandwidthServiceImpl,pon112Impl,ponUtil,iqasServiceImpl,sqmServiceImpl,diagnosisTreeImpl,videoSorceImpl,deviceAlertInfoServiceimpl,devicePerformanceServiceImpl,deviceServiceImpl,bureauDataServiceImpl,devicePfsVi
ewServiceImpl,networkPerformaceServiceImpl,performaceServiceImpl,iqasChannelInfoServiceImpl,iqasChannelPageServiceImpl,iqasViewServiceImpl,onuToOltMessageServiceImpl,ponFilberServiceImpl,mediaServiceImpl,userInfoServiceImpl,iptvWebServiceImpl,iptvToDhcpServiceImpl,dslAllServiceImpl,dslLineServiceImpl,auditServiceImpl,ipNetWorkServiceImpl,hwIptvServiceImpl,zxIptvServiceImpl,itmsCepStaServiceImpl,iptvToPerceptionServiceImpl,ponDbServiceImpl,ponLinkQualityServiceImpl,setTopBoxServiceImpl,iptvToSqmServiceImpl,sqmDbUtilServiceImpl,callIptvIntfServiceImpl,interfaceJobImpl,toDoIntfImpl,customModeFlex,diagSymptomFlex,customModeServiceImpl,diagSymptomServiceImpl,isRelatedServiceImpl,channelFlex,interfaceLogFlex,interfaceMonitor,noticeManageFlex,sysPrivilegeFlex,sysRoleFlex,sysUserFlex,thresholdConfigFlex,operationLogFlex,operationsLogServiceImpl,channelInfoConfigServiceImpl,interfaceLogServiceImpl,noticeServiceImpl,sysPrivilegeServiceImpl,sysRoleServiceImpl,sysUserServiceImpl,alarmFlex,areaInit
Flex,diagnosisTreeFlex,findDeviceFlex,funFlex,ivtAlarmFlex,specialTestFlex,areaFlex,userQueryFlex,videoSourceFlex,alarmSearchServiceImpl,areaInitServiceImpl,chanIpInfoServiceImpl,dhcpAlarmServiceImpl,funSearchServiceImpl,macroOrderServiceImpl,snmpAlarmServiceImpl,subareaInfoServiceImpl,testLanMessageServiceImpl,testOltInfoServiceImpl,testOnuInfoServicreImpl,topologyManageFlex,topologyServiceImpl,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,rightsInterceptor,loggin
gAutoProxy,operationLogsInterceptor,operationLogsAutoProxy,exceptionConvert,videoJobDetail,videoJobDetailMethod,cronTrigger,org.springframework.scheduling.quartz.SchedulerFactoryBean#0,dataSource,dataSource_1,dynamicDataSource,transactionManager,sqlSessionFactory,scan,transactionInterceptor,org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator#0,thresholdDetailMapper,operationLogMapper,interfaceLogsMapper,noticeMapper,sysPrivilegeMapper,sysRoleMapper,sysUserMapper,channelIpMapMapper,opLogMapper,videoSourceQualityMapper,areaMapper,chanIpInfoMapper,channelAlarmMapper,channelBasicMapper,hwSnmpAlarmMapper,netWorkAlarmMapper,netWorkFunMapper,proAlarmMapper,proFunMapper,stbAlarmDetailInfoMapper,stbAlarmInfoMapper,stbFunMapper,subareaInfoMapper,zteSnmpAlarmMapper,iqasChannelInfoMapper,iqasChannelQualityMapper,iqasVodInfoMapper,topologyMapper,deviceAlertMapper,deviceInfoMapper,deviceLinkMapper,devicePerfromaceMapper,devicePortMapper,routeInfoMapper,terminalBizInfoMapper,testArea
Mapper,authenResultMapper,dhcpAlarmMapper,dslLineAnormalInfoMapper,dslLineQualityMapper,ipNetWorkDevPerMapper,ipNetWorkMacroMapper,ipNetWorkPortPFDetailMapper,ipNetWorkPortPFMapper,ipNetWorkQualityDetailMapper,ipNetWorkQualityMapper,ipNetWorkSeqMapper,juDataCheckMapper,juEqupCheckDiffMapper,juEqupCheckMapper,juEqupCheckResultDescMapper,TBInfoMapper,itmsCpeStaMapper,perceptionMapper,testActiveDslMapper,testAdslPortInfoMapper,testAdslPortPerfMapper,testAdslPortStatMapper,testBoardInfoMapper,testDeltMapper,testFtthMapper,testLanPortInfoMapper,testLanPortPerfMapper,testMacaddrMapper,testNeAlarmMapper,testNeInfoMapper,testOnuInfoMapper,testOnuInvalidAlarmHisMapper,testOnuOfflineAlarmHisMapper,testOnuOnlineMapper,testOnuOutsideLineMapper,testOnuPoweroffMapper,testOnuStateMapper,testPingIpMapper,testPonInfoMapper,testPonLogMapper,testResourceDeviceMapper,testResourceMapper,testSeltMapper,testTestResultMapper,sqmUser5QueryMapper,sqmUser5ResponseMapper,userCertificationMapper,userInfoMapper,use
rSubsMapper,zteServiceQlistMapper,zteServiceQlogMapper,zteUserQlistMapper,zteUserQlogMapper,diagCustomModeMapper,diagSymptomMapper,isRelatedMapper,jobInterfaceResultMapper,mediaInfoMapper]; root of factory hierarchy
2012-06-30 02:22:44,171 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Ignoring bean creation exception on FactoryBean type check: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ticketService' defined in file [E:\zznodeworkspace\.metadata\.me_tcat\webapps\IPTV\WEB-INF\classes\applicationContext-cache.xml]: Cannot resolve reference to bean 'iptvToDhcpService' while setting bean property 'target'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'iptvToDhcpService' is defined
2012-06-30 02:22:44,171 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'customModeServiceImpl'
2012-06-30 02:22:44,171 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] - Don't need to create transaction for [$Proxy196.getAllCustomMode]: This method isn't transactional.
2012-06-30 02:22:44,171 DEBUG [org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor] - Found exception handler method: public void com.zznode.iptvs.core.intercept.OperationLogsInterceptor.afterThrowing(java.lang.reflect.Method,java.lang.Object[],java.lang.Object,java.lang.Throwable) throws java.lang.Throwable
2012-06-30 02:22:44,171 DEBUG [org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor] - Found exception handler method: public void com.zznode.iptvs.core.exception.AopExceptionHandler.afterThrowing(java.lang.reflect.Method,java.lang.Object[],java.lang.Object,java.lang.Throwable) throws java.lang.Throwable
2012-06-30 02:22:44,171 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - Fetching JDBC Connection from DataSource
2012-06-30 02:22:44,171 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@1186df7 [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1ab74bd)
2012-06-30 02:22:44,171 DEBUG [org.mybatis.spring.SqlSessionUtils] - Creating SqlSession with JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1c443f0]
2012-06-30 02:22:44,171 DEBUG [java.sql.Connection] - ooo Connection Opened
2012-06-30 02:22:44,171 DEBUG [org.mybatis.spring.transaction.SpringManagedTransaction] - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1c443f0] will not be managed by Spring
2012-06-30 02:22:44,171 DEBUG [org.mybatis.spring.SqlSessionUtils] - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@100bb12] was not registered for synchronization because synchronization is not active
2012-06-30 02:22:44,171 DEBUG [java.sql.PreparedStatement] - ==>  Executing: select * from DIAG_CUSTOM_MODE 
2012-06-30 02:22:44,171 DEBUG [java.sql.PreparedStatement] - ==> Parameters: 
2012-06-30 02:23:03,781 DEBUG [com.mchange.v2.c3p0.impl.NewPooledConnection] - com.mchange.v2.c3p0.impl.NewPooledConnection@1ab74bd handling a throwable.
java.sql.SQLException: Io 异常: Connection reset
	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.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1052)
	at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:297)
	at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
	at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)
	at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.ibatis.logging.jdbc.ResultSetLogger.invoke(ResultSetLogger.java:31)
	at $Proxy255.next(Unknown Source)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.shouldProcessMoreRows(FastResultSetHandler.java:180)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:171)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:146)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:112)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:238)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:112)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:78)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:72)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
	at $Proxy11.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)
	at org.apache.ibatis.binding.MapperMethod.executeForList(MapperMethod.java:100)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:70)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:38)
	at $Proxy194.getAllCustomMode(Unknown Source)
	at com.zznode.iptvs.manage.custommode.service.impl.CustomModeServiceImpl.getAllCustomMode(CustomModeServiceImpl.java:165)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy196.getAllCustomMode(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy197.getAllCustomMode(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy197.getAllCustomMode(Unknown Source)
	at com.zznode.iptvs.core.GlobalSysInfo.initCustomMode(GlobalSysInfo.java:178)
	at com.zznode.iptvs.core.SystemInit.initSystem(SystemInit.java:99)
	at com.zznode.iptvs.core.SystemInit.init(SystemInit.java:44)
	at com.zznode.iptvs.core.StartupListener.contextInitialized(StartupListener.java:45)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
	at org.apache.catalina.core.StandardService.start(StandardService.java:516)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2012-06-30 02:23:03,812 DEBUG [com.mchange.v2.sql.SqlUtils] - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: null; errorCode: 17002]
java.sql.SQLException: Io 异常: Connection reset
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

问题补充：可以看到前面的几个查询没有问题。在查询select * from DIAG_CUSTOM_MODE   时报错报错信息第54行。

Executing: select * from DIAG_CUSTOM_MODE
2012-06-30 02:22:44,171 DEBUG [java.sql.PreparedStatement] - ==> Parameters:
2012-06-30 02:23:03,781 DEBUG [com.mchange.v2.c3p0.impl.NewPooledConnection] - com.mchange.v2.c3p0.impl.NewPooledConnection@1ab74bd handling a throwable.
java.sql.SQLException: Io 异常: Connection reset
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

问题补充：可以肯定跟网络有一定的关系！我测试过几次。网络好的时候就OK。网络不好的时候。就经常出现这种情况！

2012年6月30日 02:25

wyuxiao729
1
0 0 2

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

0 0

你觉得有木有可能是连接超时的问题，你的c3p0配置里的timeout时间呢？

看异常就是在取数据的是后还在fetch()遍历取的时候，连接就重置了，个么你试试取单个customMode 不要用getAll啊，个人觉得是超时了改下配置的时间

at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1052)  
    at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:297)  
    at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)  
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)

2012年6月30日 10:55