Auto commit data in MySql database using JDBC

Originally Posted by jith87

con = DriverManager.getConnection("jdbc:mysql:///jk","rjk", "sivaji");
con.setAutoCommit(false);
java.sql.Statement stmt = con.createStatement();
stmt.executeUpdate("INSERT INTO jk1(fname, lname) VALUES('a', 'b')");
stmt.executeUpdate("INSERT INTO jk1(fname, lname) VALUES('c', 'd')");
con.rollback();
stmt.executeUpdate("INSERT INTO jk1(fname, lname) VALUES('x', 'y')");
con.commit();

By ths code the records containing values a,b and c,d should nt be saved bt the record containing x,y should be saved...bt all the three records r getting saved...Pls help....

Originally Posted by r035198x

1.) Use code tags when posting code
2.)By default all new connections are created in autocommit mode. You set the flag before creating the connection.
Interchange these two statements

Originally Posted by jith87

What is meant by code tags?

Originally Posted by r035198x

Compare how you posted your code and and how I posted it in the posts above. Code tags make it easier to read that code that you post in the forum.