4 Replies Latest reply on Oct 24, 2007 6:52 AM by cfchick12

    cftransaction with Multiple Datasource /Query

      I need help with accessing some rows from Sql Server database(a select statement) when I am inserting rows into DB2 database within the cftransaction. I get the following error.
      "Message : Data source MANAGEMENT verification failed.
      Detail: The root cause was that: java.sql.SQLException: Datasource names for all the database tags within CFTRANSACTION must be the same."
      I realised I can't perform this.

      Eventhough I did not like the idea, I put this in a request variable in application.cfm. Then I try to do a QofQ using the Request variable, I still get the same message.

      I can't perform this after the commit, it has to be within that transaction.
      Right now my solution is putting it in application.cfm and looping the query to get
      my result. Is there a better solution for this?

      Thanks all for your time.