Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Type 2 Driver

 
priya shankar
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
priya shankar
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic