One Star

[resolved] Problem connecting a DB2 database

Connection failure. You must change the Database Settings.
unsupported encoding Cp037 for result set column
Upgraded to JRE 6. Not sure what else I need to do. Ensured that my nodes were cataloged and MSQuery was able to connect.
Looking for any suggestions as to what I can try next. Thanks.
update: when I remove the schema value it connects. While this helps, it still poses a problem as the tables wont import w/o schema...
in case it helps here is the error log:
!ENTRY org.talend.libraries 4 0 2009-10-06 14:35:21.571
!MESSAGE 2009-10-06 14:35:21,571 ERROR org.talend.commons.exception.ExceptionHandler - unsupported encoding Cp037 for result set column
!STACK 0
com.ibm.db2.jcc.a.SqlException: unsupported encoding Cp037 for result set column
at com.ibm.db2.jcc.a.j.a(j.java:429)
at com.ibm.db2.jcc.b.kc.a(kc.java:2366)
at com.ibm.db2.jcc.b.jb.a(jb.java:3167)
at com.ibm.db2.jcc.b.jb.a(jb.java:1720)
at com.ibm.db2.jcc.b.jb.b(jb.java:1653)
at com.ibm.db2.jcc.b.jb.a(jb.java:1618)
at com.ibm.db2.jcc.b.jb.m(jb.java:431)
at com.ibm.db2.jcc.b.jb.l(jb.java:335)
at com.ibm.db2.jcc.b.jb.e(jb.java:92)
at com.ibm.db2.jcc.b.w.e(w.java:72)
at com.ibm.db2.jcc.b.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.rf.q(rf.java:1363)
at com.ibm.db2.jcc.a.sf.d(sf.java:2350)
at com.ibm.db2.jcc.a.tf.X(tf.java:188)
at com.ibm.db2.jcc.a.t.a(t.java:7199)
at com.ibm.db2.jcc.a.t.Wd(t.java:5795)
at com.ibm.db2.jcc.a.t.getSchemas(t.java:5723)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.checkSchemaConnection(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(Unknown Source)
at org.talend.repository.ui.utils.ManagerConnection.check(Unknown Source)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.checkConnection(Unknown Source)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.access$16(Unknown Source)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$3.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.talend.repository.ui.actions.metadata.CreateConnectionAction.doRun(Unknown Source)
at org.talend.repository.ui.actions.AContextualAction$2.run(Unknown Source)
at org.talend.repository.RepositoryWorkUnit.executeRun(Unknown Source)
at org.talend.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(Unknown Source)
at org.talend.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(Unknown Source)
at org.talend.repository.ui.actions.AContextualAction.run(Unknown Source)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:583)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:500)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2198)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:493)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:488)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.talend.rcp.intro.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:382)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
!SESSION 2009-10-06 14:59:19.075 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_16
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] Problem connecting a DB2 database

Needed to change my DB type to IBM DB2 ZOS. Worked like a charm then.
1 REPLY
One Star

Re: [resolved] Problem connecting a DB2 database

Needed to change my DB type to IBM DB2 ZOS. Worked like a charm then.