Nov 4
Something interesting I just discovered.
For some reason only known to Macromedia ColdFusion makes seperate db calls outside of the and it does not use the the username/password you have specified in your tag. So If you do not store the username/password in the DSN (which you shouldn't do anyway on a shared server) you are going to get the error below in your application logs.
Views: 309
[Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01
From my testing it appears that the transaction processing does actually still work, and rollbacks do occur if all queries do not complete. But there may well be some other drawbacks to this behaviour.
To avoid this error you can move all your transactional processing into stored procedures instead.
Recent Comments