squirrel-sql-users

[Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[George L. <glu...@gm...>]

Hi,

I just downloaded squirrelSql and I can't connect to my oracle 10g
instance.  The faq states that it connects to oracle 8, but that's
hella old.  That can't be right.  Or maybe it is?  Can someone shed
some light?

TIA,
geo

--=20
"The wheel's spinning, but the hamster's dead"

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hi,
>
>I just downloaded squirrelSql and I can't connect to my oracle 10g
>instance.  The faq states that it connects to oracle 8, but that's
>hella old.  That can't be right.  Or maybe it is?  Can someone shed
>some light?
>  
>
I use it regularly to connect to Oracle 9i.  What happens when you 
attempt to connect?
Do you have an exception stack trace at the bottom of the log 
(Windows->View SQuirreL Logs)?

Rob Manning


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hi Rob,
>
>I get an exception trace. Not sure what is goin on though.  My oracle
>thin driver setup seems correct, my login data seems correct.  Just
>can't connect.
>
>Below is the stack trace I get (see attachment also).  Any help would
>be appreciated.
>
>thank you,
>George
>
>
>java.lang.ArrayIndexOutOfBoundsException: 7
>
>	at oracle.security.o3logon.C0.r(C0)
>
>	
>
There's some other folks having this issue, and it seems to happen in 
apps other than Squirrel. 
See:

http://groups-beta.google.com/group/weblogic.developer.interest.jdbc/browse_thread/thread/7a5425d2be6081ea/e3a9852854cc370b?lnk=st&q=ArrayIndexOutOfBoundsException+Oracle+10+oracle.security.o3logon&rnum=1&hl=en#e3a9852854cc370b

Are you positive that you have the jdbc driver that applies to your 
version of the database? (If Oracle, it's probably best to
use the one from the server - $ORACLE_HOME/jdbc/lib/classesxx.zip)

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hi Rob,
>
>Updated my thin driver for 10g and it work now! thx!
>
>george
>  
>
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


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

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

Re: [Squirrel-sql-users] does squirrel-sql connect to oracle 10g?

[Rob M. <Rob...@co...>]

George Lui wrote:

>Hey Rob,
>
>Thanks for all the extra info!  Funny how I had a 8.1.7 thin driver
>failing to connect to a 10.1.0.X.X oracle db even though the
>compatibility FAQ stated that it can! :)
>  
>
Indeed, I noticed that.  It would be nice if their driver handled newer 
version incompatibility a
little more gracefully ( like how about saying the version of the driver 
is older than what the
database server allows ). 

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83