my dog learned polymorphism*
The moose likes JDBC and the fly likes Difference between thin driver and oci driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Difference between thin driver and oci driver" Watch "Difference between thin driver and oci driver" New topic
Author

Difference between thin driver and oci driver

sandesh pawar
Greenhorn

Joined: Feb 16, 2004
Posts: 4
hi,
Can u tell me whats a difference between thin driver and oci driver.In what they come.which is the fastest and why.Which is more sensible to use and why?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60765
    
  65

Clearly not a JSP question. Moving to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by sandesh pawar:
hi,
Can u tell me whats a difference between thin driver and oci driver.In what they come.which is the fastest and why.Which is more sensible to use and why?

Difference between OCI and thin: Oracle JDBC docs ( need to register with Oracle site )
Performance difference between the two drivers: Java Programming with Oracle JDBC - By Donald Bales
Deployment differences - the thin drivers are a self-contained jar file that can just be added to the classpath to use where as the OCI drivers require a full install of the Oracle client on every machine. I prefer the thin drivers as they make deployment of my apps easier. I have not experienced any performance problems in 3 years of using the thin drivers.
Jamie
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Difference between thin driver and oci driver
 
Similar Threads
thin and oci
Oracle Blob using Java help (Error: JVM_recv in socket input stream read )
Oracle Drivers
DSN and DSN less connection
finding Driver Type