Auto commit data in MySql database using JDBC

[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....

[r035198x]

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....

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

 con.setAutoCommit(false);
java.sql.Statement stmt = con.createStatement();

[jith87]

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

 con.setAutoCommit(false);
java.sql.Statement stmt = con.createStatement();

What is meant by code tags?

[r035198x]

What is meant by code tags?

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.

[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.

Now jith87, please stop all this double posting for the same question. That is simply against the site guidelines and I hope I won't have to warn you about it again. Did you read the response that I posted for this question?