ORA-01453: SET TRANSACTION must be first statement of transaction

Posts   
 
    
buckd32
User
Posts: 20
Joined: 09-Oct-2009
# Posted on: 04-Nov-2009 12:27:20   

change my code to

 public void SaveEntity(IEntity2 entity, bool refetch)
    {

        using (DataAccessAdapter adapter = new DataAccessAdapter())
        {
            adapter.StartTransaction(IsolationLevel.ReadCommitted, "TwoUpates");
            adapter.SaveEntity(entity, refetch, true);
            // done
            adapter.Commit();


        }
    }

but i still getting the problem

ORA-01453: SET TRANSACTION must be first statement of transaction

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-01453: SET TRANSACTION must be first statement of transaction

Source Error:

Line 375: } Line 376: Line 377: _dataservice.SaveEntity(webs, false); Line 378: OracleConnection cn = new OracleConnection(ConfigurationManager.ConnectionStrings

buckd32
User
Posts: 20
Joined: 09-Oct-2009
# Posted on: 04-Nov-2009 12:59:14   

solved i put the code around a fillentity event i had as well and seems to have solved the problem well ii hope