Performing ORM and non-ORM transactions in one request.
During the processing of a request, we need to perform an ORM statement and a non-ORM cftransaction on 2 different data sources.
Example:
# Note, 'someObject' is a persistent CFC with a datasource attribute of 'DSN1'.
<cftransaction>
<cfset myObjects = EntityLoad('someObject') />
</cftransaction>
<cftransaction>
<cfquery name="test" datasource="DSN2">
INSERT INTO ...
</cfquery>
</cftransaction>
Whenever we hit the 2nd cftranaction block, we get the following error:
| Message=A transaction cannot be started on more than one datasource. |
This works in CF 9.0.1, but fails on CF 9.0.1 HF3, CF 9.0.2, and on CF 10.
