File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Type 2 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 2 Driver" Watch "Type 2 Driver" New topic
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: 8919

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: 8919

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Type 2 Driver