70
CONFIGURING AND ADMINISTERING COLDFUSION 10
Data Source Management
L
ast
u
p
dated
7/9/2
01
2
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 93.
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
72
Apache Derby Embedded
“
Connecting to Apache Derby Embedded
” on page
73
DB2 Universal Database
4
“
Connecting to DB2 Universal Database
” on page
74
DB2 OS/390
4
“
Connecting to other data sources
” on page
89
Informix
4
“
Connecting to Informix
” on page
75
Microsoft Access
3
“
Connecting to Microsoft Access
” on page
77
Microsoft Access with Unicode support
2
“
Connecting to Microsoft Access with Unicode
” on page
78
Microsoft SQL Server
4
“
Connecting to Microsoft SQL Server
” on page
79
MySQL
4
“
Connecting to MySQL
” on page
82
ODBC Socket
3
“
Connecting to ODBC Socket
” on page
86
Oracle
4
“
Connecting to Oracle
” on page
87
Other
“
Connecting to other data sources
” on page
89
Sybase
4
“
Connecting to Sybase
” on page
91