jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Want to know how drivers work Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Want to know how drivers work" Watch "Want to know how drivers work" New topic

Want to know how drivers work

Vrushali Gore
Ranch Hand

Joined: Oct 17, 2005
Posts: 40
Thanks for whatever information you hace passed on to me. But you can say that really I am confused about how the things happen with drivers? In type1 & type2 we say that we need to have drivers on to the client side, but in case of type3 & type4 we don't need then on the client side. Even libraries needed are to be there on the Client side that is what we say about type1 & type2.

Why all this processing takes place on the client side? How actually drivers work & why do they work that way? Can you help me out in knowing all these things? So i guess my doubt would be more clear?

One more thing that i wanted to know is that can i get the names of the drivers and URLs of the drivers for varoius dbs?

Thanks a lot for ur info about drivers.
Shrinivas Mujumdar
Ranch Hand

Joined: Aug 27, 2004
Posts: 328
Hello Vrushali,
There is no need to think of how it works internally & why certain stuff is client side as far as programming is concerned....but not to disappoint you here is some stuff from my side :

Type 1,2 & 4 are drivers which can be used for Rich Client Application independently (without any need of Web/App. Server), these drivers know how to connect to DB & fire the queries etc.....so if you want to use these drivers on client side ,a client application must know where these drivers are located
Type 1 : No need to play with driver since it is available in rt.jar which comes with JDK so Java knows where it will be

Type 2: if i talk about windows, then you must specify where the DLL's are present (partly Java,Partly NATIVE)
Type 4: Portable but atleast must be in a classpath to make use of.

Type 3 :
It is used in Web/App Server & internally makes use of Type 1,2 or 4

If you are using web/App server best option is use DataSource to get connection with DB Since it gives you flexibility & ease of Configuration
Hey all these things happens on the server side


To Know some details about drivers & their history
refer: Java & CORBA Yellow color big book don't remember author /Pub. Name

I hope this helps or otherwise shoot a question back by clicking Post Reply on a page do not click on Post New Topic so that you can track a discussion


Type 3 driver
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33125

For anyone reading this, the original thread was here. This one is just different enough to warrant a new topic. In general, I agree with Shrinivas about replying.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Vrushali Gore
Ranch Hand

Joined: Oct 17, 2005
Posts: 40
Thanks Shriniwas sir for what all you told me. I always feel really very uncomfortable when I explain the drivers. When we say in Type 1 & Type 2 drivers that this processing takes place on client side, is this a way drivers works we have to say. Is there any explaination for why it takes place on client side?

In case of all 4 drivers we need to have them on to the client side. When we design any web application then in such case how we can do all these things onto the client side?

Rather our work would be difficult in that case. one good option that is availbale is only making use of datasource so that no need of anything on client side. Is it this way?

Thanks once again. But please let me know this thing.

I will refer that yellow book.
I agree. Here's the link: http://aspose.com/file-tools
subject: Want to know how drivers work
It's not a secret anymore!