Configure SQuirrel SQL Client to work for DB2/AS400

sql jdbc db2 squirrel-sql
serhio picture serhio · Dec 17, 2013 · Viewed 20.2k times · Source

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"

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.

Answer

Paul Bastide picture Paul Bastide · Dec 19, 2013

if it's an AS400, then you should use JTOpen libraries to connect.

http://jt400.sourceforge.net/

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 

set CLASSPATH=%CLASSPATH%;c:/jt400.jar

Related questions

How do you get values from all columns using ResultSet.getBinaryStream() in jdbc?

How do I to write an entire table to a flat file (text file) using jdbc? So far I've attempted the following: Statement statement = connection.createStatement(); ResultSet result = statement.executeQuery("SELECT * FROM tablename"); BufferedInputStream buffer; FileOutputStream out = new FileOutputStream("flatfile.…

Read More
SQL query of multi-member file on AS400

On AS400 in interactive SQL in a 5250 session, select * from myfile returns rows from one member only when myfile has more than one member. How can I get rows from a specific member? Important: in the end I'd like to …

Read More
Do a DB2 insert with a select and parameters

I want to do something like this: INSERT INTO TABLEA ( COLUMN1, COLUMN2, COLUMN 3 ) SELECT FOOBAR, DOOBAR, ? FROM TABLEB And then send this to JDBC via Spring JDBC to update... simpleJdbcTemplate.update( mySqlFromAbove, someVariableToReplaceQuestionMark ); Is this even possible? It would work …

Read More