MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Bedienungsanleitung PDF herunterladen (Seite 38)

30 Chapter 3 Data Source Management

About JDBC

JDBC is a Java API (Application Programming Interface, an interface between

application programs and the operating system) that you use to execute SQL statements.

JDBC enables an application, such as ColdFusion, to interact with a variety of relational

databases, without using interfaces that are database- and platform-specific.

Note: JDBC is not an acronym; however, it is often believed to stand for Java DataBase

Connectivity.

The following table describes the four types of JDBC drivers:

Type Name Description

1JDBC-ODBC

bridge

Translates JDBC calls into ODBC calls, and sends them to the

ODBC driver.

Advantages Allows access to many different databases.

Disadvantages The ODBC driver, and possibly the client

database libraries, must reside on the ColdFusion server

computer. Performance is also below par.

Macromedia does not recommend this driver type unless your

application requires specific features of these drivers.

2Native-API/

partly Java driver

Converts JDBC calls into database-specific calls.

Advantages Better performance than Type 1 Driver.

Disadvantages The vendor’s client database libraries must

reside on the same computer as ColdFusion.

Macromedia does not recommend this driver type unless your

application requires specific features of these drivers.

3JDBC-Net pure

Java driver

Translates JDBC calls into the middle-tier server, which then

translates the request to the database-specific

native-connectivity interface.

Advantages No need for vendor’s database libraries to be

present on client computer. Can be tailored for small size (faster

loading).

Disadvantages Database-specific code must be executed in

the middle-tier.

4 Native-protocol/

all-Java driver

Converts JDBC calls into the network protocol used directly by

the database.

Advantages Fast performance. No special software needed

on the computer on which you run ColdFusion.

Disadvantages Many of these protocols are proprietary,

requiring a different driver for each database.

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 67 68

Kommentare zu diesen Handbüchern

Keine Kommentare

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Bedienungsanleitung Seite 38

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Server MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER