Yes, it is possible to use type 2 drivers in real world. Type 2 drivers require client side native library installation. However it is better to use type 4 drivers. This a pure Java driver requiring no client side installation.Most of the databases have a type 4 driver. Type 4 drivers peform better then type 2. For e.g. Oracle thin driver is a type 4 driver [ August 25, 2003: Message edited by: Pradeep Bhat ]
Thanks Bhatt Could u tell me what native library i need to install in client side when i use type 2..Let me confirm whether OCI 8 is a type 2 driver. Can u name a few type 4 drivers... Is thin oracle drievr is a type 4 driver...To use type 4 what should i install .. thanks priya
BTW, I am bhat and not bhatt. Link for Oracle drivers http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/factsht.htm For using type 2, you need to install oracle client on the m/c where type 2 driver is being installed. The native library is the C library, called OCI (Oracle Call Interface), interacts with an Oracle database.