permaculture playing cards*
The moose likes JDBC and the fly likes JDBC driver confusion Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC driver confusion" Watch "JDBC driver confusion" New topic
Author

JDBC driver confusion

Nidhi Nagre
Ranch Hand

Joined: Nov 05, 2007
Posts: 64
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30085
    
149

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Nidhi Nagre
Ranch Hand

Joined: Nov 05, 2007
Posts: 64
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

Joined: Dec 20, 2006
Posts: 2491
    
    8

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


OCUP UML fundamental and ITIL foundation
youtube channel
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30085
    
149

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

Joined: Nov 05, 2007
Posts: 64
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

Joined: Sep 29, 2002
Posts: 1683
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.


SCJP 1.4, SCWCD 1.3, SCBCD 1.3
anilson cunha
Greenhorn

Joined: Jan 06, 2008
Posts: 1
look for a similar questions and answer here: http://www.hotitles.com
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: JDBC driver confusion
 
Similar Threads
query working in sqldeveloper and not from java jdbc
How to connect jdk1.7 and oracle 10g express edition in eclipse
Oracle Connection with JSP
Tomcat and Oracle, will i transfer any file?
Web Application Class Loader and Weblogic