Squirrel not loading drivers in Ubuntu Hardy

View: New views

2 Messages — Rating Filter: Alert me

Squirrel not loading drivers in Ubuntu Hardy

by John Beaumont :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

Have just downloaded and installed the latest version from your website.
I accepted the default path "/usr/local/SQuirreL SQL Client" ticked all
the various driver plugins along the way and everything seem to go fine.

However when I start the program all the drivers in the list except the
JDBC:ODBC bridge show up as red circles with white crosses. Trying to
use any driver produces an error:

java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver
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:168)
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:279)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:619)

What could be wrong? I feel I'm missing something really obvious. I
tried a reinstall and running the program as root so far.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: Squirrel not loading drivers in Ubuntu Hardy

by manningr :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

The installer doesn't contain any JDBC drivers. The database-specific plugins that are available in the installer extend SQuirreL to use database-specific queries to show things like SQL source for various objects, etc. You will need to download the JDBC driver that matches the version of SQLServer that you are using. You can place it in the SQUIRREL_HOME/lib directory and restart SQuirreL, then attempt to connect again.

Rob

On Thu, May 22, 2008 at 4:59 PM, John Beaumont <john@...> wrote:

Hi,

Have just downloaded and installed the latest version from your website.
I accepted the default path "/usr/local/SQuirreL SQL Client" ticked all
the various driver plugins along the way and everything seem to go fine.

However when I start the program all the drivers in the list except the
JDBC:ODBC bridge show up as red circles with white crosses. Trying to
use any driver produces an error:

java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver
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:168)
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:279)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:619)

What could be wrong? I feel I'm missing something really obvious. I
tried a reinstall and running the program as root so far.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users