Configuring the Oracle 10g Database Driver for ColdFusion MX

Oracle has recently released Oracle 10g Express Edition (XE), a free edition of their database server. While Macromedia supports connections to Oracle 10g from ColdFusion MX 7.01 using the built-in JDBC drivers that ship with ColdFusion, this version of Oracle is not officially supported with earlier versions including ColdFusion MX 7 or ColdFusion MX 6.x.

If you would like to connect an earlier version of ColdFusion MX to Oracle 10g, or would like to try an alternate driver if you're already using CFMX 7.01, then here is how to configure the 10g JDBC driver provided by Oracle for use with ColdFusion. This driver is often refered to as the Oracle Thin Client. Sometimes driver behavior varies between two vendors, so its often very helpful to try alternate driver versions.


ColdFusion MX 7.01 installation on RHEL4 - Warning: C++ compatibility pack

With support for Red Hat Enterprise Linux 4 introduced by ColdFusion MX 7.01, a C++ compatibility pack warning may be erroneously presented during ColdFusion installation. The ColdFusion MX installation script uses the command rpm --query compat-libstdc++ to ascertain if the C++ compatibility pack is installed on the system. The actual RPM package name is not compat-libstdc++ so the rpm command does not return a successful result and the CFMX installation script produces warning.

To more accurately determine the status of a C++ compatibility pack on the system, the ColdFusion MX installation script should either query all packages and use the grep command as a filter or query the exact package name. For example, the command rpm -qa | grep compat-libstdc++ queries all packages and filters or greps on the string compat-libstdc++. On my RHEL4 system, this command produced two results, compat-libstdc++-33-3.2.3-47.3 and compat-libstdc++-296-2.96-132.7.2.


Installation and configuration of CFMX 7.01 on RHEL 4 with Apache and MySQL

This meeting of the Online ColdFusion Meetup Group has been recorded and is available for viewing here:
The subject of this meeting was installing ColdFusion MX 7.01 server application on Red Hat Enterprise Linux 4, configuring it for the Apache webserver, and connecting to and using the MySQL 4.1 database. I tried to cover everything you need to know to get started while demonstrating the range of problems that some users encounter and then showing the solutions.

The topic list includes:

  • Installing ColdFusion MX 7.01 Server Configuration
  • Usage of Red Hat System V "boot scripts" with the service command.
  • Identifying and fixing CFMX problems due to missing X libraries
  • Identifying and fixing SELinux security context problems the right way. Security Enhanced Linux is now ACTIVE by default in Red Hat 4 and Fedora Core 4
  • Configuring Apache webserver and adding the CFMX connector module to the same SELinux security context as Apache.
  • MySQL 4.1 commandline usage to create databases and assign users in a secure manner
  • Configuration of JDBC driver for CFMX to connect to MySQL 4.1 (rather than 3.2x)
  • Demonstration of Linux user and group management for web application development

  • Installation of the CFEclipse plugin, a free and alternative IDE to develop ColdFusion applications while working on Linux or Mac OS X workstations, rather than using Homesite or Dreamweaver.

After watching the recording you'll be able to set this up for yourself at home all for free. Apache, MySQL, and Eclipse/CFEclipse are free products for home use, and rather than using Red Hat Enterprise Linux you can use its little brother Fedora Linux instead.


Lots of public momentum behind CFMX 7.01 for Mac OS X

Todd Matthews posted to the CF-Talk list that eWeek has published a very positive article about CFMX 7.01 support for Mac OS X in production.

Macromedia ColdFusion Supports Mac OS X 'Tiger'

Yahoo's Finance news is running a similar, but longer article:

Macromedia ColdFusion MX 7 Offers Mac OS X 'Tiger' and Mac OS X Server 'Tiger' Support, Achieves Rapid Customer Adoption

Further, Sean Corfield just posted about a new CF_OSX Blog that is looking for contributors.

Also, check out my screenshots of the ColdFusion MX 7.01 GUI installation.

Installing ColdFusion MX 7.01 Server Configuration on Mac OS X

I've put together a collection of screen shots to walk you through the new GUI installer for ColdFusion 7.01 for Mac OS X. Previously one had to perform several tedious prerequisite installations, but now CFMX is available in a clickable, user friendly installer.

Screenshots of CFMX 7.01 Installation on Mac OS X

For the first time, the System Requirements page lists support for production use of Apple Mac OS X 10.3.9, 10.4.2 and 10.4.3. Previously, the sysreqs had a footnote for for Mac to indicate support was development only.

Some versions of Windows now bear the Development Only footnote, including Windows 2000 Professional and Windows XP.

For convenience in starting and stopping the server as well as using the web server config tool, check out the

ColdFusion MX 7.01 Just Released

In these last 10 minutes the CFMX Updates page on was modified to include the lastest revision of ColdFusion MX, 7.01. This free update for CFMX 7 provides support for Network Deploy on WebSphere, support for Oracle 10g, support for Red Hat Enterprise Linux 4 and Suse 9 Enterprise Linux, a Mac OS X clickable and user friendly installation GUI for the familiar Server Configuration of ColdFusion MX, as well as a bundle of bug fixes.

Check out more here:

* Welcome to Merrimack: An Even Better ColdFusion MX 7 DevNet article
* FAQ about the ColdFusion MX 7 Updater (7.0.1)
* Downloads page for ColdFusion MX 7.01
* Screenshots of CFMX 7.01 installation on Mac OS X
* ColdFusion MX 7 Updater Release Notes

The System Requirements page is still pointing to the CFMX 7.0 version, so hopefully that will get updated soon.

Some AdminAPI methods are server configuration only

The new ColdFusion MX 7 Administrator API feature provides a supported mechanism to read, create, and modify CFMX settings, as described in the documentation. Additional information about what methods the AdminAPI can provide is found by browsing to the various CFCs that implement the API. The CFC Explorer renders metadata about API methods including hints, properties, arguments, and usage.

For example when browsing to /CFIDE/adminapi/runtime.cfc you'll find a summary of methods available at the top of the page including clearTrustedCache, getLastClientID, and getJVMProperty for just a few. You'll also note that some methods are marked by an asterisk to indicate they are private methods intended for use internally to the CFC such that publicly accessible methods may call the private methods in turn.


Breaking the silence

Just when I returned from sabbatical and started getting blog-happy, I ran into an error that prevented me from updating or inserting into the blog database. It had stopped me from adding new blog entries this week, and if you had encountered an error recently when adding a comment, please try again. I worked with my ISP to resolve the problem, and I can finally release my blogging frustrations!! :-)

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The log file for database 'TalkingTree' is full. Back up the transaction log for the database to free up some log space.

Progressive JPG images don't render in Flex's mx:Image tag

Just ran across a problem where two JPG images were intended for display in Flex 1.5 using the mx:Image tag, but only one image would render in the browser. Using a clue from a Flash Player problem, I opened both images up in PaintShop Pro and saved them again but as Standard JPG and as Progressive JPG. Only the Standard JPG images would render, but not the Progressive JPG. Standard and Progressive are options when saving JPG files in most image editors. So if you find this problem, try saving the image again but in Standard JPG format and Flex will be able to render it.

"1.0" encoding="utf-8"?>
"test1_standard.jpg" width="150" height="150"/>
"test1_progressive.jpg" width="150" height="150"/>

Back in the saddle again

This week I've returned to the office from Macromedia's generous sabbatical program. For the last 45 days I've occupied myself with a wide range of activities, and surprisingly almost none of which had anything to do with ColdFusion. Now that's a vacation!


Previous Entries / More Entries