Could not connect to SQL Database using SQuirrelSQL

Question

I encounter the following error when trying to connect to a database using SQuirreLSQL.

Error :

Unexpected Error occured attempting to open an SQL connection

Stacktrace :

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.util.concurrent.FutureTask.report(FutureTask.java:122)
    at java.util.concurrent.FutureTask.get(FutureTask.java:202)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
    ... 5 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:270)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:128)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
    ... 7 more

I also tried to check Driver Properties and the following error is displayed :

Loading JDBC driver "Microsoft MSSQL Server JDBC Driver" failed. Can not load driver properties tab.

Have you installed the MSSQL JDBC driver and made it available to SQuirrel via it's driver manager? Have you read the Introduction, Features and Screen Shots section? — MadProgrammer
– MadProgrammer, Commented Jul 21, 2014 at 5:16
I'm sorry for the late update. It turns out that I have not yet configured the driver. Issue has been resolved after I put sqljdbc4.jar in SQuirrel > Contents > Resources > Java > lib. I appreciate your reply. Thank you very much :) — ariabele
– ariabele, Commented Jul 21, 2014 at 8:59
@zhanxw, official download page is : msdn.microsoft.com/en-us/data/aa937724.aspx — ariabele
– ariabele, Commented May 7, 2015 at 3:11

ROMANIA_engineer · Accepted Answer · 2016-06-08 08:37:15Z

5

You need to copy driver into squirrel-sql/lib folder. I've had same issue with MySql driver. After copied drived into:

$HOME/squirrel-sql-3.7/lib/mysql-connector-java-3.0.17-ga-bin.jar

and restart Squirrel - there was no error anymore.

edited Jun 8, 2016 at 8:37

ROMANIA_engineer

57k30 gold badges211 silver badges207 bronze badges

answered Apr 19, 2016 at 17:45

Konki

3263 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could not connect to SQL Database using SQuirrelSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related