Transaction Problem

ErikJL posted on Friday, October 10, 2008

We're using CSLA objects for database access, mostly for reading but one also for read-write. I'm having an issue with an Inset statement in that it seems the transaction never gets completed, yet the code produces no errors as I step through it. After creating a child object, placing it in the list,  performing the .Save() method on the list, and exiting the button-click event, no row is placed into the database and I also see this error when trying to truncate the table:

ORA-00054: resource busy and acquire with NOWAIT specified

When I exit the debugger, the SQL error goes away but there still isn't a row in the table. The really odd thing is that we have a simple tester form that binds this CSLA listobject to a datagridview and it works just fine. However, this problem arises when the list object is embedded in some other objects we've created. Here is how we're using the objects:

TCTInpQList inpqList = TCTInpQList.NewTCTInpQList();

foreach (TWACSPath path in this.pathList.Values)

{

TCTInpQ TCTInpQitem = TCTInpQ.NewTCTInpQ();

(then we hydrate the properties of  TCTInpQitem )

inpqList.Add(TCTInpQitem);

}

TCTInpQList cloneList = inpqList.Clone();

cloneList.ApplyEdit();

inpqList = cloneList.Save();  //this is where the ORA error appears until the debugger is stopped

 

I'm using VS2005 on WINXP, CSLA version