Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC driver confusion

 
Nidhi Nagre
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • 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?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • 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
  • 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?
 
Jan Cumps
Bartender
Posts: 2602
13
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • 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
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • 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
  • 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)?
 
Roger Chung-Wee
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
  • 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.
 
anilson cunha
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
look for a similar questions and answer here: http://www.hotitles.com
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic