Devart Forums

Code: Select all

System.Data.UpdateException was unhandled by user code
  Message=Fehler beim Aktualisieren der Einträge. Weitere Informationen finden Sie in der internen Ausnahme.
  Source=System.Data.Entity
  StackTrace:
       bei System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
       bei System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
       bei System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
       bei System.Data.Objects.ObjectContext.SaveChanges()
       bei PRODOK.Core.BusinessLayer.BusinessObjects.CboBase.DeleteDataInDb() in D:\Entwickl\Prodok\V10\Prodok\PRODOK.Core\BusinessLayer\BusinessObjects\CboBase.cs:Zeile 557.
       bei PRODOK.Core.BusinessLayer.BusinessObjects.CboDocument.DeleteDataInDb() in D:\Entwickl\Prodok\V10\Prodok\PRODOK.Core\BusinessLayer\BusinessObjects\CboDocument.cs:Zeile 499.
       bei PRODOK.Core.BusinessLayer.BusinessObjects.CboDocument.DeleteExecute(ExecContext args) in D:\Entwickl\Prodok\V10\Prodok\PRODOK.Core\BusinessLayer\BusinessObjects\CboDocument.cs:Zeile 568.
  InnerException: Devart.Data.Oracle.OracleException
       Message=ORA-08177: can't serialize access for this transaction
ORA-06512: at "PDK-PRJ-ORA_DEMO90D.U_Revisions", line 273
ORA-04088: error during execution of trigger 'PDK-PRJ-ORA_DEMO90D.U_Revisions'
       Source=Devart.Data.Oracle
       ErrorCode=-2147467259
       Code=8177
       Offset=0
       StackTrace:
            bei xc.t.d()
            bei Devart.Data.Oracle.bi.k()
            bei Devart.Data.Oracle.bi.c()
            bei Devart.Data.Oracle.p.a(Int32 A_0, a4 A_1)
            bei Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
            bei Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
            bei Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
            bei Devart.Data.Oracle.Entity.k.a.n()
            bei System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
            bei System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
       InnerException: 

Code: Select all

    try {
        new OracleMonitor() { IsActive = true };
        using (TransactionScope trans = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0))) {
            using (OracleConnection conn = new OracleConnection()) {
                conn.ConnectionString = "server=dboracle;direct=true;sid=orcl1120;uid=scott;pwd=tiger;";
                conn.Open();

                OracleScript script = new OracleScript();
                script.Connection = conn;
                script.ScriptText = @"CREATE TABLE A111 (
                    ID NUMBER(38),
                    DATAA VARCHAR2(20),
                    CONSTRAINT PK_A111 PRIMARY KEY (ID));
                CREATE TABLE B111 (
                    ID NUMBER(38),
                    DATAB VARCHAR2(20),
                    CONSTRAINT PK_B111 PRIMARY KEY (ID));
                CREATE OR REPLACE TRIGGER TRIGGER111
                AFTER INSERT ON A111
                REFERENCING NEW AS NEWVALUES OLD AS OLDVALUES FOR EACH ROW
                BEGIN
                    insert into b111 values (:NewValues.id, :NewValues.dataA);
                END;";
                script.Execute();

                OracleCommand cmd = conn.CreateCommand();
                //cmd.CommandText = "delete from a111";
                //cmd.ExecuteNonQuery();
                //cmd.CommandText = "delete from b111";
                //cmd.ExecuteNonQuery();

                cmd.CommandText = "insert into a111 values (:id, 'some data')";
                cmd.Parameters.Add("id", OracleDbType.Integer);
                for (int i = 0; i < 100000; i++) {
                    cmd.Parameters["id"].Value = i;
                    cmd.ExecuteNonQuery();
                }
            }
            trans.Complete();
        }
    }
    catch (Exception ex) {
        Console.WriteLine(ex.Message + ex.InnerException);
    }

Code: Select all

using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, 
new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }))
{
...
}