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.DB2Driver in the db2jcc.jar) with the
following URL:
jdbc:db2://ip:port/dbname (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 ClassNotFound for COM.ibm.db2.jdbc.net.DB2Driver. 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-EventQueue-1] ERROR
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager - Unable to find
Driver Class COM.ibm.db2.jdbc.net.DB2Driver for JDCB driver IBM DB2 Net
Driver
139441 [AWT-EventQueue-1] ERROR
net.sourceforge.squirrel_sql.fw.sql.DataCache - Could not find class
COM.ibm.db2.jdbc.net.DB2Driver in neither the Java class path nor the Extra
class path of the IBM DB2 Net Driver driver definition:
java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.net.DB2Driver
java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.net.DB2Driver
***snip***
160567 [AWT-EventQueue-1] INFO
net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
load COM.ibm.db2os390.dsn.JARLoader to check if it is assignable to
java.sql.Driver. Reason: java.lang.NoClassDefFoundError:
com/ibm/jvm/classloader/Shareable
168067 [AWT-EventQueue-1] ERROR
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager - Unable to find
Driver Class COM.ibm.db2.jdbc.net.DB2Driver for JDCB driver IBM DB2 Net
Driver
191114 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SchemaInfo - Error occured
creating data types collection
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -471, SQLSTATE:
null, SQLERRMC: null
at com.ibm.db2.jcc.a.cy.d(cy.java:1259)
***snip***
191443 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SchemaInfo - failed to load
table names
com.ibm.db2.jcc.a.SqlException: DatabaseMetaData method called after
connection was closed
at com.ibm.db2.jcc.a.s.eg(s.java:8188)
at com.ibm.db2.jcc.a.s.a(s.java:6228)
at com.ibm.db2.jcc.a.s.getTables(s.java:6215)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:1056)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.loadTables(SchemaInfo.java:789)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:181)
at
net.sourceforge.squirrel_sql.client.session.Session.loadTableInfo(Session.java:642)
at
net.sourceforge.squirrel_sql.client.session.Session.access$100(Session.java:70)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:199)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
191443 [Thread-6] ERROR
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel
- Error in supportsCatalogs()
com.ibm.db2.jcc.a.SqlException: invalid operation: connection closed
at com.ibm.db2.jcc.a.o.bs(o.java:2944)
at com.ibm.db2.jcc.a.o.getMetaData(o.java:1284)
|
