Re: Error in Squirrel when connecting to Database

This now is a problem with your DB connection:
In your driver window open your driver definition and look at the "Extra Class 
Path" tab. You must add the path to your driver jar here. When done the driver 
definition should be marked with a blue hook in the drivers window.

Finally in your Alias definition make sure the right driver definition is used.


Gerd

JJeff wrote:
> After trying to install 2.51, I get this error when connecting to the
> database:
> 
> Unexpected Error occured attempting to open an SQL connection.
> 
> java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
>       at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
>       at java.security.AccessController.doPrivileged(Native Method)
>       at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
>       at
> net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:164)
>       at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>       at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
>       at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
>       at java.lang.Class.forName0(Native Method)
>       at java.lang.Class.forName(Class.java:247)
>       at
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:128)
>       at
> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
>       at
> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:283)
>       at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>       at java.lang.Thread.run(Thread.java:619)
> 
> So, I was thinking it's something wrong on my side since the installation
> should be working for most other people. Is it some Windows Setting issue?
> Am using it on WinXP.
> 
> Thanks
> 
> Jeff
> 
> 
> JJeff wrote:
>> Thanks for your quick response, I have tried to re-install SQuirrel many
>> time.
>>
>> I forgot to state that I am using version 2.2 Final. I tried to uninstall
>> and reinstall 2.51, but the problem seemed get worse and I couldn't even
>> log in to any of my databases, hitting errors about user name and pasword
>> not matching even though SQLPlus had no problems with the username and
>> password.
>>
>> I since reverted back to ver 2.2 and trying to find a solution to the
>> problem.  I will try again with the re-installation, but I am hoping for
>> another solution.
>>
>> Thanks.
>>
>>
>>
>> Gerd Wagner wrote:
>>> This looks much like a installation problem. It's pretty sure that it
>>> doesn't 
>>> have anything to do with your DB connection.
>>>
>>> I'd simply try to reinstall SQuirreL.
>>>
>>> Gerd
>>>
>>>
>>
> 


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/