|
From: Stefan S. <st...@ph...> - 2005-07-21 14:28:53
|
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 * |
