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
Details 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
Shrinivas
Type 3 driver