transaction demarcation in query templates and BLE?

[Former Member]

We have a business process which needs to insert N-many records into a table as a single transaction - if one insert fails, they all rollback. The number of records and record values are, of course, variable. How does xMII 11.5 support this or does it?

I could think of some very ugly hacks using a fixed query and creative use of query template parameters, but I'd rather not go there.

Thanks,

-tim

[Former Member]

I guess you could insert multiple records into a temporary table (possibly using a guid for each mass load). Then call a separate query (stored procedure actually) to copy the temp table to the real table and then use transactional logic in the stored procedure. Perhaps this falls under your "ugly hack" category.

[Former Member]

XMII has no database transactional support.

The last site I worked at rolled their own action block to handle this and support distributed transactions. Basically, any number of data connections and SQL statements could be passed to the action block and then commiited in one pass. It was quite a bit of work but it was a major requirement of the client.