|
From: Robert M. <rob...@gm...> - 2006-07-08 11:47:42
|
On 7/7/06, Karr, David <dav...@wa...> wrote: > I had SQuirreL 2.1 installed, and I installed 2.2 over it. I entered a > new alias for an Oracle thin connection, but it fails with "The Network > Adapter could not establish the connection" when I try to connect. > Another person at another location in my company uses Squirrel (not sure > which version) to connect to the same db, with no trouble. I looked at > the driver properties, and the driver class name wasn't quite what I > expected, so I changed it to what I expected (oracle.jdbc.OracleDriver), > but it made no difference. I then wrote a trivial build.xml that uses > the same connection info (and classpath to the driver) and just tries to > list the available tables, and it works perfectly fine. > > What could be going wrong here? Have a look at the attached java code that Gerd Wagner created to simlate the way that SQuirreL obtains connections. It's a simple command-line program that expects four arguments (driverclass, url, user ,password). It's about as simple as it can be and might be useful in demonstrating issues with the driver or connection properties outside of SQuirreL. Rob |
