multiple database commands in one transaction

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

multiple database commands in one transaction

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> multiple database commands in one transaction

Page: [1]

Message

<< Older Topic Newer Topic >>

multiple database commands in one transaction - 5 October 2006

dendor

Posts: 8
Score: 0
Joined: 27 March 2006
Status: offline

Hi,

I am wondering if and how to put multiple insert or stored procedure commands one database transaction. Can this be done with TopXML?

For example, we would like to insert parent and childrecords in one transaction (like order and orderline)

Kind regards,

Pim Waaijenberg

< Message edited by dendor -- 5 October 2006 >

Post #: 1

RE: multiple database commands in one transaction - 5 October 2006

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

You can simply add multiple objects when generating the Send Port Schema. I.e. Orders, OrderLines.

You then use the Looping functoid to loop through the source into the destination.

The Adapter will then treat these as a single transaction.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to dendor)

Post #: 2