Geeks With Blogs

News View Michael Stephenson's profile on BizTalk Blog Doc View Michael Stephenson's profile on LinkedIn

Michael Stephenson keeping your feet on premise while your heads in the cloud

Problem

We were consuming a package in an Oracle Database using the Oracle DB adapter.  When we called it we were getting an error about using rollback.  We were not using a transaction on the port so not sure why this error was occuring.

Solution

After a little searching we found that the solution was that in the DSN on the work around tab there is an option for enabling MSDTC transaction.  This needs to be unticked if you are calling a package/stored procedure which will commit or rollback a transaction.

As it happened in the package they were making multiple inserts and using their own transaction to manage them.  Note this was using Oracle 806 so this may not be a problem in newer versions.

Posted on Friday, October 13, 2006 12:13 PM BizTalk | Back to top


Comments on this post: Oracle DB Adapter and Transactions

# re: Oracle DB Adapter and Transactions
Requesting Gravatar...
Amazing post thanks for sharing with all of us and we all are very thankful after seeing this postGJF
Feliz Navidad 2016
Feliz Año Nuevo 2017 ihiy yigtiy
Left by DIPIKA on Dec 16, 2016 9:44 PM

# re: Oracle DB Adapter and Transactions
Requesting Gravatar...
Left by mobdro tv app for pc on May 12, 2017 6:23 PM

Your comment:
 (will show your gravatar)


Copyright © Michael Stephenson | Powered by: GeeksWithBlogs.net