facebook

Database Explorer Issue connecting to DB2

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #218486 Reply

    duckman75
    Member

    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)

    #218528 Reply

    Riyad Kalla
    Member

    I am checking with our DB dev

    #218551 Reply

    support-jeff
    Member

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

    #218658 Reply

    duckman75
    Member

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

    #219227 Reply

    support-jeff
    Member

    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!

Viewing 5 posts - 1 through 5 (of 5 total)
Reply To: Database Explorer Issue connecting to DB2

You must be logged in to post in the forum log in