JDBC Driver Types

-
JDBC Driver Types -
    Java has four type of JDBC driver for accessing and managing the relational databases.

1.JDBC-ODBC Bridge Driver – Type 1
2.JDBC-Native API - Type 2
3.JDBC-Net-protocol driver - Type 3
4.pure Java - Type 4 

JDBC ODBC Bridge Driver (Type 1) -
    JDBC ODBC Bridge Driver is fully platform dependent. This driver is used for learning phase of java. For making the JDBC ODBC connection, there is need to make DSN with the database in microsoft windows. This driver makes a bridge over the java application to DSN  and DSN point to the database.

JDBC-Native API / partly Java driver (Type 2) -
This driver used the Native api of other language like c/c++ for making connection with database. This driver is partly written java and C (C++) language.
This is vender specific driver, we need to install software for making connection through this driver. The Oracle Call Interface (OCI) driver is an example

JDBC-Net-protocol driver (Type 3) -
    For this driver, need a middle tire server. All the request will for to middle tire server and then this server call the database according to the request.
    There is no need to any other software or libraries because this driver is based on the server. This driver is totally written in java and also fully portable.

Pure Java (Type 4) -
    Pure Java driver is also fully written in java. Some database provide the libraries for making the connection. This driver is directly communicate with database.
    The major benefit of using a type 4 jdbc drivers are that they are completely written in Java to achieve platform independence and eliminate deployment administration issues. It is most suitable for the web.

Comments

Post a Comment

Recent Post

Recent Posts Widget

Popular posts from this blog

Capture image from webcam java code, examples

-
import java.applet.Applet; import java.awt.BorderLayout; import java.awt.Component; import java.awt.Dimension; import java.awt.Frame; import java.awt.Graphics; import java.awt.Graphics2D; import java.awt.Image; import java.awt.Panel; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.awt.image.BufferedImage; import java.io.FileOutputStream; import java.net.MalformedURLException; import java.net.URL; import javax.media.Buffer; import javax.media.CaptureDeviceInfo; import javax.media.CaptureDeviceManager; import javax.media.Manager; import javax.media.MediaLocator; import javax.media.Player; import javax.media.control.FrameGrabbingControl; import javax.media.format.VideoFormat; import javax.media.util.BufferToImage; import javax.swing.JButton; import javax.swing.JComponent; import com.sun.image.codec.jpeg.JPEGCodec; import com.sun.image.codec.jpeg.JPEGE...
Read more

How to capture finger prints in java

-
Java code for capture finger prints. NBioBSPJNI.FIR_HANDLE hSavedFIR; hSavedFIR = bsp.new FIR_HANDLE(); bsp.Enroll(hSavedFIR, null); // Enroll bsp.Capture(hSavedFIR); // Capture // Get Text FIR if (bsp.IsErrorOccured() == false) { NBioBSPJNI.FIR_TEXTENCODE textSavedFIR; textSavedFIR = bsp.new FIR_TEXTENCODE(); bsp.GetTextFIRFromHandle(hSavedFIR, textSavedFIR); } // Get Binary FIR if (bsp.IsErrorOccured() == false) { NBioBSPJNI.FIR fullSavedFIR; fullSavedFIR = bsp.new FIR(); bsp.GetFIRFromHandle(hSavedFIR, fullSavedFIR); } You can capture both type in your database and file. 1)textFIR 2)BinaryFIR
Read more

Shallow Copy Deep Copy Java example

-
Shallow Copy Deep Copy  Java example Before knowing about Shallow Copy and Deep Copy you need to know about Clonable interface. Clonable interface -     Java has a clonable interface for make clone of any object.     Clonable Interface is a marker interface.     Clonable Interface has no method.     Class which implements Clonable interface, JVM give the permission for making the clone of         this class. Shallow Copy -              Clone can be archived by object.clone() method. It gives the Shallow copy of the object. In this process a new object is created That have all the value and instance variable. And if main object has any references to other object then the references are copied in the shallow copy. Example - class A implements Cloneable{         A(String personName, Integer age){  ...
Read more