Skip to main content
June 10, 2013
Question

Performing ORM and non-ORM transactions in one request.

  • June 10, 2013
  • 0 replies
  • 800 views

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.

This topic has been closed for replies.