SQuirreL SQL is an open-source Java SQL Client program for any JDBC. DMOZ Java and. Download the file squirrel-sql--install.jar and execute it. Download the install JAR from. When you start up SQuirreL SQL Client, you'll see a Drivers window that. Name the alias 'DB2 Squirrel DB.
How to configure SQuirreL for DB2 access.
In SQuirreL I do see two DB2 drivers. But they are both marked with an red X.
I checked with Start Page but did not find an easy solution :/
Thorsten NiehuesThorsten Niehues1 Answer
- Download the DB2 Driver from the IBM Website and extract the ZIP archive.
Optionally you may want to copy it from the DB2 Server installation path:/opt/ibm/db2/V11.1/java/db2jcc4.jar
- Use
db2jcc4.jar
and copy it into the squirrel folder e.g.plugins/db2
- In der Driver in the tab 'Extra Class Path' add the db2jcc4.jar file
- Change the class name to
com.ibm.db2.jcc.DB2Driver
Not the answer you're looking for? Browse other questions tagged db2squirrel-sql or ask your own question.
I use the ancient System i Navigator (french) to get to query a DB2 (AS/400) database.
I liked to update the client and use a more fresh (and English) sql client for that database.
So, I installed the SQuirrel SQL client (3.5.0, the latest at day).
After the installation and launching, I discovered that the 'IBM DB2 App Driver' is not 'checked'.The message when I click on it says:
'Could not find class COM.ibm.db2.jdbc.app.DB2Driver in neither the Java class path nor the Extra class path of the IBM DB2 App Driver driver definition: java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver'
Db2 Driver Download
As I understood I need to copy a (universal?) JDBC driver in the SQuirrel 'lib' folder. How to get it?
I don't have any 'classpath' defined in the environmental variables (I am on Windows 7 x64). I am not a Java developer, so I am not sure if I need or not to configure that classpath to make work that sql client.
serhioserhio2 Answers
if it's an AS400, then you should use JTOpen libraries to connect.
JT400 has the JARS you need to use. Note, the class name mentioned above is not the same as what is expected on the AS400....
I remember it being something like this....
com.ibm.as400.access.AS400JDBCDriver...
you'll want to double check
if you start squirrel-sql
on the commandline you can add this
Squirrel Db2 Setup
Db2 Driver For Squirrel
Db2 Drivers For Windows
If want a really quick and easy 'command-line' JDBC client, you can use the one included in the JTOpen. I use it all the time so I don't have to open yet another window.
Here is an example.