RSB posted on Monday, May 21, 2007

I am new to CSLA.

I am trying to do Insert with TransacationalScope attribute set. I am using Oracle10g, ODP.NET 2.0 and use a separate Data Access Layer. I do the insert and after establishing the Oracle connection successfully, and creating an Oracle command, parameters. I execute

cmd.ExecuteNonQuery(); // this step fails and the error I get is "Transaction rolled back"

I do not understand what is failing? Any help appreciated.

Thank you
RSB

david.wendelken replied on Monday, May 21, 2007

Verify the parameter values you are using, then go into Sql*Plus (Sql*Navigator, Toad, etc.) and run the underlying SQL command with the same to see what the real error is.

I'm assuming that you've debugged the values in the exception that was raised and none of the data in that exception provides more detailed info.

ajj3085 replied on Tuesday, May 22, 2007

Also verify that Distributed Transactions is enabled on both computers, and the appropriate firewall ports have been opened.

I think that using TS with Oracle will automatically promote the transaction to distributed.