This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Type of driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Type of driver" Watch "Type of driver" New topic

Type of driver

Jithesh Kumar
Ranch Hand

Joined: Mar 09, 2010
Posts: 46
Which type of drivers we will use in a web application.what is the condition we consider
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
These days, the answer is almost always "type 4", particularly if you aren't clear on what the various types of drivers are.
Harpreet Singh janda
Ranch Hand

Joined: Jan 14, 2010
Posts: 317

For the development purpose we generally use the type1 driver but mostly type 4 driver is used.
Shanky Sohar
Ranch Hand

Joined: Mar 17, 2010
Posts: 1051

we can use both type 3 and type 4 .........

but type 1 driver is not suppored for web application because it require the odbc driver to installed on each client machine.
this driver is used only when you want that webapplication to run on your own machine only.

but when you require that application to run on each and every machine on web,so there is need of driver 2,3,4

but we can use type 2 but there is some problem that this is not secured enough as compare to type 3 and type 4 because if we want to change the database then we have to change the native API....

so preferred means for web-based application is type 3 and type 4..
but when it comes to performance always use type 4.
because it is a pure java driver and it communicates directly with vender's database through socket communication.

SCJP6.0,My blog Ranchers from Delhi
Jan Cumps

Joined: Dec 20, 2006
Posts: 2565

Here is the Oracle explanation.
Note that the distinction is based on the technology used by the drivers.

OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: Type of driver
It's not a secret anymore!