· Jul 20, 2018

Oracle Transaction


I have a question related with EnsLib.SQL.OutboundAdapter adapter.

Is there a way to open an oracle transaction and do either commit or rollback depending on the query result?

Is posible to keep open an oracle transaction to execute a lot of queries on different methods on the same business operation and do a commit when the business process finished?

Thanks and Best Regards

Sergio Vidal

Discussion (4)0
Log in or sign up to continue

Thanks for your answer.

There is posible to use these on differents methods?

I mean 

A Business Process "BP1" execute a method in an Operation "OP1" that create a TRANSACTION "TR1"

Then the BP1 execute a second method on the OP1 that execute a query (i.e. UPDATE a table)

Then the BP1 execute a third method on OP1 and execute a COMMIT on TR1

That is posible or I have to open and close the transaction in the same method?


It would be easier to start and finish the transaction in one method (or rather one request to a BO).

Why not send the request to BO containing a list of UPDATES to perform and BO would automatically wrap them in a transaction, returning either a success or error and the position of failed UPDATE statement? Even better send list of some struct and construct statements in BO.

While workarounds are possible (1 Job for BO + indefinite timeout + FIFO on caller part) it would probably be a bad idea.