[duckman75]

I am receiving the following error when trying to connect to a DB2 database using IBMs db2jcc.jar jdbc driver:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Oct 28, 2004 16:19:21.71
!MESSAGE Unable to retrieve database metadata
!STACK 0
com.ibm.db2.jcc.c.DisconnectException: unsupported encoding for result set column
at com.ibm.db2.jcc.c.f.a(f.java:351)
at com.ibm.db2.jcc.a.bt.a(bt.java:1893)
at com.ibm.db2.jcc.a.d.a(d.java:1080)
at com.ibm.db2.jcc.a.be.a(be.java:1523)
at com.ibm.db2.jcc.a.be.l(be.java:376)
at com.ibm.db2.jcc.a.be.k(be.java:294)
at com.ibm.db2.jcc.a.be.e(be.java:89)
at com.ibm.db2.jcc.a.s.e(s.java:108)
at com.ibm.db2.jcc.a.bq.i(bq.java:143)
at com.ibm.db2.jcc.c.cf.j(cf.java:966)
at com.ibm.db2.jcc.c.cg.a(cg.java:1551)
at com.ibm.db2.jcc.c.ch.executeQuery(ch.java:124)
at com.ibm.db2.jcc.c.p.a(p.java:7296)
at com.ibm.db2.jcc.c.p.getSchemas(p.java:6206)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:242)
at com.genuitec.eclipse.sqlexplorer.plugin.wizards.ConnectionProfileWizardSchemaPage$5.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2772)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2431)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:668)
at org.eclipse.jface.window.Window.open(Window.java:648)
at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.EditConnectionProfileAction.run(Unknown Source)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:881)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:915)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:866)
at org.eclipse.jface.action.ActionContributionItem$7.handleEvent(ActionContributionItem.java:785)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2772)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2431)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1377)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1348)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:254)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:141)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:96)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:335)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.basicRun(Main.java:185)
at org.eclipse.core.launcher.Main.run(Main.java:704)
at org.eclipse.core.launcher.Main.main(Main.java:688)

[Riyad Kalla]

I am checking with our DB dev

[support-jeff]

I do not think this is the problem, but would you please turn off auto-commit and retry?

[duckman75]

I get the same error message with auto-commit turned off.

[support-jeff]

Figures. What version of DB2 and drivers are you using? I know there are problems with earlier versions of DB2, and since I do not have access to testing with DB2 yet, it is hard to diagnose problems. Also please post your Eclipse and MyEclipse install info per the posting guidelines. Thanx!

[Author]

Posts