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

--------------------------------------------------------------------------------

Please do not double post.

[pbmods]

Heya, Jith.

Please use CODE tags when posting source code:

[CODE=java]
Java code goes here.
[/CODE]

[bartonc]

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

--------------------------------------------------------------------------------

Check your table type. You must use the innodb engine:

CREATE TABLE  `database_name`.`table_name` (
  `itemID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`itemID`)
) ENGINE=InnoDB;

[r035198x]

Check your table type. You must use the innodb engine:

CREATE TABLE  `database_name`.`table_name` (
  `itemID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`itemID`)
) ENGINE=InnoDB;

Even then, he creates the connection with the database after setting autoCommit to false. A newly created connection has autoCommit set to true by default so the setAutoCommit(false) at the top there is just useless. He should set autoCommit(false) after creating the connection.