Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Rob M. <Rob...@co...> - 2005-08-01 23:33:30
|
Rob Manning wrote: > George, > > I'm glad you found the problem. In general, Oracle says you may use a > newer driver to connect > to a older version of it's database server. I think going forward > won't work in some cases. So now we definitely know that 8i -> 10g is > a no go :) > Rob As a followup to my previous post, I found an Oracle driver compatibility FAQ which outlines the following: Which JDBC drivers support which versions of Oracle Database? * JDBC 8.1.7 drivers can talk to RDBMS o 10.1.0 o 9.2.0 o 9.0.1 o 8.1.7 o 8.1.6 o 8.1.5 o 8.0.6 o 8.0.5 o 8.0.4 o 7.3.4. * JDBC 9.0.1 drivers can talk to RDBMS o 10.1.0 o 9.2.0 o 9.0.1 o 8.1.7 o 8.1.6 o 8.1.5 o 8.0.6 o 8.0.5 o 8.0.4 o 7.3.4 * JDBC 9.2.0 drivers can talk to RDBMS o 10.1.0 o 9.2.0 o 9.0.1 o 8.1.7 * JDBC 10.1.0 drivers can talk to RDBMS o 10.1.0 o 9.2.0 o 9.0.1 o 8.1.7 * JDBC 10.2.0 drivers can talk to RDBMS o 10.2.0 o 10.1.0 o 9.2.0 o 9.0.1 o 8.1.7 Note that there is a known bug (#1725012) when using JDBC 8.1.7 thin driver to connect to a 9.0.1 RDBMS - applying the corresponding JDBC patch solves this known bug. The following versions of the Oracle JDBC drivers are no longer supported. * JDBC 7.3.4 drivers can talk to RDBMS 7.3.4. * JDBC 8.0.4 drivers can talk to RDBMS 8.0.4 and 7.3.4. * JDBC 8.0.5 drivers can talk to RDBMS 8.0.5, 8.0.4 and 7.3.4. * JDBC 8.0.6 drivers can talk to RDBMS 8.0.6, 8.0.5, 8.0.4 and 7.3.4. * JDBC 8.1.5 drivers can talk to RDBMS 8.1.5, 8.0.6, 8.0.5, 8.0.4 and 7.3.4. * JDBC 8.1.6 drivers can talk to RDBMS 8.1.6, 8.1.5, 8.0.6, 8.0.5, 8.0.4 and 7.3.4. Note: The ADT features in 8.1.5 driver and above only works for 8.1.5 database and above. A related question is about versions NOT listed here. If its not listed here, its probably not supported. You should verify with your support channel that you are still on a supported version of Oracle. For example, a lot of people have asked about 8.0.3 - support for which was discontinued long ago. People still using 8.0.3 need to contact their support channels for upgrade info (some of these upgrades are free!). How is that for a definitive answer :-) Rob CollabraSpace - Revolutionary Collaboration Visit us at http://www.collabraspace.com This message has been scanned for viruses by ClamAV v0.83 |