Today, I've found that CFTransaction cannot work for different datasource. This one is really bad for CFDevelopers like us. Because we need to use CFTransaction when we need to do long process for so many query transaction within our code with different datasource.

When I use above coding with different datasource within CFTransaction, CF return "Datasource name must be same within CFTransaction". That's why I need to change like

I feel it's not safe at all and it might be half-process for database if some of query got error. And I have not found any nice solution for using different datasource like CFTransaction's yes-or-failed-all method.

This entry was posted on November 4, 2012 at 7:37 PM and has received 1028 views. There are currently 0 comments. Print this entry.