问答首页 → Java企业应用
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。网络不好的时候。就经常出现这种情况！
OracleiBATISc3p0clob 
2012年6月30日 02:25

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
0 0

这个连接打开时数据库可能重启了，导致了连接重置

2012年6月30日 07:59

相关推荐

    ORACLE中CLOB字段转String类型

    ### ORACLE中CLOB字段转String类型 在Oracle数据库中，`CLOB`（Character Large Object）是一种用于存储大量文本数据的数据类型。由于其能够存储非常大的文本块（最大可达4GB），因此常被用于存储文章、报告或任何...

    jdbc读写Oracle的CLOB字段

    JDBC读写Oracle的CLOB字段

    Oracle导出Clob,Blob工具

    Oracle数据库在处理大对象（LOB）类型，如Clob（Character Large Object）和Blob（Binary Large Object）时，有时需要专门的工具来进行高效且安全的数据导出。这些字段通常存储大量的文本或二进制数据，比如长篇文档...

    ibatis 读取oracle clob类型

    ibatis 读取oracle clob类型

    读取oracle数据库中clob字段的值

    ### 读取Oracle数据库中CLOB字段的值 在处理Oracle数据库时，经常会遇到需要读取CLOB（Character Large Object）类型字段的情况。CLOB主要用于存储大量的文本数据，如文章、文档等内容。由于CLOB类型的数据量可能...

    Oracle如何对CLOB行字段来执行全文检索

    Oracle CLOB 行字段全文检索实现方法 Oracle 数据库中，CLOB 行字段是一种常用的数据类型，用于存储大文本数据。然而，在 Oracle8i 版本之前，对大字段 CLOB 仍然不支持在 where 子句直接的 Like 操作。这使得...

    向Oracle数据库插入Clob大段文本解决方法

    在处理Oracle数据库中的大文本数据时，CLOB（Character Large Object）类型被广泛应用于存储大量字符数据，如文章、报告或任何大型文本信息。本文将详细介绍如何有效地向Oracle数据库插入Clob大段文本，以及在操作...

    java读写oracle clob字段

    - 从数据库中读取CLOB字段时，需要查询数据并获取`ResultSet`。然后，可以使用`getClob()`方法获取CLOB对象： ```java ResultSet rs = pstmt.executeQuery(); if (rs.next()) { CLOB clob = rs.getClob("str");...

    ibatis oracle clob

    标题 "ibatis oracle clob" 涉及到的是在Java开发中，使用iBATIS框架与Oracle数据库交互时处理CLOB（Character Large Object）类型数据的问题。CLOB是Oracle数据库用于存储大文本数据（如XML文档、长篇文章等）的...

    sql server中的image类型的数据导出到oracle的clob字段中

    SQL Server 中 Image 类型数据导出到 Oracle 的 CLOB 字段中 在进行数据库迁移或数据交换时，需要将不同数据库管理系统之间的数据类型进行转换。在本文中，我们将讨论如何将 SQL Server 中的 Image 类型数据导出到 ...

    运用Java如何存取Oracle中的CLOB类型字段

    ### 运用Java如何存取Oracle中的CLOB类型字段 #### 概述 在数据库操作中，经常会遇到处理大量文本数据的需求，例如存储文章、新闻、文档等。Oracle数据库提供了CLOB（Character Large Object）类型来存储大容量的...

    java存储oracle中的clob类型

    在实际项目中推荐使用连接池技术，如C3P0、HikariCP等，这有助于提高性能和资源利用率。 **总结** 本文主要介绍了在Java中处理Oracle数据库CLOB类型的基本方法，包括CLOB的读写操作、中文编码问题的处理以及一些...

    关于oracle中clob字段查询慢的问题及解决方法

    总结来说，解决Oracle中CLOB字段查询慢的问题，可以采取以下策略： 1. 使用DBMS_LOB包的函数进行部分数据转换和查找。 2. 创建全文索引来加速文本搜索，但需考虑额外的存储和维护成本。 3. 如果可能，优化查询语句，...

    hibernate存取oracle的clob

    ### Hibernate 存取 Oracle 的 CLOB 在 Java 开发中，使用 Hibernate 框架进行数据库操作是非常常见的。其中，处理 Oracle 数据库中的 CLOB 类型数据是一项重要的技能。CLOB（Character Large Object）是一种用于...

    mysql和Oracle在对clob和blob字段的处理

    - 存储机制：MySQL的`TEXT`和`BINARY`系列数据类型通常存储在数据页中，而Oracle的`CLOB`和`BLOB`可以存储在表空间中，允许更大的数据量。 - 索引支持：Oracle支持对`CLOB`和`BLOB`字段建立索引，而MySQL的索引...

    iBATIS操作Oracle CLOB数据

    4. **查询操作**：查询包含CLOB字段的记录时，iBATIS会自动处理CLOB的读取。但是，由于CLOB可能很大，所以在处理结果集时应谨慎，避免内存溢出。 5. **类型处理器**：iBATIS提供了一个`OracleClobHandler`，它可以...

    Oracle导出Clob,Blob工具版本2

    Oracle数据库在存储大对象（BLOB和CLOB）时提供了强大的功能，但处理这些类型的数据进行导入导出可能会带来挑战。"Oracle导出Clob,Blob工具版本2" 是一个专为解决这个问题而设计的应用程序，它改进了对CLOB...

    weblogic.jdbc.wrapper.Clob_oracle_sql_CLOB 类型转换解决办法

    ### WebLogic 下 Oracle CLOB 类型转换解决方案 在使用 WebLogic 服务器进行应用程序开发时，尤其是在处理 Oracle 数据库中的 CLOB 类型数据时，开发者可能会遇到类型转换的问题。本文将详细介绍如何通过反射机制来...

Magicbox
Ask-but
我的问答 FAQ | 勋章

相关推荐

已解决问题

未解决问题

排行榜

Global site tag (gtag.js) - Google Analytics