• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

JDBC driver confusion

 
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've downloaded the relevent jar file named oracle 10g database driver from oracle site. but I'm still not sure that the jar file, I've downloaded, is a JDBC driver to connect to oracle 10g database or not?
is oracle database driver and jdbc driver are two diffrent entities?

please ensure me which catagory driver should i use for a web application using java as front end and oracle as backend and where can i download it from?
 
author & internet detective
Posts: 42102
933
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Nidhi,
All of Oracle's JDBC drivers are listed on this page of their site. For Java 1.4 and 5, use ojdbc14.jar. For earlier versions of Java, use classes12.jar.
 
Nidhi Nagre
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
and for java 1.6.x?

well,after briefing through documentation on Oracle JDBC drivers available in this site, i came to know about four types of oracle JDBC drivers.

Thin driver
It is a pure Java driver used on the client side, without an Oracle client installation. It can be used with both applets and applications.

what does this mean? only applet's can use fuctionality of this driver, not servlets?
if a client request for a web page across an internet that ultimately will be retrived from data base, then is it mean that he must have installed oracle database in his machine?

please give me descriptive points to understand that , how each of four drivers is used?
 
Bartender
Posts: 2662
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

Originally posted by Nidhi Nagre:
and for java 1.6.x?

only applet's can use fuctionality of this driver, not servlets??

No. Thin driver can be used by servlets too. A thin driver can make the connection to the database on its own. You don't need to install Oracle client software.

if a client request for a web page across an internet that ultimately will be retrived from data base, then is it mean that he must have installed oracle database in his machine?

No. It is your application server that will connect to your database, and get information from the tables.
The end user of the web page will not need any Oracle software.

Regards, Jan
 
Jeanne Boyarsky
author & internet detective
Posts: 42102
933
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Nidhi Nagre:
and for java 1.6.x?


Also ojdbc14.jar. A new driver was introduced for Java 1.4+. They probably just haven't updated the documentation on the page I paraphrased. There isn't a new driver for Java 1.6.
 
Nidhi Nagre
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
although, I've a bit understanding about Application server, Database server and Web server but Nevertheless, Please explain how these are related to each other.

If I've Oracle 10g installed in my machine then, is it a local copy of database server or of a database ? diffrence between database server and database?

somwhere i read that Tomcat is a Web server which serves Https and can't serve EJB whereas, in my machine tomcat is installed and it is serving Https as well as servlets and JSP's, how is it a contradict?

how application server and web server are related?
if a user makes a http request across internet using java as front end then who serves this request, a web server(installed in remost host) or an application server(like websphere)?
 
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
A Java Enterprise Edition Application Server implements the Enterprise Edition specifications. The biggest servers are BEA's WebLogic Server amd IBM's WebSphere. These servers include a servlet container (for JSPs and servlets) and an EJB container (for Enterprise JavaBeans).

If you don't need an EJB container but do need a servlet container, then Tomcat is a popular choice.

As for database connectivity ... in my department, we use WebLogic Server with a third-party driver (which happens to be the thin Oracle driver). It's simple to set up a JDBC connection pool for each database. When the datasource.getConnection() method is invoked, WebLogic Server returns a logical JDBC Connection.
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
look for a similar questions and answer here: http://www.hotitles.com
 
Life just hasn't been the same since the volcano erupted and now the air is full of tiny ads.
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic