Using Apache's Database Connection Pool with ColdFusion MX

A friend sent this to me. Unsupported by Macromedia for sure, but worth a look.

For compulsive connection-pool tinkerers. I got this to work with CF, but it is rather messy and fraught with peril.

The DBCP Component, from Apache Jakarta Project
description: Commons-DBCP provides database connection pooling services.

Briefly - dbcp can be set up as a JDBC driver, and then configured to use a real JDBC driver of your choice. It works with the drivers in macromedia_drivers.jar, as long as you're calling dbcp from an appropriate edition of CF.

  • You set up an "other" datasource to jdbc:apache:commons:dbcp:/{name}.
  • It is important to UnCheck the "Maintain Connections" box.
  • You edit the file {name}.jocl to have all your exotic connection-pool settings and the correct URL for your database.
  • Put two jar files and the directory containing {name}.jocl in your classpath, tinker with some fussy XML for a few hours, and viola - yet another database connection pool.
  • Commons DBCP Downloads
  • See the notes at the bottom of sample.jocl for all the details.

CFMX 7 Podcast Series: Introducing the 'Making Blackstone' Series

Fifth in this series of podcasts is a reading of the Macromedia Devnet article on Introducing the "Making Blackstone" Series by Damon Cooper and Tim Buntel.

This article was published in late 2004 before th release of ColdFusion MX 7 while the product was still codenamed Blackstone during the Beta cycle. It introduces the series of subsequent articles to be written by ColdFusion Engineers who developed various feature sets of the new release. Check the first three podcasts in this series for some of those articles already including CFForm by Mike Nimer, Clustering and Sourceless Deploy by Geoff Green and Erik Tierney, and New Verity Features by Tom Jordahl.

Logged In: Introducing the "Making Blackstone" Series
Check out articles from the ColdFusion engineering team and get an under-the-hood look at Blackstone.


To subscribe to the ColdFusion podcasts you can set your podcast-enabled blog aggregator such as iPodder or Feed Demon to the ColdFusion Podcast RSS 2.0 feed.

CFMX 7 Podcast Series: Introducing ColdFusion MX 7

Fourth in this series of podcasts is a reading of the Macromedia Devnet article on the Introducing ColdFusion MX 7 by Ben Forta.

If I had planned the order of these podcasts better, this should have been the first of the series, so its a little odd to have the introduction to ColdFusion MX 7 after some of the feature articles. Well, enjoy anyway.

Introducing ColdFusion MX 7
Get an overview of the hot new features in ColdFusion MX 7the most customer-driven release to date.


To subscribe to the ColdFusion podcasts you can set your podcast-enabled blog aggregator such as iPodder or Feed Demon to the ColdFusion Podcast RSS 2.0 feed.