squirrel-sql-users

[Squirrel-sql-users] SQuirreL-SQL and Oracle versions

[Stefan S. <st...@ph...>]

Hello,

I am able to use SQuirreL-SQL with a Oracle 8.1... JDBC driver and connect 
to an Oracle 9.2... databse.  But I also would like to connect to an 
Oracle 10.1... database. But in the Oracle world the database's and 
client's major version number can only differ by one if it should work.

Therefore I need at least an Oracle 9.2... JDBC driver. But I was not able 
to use any 9.2... or 10.1... Oracle JDBC driver with SQuirrel_SQL. Does 
naybody know what I have to do to make it work, or is this a fundamental 
problem?

Thanks
	Stefan

************* Stefan Stonjek ******** s.s...@ph... ******
* Univ. of Oxford;  Physics Dept.;   Keble Road;  Oxford; OX1 3RH;  UK *
******** phone: +44-1865-283111 ********** fax: +44-1865-273418 ********
* CERN / ATLAS ** Bat 40-3-C28 ** CH-1211 Geneve 23 ** +41-22-767-1175 *

Re: [Squirrel-sql-users] SQuirreL-SQL and Oracle versions

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

Stefan Stonjek wrote:

>Therefore I need at least an Oracle 9.2... JDBC driver. But I was not able 
>to use any 9.2... or 10.1... Oracle JDBC driver with SQuirrel_SQL. Does 
>naybody know what I have to do to make it work, or is this a fundamental 
>problem?
>  
>
Hello Stefan,

I use the Oracle 9i jdbc driver (getDriverVersion() reports 9.2.0.1.0) 
with SQuirreL every day to
connect to an Oracle 9i database.  I use the driver that came with 
Oracle 9i when I installed it.
(<ORACLE_HOME>/ora92/jdbc/lib/classes12.zip).  It works flawlessly for 
me.  When you
say you were not able to use any 9.2 Oracle jdbc driver with SQuirreL, 
could you be more
specific?  Were you getting an error message?

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] SQuirreL-SQL and Oracle versions

[Stefan S. <st...@ph...>]

Hello Rob,

thank you for the fast reply. I found that I had "classes12.jar" and 
"classes12.zip" in my CLASSPATH. Both of them from Oracle 9.2... As soon 
as I reduced it to "classes12.jar" it worked.

Then I tried the same with Oracle 10.1... JDBC drivers. In this case it 
failed an to got the attaced error message.

Thanks
	Stefan

On Thu 21-Jul-2005 07:13 -0400, Rob Manning wrote

> Stefan Stonjek wrote:
> 
> >Therefore I need at least an Oracle 9.2... JDBC driver. But I was not able 
> >to use any 9.2... or 10.1... Oracle JDBC driver with SQuirrel_SQL. Does 
> >naybody know what I have to do to make it work, or is this a fundamental 
> >problem?
> 
> I use the Oracle 9i jdbc driver (getDriverVersion() reports 9.2.0.1.0)  
> with SQuirreL every day to connect to an Oracle 9i database. I use the
> driver that came with Oracle 9i when I installed it.
> (<ORACLE_HOME>/ora92/jdbc/lib/classes12.zip).  It works flawlessly for
> me. When you say you were not able to use any 9.2 Oracle jdbc driver
> with SQuirreL, could you be more specific? Were you getting an error
> message?
 

************* Stefan Stonjek ******** s.s...@ph... ******
* Univ. of Oxford;  Physics Dept.;   Keble Road;  Oxford; OX1 3RH;  UK *
******** phone: +44-1865-283111 ********** fax: +44-1865-273418 ********
* CERN / ATLAS ** Bat 40-3-C28 ** CH-1211 Geneve 23 ** +41-22-767-1175 *

Re: [Squirrel-sql-users] SQuirreL-SQL and Oracle versions

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

Stefan Stonjek wrote:

>Hello Rob,
>
>thank you for the fast reply. I found that I had "classes12.jar" and 
>"classes12.zip" in my CLASSPATH. Both of them from Oracle 9.2... As soon 
>as I reduced it to "classes12.jar" it worked.
>
>Then I tried the same with Oracle 10.1... JDBC drivers. In this case it 
>failed an to got the attaced error message.
>  
>
java.sql.SQLException: Io exception: The Network Adapter could not 
establish the connection

usually indicates that the listener process is down or misconfigured 
(assuming network connectivity
isn't an issue).  Did you try 'lsnrctl status' on the server running 
Oracle 10g?

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] SQuirreL-SQL and Oracle versions

[Stefan S. <st...@ph...>]

Hello Rob,

network can't be the issue here. 

