Classes12 or ojdbc14.jar ?

[Rakesh Ravi]

Hi All,

I have a doubt regarding JDBC thin drivers to be used in a application.

Which jar file need to be used out of Classes12 , ojdbc14 for a application running on Tomcat server with jdk 1.5 ?

According to this url form oracle.com http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html, ojdbc14 is the jar for jdk 1.4 or 1.5 but surprisingly most of the applications running on our Tomcat server are using classes12.jar version without any issues!

Could any one advice on the correct jar to be used?

Thanks

[Joe Ess]

Rakesh Ravi wrote:. . . surprisingly most of the applications running on our Tomcat server are using classes12.jar version without any issues!

This is not surprising because Java versions are backwards compatible (i.e. something created with an earlier JDK can be executed with a newer one). The newer version, ojdbc14, contains enhancements and data types which are not compatible with earlier JVM's (the JDBC API 3 was introduced in JDK 1.4).

[ken zhu]

Actually, i also have this confusion.
Many articles said ojdbc14.jar is oralce10g jdbc driver, so what are their relation between JDK version(JDK1.4/JDK1.5/JDK1.6) AND Oracle database version(Oracle 9i/10g) AND JDBC Driver Version(classes12.jar/ojdbc14.jar) ?

our project is JDK1.4+Oralce9.2+ojdbc14.jar and i don't whether is good or not .

[Joe Ess]

ojdbc14.jar is for JDK versions 1.4 and above.

[ken zhu]

Joe Ess wrote:ojdbc14.jar is for JDK versions 1.4 and above.

Does it have any relation with database version like Oracle 9i or Oracle 10g?

[Joe Ess]

Not to my knowledge.

[Balu Sadhasivam]

ken zhu wrote:Actually, i also have this confusion.
Many articles said ojdbc14.jar is oralce10g jdbc driver, so what are their relation between JDK version(JDK1.4/JDK1.5/JDK1.6) AND Oracle database version(Oracle 9i/10g) AND JDBC Driver Version(classes12.jar/ojdbc14.jar) ?

our project is JDK1.4+Oralce9.2+ojdbc14.jar and i don't whether is good or not .

Each of these ojdbc jars are related to particular JDK version , but Java supports backward compatability , so you can use ojdbc14 jar in any web/appserver supporting JDK 1.4 or higher.

similarly ojdbc5.jar is for JDK 1.5 and higher (cant be used in webcontainer which does not jdk 5)
ojdbc6.jar is for JDK 1.6 and higher

[james huska]

hello,

i have a question concerning on working with Oracle bu i do not where to begin..

i have an oracle database application server v 11g and i have to make a small application to another server to fetch some information. The service on remote server is Web Service.

I have to use Java to fetch this information and then later update it on oracle.

i have no idea to begin because i have never worked with oracle..

will you please help me with where to begin... i will really appreciate...

i am stuck for days with this problem.

thanks
mwandu, oracle new

[Balu Sadhasivam]

james,

Welcome to Javaranch.

Instead of posting in the old topic , start a new thread , you would get more responses to it. BTW if your requirement is on Webservices , post in Webservice Forum.