If each of those instances is in its own JVM, then yes, they would be 5 separate connections being used concurrently.
-----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:31 AM To: CF-Talk Subject: JDBC connection pooling coldfusion does jdbc connection pooling, right? so if I have 100 people browsing my web site, coldfusion will send queries over the DSN's existing connection right? And if "Maintain DB connection" is checked, that connection will always be there once it's been accessed at least once.. Now, if I have 5 instances of coldfusion, each of them with a DSN to the same database, then I would (potentially) have 5 concurrent connections... is that right? The reason I'm asking is because of the licensing model for Starquest's StarSQL for Java DB2 driver... it's licensed on a "per concurrent connection" basis Just trying to figure out how many concurrent connections I might have... Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