If I am using the Oracle 9.2... JDBC drivers everything works well. But if
I switch to Oracle 10.1... JDBC drivers I get the error. This behavior is
reproducible by switching between the different versions of
"classes12.jar". This is true for an Oracle 9.2... database.

I just found that everything works well with the 10.1... JDBC drivers if 
one connects to a 10.1... database.....

This should not happen. According to Oracle client and database can 
interact if the difference in the major release number is not bigger than 
one.

I assume that the seen problem is an Oracle problem and not a SQuirreL-SQL 
one.

Thanks
	Stefan


On Thu 21-Jul-2005 10:06 -0400, Rob Manning wrote

> Stefan Stonjek wrote:
> 
> >Hello Rob,
> >
> >thank you for the fast reply. I found that I had "classes12.jar" and 
> >"classes12.zip" in my CLASSPATH. Both of them from Oracle 9.2... As soon 
> >as I reduced it to "classes12.jar" it worked.
> >
> >Then I tried the same with Oracle 10.1... JDBC drivers. In this case it 
> >failed an to got the attaced error message.
> >  
> >
> java.sql.SQLException: Io exception: The Network Adapter could not 
> establish the connection
> 
> usually indicates that the listener process is down or misconfigured 
> (assuming network connectivity
> isn't an issue).  Did you try 'lsnrctl status' on the server running 
> Oracle 10g?
 

************* Stefan Stonjek ******** s.s...@ph... ******
* Univ. of Oxford;  Physics Dept.;   Keble Road;  Oxford; OX1 3RH;  UK *
******** phone: +44-1865-283111 ********** fax: +44-1865-273418 ********
* CERN / ATLAS ** Bat 40-3-C28 ** CH-1211 Geneve 23 ** +41-22-767-1175 *

Re: [Squirrel-sql-users] SQuirreL-SQL and Oracle versions

[Maury H. <ml1...@sh...>]

Stefan:

> If I am using the Oracle 9.2... JDBC drivers everything works well. But if
> I switch to Oracle 10.1... JDBC drivers I get the error. This behavior is
> reproducible by switching between the different versions of
> "classes12.jar". This is true for an Oracle 9.2... database.

I have been using v10 JDBC drivers with SQuirreL for some time, and connect 
to both 10g and 9i (both r1 and r2) databases with no problems.  There must 
be some problem in a configuration somewhere.

However, if you still cannot work out the problem, there is no reason why you 
cannot make a copy of the 'Oracle Thin Driver' and configure one to use the 
9i driver, and the other the 10g driver.  Then, use the appropriate one when 
creating the alias for your database.


Maury...

Re: [Squirrel-sql-users] SQuirreL-SQL and Oracle versions

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

Stefan Stonjek wrote:

>Hello Rob,
>
>network can't be the issue here. 
>
>If I am using the Oracle 9.2... JDBC drivers everything works well. But if
>I switch to Oracle 10.1... JDBC drivers I get the error. This behavior is
>reproducible by switching between the different versions of
>"classes12.jar". This is true for an Oracle 9.2... database.
>
>I just found that everything works well with the 10.1... JDBC drivers if 
>one connects to a 10.1... database.....
>
>This should not happen. According to Oracle client and database can 
>interact if the difference in the major release number is not bigger than 
>one.
>  
>
Yes, I've heard that too somewhere before.  I don't have access to a 10g 
database, or else I'd test
it myself.  Very interesting result you are seeing (10g driver can't 
talk to a 9i server).

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] SQuirreL-SQL and Oracle versions

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

Rob Manning wrote:

> Stefan Stonjek wrote:
>
>> Hello Rob,
>>
>> network can't be the issue here.
>> If I am using the Oracle 9.2... JDBC drivers everything works well. 
>> But if
>> I switch to Oracle 10.1... JDBC drivers I get the error. This 
>> behavior is
>> reproducible by switching between the different versions of
>> "classes12.jar". This is true for an Oracle 9.2... database.
>>
>> I just found that everything works well with the 10.1... JDBC drivers 
>> if one connects to a 10.1... database.....
>>
>> This should not happen. According to Oracle client and database can 
>> interact if the difference in the major release number is not bigger 
>> than one.
>>  
>>
> Yes, I've heard that too somewhere before.  I don't have access to a 
> 10g database, or else I'd test
> it myself.  Very interesting result you are seeing (10g driver can't 
> talk to a 9i server).

Actually, I just recently upgraded my JDBC driver to 10g. (There was a 
bug that I was tripping over in the
9i driver when talking to a 9i database server.)  Believe it or not, the 
10g driver works well with the 9i database.
In fact, it solved the problem I was having with the 9i driver as well.

Rob


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