Auto commit data in MySql database using JDBC

[jith87]

con = DriverManager.g etConnection("j dbc:mysql:///jk","rjk", "sivaji");
con.setAutoComm it(false);
java.sql.Statem ent stmt = con.createState ment();
stmt.executeUpd ate("INSERT INTO jk1(fname, lname) VALUES('a', 'b')");
stmt.executeUpd ate("INSERT INTO jk1(fname, lname) VALUES('c', 'd')");
con.rollback();
stmt.executeUpd ate("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.g etConnection("j dbc:mysql:///jk","rjk", "sivaji");
con.setAutoComm it(false);
java.sql.Statem ent stmt = con.createState ment();
stmt.executeUpd ate("INSERT INTO jk1(fname, lname) VALUES('a', 'b')");
stmt.executeUpd ate("INSERT INTO jk1(fname, lname) VALUES('c', 'd')");
con.rollback();
stmt.executeUpd ate("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
[CODE=java] con.setAutoComm it(false);
java.sql.Statem ent stmt = con.createState ment();[/CODE]

[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
[CODE=java] con.setAutoComm it(false);
java.sql.Statem ent stmt = con.createState ment();[/CODE]

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?