java - Oracle JDBC 自动提交

Question

假设我的代码大致类似于以下内容:(使用 oracle 10G jdbc)。在这种特定情况下会提交事务吗？

    public void someMethod(){
    try {
    OracleConnection connection = getConnectionFromPool();
    connection.setAutoCommit(false);

    // Do some transaction here - complete transaction, no errors occurred

    ...

    //Throw my own exception here
    throw new Exception("Custom Exception");


    } catch (Exception e}
    {
      ...
    }
    finally {
      connection.setAutoCommit(true);
    }
    }

Answer 1

According to the JavaDocs ，它应该提交:

NOTE: If this method is called during a transaction and the auto-commit mode is changed, the transaction is committed. If setAutoCommit is called and the auto-commit mode is not changed, the call is a no-op.

但是:如果你依赖这个，就意味着你依赖驱动程序来满足这个要求——这是我不会做的事情(我永远不会依赖隐含的东西)

如果您想确保您的事务已提交，请调用 commit()。