Adobe 38000827 Administration Guide - Page 38

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

Get Adobe 38000827 - Macromedia ColdFusion MX Standard Edition PDF manuals and user guides
UPC - 718659577186
View all Adobe 38000827 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 38 highlights

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 1 2 3 4 Name Description JDBC-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. Native-API/ Converts JDBC calls into database-specific calls. partly Java driver 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. JDBC-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. Native-protocol/ Converts JDBC calls into the network protocol used directly by all-Java driver 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. 30 Chapter 3 Data Source Management

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
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
1
JDBC-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.
2
Native-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.
3
JDBC-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.