System information

35
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
JDBC drivers are stored in JAR files. For example, the JDBC drivers that are supplied with ColdFusion are in the
_drivers.jar file. If you are using another JDBC driver, you must store it in the ColdFusion classpath. For example,
cf_root/cfusion/lib (server configuration) or cf_webapp_root/WEB-INF/cfusion/lib (multiserver or J2EE
configuration).
Supplied drivers
The following table lists the database drivers supplied with ColdFusion and where you can find more information
about them:
To see a list of database versions that ColdFusion supports, go to www.adobe.com/go/learn_cfu_cfsysreqs_en.
When running in the J2EE configuration, the ColdFusion Administrator also lets you configure a data source that
connects to a JNDI data source. A Java Naming and Directory Interface (JNDI) data source is equivalent to a
ColdFusion data source, except you define it by using your J2EE application server. After it’s defined, ColdFusion
applications use it as they would any data source. For information on defining a JNDI data source, see
“Connecting to
JNDI data sources” on page 57.
Adding data sources
In the ColdFusion Administrator, you configure your data sources to communicate with ColdFusion. After you add a
data source to the Administrator, you access it by name in any CFML tag that establishes database connections; for
example, in the cfquery tag. During a query, the data source tells ColdFusion which database to connect to and what
parameters to use for the connection.
The ColdFusion Administrator organizes information about all ColdFusion server database connections in a single
location. In addition to adding data sources, you can use the Administrator to specify changes to your database
configuration, such as relocation, renaming, or changes in security permissions.
Driver Type For more information
Apache Derby Client “Connecting to Apache Derby Client” on page 37
Apache Derby Embedded “Connecting to Apache Derby Embedded” on page 38
DB2 Universal Database 4 “Connecting to DB2 Universal Database” on page 39
DB2 OS/390 4 “Connecting to other data sources” on page 53
Informix 4 “Connecting to Informix” on page 40
Microsoft Access 3 “Connecting to Microsoft Access” on page 41
Microsoft Access with Unicode support 2 “Connecting to Microsoft Access with Unicode” on page 42
Microsoft SQL Server 4 “Connecting to Microsoft SQL Server” on page 43
MySQL 4 “Connecting to MySQL” on page 46
ODBC Socket 3 “Connecting to ODBC Socket” on page 51
Oracle 4 “Connecting to Oracle” on page 52
Other “Connecting to other data sources” on page 53
Sybase 4 “Connecting to Sybase” on page 56