On 12/22/05, David Livingston <[EMAIL PROTECTED]> wrote:
It means that you have wrapped a cftransaction around several cfquery's that have different datasources. This is not allowed when you use cftransaction. All of your queries must use the same datasource inside of a cftransaction tag.DaveOn Dec 22, 2005, at 3:59 PM, Chris Gomez wrote:I'm working on a newsletter form. all the data is supposed to be saved to a db. I'm using cftransaction for the queries. But, I keep getting the following error:Data source xxxxx verification failed. The root cause was that: java.sql.SQLException: Datasource names for all the database tags within CFTRANSACTION must be the same.
I restarted the server and tried again. The problem happens when there is a failure in the cftransaction.
The error occurred on line 4.
The only way I've found so far to work around the error is to restart the cf services.
Any one have any ideas?
Chris
btw, this is using cfmx 6.1_______________________________________________Reply to DFWCFUG:Subscribe/Unsubscribe:List Archives:DFWCFUG Sponsors:
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://lists1.safesecureweb.com/mailman/private/list
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://lists1.safesecureweb.com/mailman/private/list http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
