have you got connection pooling turned on? Maybe there are too many connection to the DB server
maybe you are running out of l incenses on the DB server?? 2009/2/6 Scott Mulholland <[email protected]> > > Nothing changed at the database level but this issue has actually gotten > much worse today. Every other click in the app throws: > > > Data source DATASOURCENAME verification failed. The root cause was that: > > java.sql.SQLException: Datasource names for all the database tags within > > CFTRANSACTION must be the same. > > For pages that have no cftransaction tags on them. The datasource it says > failed verification verifies fine in the admin as well. We even deleted > the > datasource and then recreated it and that seemed to fix it for about 5 > minutes. It is more than one datasource appearing in the messages as well. > > Anyone else ever experienced this?? > > > -----Original Message----- > From: AJ Mercer [mailto:[email protected]] > Sent: Tuesday, January 27, 2009 7:38 PM > To: cf-talk > Subject: Re: Strange Datasource error > > > Has someone been modifying the settings on the database server? > Maybe transaction behavior was changed there - As I understand it, CF will > use the default transaction settings (eg dirty read, committed read ...) > > > 2009/1/28 Scott Mulholland <[email protected]> > > > Out of nowhere today I had two different applications that utilize the > same > > datasource begin throwing the error: > > > > > > > > Data source DATASOURCENAME verification failed. The root cause was that: > > java.sql.SQLException: Datasource names for all the database tags within > > CFTRANSACTION must be the same. > > > > > > > > The strange part is they don't use cftransaction? Has anyone seen this > > type > > of thing before? A reboot seems to have stopped it but I would like to > > know > > if anyone knows the cause. > > > > > > > > Thanks, > > > > Scott > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
