The Files depend on the version of the JDK you are using
Classes12 is meant for JDK 1.2 and 1.3
ojdbc14 is meant for JDK 1.4
ojdbc5 is meant for use with JDK 1.5 and 1.6
Now for each of these jar files there are 5 or 6 different versions
(9.2.0.4,10.1,10.2.0.4,11.1.0,11.2, ...)
Now each of these versions has multiple versions of the JDBC drivers.
The safest place to get your JDBC drivers is at:
http://otn.oracle.com sign up for a OTN account, it is free, download
the latest driver for the JDK you are currently running. JDBC drivers
are backwards compatible with previous versions of Oracle. If you get
the 11.1.0 version of ODJBC14.jar it is compatible with all versions
of 10g and 9i.
Confusing I know, the best working JDBC drivers are probably going to
be 11. I have had good experience with the 10.2.0.4 drivers. The 11
Drivers have a few bugs, the 10.2.0.3 and 10.2.0.1 drivers have some
issues with security. Avoid the 9.2.0.* drivers and 8i drivers too
buggy.
Thanks, hope this helps.
Don
On Dec 15, 2009, at 10:26 PM, Cheong Hee (Gmail) wrote:
Hi Don
Just curious, which version of ojdbc.jar needs to be avoided. Is
odbc14.jar good for use?
Cheers
Cheong Hee
----- Original Message ----- From: "Don Lindsay" <[email protected]>
To: "Andrew Lindesay" <[email protected]>
Cc: "WebObjectsDev Development" <[email protected]>
Sent: Wednesday, December 16, 2009 8:55 AM
Subject: Re: Oracle and EOF with Timestamps
Andrew;
Your JDBC file. Where did you get it from? We need to know the
version of the file. There are 6 or 8 versions of the OJDBC5.jar
file floating around. Some work and some do not. :)
Don
On Dec 15, 2009, at 4:25 AM, Andrew Lindesay wrote:
Hello Don;
select * from v$version;
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
What version is your jdbc file?
ojdbc5 -- JDBC for 1.5
I take it you are using the thin driver and not the OCI driver
correct?
jdbc:oracle:thin:.....
cheers.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chng34%40gmail.com
This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
