异常SQL状态[null]；错误代码[31]；连接已关闭：连接已关闭；嵌套异常是java.sql.sqlexception

Question

<bean id="dataSource" class="oracle.ucp.jdbc.PoolDataSourceFactory"
      factory-method="getPoolDataSource" lazy-init="true" >
    <property name="connectionFactoryClassName" value="oracle.jdbc.pool.OracleDataSource"/>
    <property name="user" value="${jdbc.username}" />
    <property name="password" value="${jdbc.password}" />
    <property name="URL" value="${jdbc.url}" />
    <property name="connectionWaitTimeout" value="30" />
    <property name="minPoolSize" value="3"/>
    <property name="maxPoolSize" value="20"/>
    <property name="abandonedConnectionTimeout" value="300"/>
    <property name="inactiveConnectionTimeout" value="900"/>
    <property name="validateConnectionOnBorrow" value="true"/>
    <property name="exceptionManager" value="exceptionManager"/> 
</bean>

我坚持这个问题，如果有任何帮助是非常感谢的

请在以上问题上帮助我

Answer 1

经过一个星期的努力,我终于解决了这个问题：

解决方案：很可能是基于全局临时表(GTT)打开游标，该表是用on COMMIT DELETE ROWS选项创建的。ORA-08103:object Not Regoner exists错误的原因是紧随delete语句之后的commit语句。DBA团队不同意在提交保留行时更改GTT，所以最后我在Java服务层中添加了代码库[实现了Spring-Programmatic TransactionManager.rollback（status）int catch block这导致了连接关闭错误。

修复：

import java.util.List;
import javax.sql.DataSource;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;

public class StudentJDBCTemplate implements StudentDAO {
   private DataSource dataSource;
   private JdbcTemplate jdbcTemplateObject;
   private PlatformTransactionManager transactionManager;

   public void setDataSource(DataSource dataSource) {
      this.dataSource = dataSource;
      this.jdbcTemplateObject = new JdbcTemplate(dataSource);
   }
   public void setTransactionManager(PlatformTransactionManager transactionManager) {
      this.transactionManager = transactionManager;
   }
   public void create(String name, Integer age, Integer marks, Integer year){
      TransactionDefinition def = new DefaultTransactionDefinition();
      TransactionStatus status = transactionManager.getTransaction(def);

      try {
         String SQL1 = "insert into Student (name, age) values (?, ?)";
         jdbcTemplateObject.update( SQL1, name, age);

         // Get the latest student id to be used in Marks table
         String SQL2 = "select max(id) from Student";
         int sid = jdbcTemplateObject.queryForInt( SQL2 );

         String SQL3 = "insert into Marks(sid, marks, year) " + "values (?, ?, ?)";
         jdbcTemplateObject.update( SQL3, sid, marks, year);

         System.out.println("Created Name = " + name + ", Age = " + age);
         transactionManager.commit(status);
      } 
      catch (DataAccessException e) {
         System.out.println("Error in creating record, rolling back");
         **transactionManager.rollback(status);**
         throw e;
      }
      return;
   }
   public List<StudentMarks> listStudents() {
      String SQL = "select * from Student, Marks where Student.id=Marks.sid";
      List <StudentMarks> studentMarks = jdbcTemplateObject.query(SQL, 
         new StudentMarksMapper());

      return studentMarks;
   }
}