Does mysql Connector/J support transaction?
I am using mysql-connector-java-3.0.14-production-bin.jar driver. and 5.0-alpha server.
But still queries dont rollback.
Sample code:
con.setAutoCommit(false);
String query = "insert into cat_operation values(3,'ex1','N')";
java.sql.Statement statement = con.createStatement();
statement.executeUpdate(query);
con.rollback();
//con.commit();
System.out.println("End");
What could be the reason?
Zensar Technologies Ltd. Mail Disclaimer: This e-mail and any files transmitted with it
are confidential and the views expressed in the same are not necessarily the views of
Zensar Technologies Ltd., and its Directors, Management or Employees. This communication
represents the originator's personal views and opinions. If you are not the intended
recipient or the person responsible for delivering the e-mail to the intended recipient,
be advised that you have received this e-mail by error, and that any use, dissemination,
forwarding, printing, or copying of this e-mail is strictly prohibited. You shall be
under obligation to keep the contents of this e-mail, strictly confidential and shall not
disclose, disseminate or divulge the same to any Person, Company, Firm or Entity. Please
ensure you have adequate virus protection before you open or detach any documents from
this transmission. Zensar Technologies Ltd. does not accept any liability for virus. If
you received this e-mail in error, please immediately notify administrator@stripped.
The rights to monitor all e-mail communication through our network are reserved with us.
