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

Use of req.query, req.params and req.body in NODE JS

-
Image
I am writing this article for beginners. Because, at the time of learning node js, this is very confusing where and how we need to use req.query, req.params and req.body . I am going to explain these three req method below. 1.        Req.query 2.        Req.params 3.        Req.body Req.query: When request is coming in key and value pair, for example, if your URL looks like below URL http://localhost:3000/search?name=xyz&age=16 In the above URL, you can see that request is coming in key and value pair . First key is name and value is xyz, second key is age and value is 16. In the node js programing, if you want to parse this url then use req.query. Below is the code snippet to parse this URL. router.get('/search', function(req, res, next) {   var name = req.query.name;   console.log(`Name :  ${name}`)   var age = req.query.age;   console.log(`Age :  ${age}`)   res.send('Request has parsed see console');   }); Req.param
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