java.sql.SQLException: ORA-00028: your session has been killed

https://blog.csdn.net/wzg725/article/details/82220290

2019-09-21 18:47:14.144 [pool-1-thread-1] INFO  com.scai.dispatcher.job.CreditQueryJob - queryCreditApplyJobData -> queueSize=[0],maxQueueSize=[100]
2019-09-21 18:47:14.145 [pool-1-thread-1] DEBUG c.s.d.m.J.queryCreditJobRuleDecisionReq - ==>  Preparing: select * from ( select tmp_page.*, rownum row_id from ( select * from SCAI_ZBANK_RULEDECISION_REQ where VERSION = 0 and (APPLY_STAUTS = '1' or APPLY_STAUTS = '1.5')
 ) tmp_page where rownum <= ? + ? ) where row_id > ? 
2019-09-21 18:47:14.145 [pool-1-thread-1] DEBUG c.s.d.m.J.queryCreditJobRuleDecisionReq - ==> Parameters: 100(Integer), 0(Integer), 0(Integer)
2019-09-21 18:47:14.159 [pool-1-thread-1] ERROR com.alibaba.druid.pool.DruidDataSource - discard connection
java.sql.SQLException: ORA-00028: your session has been killed

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
        at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)
        at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
        at com.sun.proxy.$Proxy114.execute(Unknown Source)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
        at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
        at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
        at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
        at com.sun.proxy.$Proxy74.selectList(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
        at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
        at com.sun.proxy.$Proxy79.queryCreditJobRuleDecisionReq(Unknown Source)
        at com.scai.dispatcher.job.CreditQueryJob.queryCreditApplyJobData(CreditQueryJob.java:108)
        at com.scai.dispatcher.job.CreditQueryJob.execute(CreditQueryJob.java:56)
        at com.scai.dispatcher.job.CreditQueryJob.lambda$run$0(CreditQueryJob.java:168)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Exception in thread "pool-1-thread-1" org.springframework.dao.ConcurrencyFailureException: 
### Error querying database.  Cause: java.sql.SQLException: ORA-00028: your session has been killed

项目的测试环境出现了这个情况，生产环境比较稳定。为两台机器，配置也高。按照上个网址的也换下版本试试。由

<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>

换成11.2.0.4