Hello all, I'm trying to use Squirrel to connect to a db2 db running on z/ OS. I'm using the type4 driver (com.ibm.db2.jcc. DB2 Driver in the db2jcc.jar) with the following URL: jdbc: (actual values not displayed) When I test the connection, I get connection successful, but when I try to connect I get an error -99999 that the connection is closed. Looking at the squirrel log (attached below it looks like I get an error message for Class Not Found for COM.ibm.db2.jdbc.net. DB2 Driver. This is odd as I'm not trying to use this class. Also, squirrel tries to execute some null procedures and gets a -471 error back from db2. Finally the connection closes (don't know why). I've checked out the db2 side and it looks fine, this user can connect and the db2 says there are no error messages in the db2 log. It seems like even though I specify the type4 squirrel is trying to use the type3 or 2 drivers. I'm able to use this driver from another machine and squirrel works fine. Any ideas? Thanks, BAL (not the full amount as was too much for hotmail to process 139426 [ AWT- Event Queue-1] ERROR net.sourceforge.squirrel_sql.fw.sql. SQLDriver Manager - Unable to find Driver Class COM.ibm.db2.jdbc.net. DB2 Driver for JDCB driver IBM DB2 Net Driver 139441 [ AWT- Event Queue-1] ERROR net.sourceforge.squirrel_sql.fw.sql. Data Cache - Could not find class COM.ibm.db2.jdbc.net. DB2 Driver in neither the Java class path nor the Extra class path of the IBM DB2 Net Driver driver definition: java.lang. Class Not Found Exception: COM.ibm.db2.jdbc.net. DB2 Driver java.lang. Class Not Found Exception: COM.ibm.db2.jdbc.net. DB2 Driver *snip [ AWT- Event Queue-1] INFO net.sourceforge.squirrel_sql.client.gui.db. Driver Internal Frame - Failed to load COM.ibm.db2os390.dsn. JARLoader to check if it is assignable to java.sql. Driver. Reason: java.lang. No Class Def Found Error: com/ibm/jvm/classloader/ Shareable.
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 (, 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. DB2 Driver in neither the Java class path nor the Extra class path of the IBM DB2 App Driver driver definition: java.lang. Class Not Found Exception: COM.ibm.db2.jdbc.app. DB2 Driver 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.
Download Now