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

java h2 squirrel-sql
Neoasimov picture Neoasimov · Sep 11, 2014 · Viewed 8.9k times · Source

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

Colin Bell picture Colin Bell · Sep 17, 2014

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

Related questions

Spring Boot default H2 jdbc connection (and H2 console)

I am simply trying to see the H2 database content for an embedded H2 database which spring-boot creates when I don't specify anything in my application.properties and start with mvn spring:run. I can see hibernate JPA creating the …

Read More
H2 in-memory database. Table not found

I've got a H2 database with URL "jdbc:h2:test". I create a table using CREATE TABLE PERSON (ID INT PRIMARY KEY, FIRSTNAME VARCHAR(64), LASTNAME VARCHAR(64));. I then select everything from this (empty) table using SELECT * FROM PERSON. So far, …

Read More
Can I have H2 autocreate a schema in an in-memory database?

(I've already seen the H2 database In memory - Init schema via Spring/Hibernate question; it is not applicable here.) I'd like to know if there's a setting in H2 that will allow me to auto-create a schema upon connecting …

Read More