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?
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?
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.
Joined: Nov 05, 2007
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)?
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.