• 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

Driver Type

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can anyone please let me know which driver type category "ojdbc5.jar" falls under.
using the DB as Oracle 11g.

Thanks in advance,

Pratik
 
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi

are you asking the DriverManager Class ??
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to JavaRanch, Pratik.

It depends on the connection string you are using. Several types are bundled inside this jar.

From Oracle:

These are the driver versions in the 11R1 release:

- JDBC Thin Driver 11R1
100% Java client-side JDBC driver for use in client applications,
middle-tier servers and applets.

- JDBC OCI Driver 11R1
Client-side JDBC driver for use on a machine where OCI 11R1
is installed.

- JDBC Thin Server-side Driver 11R1
JDBC driver for use in Java program in the database to access
remote Oracle databases.

- JDBC Server-side Internal Driver 11R1
Server-side JDBC driver for use by Java Stored procedures. This
driver used to be called the "JDBC Kprb Driver".



Regards, Jan
 
Pratik Chhichhia
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi jan,

Thanks.

I am using following 2 properties at the time of connecting to oracle.
driver.class.name = oracle.jdbc.driver.OracleDriver
url = jdbcracle:thin:@ipaddr:1521:testdb

Moreover, I referred docs on sun.com which says following:
"A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS.
Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine."

Can you throw some more light on above reference from the doc keeping the url and driver class in the middle.

Thanks again,
Pratik

Jan Cumps wrote:Welcome to JavaRanch, Pratik.

It depends on the connection string you are using. Several types are bundled inside this jar.

From Oracle:

These are the driver versions in the 11R1 release:

- JDBC Thin Driver 11R1
100% Java client-side JDBC driver for use in client applications,
middle-tier servers and applets.

- JDBC OCI Driver 11R1
Client-side JDBC driver for use on a machine where OCI 11R1
is installed.

- JDBC Thin Server-side Driver 11R1
JDBC driver for use in Java program in the database to access
remote Oracle databases.

- JDBC Server-side Internal Driver 11R1
Server-side JDBC driver for use by Java Stored procedures. This
driver used to be called the "JDBC Kprb Driver".



Regards, Jan

 
Pratik Chhichhia
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi prakash,

Thanks for the reply.

Yes, exactly.

I am using following props to connect.
driver.class.name = oracle.jdbc.driver.OracleDriver
url = jdbcracle:thin:@ipaddr:1521:testdb

Can you throw some light relevant to this ?

Thanks again.
Pratik

prakash pawar wrote:hi

are you asking the DriverManager Class ??

 
reply
    Bookmark Topic Watch Topic
  • New Topic