[David Peterson]

If I try to use this with the database explorer w/ Sybase ASE, I get “Error displaying data” in com.genuitec.eclipse.sqlexplorer.

[Riyad Kalla]

Can you please post all the information we request in the [URL=http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-393.html]Posting Guidelines[/URL] thread at the top of this forum? That will give us some context so that we can determine if this is an installation issue, a configuration problem, or a bug. Thanks.

[Haris Peco]

hockey_dave ,

Please, add your procedure (myprocedure), if you can on forum or support@myeclipse.com ATTN snpe

Best

[David Peterson]

Version: 3.1.2
Build id: M20060118-1600

– yes

– yes, Epic Perl, azzurri clay
– 4 build, doc, junit source 3.12

– Version: 4.1.0
Build id: 20060122-4.1-GA
– java version “1.5.0_06”
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode, sharing)
– NA
– Connect to database and type in sp_help
– none

$ cat .log

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-02-17 16:39:09.638
!MESSAGE Error displaying data
!STACK 0
java.sql.SQLException: JZ0S2: Statement object has already been closed.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:565)
at com.sybase.jdbc3.jdbc.SybStatement.checkDead(SybStatement.java:2051)
at com.sybase.jdbc3.jdbc.SybStatement.getUpdateCount(SybStatement.java:9
23)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress$2.run(SqlExecP
rogress.java:228)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.ja
va:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(Mod
alContext.java:153)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:303)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDi
alog.java:447)
at com.genuitec.eclipse.sqlexplorer.actions.ExecSQLAction.run(ExecSQLAct
ion.java:68)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection
(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContri
butionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionC
ontributionItem.java:441)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.jav
a:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:10
3)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformAct
ivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:163)
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.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-02-17 16:39:09.678
!MESSAGE Could not close statement
!STACK 0
java.sql.SQLException: JZ0S2: Statement object has already been closed.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:565)
at com.sybase.jdbc3.jdbc.SybStatement.checkDead(SybStatement.java:2051)
at com.sybase.jdbc3.jdbc.SybStatement.close(SybStatement.java:487)
at com.sybase.jdbc3.jdbc.SybStatement.close(SybStatement.java:475)
at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.closeResultSet(S
qlTableModel.java:131)
at com.genuitec.eclipse.sqlexplorer.views.SQLResultsView.setData(SQLResu
ltsView.java:81)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress$1.run(SqlExecP
rogress.java:179)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.ja
va:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(Mod
alContext.java:153)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:303)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDi
alog.java:447)
at com.genuitec.eclipse.sqlexplorer.actions.ExecSQLAction.run(ExecSQLAct
ion.java:68)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection
(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContri
butionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionC
ontributionItem.java:441)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.jav
a:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:10
3)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformAct
ivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:163)
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.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-02-17 16:39:09.688
!MESSAGE Could not close statement
!STACK 0
java.sql.SQLException: JZ0S2: Statement object has already been closed.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:565)
at com.sybase.jdbc3.jdbc.SybStatement.checkDead(SybStatement.java:2051)
at com.sybase.jdbc3.jdbc.SybStatement.close(SybStatement.java:487)
at com.sybase.jdbc3.jdbc.SybStatement.close(SybStatement.java:475)
at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.closeResultSet(S
qlTableModel.java:131)
at com.genuitec.eclipse.sqlexplorer.views.SQLResultsView$4.widgetDispose
d(SQLResultsView.java:188)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:
101)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:867)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:848)
at org.eclipse.swt.widgets.Widget.releaseWidget(Widget.java:755)
at org.eclipse.swt.widgets.Control.releaseWidget(Control.java:1574)
at org.eclipse.swt.widgets.Scrollable.releaseWidget(Scrollable.java:195)

at org.eclipse.swt.widgets.Composite.releaseWidget(Composite.java:594)
at org.eclipse.swt.widgets.Table.releaseWidget(Table.java:1725)
at org.eclipse.swt.widgets.Widget.releaseResources(Widget.java:720)
at org.eclipse.swt.widgets.Composite.releaseChildren(Composite.java:588)

at org.eclipse.swt.widgets.Composite.releaseWidget(Composite.java:593)
at org.eclipse.swt.widgets.Widget.releaseResources(Widget.java:720)
at org.eclipse.swt.widgets.Composite.releaseChildren(Composite.java:588)

