| Author |
Type 2 Driver
|
priya shankar
Greenhorn
Joined: May 12, 2003
Posts: 21
|
|
Hi
Is it possible to use type 2 Driver say OCI8 oracle Driver in real world project and in a project which uses MVC architecture...
If not what are the drivers ...
thanks
priya
|
 |
Pradeep bhatt
Ranch Hand
Joined: Feb 27, 2002
Posts: 8876
|
|
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 ]
|
Groovy
|
|
priya shankar
Greenhorn
Joined: May 12, 2003
Posts: 21
|
|
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
|
|
Pradeep bhatt
Ranch Hand
Joined: Feb 27, 2002
Posts: 8876
|
|
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.
Download Oracle JDBC drivers here
http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html
|
|
 |
|
|
subject: Type 2 Driver
|
|
|
0
