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

a simple example for jdbc PreparedStatement

a simple example for PreparedStatement package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); //stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); String sql="select * fr...
1 comment
Read more

Server-Side Pagination with React-Table and Spring Boot JPA with H2 Database

Pagination is a common technique used to split large amounts of data into smaller, more manageable chunks. With server-side pagination, data is retrieved from the server in smaller batches, reducing the amount of data transferred over the network and improving application performance. React-Table provides a wide range of built-in features such as sorting, filtering, pagination, row selection, and column resizing. These features can be easily configured and customized to fit specific requirements. For example, you can customize the sorting behavior to handle multiple sorting criteria, or you can add custom filters to the table to handle complex data filtering scenarios. Additionally, React-Table provides a flexible API that allows developers to extend its functionality with custom hooks, plugins, and components. This means that you can easily add custom functionality to the table, such as exporting data to CSV or integrating with external data sources. In terms of styl...
Post a Comment
Read more