Java and Database Connectivity: Slide 79

Java and Database Connectivity

Transactions with JDBC

Remember, transactions aren't supported by all databases!
JDBC can't make transactions happen in databases which don't support them

    	Connection c = DriverManager.getConnection( url, user, pass);

        c.setAutoCommit( false)

        // Do some things which need to be done together

        c.commit();     // commit them

        // Do some more things which need to be done together

        c.commit();     // commit them

        c.close();