• Home
  • Courses

    About Courses

    • Core Java
    • JDBC
    JDBC

    JDBC

    Free
    Read More
  • Features
    • Portfolio
    • About Us
    • FAQs
  • Gallery
  • Blog
  • Contact
      • Cart

        0
    Hacked by Katib | Turkish Hacker | SpyHackerz.OrgHacked by Katib | Turkish Hacker | SpyHackerz.Org
    • Home
    • Courses

      About Courses

      • Core Java
      • JDBC
      JDBC

      JDBC

      Free
      Read More
    • Features
      • Portfolio
      • About Us
      • FAQs
    • Gallery
    • Blog
    • Contact
        • Cart

          0

      JAVA TECHNOLOGIES

      • Home
      • All courses
      • JAVA TECHNOLOGIES
      • JDBC
      LP CoursesJAVA TECHNOLOGIESJDBC
        • Lecture1.1
          What is JDBC? 30 min
        • Lecture1.2
          DBMS and RDBMS 30 min
        • Lecture1.3
          Basic SQL Syntax 30 min
        • Lecture1.4
          Install MySql 30 min
        • Lecture1.5
          JDBC driver 30 min
        • Lecture1.6
          JDBC Connection 30 min
        • Lecture1.7
          JDBC Statement 30 min
        • Lecture1.8
          JDBC ResultSet 30 min
        • Lecture1.9
          JDBC Transactions 30 min
        • Lecture1.10
          Insert Records-PreparedStatement Example 30 min
        • Lecture1.11
          Insert Records-Statement Example 30 min
        • Lecture1.12
          Update Records-Example 30 min
        • Lecture1.13
          Delete Records-Example 30 min
        • Lecture1.14
          Stored Procedures-Example 30 min

        JDBC driver

        A Java program that uses the JDBC API loads the specified driver for a particular DBMS before it actually connects to a database. The JDBC DriverManager class then sends all JDBC API calls to the loaded driver.

        The four types of JDBC drivers are:

        1. Type 1: JDBC-ODBC Bridge Driver

        Translates JDBC API calls into Microsoft Open Database Connectivity (ODBC) calls that are then passed to the ODBC driver. The ODBC binary code must be loaded on every client computer that uses this type of driver.

        jdbc type 1 driver

        2. Type 2: JDBC-Native API

        Converts JDBC API calls into DBMS-specific client API calls. Like the bridge driver, this type of driver requires that some binary code be loaded on each client computer.

        jdbc type 2 driver

        3. Type 3: JDBC-Net pure Java

        Sends JDBC API calls to a middle-tier net server that translates the calls into the DBMS-specific network protocol. The translated calls are then sent to a particular DBMS.

        jdbc type 3 driver

        4. Type 4: 100% pure Java

        Converts JDBC API calls directly into the DBMS-specific network protocol without a middle tier. This allows the client applications to connect directly to the database server.

        jdbc type 4 driver

        Prev Install MySql
        Next JDBC Connection

        Leave A Reply Cancel reply

        Your email address will not be published. Required fields are marked *

        All Courses

        • JAVA TECHNOLOGIES

        Latest Courses

        Core Java

        Core Java

        Free
        JDBC

        JDBC

        Free
        logo-eduma-the-best-lms-wordpress-theme

        contactus@tech2our.com

        Company

        • About Us
        • Blog
        • Contact

        Links

        • Courses
        • Events
        • FAQs

        Support

        • Documentation
        • Forums
        • Language Packs

        Copyright © 2012-2017 Tech2Our.com. All Rights Reserved.

        • Privacy
        • Terms
        • Sitemap