facebook
  1. MyEclipse IDE
    2.  > 
  2. General Development

MyEclipse Database Explorer – Schema not expanding

  1. MyEclipse IDE
    2.  > 
  2. General Development

Tagged: 

Viewing 3 posts - 16 through 18 (of 18 total)
1 2
  • Author
    Posts
  • September 15, 2015 at 4:42 pm #452935 Reply

    Brian Fernandes
    Moderator

    Jane,

    I’m afraid we haven’t been able to make further progress on this issue since our last discussion here.

    In the log you sent earlier, we noticed some certificate issues – they were not related to the DB Explorer directly but I wonder if we’re facing the same problems internally. Does your connection URL use https:// or http://?

    For the other versions of Eclipse where this does work (same URL / same credentials) – I’m assuming it uses your system Java installation – is it possible that this Java install was configured (by your admin team perhaps) with the right certificates to make an intranet connection? MyEclipse uses an internal version of Java that we ship with, so it would not benefit from these changes, though it is possible to point MyEclipse to another version of Java if we find that this is the cause of the issue.

    Best,
    Brian.

    October 26, 2015 at 11:35 am #456033 Reply

    janeantony
    Participant

    Hey Brian,

    I’ve been trying various options for sometime and finally got an error in the DB trace log. I’m using MyEclipse 2015 Version 2, jdk 1.7.0_79 and JDBC driver version v10.5 FP5 4.19.26. I was able to connect to the DB and when I expand the schema in the DB Explorer, I get PROCEDURE, FUNCTION and TRIGGER. When I try to expand each of these three, I get nothing. But the trace log is capturing an exception with SQLCODE -204. I’m copying pasting the one I got for triggers.

    [jcc] BEGIN TRACE_DIAGNOSTICS
    [jcc][Thread:main][SQLException@56dafdcd] java.sql.SQLException
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] DB2 SQLCA from server
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] SqlCode = -204
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] SqlErrd = { -500, 0, 0, -1, 0, 0 }
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] SqlErrmc = SYSCAT.TRIGGERS
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] SqlErrmcTokens = { SYSCAT.TRIGGERS }
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] SqlErrp = DSNXOTL
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] SqlState = 42704
    [jcc][Thread:main][SQLException@56dafdcd][Sqlca@434cca47] SqlWarn =
    [jcc][Thread:main][SQLException@56dafdcd] SQL state = 42704
    [jcc][Thread:main][SQLException@56dafdcd] Error code = -204
    [jcc][Thread:main][SQLException@56dafdcd] Tokens = SYSCAT.TRIGGERS
    [jcc][Thread:main][SQLException@56dafdcd] Stack trace follows
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.TRIGGERS, DRIVER=4.19.26
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.fp.c(Unknown Source)
    at com.ibm.db2.jcc.am.fp.d(Unknown Source)
    at com.ibm.db2.jcc.am.fp.a(Unknown Source)
    at com.ibm.db2.jcc.am.gp.a(Unknown Source)
    at com.ibm.db2.jcc.am.fp.a(Unknown Source)
    at com.ibm.db2.jcc.t4.bb.h(Unknown Source)
    at com.ibm.db2.jcc.t4.bb.b(Unknown Source)
    at com.ibm.db2.jcc.t4.p.a(Unknown Source)
    at com.ibm.db2.jcc.t4.vb.i(Unknown Source)
    at com.ibm.db2.jcc.am.fp.kb(Unknown Source)
    at com.ibm.db2.jcc.am.gp.xc(Unknown Source)
    at com.ibm.db2.jcc.am.gp.b(Unknown Source)
    at com.ibm.db2.jcc.am.gp.kc(Unknown Source)
    at com.ibm.db2.jcc.am.gp.executeQuery(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.db2.model.TriggerTypeNode.loadChildren(TriggerTypeNode.java:43)
    at com.genuitec.eclipse.sqlexplorer.model.AbstractTypeNode.getChildren(AbstractTypeNode.java:39)
    at com.genuitec.eclipse.sqlexplorer.views.DatabaseContentProvider.getChildren(DatabaseContentProvider.java:71)
    at org.eclipse.jface.viewers.AbstractTreeViewer.getRawChildren(AbstractTreeViewer.java:1372)
    at org.eclipse.jface.viewers.TreeViewer.getRawChildren(TreeViewer.java:353)
    at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:905)
    at org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:617)
    at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:815)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
    at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:791)
    at org.eclipse.jface.viewers.TreeViewer.createChildren(TreeViewer.java:611)
    at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:762)
    at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:1495)
    at org.eclipse.jface.viewers.TreeViewer.handleTreeExpand(TreeViewer.java:903)
    at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:1507)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:132)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1085)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1070)
    at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:7633)
    at org.eclipse.swt.widgets.Control.wmNotify(Control.java:5618)
    at org.eclipse.swt.widgets.Composite.wmNotify(Composite.java:1935)
    at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:5169)
    at org.eclipse.swt.widgets.Control.windowProc(Control.java:4666)
    at org.eclipse.swt.widgets.Display.windowProc(Display.java:5023)
    at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)
    at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:2443)
    at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:1553)
    at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:6501)
    at org.eclipse.swt.widgets.Control.windowProc(Control.java:4646)
    at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:6024)
    at org.eclipse.swt.widgets.Display.windowProc(Display.java:5023)
    at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
    at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
    at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
    at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.genuitec.pulse.eclipse.launcher.Main.main(Main.java:110)
    [jcc] END TRACE_DIAGNOSTICS
    [jcc][ResultSetMetaData@66741dd5] BEGIN TRACE_RESULT_SET_META_DATA
    [jcc][ResultSetMetaData@66741dd5] Result set meta data for statement Statement@2686b8fd
    [jcc][ResultSetMetaData@66741dd5] Number of result set columns: 0
    isDescribed=true[jcc][ResultSetMetaData@66741dd5]{ sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=null, sqldSchema=null }
    [jcc][ResultSetMetaData@66741dd5] END TRACE_RESULT_SET_META_DATA
    [jcc] BEGIN TRACE_DIAGNOSTICS
    [jcc][Thread:main][SQLException@5152bf7f] java.sql.SQLException
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] DB2 SQLCA from server
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] SqlCode = -516
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] SqlErrd = { -335, 0, 0, -1, 0, 0 }
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] SqlErrmc = null
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] SqlErrmcTokens = {}
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] SqlErrp = DSNXERT2
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] SqlState = 26501
    [jcc][Thread:main][SQLException@5152bf7f][Sqlca@f9a548f] SqlWarn =
    [jcc][Thread:main][SQLException@5152bf7f] SQL state = 26501
    [jcc][Thread:main][SQLException@5152bf7f] Error code = -516
    [jcc][Thread:main][SQLException@5152bf7f] Tokens = null
    [jcc][Thread:main][SQLException@5152bf7f] Stack trace follows
    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-516, SQLSTATE=26501, SQLERRMC=null, DRIVER=4.19.26
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.fp.c(Unknown Source)
    at com.ibm.db2.jcc.am.fp.d(Unknown Source)
    at com.ibm.db2.jcc.am.gp.a(Unknown Source)
    at com.ibm.db2.jcc.t4.bb.a(Unknown Source)
    at com.ibm.db2.jcc.t4.bb.b(Unknown Source)
    at com.ibm.db2.jcc.t4.p.b(Unknown Source)
    at com.ibm.db2.jcc.t4.wb.c(Unknown Source)
    at com.ibm.db2.jcc.am.gp.uc(Unknown Source)
    at com.ibm.db2.jcc.am.gp.xc(Unknown Source)
    at com.ibm.db2.jcc.am.gp.b(Unknown Source)
    at com.ibm.db2.jcc.am.gp.kc(Unknown Source)
    at com.ibm.db2.jcc.am.gp.executeQuery(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.db2.model.TriggerTypeNode.loadChildren(TriggerTypeNode.java:43)
    at com.genuitec.eclipse.sqlexplorer.model.AbstractTypeNode.getChildren(AbstractTypeNode.java:39)
    at com.genuitec.eclipse.sqlexplorer.views.DatabaseContentProvider.getChildren(DatabaseContentProvider.java:71)
    at org.eclipse.jface.viewers.AbstractTreeViewer.getRawChildren(AbstractTreeViewer.java:1372)
    at org.eclipse.jface.viewers.TreeViewer.getRawChildren(TreeViewer.java:353)
    at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:905)
    at org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:617)
    at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:815)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
    at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:791)
    at org.eclipse.jface.viewers.TreeViewer.createChildren(TreeViewer.java:611)
    at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:762)
    at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:1495)
    at org.eclipse.jface.viewers.TreeViewer.handleTreeExpand(TreeViewer.java:903)
    at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:1507)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:132)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1085)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1070)
    at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:7633)
    at org.eclipse.swt.widgets.Control.wmNotify(Control.java:5618)
    at org.eclipse.swt.widgets.Composite.wmNotify(Composite.java:1935)
    at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:5169)
    at org.eclipse.swt.widgets.Control.windowProc(Control.java:4666)
    at org.eclipse.swt.widgets.Display.windowProc(Display.java:5023)
    at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)
    at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:2443)
    at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:1553)
    at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:6501)
    at org.eclipse.swt.widgets.Control.windowProc(Control.java:4646)
    at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:6024)
    at org.eclipse.swt.widgets.Display.windowProc(Display.java:5023)
    at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
    at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
    at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
    at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.genuitec.pulse.eclipse.launcher.Main.main(Main.java:110)
    [jcc] END TRACE_DIAGNOSTICS
    [jcc] BEGIN TRACE_DIAGNOSTICS
    [jcc][Thread:main][SQLException@5d258049] java.sql.SQLException
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] DB2 SQLCA from server
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] SqlCode = -514
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] SqlErrd = { -304, 0, 0, -1, 0, 0 }
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] SqlErrmc = SQL_CURLH200C1
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] SqlErrmcTokens = { SQL_CURLH200C1 }
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] SqlErrp = DSNXERT2
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] SqlState = 26501
    [jcc][Thread:main][SQLException@5d258049][Sqlca@49096865] SqlWarn =
    [jcc][Thread:main][SQLException@5d258049] SQL state = 26501
    [jcc][Thread:main][SQLException@5d258049] Error code = -514
    [jcc][Thread:main][SQLException@5d258049] Tokens = SQL_CURLH200C1
    [jcc][Thread:main][SQLException@5d258049] Stack trace follows
    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=4.19.26
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    at com.ibm.db2.jcc.am.fp.c(Unknown Source)
    at com.ibm.db2.jcc.am.fp.a(Unknown Source)
    at com.ibm.db2.jcc.t4.bb.o(Unknown Source)
    at com.ibm.db2.jcc.t4.bb.j(Unknown Source)
    at com.ibm.db2.jcc.t4.bb.d(Unknown Source)
    at com.ibm.db2.jcc.t4.p.c(Unknown Source)
    at com.ibm.db2.jcc.t4.vb.j(Unknown Source)
    at com.ibm.db2.jcc.am.fp.mb(Unknown Source)
    at com.ibm.db2.jcc.am.gp.b(Unknown Source)
    at com.ibm.db2.jcc.am.gp.kc(Unknown Source)
    at com.ibm.db2.jcc.am.gp.executeQuery(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.db2.model.TriggerTypeNode.loadChildren(TriggerTypeNode.java:43)
    at com.genuitec.eclipse.sqlexplorer.model.AbstractTypeNode.getChildren(AbstractTypeNode.java:39)
    at com.genuitec.eclipse.sqlexplorer.views.DatabaseContentProvider.getChildren(DatabaseContentProvider.java:71)
    at org.eclipse.jface.viewers.AbstractTreeViewer.getRawChildren(AbstractTreeViewer.java:1372)
    at org.eclipse.jface.viewers.TreeViewer.getRawChildren(TreeViewer.java:353)
    at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:905)
    at org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:617)
    at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:815)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
    at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:791)
    at org.eclipse.jface.viewers.TreeViewer.createChildren(TreeViewer.java:611)
    at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:762)
    at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:1495)
    at org.eclipse.jface.viewers.TreeViewer.handleTreeExpand(TreeViewer.java:903)
    at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:1507)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:132)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1085)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1070)
    at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:7633)
    at org.eclipse.swt.widgets.Control.wmNotify(Control.java:5618)
    at org.eclipse.swt.widgets.Composite.wmNotify(Composite.java:1935)
    at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:5169)
    at org.eclipse.swt.widgets.Control.windowProc(Control.java:4666)
    at org.eclipse.swt.widgets.Display.windowProc(Display.java:5023)
    at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)
    at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:2443)
    at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:1553)
    at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:6501)
    at org.eclipse.swt.widgets.Control.windowProc(Control.java:4646)
    at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:6024)
    at org.eclipse.swt.widgets.Display.windowProc(Display.java:5023)
    at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
    at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
    at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
    at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.genuitec.pulse.eclipse.launcher.Main.main(Main.java:110)
    [jcc] END TRACE_DIAGNOSTICS

    When I checked with my DB2 DBA team, they say that for DB2 z/OS we use SYSIBM.SYSTRIGGERS to access the triggers instead of SYSCAT.TRIGGERS. And when I try this query in my SQL editor, I get the same -204.

    SELECT TRIGNAME FROM SYSCAT.TRIGGERS WHERE TRIGSCHEMA = ? ORDER BY TRIGNAME

    Thanks,
    Jane

    October 28, 2015 at 4:28 am #456275 Reply

    support-tony
    Keymaster

    Jane,

    Sorry about the delay. Thanks for the extra detail; it will surely help us to track this down. However, it’s impossible to say, at this stage, how long this will take to fix, but we’ll keep you informed.

    In the meantime, you’ve stated that you don’t see the problem with eclipse. Can you please confirm that you used the DTP (Data Tools Platform) plug-in to try with eclipse and also please mention the version.

    Apologies for the inconvenience.

  • Author
    Posts
Viewing 3 posts - 16 through 18 (of 18 total)
1 2
Reply To: MyEclipse Database Explorer – Schema not expanding

This topic is marked as closed to new replies, however your posting capabilities still allow you to do so.

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