• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

thin?

 
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In case of type4 driver , I require following URL

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@dbs:1521:orcl","scott","tiger");

Q.> What is thin?
 
author
Posts: 4335
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The opposite of a fat driver!

But seriously... Oracle provides two versions of its driver: thin and OCI (thick). Thin is based purely in java and is generally very stable whereas OCI is written in more Oracle native code and is considered more powerful.

I've found most people use thin drivers although there are some excellent reasons for using OCI. Here's a short post listing some reasons:

http://forum.java.sun.com/thread.jspa?threadID=629750&messageID=3622539
 
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What Scott said...

The "thin" driver merely requires the right jar file(s), usually just one, while the "thick" driver requires an Oracle Client installation, which includes some native code components (DLLs or shared libraries) and the environmental settings to find them.

In other words, the "thin" driver will run any place Java runs, but the "thick" driver is available only for a handful of operating systems (most of the major ones).
reply
    Bookmark Topic Watch Topic
  • New Topic