|
I have a spring batch framework set up the DB connection is going stake after 1 hr and 5 min .This works fine in Dev,QA and the issue is happening only in prod env.Pls guide
------------------------------------- 2013-07-22 14:17:29,563 INFO DeriveReturnAddressTasklet - No of getReturn responses:1704 2013-07-22 14:17:29,566 INFO DeriveReturnAddressTasklet - No of valid getReturn responses:1704 2013-07-22 14:17:29,566 INFO DeriveReturnAddressTasklet - No of error getReturn responses:0 2013-07-22 14:17:39,523 INFO SimpleStepHandler - Executing step: [createReturnOrderStep] 2013-07-22 14:17:39,619 INFO BatchCoreStepListener - Starting Step = createReturnOrderStep 2013-07-22 14:17:39,627 WARN JDBCExceptionReporter - SQL Error: 0, SQLState: null 2013-07-22 14:17:39,627 ERROR JDBCExceptionReporter - Already closed. 2013-07-22 14:17:39,630 WARN JDBCExceptionReporter - SQL Error: 0, SQLState: null 2013-07-22 14:17:39,630 ERROR JDBCExceptionReporter - Already closed. 2013-07-22 14:17:39,640 ERROR AbstractStep - Encountered an error executing the step org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is java.sql.SQLException: Io exception: Connection reset at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:599) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy10.getComponentByName(Unknown Source) at com.sears.hs.commons.batch.core.listener.BatchCoreStepListener.storeStepProperties(BatchCoreStepListener.java:87) at com.sears.hs.commons.batch.core.listener.BatchCoreStepListener.beforeStep(BatchCoreStepListener.java:46) at org.springframework.batch.core.listener.CompositeStepExecutionListener.beforeStep(CompositeStepExecutionListener.java:76) at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:192) at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:135) at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:61) at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:60) at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:144) at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:124) at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:135) at com.sears.hs.commons.batch.job.HSFlowJob.doExecute(HSFlowJob.java:66) at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:281) at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:120) at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49) at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:114) at com.sears.hs.commons.batch.core.SimpleJobManager.startJob(SimpleJobManager.java:103) at com.sears.hs.commons.batch.core.BatchJobRunner.startJob(BatchJobRunner.java:135) at com.sears.hs.commons.batch.core.BatchJobRunner.main(BatchJobRunner.java:62) Caused by: java.sql.SQLException: Io exception: Connection reset at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:566) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:958) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299) at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:4053) at org.apache.commons.dbcp.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:380) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setTransactionIsolation(PoolingDataSource.java:343) at sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50) at $Proxy28.setTransactionIsolation(Unknown Source) at org.springframework.jdbc.datasource.DataSourceUtils.prepareConnectionForTransaction(DataSourceUtils.java:174) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:511) ... 26 more Caused by: java.net.SocketException: Connection reset at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at oracle.net.ns.DataPacket.send(DataPacket.java:150) at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:180) at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:169) at oracle.net.ns.NetInputStream.read(NetInputStream.java:117) at oracle.net.ns.NetInputStream.read(NetInputStream.java:92) at oracle.net.ns.NetInputStream.read(NetInputStream.java:77) at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1034) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:588) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942) ... 40 more 2013-07-22 14:17:39,644 INFO BatchCoreStepListener - Completed Step = createReturnOrderStep, Status = FAILED 2013-07-22 14:17:45,221 INFO HSFlowJob - custom defined step status : FAILED 2013-07-22 14:17:45,222 INFO BatchJobExecutionListener - Completed Job = tpsrNPNUploadJob, Status = exitCode=FAILED;exitDescription= 2013-07-22 14:17:45,307 INFO SimpleJobLauncher - Job: [HSFlowJob: [name=tpsrNPNUploadJob]] completed with the following parameters: [ {jobOrderId=123-2}] and the following status: [FAILED] 2013-07-22 14:17:45,308 INFO SimpleJobManager - Job :tpsrNPNUploadJob ended with result = 1 with Execution Id = 38669, summary =JobExecution: id=38669, startTime=Mon Jul 22 13:14:02 EDT 2013, endTime=Mon Jul 22 14:17:45 EDT 2013, lastUpdated=Mon Jul 22 14:17:45 EDT 2013, status=FAILED, exitStatus=exitCode=FAILED;exitDescription=, job=[JobInstance: id=38585, JobParameters=[{jobOrderId=123-2}
], Job=[tpsrNPNUploadJob]] 2013-07-22 14:17:45,308 INFO BatchJobRunner - Job Result Return Code = 1
|