Adobe ColdFusion (ACF) engines require all queryExecute()
statements running within a transaction to have identical datasource
, username
, and password
options. If your application uses the JDBCStore within a <cftransaction>
block you may receive the following error message "Usernames and Passwords for all the database tags within the cftransaction tag must be the same". If your application sets the default DSN using this.datasource
in your Application.cfc file, you may be able to work around the issue by omitting the dsn
, dsnUsername
, and dsnPassword
properties from the JDBCStore.