It appears that the version of the DB2 JDBC driver that you are using doesn't
support the database character set encoding being used for that database. 
You should check to see if this is a known issue for the version of the driver
that you are using and if there are any work-arounds or fixpacks to address
the issue.
 
Rob

On Tue, Feb 8, 2011 at 8:06 AM, ali yilmaz <tolca104@yahoo.com> wrote:
Hi,
 I have installed Squirrel SQL Client v3.2.1 on Windows XP 32bit and Java version 1.6.0_22.
 I am trying to connect to a db2 database.
 The problem is this: I am able to connect successfully, however in the object tree I only see the TABLE, PROCEDURE, and UDT folders. I'm not able to see any of the schemas, tables, procedures, views etc. Any ideas on why this would be happening?


JDBC Driver CLASSNAME : com.ibm.db2.jcc.DB2Driver
getDatabaseProductVersion : DB2
getURL : jdbc:db2://hostname:446/BAGTDB2T
getDatabaseProductVersion :DSN08015
getDatabaseMajorVersion : 8
getDriverName : IBM DB2 JDBC Universal Driver Architecture getDriverVersion : 2.3.63
getDatabaseProductName : DB2

2011-02-03 14:53:31,044 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - failed to load table names
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.a(s.java:6337)
at com.ibm.db2.jcc.b.s.getTables(s.java:6247)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:982)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1211)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:446)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:347)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187)
at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:240)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:53:31,106 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to check allowed Schemas
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Wd(s.java:6428)
at com.ibm.db2.jcc.b.s.getSchemas(s.java:6355)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:275)
at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:622)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:126)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:161)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:154)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:591)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:412)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:351)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187)
at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:240)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:53:31,200 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.a(s.java:6129)
at com.ibm.db2.jcc.b.s.getProcedures(s.java:6056)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:754)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:597)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:412)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:351)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187)
at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:240)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:54:47,026 [Thread-4] ERROR net.sourceforge.squirrel_sql.fw.dialects.DialectFactory - Encountered unexpected exception while attempting to determine database product name/version: unsupported encoding Cp1026 for result set column
2011-02-03 14:54:47,089 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to get allowed Schemas
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Wd(s.java:6428)
at com.ibm.db2.jcc.b.s.getSchemas(s.java:6355)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:275)
at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:686)
at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:638)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadSchemas(SchemaInfo.java:647)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadSchemas(SchemaInfo.java:476)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:280)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:207)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:324)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2011-02-03 14:54:47,323 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Error occured creating data types collection
com.ibm.db2.jcc.b.SqlException: unsupported encoding Cp1026 for result set column
at com.ibm.db2.jcc.b.i.a(i.java:419)
at com.ibm.db2.jcc.a.zb.a(zb.java:2405)
at com.ibm.db2.jcc.a.db.a(db.java:3186)
at com.ibm.db2.jcc.a.db.a(db.java:1724)
at com.ibm.db2.jcc.a.db.b(db.java:1657)
at com.ibm.db2.jcc.a.db.a(db.java:1626)
at com.ibm.db2.jcc.a.db.m(db.java:440)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Zd(s.java:7605)
at com.ibm.db2.jcc.b.s.getTypeInfo(s.java:7539)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:711)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:899)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:314)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:207)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:324)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)



------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users