Re: [Squirrel-sql-users] Help diagnose why SQuirreL fails to connect to Oracle
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Karr, D. <dav...@wa...> - 2006-07-09 17:54:35
|
> -----Original Message----- > From: Robert Manning [mailto:rob...@gm...]=20 >=20 > On 7/8/06, Karr, David <dav...@wa...> wrote: > > > -----Original Message----- > > When I installed 2.2, my Oracle Thin driver was set up with=20 > the "Extra=20 > > Classpath" pointing to the jar file containing the class. I'm=20 > > guessing the driver data is stored in the registry, because I tried=20 > > completely removing the 2.1 directory before installing 2.2, and it=20 > > still had the same values (my aliases were still there too). >=20 > A "registry" of sorts, indeed. Not the windows registry, but=20 > some xml files under <user.home>/.squirrel-sql/ You could=20 > remove those but you would lose a bunch of custom settings. >=20 > > I just tried changing my driver definition to remove the "Extra=20 > > Classpath" entry containing the jar file, and I copied that=20 > jar file=20 > > into the "lib" subdir of SQuirreL, and then I restarted=20 > Squirrel. I=20 > > know it noticed the difference, because before that, the=20 > "Oracle OCI" > > driver didn't have a checkmark, and now it does. Unfortunately, my=20 > > connection with the Oracle Thin driver still fails. >=20 > We usually recommend using the "Extra Path" instead of=20 > tossing them in the lib directory. There are some=20 > performance and upgrade drawbacks to storing them in "lib". Ok, I went back to the old setup, with the "ojdbc14.jar" removed from the "lib" dir, and added it back to the "Extra ..." list, pointing to its original location (in the WebLogic81 distribution). > Can you connect with the test utility after your attempt to=20 > connect with SQuirreL fails? (I'm shootin' in the dark here -=20 > but sometimes my listener goes deaf and I have to restart it=20 > on WinXP with Oracle 9i) I've gone back and forth between them many times. The command-line always works, SQuirreL always fails. I even tried changing one of the command-line parameters once to verify it would fail. Is there a log file that would help? Is there some debugging I can turn on that would give us more info? |