StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTransaction in mysql
text
Body
copied!<p>I am working on a c# application with Mysql database(version 5.5). I am facing an issue where I need to catch an exception occurred in Mysql. It doesn't matter whether it is caught in Mysql or in dotNet. The problem is that I want to rollback all my previous work when an exception/error is occurred; be it of MySqlException or custom one. And yes, I tried using <code>TransactionScope</code> and <code>MySqlTransaction</code> but it didn't rollback my work. If anyone has any ideas or suggestions, please guide me. Thanks.</p> <p>Edit:Code</p> <pre><code> MySqlConnection con = new MySqlConnection(cnstring); if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); MySqlCommand cmd; TransactionScope ob = new TransactionScope(); try { cmd = new MySqlCommand("testProcedureSignal", con); cmd.Parameters.Add(new MySqlParameter("pval", 1)); cmd.Parameters.Add(new MySqlParameter("@intException", MySqlDbType.Int32) { Direction = ParameterDirection.Output }); cmd.Parameters.Add(new MySqlParameter("@strErrorMessage", MySqlDbType.VarChar) { Direction = ParameterDirection.Output }); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); } catch (MySqlException e) { con.Close(); ob.Dispose(); return; } ob.Complete(); con.Close(); </code></pre> <p>And this is the Procdeure:</p> <pre><code>CREATE PROCEDURE `testProcedureSignal`( pval INT, OUT intException INT, OUT strErrorMessage VARCHAR(255) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; END; SET intException = 100; START TRANSACTION; INSERT INTO demo (data) values (intException); SET intException = intException + 10; INSERT INTO demo (data) values (intException); DROP TABLE teeeee;-- this table does not exist INSERT INTO demo2 (data1,data2) values ('demo2',intException + 10); SET intException = 111; SET intException = 2; COMMIT; END </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload