Squirrel SQL & H2 plugin on Windows: ClassNotFoundException: org.h2.Driver

Question

I am trying to use the Squirrel SQL client to connect to a H2 server instance.

The problem I am facing is that when I hit the "connect" button of the server I want to connect to, then I am getting a:

ClassNotFoundException: org.h2.Driver

I thought it was because h2.jar was not in the classpath. Then I edited squirrel-sql.bar to try two things.

The first thing I tried is to add the JAR into the PATH like this:

SET PATH=%PATH%;C:\Program Files\squirrel-sql-3.5.3\plugins\h2.jar

Then I restarted Squirrel. Same error.

Then I tried adding:

set TMP_CP=%TMP_CP%;"C:\Program Files\squirrel-sql-3.5.3\plugins\h2.jar"

Then I restarted Squirrel. Same error.

When I look at the console, I can see that h2.jar is in the PATH and/or the SQUIRREL_CP but the same error occurs all the time.

I am wondering if I am not forgetting something bout how to install/configure SQuirrel and/or H2?

Answer 1

Rather than modifying the batch files every time you use a different driver just modify the drivers classpath through the GUI.

Double click on the appropriate driver in the Drivers tab then click on the "Extra Class Path" tab and add the driver jar.

You can find more information under "How to connect to a Database" in the SQuirreL section in the Help file. Press F1 in SQuirreL to see the Help file. You can see a screenshot at http://www.squirrelsql.org/screenshots/driver.html