Skip to main content

JDBC Driver types


Application that use JDBC require JDBC drivers. JDBC drivers are software libraries that communicate between a java application and a database. All JDBC drivers follow the API defined in java SE .
  
                                                      There are four type of drivers available distinguished by their architecture they are:

Type 1: JDBC-ODBC Bridge





















This is an old type when the jdbc is started  ODBC is the dominant  model to communicate with the data base. And java first communicate with database through ODBC.
  • -communicates through ODBC drivers installed on client
  • Can talk to any database

But
  • -not  100% Java and not portable
  • -drivers must be on the same computer as application
  • -the ODBC driver must match the database version



Type 2:native API/partly Java

  • Communicates through OS specific Api
  • Better performance than JDBC/ODBC Bridge

But
  • -not  100% Java and not portable
  • -native API driver must be installed on the application client
  • -if the database is updated, the client software must be updated


Type 3: all Java /network-protocol Driver


















  • Communicates through network to middleware server
  • Driver is server-based; vendor-specific libraries not required on the client
  • The client driver can be very small 


Type 4 :100% java thin driver

  •  













  • Communicates directly from application to database
  • The driver is 100% java; no additional layers to install of maintain
  • The driver is installed with the application, so maintenance is simplified

But
  • You need a different driver for each database

now i think you have get the overall idea about the JDBC driver types . I feel so sleepy right now may be i will go off soon or will back after some time ; most probably you have to wait a whole day for  next post... 
Labels:

Comments

Post a Comment

Popular posts from this blog

Configuring Multiple Profiles in a Single YAML File for Spring Boot Application

Spring Boot provides a convenient way to configure application properties using YAML files. In a typical scenario, you might have different configurations for different environments such as development, testing, and production. Instead of maintaining multiple YAML files for each profile, you can configure multiple profiles within a single YAML file. This approach simplifies the configuration management process. Let's see how to achieve this. Step 1: Create a YAML Configuration File First, create a YAML file (e.g., application.yml ) in your Spring Boot project's resource directory. This file will contain the configuration properties for all the profiles you want to define. spring: profiles: active: dev logging: level: root: INFO com.example: DEBUG # Configuration for the 'dev' profile --- spring: profiles: dev database: url: jdbc:mysql://localhost:3306/devdb username: devuser password: devpassword # Co...
Post a Comment
Read more

How to Open a Project in IntelliJ IDEA from the Command Line: A Step-by-Step Guide

How to Open a Project in IntelliJ IDEA from the Command Line IntelliJ IDEA is a popular and powerful Integrated Development Environment (IDE) for Java development. You may have a project folder that you want to open in IntelliJ IDEA. In this tutorial, we will walk through the steps for opening a project in IntelliJ IDEA from the command line. Configure IntelliJ IDEA for Command Line Use Before we can open a project in IntelliJ IDEA from the command line, we need to make sure that it is properly configured. Here are the steps: Open IntelliJ IDEA and go to Tools > Create Command-line Launcher . Select the installation path and click OK . Make sure that the launcher is added to your system PATH variable. You can do this by opening a terminal or command prompt and typing: which idea If the output is the path to the IntelliJ IDEA launcher, then you're good to go! Open a Project in IntelliJ IDEA from the Command Line Open your terminal or command prompt. ...
Post a Comment
Read more

A End to End ant Build xml snippet

A End to End ant Build xml snippet you could use for reference <?xml version="1.0" encoding="UTF-8"?> <project name="End to End Build" default="sendmail" basedir=".">     <target name="init">         <tstamp />         <property file="build.properties" />             <path id="classpath">             <pathelement path="${servlet.jar}" />             <pathelement path="${junit.jar}" />         </path>
18 comments
Read more