at org.eclipse.swt.widgets.Composite.releaseWidget(Composite.java:593)
at org.eclipse.swt.widgets.Widget.releaseResources(Widget.java:720)
at org.eclipse.swt.widgets.Composite.releaseChildren(Composite.java:588)

at org.eclipse.swt.widgets.Composite.releaseWidget(Composite.java:593)
at org.eclipse.swt.widgets.TabFolder.releaseWidget(TabFolder.java:534)
at org.eclipse.swt.widgets.Widget.dispose(Widget.java:382)
at com.genuitec.eclipse.sqlexplorer.views.SQLResultsView.setData(SQLResu
ltsView.java:85)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress$1.run(SqlExecP
rogress.java:179)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.ja
va:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(Mod
alContext.java:153)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:303)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDi
alog.java:447)
at com.genuitec.eclipse.sqlexplorer.actions.ExecSQLAction.run(ExecSQLAct
ion.java:68)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection
(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContri
butionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionC
ontributionItem.java:441)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.jav
a:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:10
3)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformAct
ivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:163)
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.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-02-17 16:43:02.600
!MESSAGE Error displaying data
!STACK 0
java.sql.SQLException: JZ0S2: Statement object has already been closed.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:565)
at com.sybase.jdbc3.jdbc.SybStatement.checkDead(SybStatement.java:2051)
at com.sybase.jdbc3.jdbc.SybStatement.getUpdateCount(SybStatement.java:9
23)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress$2.run(SqlExecP
rogress.java:228)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.ja
va:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(Mod
alContext.java:153)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:303)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDi
alog.java:447)
at com.genuitec.eclipse.sqlexplorer.actions.ExecSQLAction.run(ExecSQLAct
ion.java:68)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection
(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContri
butionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionC
ontributionItem.java:441)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.jav
a:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:10
3)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformAct
ivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:163)
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.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

*** Date: Fri Feb 17 16:50:11 EST 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_06

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.0 GA
Build id: 20060122-4.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse Platform

Version: 3.1.2
Build id: M20060118-1600

Eclipse RCP

Version: 3.1.2
Build id: M20060118-1600

Eclipse Java Development Tools

Version: 3.1.2
Build id: M20060118-1600

Eclipse Plug-in Development Environment

Version: 3.1.2
Build id: M20060118-1600

Eclipse Project SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\Program Files\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
e2c_38
-vm
C:\WINDOWS\system32\javaw.exe

SYBASE_JRE=C:\sybase\shared-1_0\JRE-1_3
SYBASE=C:\sybase
SYBASE_OCS=OCS-12_5
PATH=C:\sybase\OCS-12_5\bin;C:\sybase\OCS-12_5\dll;C:\sybase\OCS-12_5\lib3p;%PATH%
SYBASE=C:\sybase
PATH=C:\sybase/JS-12_5/bin;%PATH%
SYBASE=C:\sybase

[Haris Peco]

hockey_dave ,

There is bug in ME 4.1 and you get this error.Bug is fixed already.Bug don’t return correct valu in editor’s status bar.It isn’t sybase specific

Try execute procedure with :

execute sp_xxx

I will try enhance stored procedure handiling in future release ME 4.1

Thanks

[David Peterson]

execute sp_helptext @objname=’my_stored_proc’

does not work either. Here is .log from that.

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-02-22 15:09:37.287
!MESSAGE Error displaying data
!STACK 0
java.sql.SQLException: JZ0S2: Statement object has already been closed.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:565)
at com.sybase.jdbc3.jdbc.SybStatement.checkDead(SybStatement.java:2051)
at com.sybase.jdbc3.jdbc.SybStatement.getUpdateCount(SybStatement.java:9
23)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress$2.run(SqlExecP
rogress.java:228)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.ja
va:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(Mod
alContext.java:153)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:303)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDi
alog.java:447)
at com.genuitec.eclipse.sqlexplorer.actions.ExecSQLAction.run(ExecSQLAct
ion.java:68)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection
(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContri
butionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionC
ontributionItem.java:441)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.jav
a:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:10
3)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformAct
ivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:163)
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.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

[Haris Peco]

hockey_dave ,

Your error is because exists bug in 4.1 and it fixed for 4.1.1.
However,MyEclipse haven’t support for stored procedure, yet
You can execute procedure which return simple result (see my previous post), but you can’t see procedures in tree, execute procedures like ‘sp_help’ or your example (you can execute, but result isn’t always correct)

Please, be patient

Thanks

[Author]

Posts