|
From: Robert M. <rob...@gm...> - 2012-03-08 21:44:33
|
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 > > |
