*Installing and Using ColdFusion MX for IBM WebSphere Application Server*
Contents > Installing and Using ColdFusion MX for IBM WebSphere Application Server > Enabling and Using ColdFusion MX Features > Enabling ColdFusion MX functionality > Using a third-party JDBC database driver

Using a third-party JDBC database driver

ColdFusion MX includes JDBC Type 4 database drivers from Merant and MySQL, and JDBC Type 3 database drivers from Merant and SQL Link. (JDBC is an Application Programming Interface (API) for Java programs to access data.)

Data sources that you configure in the WebSphere default JNDI location are also available in ColdFusion MX. The data sources appear in the ColdFusion MX Administrator Data Source page, and you can use them in your CFML code. You cannot use the ColdFusion MX Administrator to add or modify WebSphere data sources.

In the ColdFusion MX Administrator, you can also configure and use JDBC drivers that are not included with ColdFusion MX (such as SQLAnywhere or PostgreSQL). If you do this, you can add and manage data sources that use the driver directly in ColdFusion. Use the following procedure to configure a third-party driver and add a data source that uses it:

To use a third-party JDBC database driver:

Copy the JAR file for the database driver to a directory that is on your Java CLASSPATH. For example, you might put the file in the cf_root\WEB-INF\lib directory in Windows, or the cf_root/WEB-INF/lib directory on UNIX.
In the ColdFusion MX Administrator, on the Data Sources page, add the JDBC data source by selecting Other from the Driver drop-down list box.
For more information, see the ColdFusion MX Administrator online Help.

You can now use the third-party JDBC database driver.


Contents > Installing and Using ColdFusion MX for IBM WebSphere Application Server > Enabling and Using ColdFusion MX Features > Enabling ColdFusion MX functionality > Using a third-party JDBC database driver

Version 6.1