Only if you are using InnoDB tables.
(or BerkelyDB tables, but I'm not absolutely sure about these)
Kishor Patil wrote:
> 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-mai
l in error, please immediately notify administrator@stripped. The rights to monitor all
e-mail communication through our network are reserved with us.
>
>
>
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company jmathis@stripped
525 Camino de los Marquez, Ste 6 http://www.predict.com
Santa Fe, NM 87505
