Re: [Squirrel-sql-users] DB2
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Robert M. <rob...@gm...> - 2011-02-08 13:19:48
|
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 <tol...@ya...> 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |