OracleTransaction.Rollback Metode

Referensi

Definisi

Ruang nama:: System.Data.OracleClient

Rakitan:: System.Data.OracleClient.dll

Penting

Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.

Mengembalikan transaksi dari status tertunda.

public:
 virtual void Rollback();

public:
 override void Rollback();

public void Rollback ();

public override void Rollback ();

abstract member Rollback : unit -> unit
override this.Rollback : unit -> unit

override this.Rollback : unit -> unit

Public Sub Rollback ()

Public Overrides Sub Rollback ()

Penerapan

Rollback()

Pengecualian

Exception

Terjadi kesalahan saat mencoba melakukan transaksi.

InvalidOperationException

Transaksi telah dilakukan atau digulung balik.

-atau-

Koneksi terputus.

Contoh

Contoh berikut membuat OracleConnection dan OracleTransaction. Ini juga menunjukkan cara menggunakan BeginTransactionmetode , , Commitdan Rollback .

public void RunOracleTransaction(string connectionString)
{
    using (OracleConnection connection = new OracleConnection(connectionString))
    {
        connection.Open();

        OracleCommand command = connection.CreateCommand();
        OracleTransaction transaction;

        // Start a local transaction
        transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
        // Assign transaction object for a pending local transaction
        command.Transaction = transaction;

        try
        {
            command.CommandText =
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')";
            command.ExecuteNonQuery();
            command.CommandText =
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')";
            command.ExecuteNonQuery();
            transaction.Commit();
            Console.WriteLine("Both records are written to database.");
        }
        catch (Exception e)
        {
            transaction.Rollback();
            Console.WriteLine(e.ToString());
            Console.WriteLine("Neither record was written to database.");
        }
    }
}

Public Sub RunOracleTransaction(ByVal connectionString As String)
    Using connection As New OracleConnection(connectionString)
        connection.Open()

        Dim command As OracleCommand = connection.CreateCommand()
        Dim transaction As OracleTransaction

        ' Start a local transaction
        transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted)
        ' Assign transaction object for a pending local transaction
        command.Transaction = transaction

        Try
            command.CommandText = _
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')"
            command.ExecuteNonQuery()
            command.CommandText = _
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')"
            command.ExecuteNonQuery()
            transaction.Commit()
            Console.WriteLine("Both records are written to database.")
        Catch e As Exception
            transaction.Rollback()
            Console.WriteLine(e.ToString())
            Console.WriteLine("Neither record was written to database.")
        End Try
    End Using
End Sub

Keterangan

Transaksi hanya dapat digulung balik dari status tertunda (setelah BeginTransaction dipanggil, tetapi sebelumnya Commit dipanggil).

Berlaku untuk

Bagikan melalui