Hi again, Thanks for taking the time to point me in the right direction with this one. I've done a little more investigation and I've discovered that this the change in behaviour is not simply due to the move from CF7 to CF8.
I am happy to confirm that I have now seen DB connections pooled correctly in CF8 using Firebird's Jaybird driver. This does leave me with a couple of interesting questions, although not ones that really needs answers as I can work around the problem. Here's the scenario: I have a number of Linux boxes each with a CF8 enterprise instance, the CF instances are clustered. Each box also has an Apache installation, each Apache can see the whole cluster. The Apache instances are load balanced. The web source code is on an NFS share which each Linux box has mounted. I decided it would be convenient to have a bit of code on each server which would not come from the NFS share and would be unique to each server. It simply provides information to the load balancers about how the servers are getting on. I discovered this could be achieved by dropping this code into CF's WEB-INF directory. It's the code which runs here which builds a new connection to the DB each time it's run, seemingly ignoring the pooling settings, although it simply refers to the same datasource as the main app. As it turns out, this code wasn't unique after all and it can return to the NFS share but it raises a couple of interesting questions: 1. Should one put .cfm files under the WEB-INF directory? 2. Is it significant / interesting that it seems to behave differently with respect to DB pooling? Cheers, Simon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
