Managing ColdFusion MX
47
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:
1
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.
2
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.
Managing ColdFusion MX
This section explains how to manage ColdFusion MX and the Windows services that are created
when you deploy ColdFusion MX.
Managing the ColdFusion MX application
IBM WebSphere Application Server manages the ColdFusion MX web application. Therefore, to
start, stop, or restart ColdFusion MX, start, stop, or restart the ColdFusion application in the
WebSphere Administrator. For more information, see your WebSphere documentation. To
manage most ColdFusion MX characteristics and resources, such as data sources and debugging
settings, use the ColdFusion MX Administrator.
Note:
If you enable or disable security in the ColdFusion MX Administrator, you must stop and restart
the server for ColdFusion MX for your changes to take effect.
Managing ColdFusion MX Windows services
This section describes the Windows ODBC services that the ColdFusion MX Configuration and
Migration Wizard installations.
Overview of services
The ColdFusion MX Startup Wizard creates the following services in Windows:
Service
Purpose
ColdFusion MX ODBC agent
The service used to configure data sources for the ColdFusion MX
ODBC server.
ColdFusion MX ODBC server
The middle-tier service for ODBC connections that use the
ColdFusion MX DataDirect drivers for Microsoft Access and
ODBC Socket.
