|
From: Jim It <ji...@ho...> - 2012-03-09 01:21:44
|
Matt, What driver are you using? You should be using either the jt400.jar included with IBM Client Access install or from the jt400.jar from JTOpen. http://jt400.sourceforge.net/ Jim Date: Thu, 8 Mar 2012 16:44:24 -0500 From: rob...@gm... To: dic...@uk... CC: squ...@li... Subject: Re: [Squirrel-sql-users] Code page problem with SQL Squirrel ? Any app that tries to use that DB2 driver to inspect the procedures in your database is going to run into that issue. It's not just SQuirreL, judging by the stack trace. You should see if there is a fixpack that has an update for your driver, or file a support request with IBM. Rob On Wed, Mar 7, 2012 at 9:44 AM, Dickinson, Matthew <dic...@uk...> wrote: Hi Hopefully someone can help me. I have been using SQL squirrel to access a DB2 database on a AS400. I have been successfully accessing my database until recently when I have started getting the following error 2012-03-07 13:07:03,216 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures com.ibm.db2.jcc.am.SqlDataException: [jcc][t4][10275][10041][3.61.65] Unsupported ccsid, encoding, or locale: "Cp858". ERRORCODE=-4220, SQLSTATE=22021 at com.ibm.db2.jcc.am.ed.a(ed.java:668) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:85) at com.ibm.db2.jcc.am.o.a(o.java:432) at com.ibm.db2.jcc.t4.cc.a(cc.java:2349) at com.ibm.db2.jcc.t4.cb.a(cb.java:3407) at com.ibm.db2.jcc.t4.cb.a(cb.java:1982) at com.ibm.db2.jcc.t4.cb.b(cb.java:1919) at com.ibm.db2.jcc.t4.cb.a(cb.java:1887) at com.ibm.db2.jcc.t4.cb.l(cb.java:574) at com.ibm.db2.jcc.t4.cb.k(cb.java:348) at com.ibm.db2.jcc.t4.cb.e(cb.java:97) at com.ibm.db2.jcc.t4.q.e(q.java:81) at com.ibm.db2.jcc.t4.rb.k(rb.java:160) at com.ibm.db2.jcc.am.gn.jb(gn.java:2188) at com.ibm.db2.jcc.am.hn.b(hn.java:3917) at com.ibm.db2.jcc.am.in.dc(in.java:144) at com.ibm.db2.jcc.am.jc.a(jc.java:7799) at com.ibm.db2.jcc.am.jc.a(jc.java:6091) at com.ibm.db2.jcc.am.jc.a(jc.java:6018) at com.ibm.db2.jcc.am.jc.getProcedures(jc.java:6008) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:755) 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:241) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Unknown Source) Caused by: java.io.UnsupportedEncodingException: Cp858 at sun.io.Converters.getConverterClass(Unknown Source) at sun.io.Converters.newConverter(Unknown Source) at sun.io.ByteToCharConverter.getConverter(Unknown Source) at com.ibm.db2.jcc.am.u.<init>(u.java:10) at com.ibm.db2.jcc.am.s.a(s.java:10) at com.ibm.db2.jcc.am.o.a(o.java:428) ... 25 more Any tips/ suggestions ? Matt This message was created by: MATT DICKINSON – Senior Consultant - UK Technology Centre Innovation Group Tel: +44 (0) 1489 898370 I Fax: +44 (0) 1489 579181 I Mob: +44 (0) 7818 032113 I E-mail: dic...@uk... I Web: www.uk.innovation-group.com ________________________________________________________________________ Any opinions expressed in this email are those of the individual and not necessarily the company. The contents of this email and any attachments are confidential to The Innovation Group PLC and are solely for use by the intended recipient at the email address to which it has been addressed. This email and any attachments may not be disclosed to or used by anyone other than the intended recipient, nor may it be copied in any way. If you have received this email in error, please forward a copy of this email to its...@uk... and then delete it from your system. The Innovation Group PLC: Registered in England 3256771 Registered Office: Yarmouth House 1300 Parkway Solent Business Park Whiteley Hampshire PO15 7AE UK http://www.innovation-group.com This email and any attachments has been swept for computer viruses. Neither The Innovation Group PLC nor the sender accept any responsibility for computer viruses once this email has been transmitted. ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
