TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

JDBC

Types of JDBC Drivers

Overview

JDBC drivers are available from a number of vendors. The drivers support different versions of the JDBC API. JDBC driver might be written purely in Java or in a mixture of the Java and Java native (JNI) methods.

There are basic four types of JDBC Drivers. They are categorized as follows:

  • Type 1 –  JDBC-ODBC Bridge Driver
  • Type 2 – Native API partly Java Driver
  • Type 3 – Middleware Driver
  • Type 4 – Pure Java Driver

Type 1

Type 1 drivers implement the JDBC API as a mapping to another data access API. The JDBC-ODBC (Open Data Base Connectivity) Bridge driver is an example of this driver. Type 1 drivers are dependent on the native library, so they are not portable to other machine architectures.

 

JBDC-ODBC Bridge Driver

Type 2

Type 2 drivers are written partly in the Java language and partly in native API. These drivers use a native client library specific to the data source to which they connect.

Type 3

Type 3 drivers use a pure Java client and communicate with a middleware using a database-independent protocol. The middleware server then communicates the JDBC client’s requests to the data source.

Type 4

Type 4 drivers are pure 100% Java and implement the network protocol for a specific data source. The JDBC client connects directly to the data source. These drivers are platform independent and can be used in Java applications.

Example:

Oracle JDBC Thin Driver is a Type 4 driver. Oracle JDBC driver can be client-side or server-side. Oracle thin driver is stateful.

—

Java Tutorial on this website:

https://www.testingdocs.com/java-tutorial/

For more information on Java, visit the official website :

https://www.oracle.com/in/java/

Related Posts

tnsnames File Oracle TestingDocs

JDBC /

Connect to Oracle Database using JDBC Thin Driver

Display Oracle Database Table JDBC

JDBC /

Display data from Oracle Database table using JDBC

JDBC API TestingDocs

JDBC /

JDBC API Components

JDBC /

JDBC ResultSet Interface

Configure Build Path Eclipse

JDBC /

Configure JDBC Driver in Java Project

‹ JDBC Architecture› Introduction to JDBC API(Java Database Connectivity)

Recent Posts

  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • RAPTOR Editions
  • Flowgorithm Conditional Breakpoint Statement
  • Flowgorithm Read Numbers from File Example
  • Search Text File Flowchart Example
  • Flowgorithm Turtle Graphics Symbols
  • Draw Circle using Flowgorithm Turtle
  • Draw Parallel Lines using Flowgorithm Graphics

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version