aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Type of driver" Watch "Type of driver" New topic
Author

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
Marshal

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


Ping & DNS - my free Android networking tools app
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
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

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


OCUP UML fundamental and ITIL foundation
youtube channel
 
jQuery in Action, 2nd edition
 
subject: Type of driver