问题描述
有一个定时任务,是请求服务器,得到并读取文件,并批量导入数据库出现的问题。每隔将近2周的时间,定时任务这块就报错。[ERROR][http-8080-22]12-1908:20:32.26JDBCExceptionReporter.logExceptions(234)|DB2SQLError:SQLCODE=-805,SQLSTATE=51002,SQLERRMC=NULLID.SYSLH2030X5359534C564C3031,DRIVER=4.0.100;nestedexceptioniscom.ibm.db2.jcc.a.SqlException:DB2SQLError:SQLCODE=-805,SQLSTATE=51002,SQLERRMC=NULLID.SYSLH2030X5359534C564C3031,DRIVER=4.0.100[WARN][http-8080-8]12-1908:25:50.359JDBCExceptionReporter.logExceptions(233)|SQLError:-805,SQLState:51002[ERROR][http-8080-8]12-1908:25:50.360JDBCExceptionReporter.logExceptions(234)|DB2SQLError:SQLCODE=-805,SQLSTATE=51002,SQLERRMC=NULLID.SYSLH2030X5359534C564C3031,DRIVER=4.0.100org.springframework.jdbc.UncategorizedSQLException:Hibernateoperation:couldnotexecutequery;uncategorizedSQLExceptionforSQL[SELECTP.VALUEFROMT_BAS_PARAMETERPWHEREP.VALUE<=32500000ANDP.SMALL_CODE='FORECAST_OUT_MINVALUE'];SQLstate[51002];errorcode[-805];DB2SQLError:SQLCODE=-805,SQLSTATE=51002,SQLERRMC=NULLID.SYSLH2030X5359534C564C3031,DRIVER=4.0.100;nestedexceptioniscom.ibm.db2.jcc.a.SqlException:DB2SQLError:SQLCODE=-805,SQLSTATE=51002,SQLERRMC=NULLID.SYSLH2030X5359534C564C3031,DRIVER=4.0.100atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)atorg.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)atorg.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)atorg.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)atorg.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)atcom.ridea.lms.dao.DAOImpl.findByNative(DAOImpl.java:133)atcom.ridea.lms.service.impl.ForecastServiceImpl.checkAmountIsLarge(ForecastServiceImpl.java:910)atsun.reflect.GeneratedMethodAccessor497.invoke(UnknownSource)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)atjava.lang.reflect.Method.invoke(Method.java:597)atorg.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)at$Proxy46.checkAmountIsLarge(UnknownSource)atcom.ridea.lms.web.action.forecast.ForecastAction$11.call(ForecastAction.java:314)atcom.ridea.lms.web.action.BaseAction.toJson(BaseAction.java:179)atcom.ridea.lms.web.action.forecast.ForecastAction.checkAmountIsLarge(ForecastAction.java:311)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)atjava.lang.reflect.Method.invoke(Method.java:597)atcom.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)atcom.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atorg.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atorg.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)atorg.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atorg.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atorg.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atorg.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atorg.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)atcom.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)atorg.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)at
解决方案
解决方案二:
据说的资源没有关闭导致资源不足产生的问题。