Database - JDBC, Java Server Pages, and MySQL - Discussion
Discussion Forum : JDBC, Java Server Pages, and MySQL - General Questions (Q.No. 11)
11.
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
Discussion:
3 comments Page 1 of 1.
NAVEEN said:
1 decade ago
4 type.
4. 100%pure java.
If you are accessing one type of database, such as Oracle, Sybase, or IBM, the preferred driver type is 4.
3. jdbc-net pure java.
If your Java application is accessing multiple types of databases at the same time, type 3 is the preferred driver.
2. JDBC-NATIVE API.
Type 2 drivers are useful in situations where a type 3 or type 4 driver is not available yet for your database.
1. JDBC-ODBC BRIDGE DRIVE.
The type 1 driver is not considered a deployment-level driver and is typically used for development and testing purposes only.
4. 100%pure java.
If you are accessing one type of database, such as Oracle, Sybase, or IBM, the preferred driver type is 4.
3. jdbc-net pure java.
If your Java application is accessing multiple types of databases at the same time, type 3 is the preferred driver.
2. JDBC-NATIVE API.
Type 2 drivers are useful in situations where a type 3 or type 4 driver is not available yet for your database.
1. JDBC-ODBC BRIDGE DRIVE.
The type 1 driver is not considered a deployment-level driver and is typically used for development and testing purposes only.
Manche Shekhar said:
1 decade ago
I think only type3 driver use three-tier architecture.
Sonali jain said:
1 decade ago
Define all types of JDBC?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers