Re: Error on failed COMMIT

If we did change the server behavior, it seems unlikely that
every driver would adjust their behavior to the new server behavior
all at once and that they would all get it right while also all
preserving backward compatibility with current releases in case a
newer driver is used with an older server. I don't think that's
likely. What would probably happen is that many drivers would ignore
the change, leaving applications to cope with the differences between
server versions, and some would change the driver behavior
categorically, breaking compatibility with older server versions, and
some would make mistakes in implementing support for the new behavior.
And maybe we would also find that the new behavior isn't ideal for
everybody any more than the current behavior is ideal for everybody.

try {
    conn.setAutoCommit(false);
    try {
        conn.createStatement().execute("insert into notnullable values (NULL)");
    } catch (SQLException ex ) {
        ex.printStackTrace();
        //ignore this exception
    }
    conn.commit();
} catch ( SQLException ex ) {
    ex.printStackTrace();
    conn.rollback();
}
conn.close();

Dave Cramer