committing an aborted transaction

If one commits an aborted transaction, it seems to rollback without any
notice.  Whether a transaction should be aborted by an exception seems
debatable, but to have a commit quietly rollback instead is terrible design.
Committing an aborted transaction should throw an exception.  Below is an
example program:


import java.sql.*;

public class P {
    public static void main(String[] args) throws Exception {
        Class.forName("org.postgresql.Driver");
        Connection con =
DriverManager.getConnection("jdbc:postgresql://localhost/n1","postgres","word");
        Statement stmt = con.createStatement();
        stmt.executeUpdate("drop table if exists t");
        stmt.executeUpdate("create table t (id integer)");
        stmt.close();

        con.setAutoCommit(false);
        stmt = con.createStatement();
        stmt.executeUpdate("insert into t (id) values (1)");
        ResultSet rs = stmt.executeQuery("select * from t where id=1");
        System.out.println( (rs.next() ? "ok" : "not found") + " in transaction");
        try {
            stmt.executeUpdate("nonsense");
        } catch(SQLException e) {}
        stmt.close();
        con.commit();

        con.setAutoCommit(true);
        stmt = con.createStatement();
        rs = stmt.executeQuery("select * from t where id=1");
        System.out.println( (rs.next() ? "ok" : "not found") + " after
transaction");
        stmt.executeUpdate("drop table if exists t");
        stmt.close();
        con.close();
    }
}

--
View this message in context: http://www.nabble.com/committing-an-aborted-transaction-tp20519423p20519423.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.