[scentille]

After executing HQL and generating a Query Result, I am clicking on the result object but the properties of the object are NOT visible in the “Properties” panel. How do you view the properties of a HQL Query Result object?

Thanks in advance,

Scott

[Brian Fernandes]

Scott,

What version of MyEclipse are you using?

What does your query look like – usually the properties view will work only if you have POJOs as part of the query results.
e.g. “select id, name from MyTable” will return the id and the name directly in your results view, so the properties view will not show you additional information.
However, “from MyTable” will return all the MyTable objects and the properties view will show you additional data on selection.

Hope this helps,
Brian.

[scentille]

Hi Brian,

MyEclipse Version: 5.0.1
Build id: 20060810-5.0.1-GA

It looks like there is a problem when viewing the properties for a joined table result because when executing the following example:

from MyTable01 t01
inner join t01.MyTable02 as t02
where id = 1

A valid Hibernate Query Result row object was returned but the properties are not available.

Also, I tested your “from MyTable” and it worked fine.

Any ideas?

Thanks,

Scott

[Brian Fernandes]

Scott,

Thank you for the detailed response. I will use your query to replicate this internally.

What happens when you click the result, does the Property view just remain blank – or iss an exception logged (you should see this in the Error Log view)?

Best,
Brian.

[scentille]

Brian,

When clicking on the result, the Property view remains blank. However, it did generate the following Runtime Exception:

java.lang.RuntimeException: WARNING: Prevented recursive attempt to activate part org.eclipse.ui.views.PropertySheet while still in the middle of activating part com.genuitec.org.hibernate.eclipse.console.views.QueryPageTabView
at org.eclipse.ui.internal.WorkbenchPage.setActivePart(WorkbenchPage.java:3140)
at org.eclipse.ui.internal.WorkbenchPage.requestActivation(WorkbenchPage.java:2743)
at org.eclipse.ui.internal.PartPane.requestActivation(PartPane.java:256)
at org.eclipse.ui.internal.PartPane.handleEvent(PartPane.java:220)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:952)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:933)
at org.eclipse.swt.widgets.Shell.setActiveControl(Shell.java:1199)
at org.eclipse.swt.widgets.Control.sendFocusEvent(Control.java:1984)
at org.eclipse.swt.widgets.Widget.wmSetFocus(Widget.java:2145)
at org.eclipse.swt.widgets.Control.WM_SETFOCUS(Control.java:3860)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3312)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.ShowWindow(Native Method)
at org.eclipse.swt.widgets.Tree.showWidget(Tree.java:4448)
at org.eclipse.swt.widgets.Control.setVisible(Control.java:2672)
at org.eclipse.ui.part.PageBook.showPage(PageBook.java:113)
at org.eclipse.ui.part.PageBookView.showPageRec(PageBookView.java:966)
at org.eclipse.ui.part.PageBookView.partActivated(PageBookView.java:748)
at org.eclipse.ui.views.properties.PropertySheet.partActivated(PropertySheet.java:192)
at org.eclipse.ui.internal.PartListenerList$1.run(PartListenerList.java:72)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:843)
at org.eclipse.ui.internal.PartListenerList.fireEvent(PartListenerList.java:57)
at org.eclipse.ui.internal.PartListenerList.firePartActivated(PartListenerList.java:70)
at org.eclipse.ui.internal.PartService.firePartActivated(PartService.java:73)
at org.eclipse.ui.internal.PartService.setActivePart(PartService.java:171)
at org.eclipse.ui.internal.WorkbenchPagePartList.fireActivePartChanged(WorkbenchPagePartList.java:56)
at org.eclipse.ui.internal.PartList.setActivePart(PartList.java:126)
at org.eclipse.ui.internal.WorkbenchPage.setActivePart(WorkbenchPage.java:3190)
at org.eclipse.ui.internal.WorkbenchPage.requestActivation(WorkbenchPage.java:2743)
at org.eclipse.ui.internal.PartPane.requestActivation(PartPane.java:256)
at org.eclipse.ui.internal.PartPane.handleEvent(PartPane.java:220)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:952)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:933)
at org.eclipse.swt.widgets.Shell.setActiveControl(Shell.java:1199)
at org.eclipse.swt.widgets.Shell.WM_MOUSEACTIVATE(Shell.java:1878)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3287)
at org.eclipse.swt.widgets.Decorations.windowProc(Decorations.java:1539)
at org.eclipse.swt.widgets.Shell.windowProc(Shell.java:1634)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.DefWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.DefWindowProc(OS.java:1918)
at org.eclipse.swt.widgets.Scrollable.callWindowProc(Scrollable.java:77)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3334)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.DefWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.DefWindowProc(OS.java:1918)
at org.eclipse.swt.widgets.Scrollable.callWindowProc(Scrollable.java:77)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3334)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.DefWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.DefWindowProc(OS.java:1918)
at org.eclipse.swt.widgets.Scrollable.callWindowProc(Scrollable.java:77)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3334)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.DefWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.DefWindowProc(OS.java:1918)
at org.eclipse.swt.widgets.Scrollable.callWindowProc(Scrollable.java:77)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3334)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1842)
at org.eclipse.swt.widgets.TabFolder.callWindowProc(TabFolder.java:158)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3334)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.DefWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.DefWindowProc(OS.java:1918)
at org.eclipse.swt.widgets.Scrollable.callWindowProc(Scrollable.java:77)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3334)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1842)
at org.eclipse.swt.widgets.Table.callWindowProc(Table.java:258)
at org.eclipse.swt.widgets.Table.callWindowProc(Table.java:183)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3334)
at org.eclipse.swt.widgets.Table.windowProc(Table.java:4491)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4025)
at org.eclipse.swt.internal.win32.OS.PeekMessageW(Native Method)
at org.eclipse.swt.internal.win32.OS.PeekMessage(OS.java:2387)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2963)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
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:336)
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)

Hope this helps!

Scott

[scentille]

Brian,

Have you made any progress yet in this issue? Still getting the same problem that the properties in the Hibernate Query Result are not available when joining files. Is there a fix for this?

Thanks,

Scott

[Brian Fernandes]

Scott,

Sorry for the delayed response. This issue hasn’t been fixed yet, but it has been filed and will hopefully be fixed in our upcoming maintanence release – ME 5.0.3.

I apologize for the inconvenience unti then,
Best regards,
Brian.

[Haris Peco]

Scott,

You can try next queries :

select t01
from MyTable01 t01
inner join t01.MyTable02 as t02
where id = 1

or

select t02
from MyTable01 t01
inner join t01.MyTable02 as t02
where id = 1

Best
Peco

[alf-kenneth]

Im having the same problem as described in this thread – that I cannot see the properties from the result object. Even the results from a simple HQL such as “from PersonDO” does not show the properties of my PersonDO object.

Is this still a bug, or is there a workaround.

brgds
-aka

[alf-kenneth]

@alf-kenneth wrote:

Im having the same problem as described in this thread – that I cannot see the properties from the result object. Even the results from a simple HQL such as “from PersonDO” does not show the properties of my PersonDO object.

Is this still a bug, or is there a workaround.

brgds
-aka

I forgot to mention that Im experiencing this problem with version 6.0.0 M1, build: 20070629-6.0.0-M1.

brgds
-aka

[Author]

Posts