|
Greetings,
I am trying to get the following query to run through eclipse hibernate console:
"from rwe.trading.jboss.plugins.ds.adso.entities.AttributesView p
where p.id.atrGrpId = 43"
If I run the generated sql in Toad, it returns 13 rows as expected.
this is the ddl for the view being queried:
CREATE OR REPLACE VIEW ATTRIBUTES_VIEW
(ATR_ID, ATR_GRP_ID, ATR_PER_START_DATE, ATR_PER_END_DATE, ATR_VGA_VAT_PET_ID,
ATR_VGA_VAT_ATT_ID, ATR_VGA_VAT_UNT_ID, ATR_ORG_ID, ATR_VGA_VAT_ORT_ID, ATR_VGA_VGT_GRT_ID,
ATR_VGA_VGT_ORT_ID, ATR_VGA_VGT_PET_ID, ATR_VGA_VGT_INT_ID, ATR_VGA_DAT_ID, ATR_ORDER,
ATR_VALUE, ATR_TEXT, ATR_DATE, ATR_BLOB, JN_USER,
JN_DATE_TIME, ATT_DESCRIPTION, RLA_ACCESS)
AS
SELECT ATR.ROWID,
ATR.ATR_GRP_ID ATR_GRP_ID,
ATR.ATR_PER_START_DATE ATR_PER_START_DATE,
ATR.ATR_PER_END_DATE ATR_PER_END_DATE,
ATR.ATR_VGA_VAT_PET_ID ATR_VGA_VAT_PET_ID,
ATR.ATR_VGA_VAT_ATT_ID ATR_VGA_VAT_ATT_ID,
ATR.ATR_VGA_VAT_UNT_ID ATR_VGA_VAT_UNT_ID,
ATR.ATR_ORG_ID ATR_ORG_ID,
ATR.ATR_VGA_VAT_ORT_ID ATR_VGA_VAT_ORT_ID,
ATR.ATR_VGA_VGT_GRT_ID ATR_VGA_VGT_GRT_ID,
ATR.ATR_VGA_VGT_ORT_ID ATR_VGA_VGT_ORT_ID,
ATR.ATR_VGA_VGT_PET_ID ATR_VGA_VGT_PET_ID,
ATR.ATR_VGA_VGT_INT_ID ATR_VGA_VGT_INT_ID,
ATR.ATR_VGA_DAT_ID ATR_VGA_DAT_ID,
ATR.ATR_ORDER ATR_ORDER,
ATR.ATR_VALUE ATR_VALUE,
ATR.ATR_TEXT ATR_TEXT,
ATR.ATR_DATE ATR_DATE,
ATR.ATR_BLOB ATR_BLOB,
ATR.JN_USER JN_USER,
ATR.JN_DATE_TIME JN_DATE_TIME,
ATT.ATT_DESCRIPTION,
RLA1.RLA_ACCESS RLA_ACCESS
FROM ATTRIBUTES ATR, ATTRIBUTE_TYPES ATT
,ROLE_ALL_ACCESSES rla1
,USER_ROLE_PRIVS
WHERE ATR.ATR_VGA_VAT_ATT_ID = ATT.ATT_ID
and rla1.rla_vga_vgt_int_id = atr.atr_vga_vgt_int_id
and (rla1.rla_vga_vgt_grt_id = atr.atr_vga_vgt_grt_id
or rla1.rla_vga_vgt_grt_id is NULL)
and (rla1.rla_vga_vgt_pet_id = atr.atr_vga_vgt_pet_id
or rla1.rla_vga_vgt_pet_id is NULL)
and (rla1.rla_vga_vgt_ort_id = atr.atr_vga_vgt_ort_id
or rla1.rla_vga_vgt_ort_id is NULL)
and (rla1.rla_vga_vat_att_id = atr.atr_vga_vat_att_id
or rla1.rla_vga_vat_att_id is null)
and (rla1.rla_vga_vat_pet_id = atr.atr_vga_vat_pet_id
or rla1.rla_vga_vat_pet_id is null)
and (rla1.rla_vga_vat_ort_id = atr.atr_vga_vat_ort_id
or rla1.rla_vga_vat_ort_id is NULL)
and (rla1.rla_vga_vat_unt_id = atr.atr_vga_vat_unt_id
or rla1.rla_vga_vat_unt_id is NULL)
and (rla1.rla_vga_dat_id = atr.atr_vga_dat_iD
or rla1.rla_vga_dat_id is NULL)
and rla1.rla_access IN ('READ','UPDATE')
and rla1.RLA_ORDER=(select max(RLA_ORDER) from ROLE_ALL_ACCESSES rla2
where rla2.rla_vga_vgt_int_id = atr.atr_vga_vgt_int_id
and (rla2.rla_vga_vgt_grt_id = atr.atr_vga_vgt_grt_id
or rla2.rla_vga_vgt_grt_id is NULL)
and (rla2.rla_vga_vgt_pet_id = atr.atr_vga_vgt_pet_id
or rla2.rla_vga_vgt_pet_id is NULL)
and (rla2.rla_vga_vgt_ort_id = atr.atr_vga_vgt_ort_id
or rla2.rla_vga_vgt_ort_id is NULL)
and (rla2.rla_vga_vat_att_id = atr.atr_vga_vat_att_id
or rla2.rla_vga_vat_att_id is null)
and (rla2.rla_vga_vat_pet_id = atr.atr_vga_vat_pet_id
or rla2.rla_vga_vat_pet_id is null)
and (rla2.rla_vga_vat_ort_id = atr.atr_vga_vat_ort_id
or rla2.rla_vga_vat_ort_id is NULL)
and (rla1.rla_vga_vat_unt_id = atr.atr_vga_vat_unt_id
or rla2.rla_vga_vat_unt_id is NULL)
and (rla1.rla_vga_dat_id = atr.atr_vga_dat_iD
or rla2.rla_vga_dat_id is NULL))
and USERNAME=USER
and GRANTED_ROLE=rla1.RLA_ROLE_ID
However If I runit through the hibernate console I get errors below. Any help would be appreciated.
Many thanks.
Hibernate version:
3.2
Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 08-May-2007 18:46:15 by Hibernate Tools 3.1.0.beta5 -->
<hibernate-mapping>
<class name="rwe.trading.jboss.plugins.ds.adso.entities.AttributesView" table="ATTRIBUTES_VIEW">
<composite-id name="id" class="rwe.trading.jboss.plugins.ds.adso.entities.AttributesViewId">
<key-property name="atrId" type="long">
<column name="ATR_ID" />
</key-property>
<key-property name="atrGrpId" type="long">
<column name="ATR_GRP_ID" precision="10" scale="0" />
</key-property>
<key-property name="atrPerStartDate" type="date">
<column name="ATR_PER_START_DATE" length="7" />
</key-property>
<key-property name="atrPerEndDate" type="date">
<column name="ATR_PER_END_DATE" length="7" />
</key-property>
<key-property name="atrVgaVatPetId" type="string">
<column name="ATR_VGA_VAT_PET_ID" length="30" />
</key-property>
<key-property name="atrVgaVatAttId" type="string">
<column name="ATR_VGA_VAT_ATT_ID" />
</key-property>
<key-property name="atrVgaVatUntId" type="string">
<column name="ATR_VGA_VAT_UNT_ID" length="30" />
</key-property>
<key-property name="atrOrgId" type="string">
<column name="ATR_ORG_ID" length="100" />
</key-property>
<key-property name="atrVgaVatOrtId" type="string">
<column name="ATR_VGA_VAT_ORT_ID" length="30" />
</key-property>
<key-property name="atrVgaVgtGrtId" type="string">
<column name="ATR_VGA_VGT_GRT_ID" />
</key-property>
<key-property name="atrVgaVgtOrtId" type="string">
<column name="ATR_VGA_VGT_ORT_ID" length="30" />
</key-property>
<key-property name="atrVgaVgtPetId" type="string">
<column name="ATR_VGA_VGT_PET_ID" length="30" />
</key-property>
<key-property name="atrVgaVgtIntId" type="string">
<column name="ATR_VGA_VGT_INT_ID" length="30" />
</key-property>
<key-property name="atrVgaDatId" type="string">
<column name="ATR_VGA_DAT_ID" length="30" />
</key-property>
<key-property name="atrOrder" type="long">
<column name="ATR_ORDER" precision="18" scale="0" />
</key-property>
<key-property name="atrValue" type="big_decimal">
<column name="ATR_VALUE" precision="38" scale="10" />
</key-property>
<key-property name="atrText" type="string">
<column name="ATR_TEXT" length="2000" />
</key-property>
<key-property name="atrDate" type="date">
<column name="ATR_DATE" length="7" />
</key-property>
<key-property name="atrBlob" type="blob">
<column name="ATR_BLOB" />
</key-property>
<key-property name="jnUser" type="string">
<column name="JN_USER" length="30" />
</key-property>
<key-property name="jnDateTime" type="date">
<column name="JN_DATE_TIME" length="7" />
</key-property>
<key-property name="attDescription" type="string">
<column name="ATT_DESCRIPTION" length="100" />
</key-property>
<key-property name="rlaAccess" type="string">
<column name="RLA_ACCESS" length="30" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs:
!SUBENTRY 2 org.hibernate.eclipse.console 4 150 2007-05-22 17:26:30.471
!MESSAGE org.hibernate.type.SerializationException: could not deserialize
!STACK 0
org.hibernate.type.SerializationException: could not deserialize
at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:217)
at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:240)
at org.hibernate.type.SerializableType.fromBytes(SerializableType.java:78)
at org.hibernate.type.SerializableType.get(SerializableType.java:39)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.type.ComponentType.hydrate(ComponentType.java:506)
at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:229)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1088)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:554)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1109)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33)
at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:79)
at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848)
at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086)
at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790)
at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905)
at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798)
at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748)
at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737)
at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264)
at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201)
at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262)
at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221)
at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698)
at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248)
at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417)
at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:173)
at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:152)
at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:110)
at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88)
at org.hibernate.eclipse.console.views.QueryPageTabView.createPartControl(QueryPageTabView.java:130)
at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:305)
at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:180)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:552)
at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:283)
at org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:512)
at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:126)
at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:269)
at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:391)
at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1102)
at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1051)
at org.eclipse.ui.internal.PartStack.presentationSelectionChanged(PartStack.java:785)
at org.eclipse.ui.internal.PartStack.access$0(PartStack.java:771)
at org.eclipse.ui.internal.PartStack$1.selectPart(PartStack.java:119)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation$1.handleEvent(TabbedStackPresentation.java:126)
at org.eclipse.ui.internal.presentations.util.AbstractTabFolder.fireEvent(AbstractTabFolder.java:267)
at org.eclipse.ui.internal.presentations.util.AbstractTabFolder.fireEvent(AbstractTabFolder.java:276)
at org.eclipse.ui.internal.presentations.defaultpresentation.DefaultTabFolder.access$1(DefaultTabFolder.java:1)
at org.eclipse.ui.internal.presentations.defaultpresentation.DefaultTabFolder$2.handleEvent(DefaultTabFolder.java:84)
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:852)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:660)
at org.eclipse.swt.custom.CTabFolder.setSelection(CTabFolder.java:3138)
at org.eclipse.swt.custom.CTabFolder.onMouse(CTabFolder.java:1922)
at org.eclipse.swt.custom.CTabFolder$1.handleEvent(CTabFolder.java:288)
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.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java: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)
Caused by: java.io.StreamCorruptedException: invalid stream header
at java.io.ObjectInputStream.readStreamHeader(Unknown Source)
at java.io.ObjectInputStream.<init>(Unknown Source)
at org.hibernate.util.SerializationHelper$CustomObjectInputStream.<init>(SerializationHelper.java:252)
at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:209)
... 88 more
!SUBENTRY 2 org.hibernate.eclipse.console 4 150 2007-05-22 17:26:30.471
!MESSAGE java.io.StreamCorruptedException: invalid stream header
!STACK 0
java.io.StreamCorruptedException: invalid stream header
at java.io.ObjectInputStream.readStreamHeader(Unknown Source)
at java.io.ObjectInputStream.<init>(Unknown Source)
at org.hibernate.util.SerializationHelper$CustomObjectInputStream.<init>(SerializationHelper.java:252)
at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:209)
at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:240)
at org.hibernate.type.SerializableType.fromBytes(SerializableType.java:78)
at org.hibernate.type.SerializableType.get(SerializableType.java:39)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.type.ComponentType.hydrate(ComponentType.java:506)
at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:229)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1088)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:554)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1109)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33)
at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:79)
at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848)
at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086)
at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790)
at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905)
at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798)
at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748)
at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737)
at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264)
at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201)
at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262)
at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221)
at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698)
at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248)
at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417)
at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:173)
at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:152)
at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:110)
at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88)
at org.hibernate.eclipse.console.views.QueryPageTabView.createPartControl(QueryPageTabView.java:130)
at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:305)
at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:180)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:552)
at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:283)
at org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:512)
at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:126)
at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:269)
at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:391)
at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1102)
at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1051)
at org.eclipse.ui.internal.PartStack.presentationSelectionChanged(PartStack.java:785)
at org.eclipse.ui.internal.PartStack.access$0(PartStack.java:771)
at org.eclipse.ui.internal.PartStack$1.selectPart(PartStack.java:119)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation$1.handleEvent(TabbedStackPresentation.java:126)
at org.eclipse.ui.internal.presentations.util.AbstractTabFolder.fireEvent(AbstractTabFolder.java:267)
at org.eclipse.ui.internal.presentations.util.AbstractTabFolder.fireEvent(AbstractTabFolder.java:276)
at org.eclipse.ui.internal.presentations.defaultpresentation.DefaultTabFolder.access$1(DefaultTabFolder.java:1)
at org.eclipse.ui.internal.presentations.defaultpresentation.DefaultTabFolder$2.handleEvent(DefaultTabFolder.java:84)
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:852)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:660)
at org.eclipse.swt.custom.CTabFolder.setSelection(CTabFolder.java:3138)
at org.eclipse.swt.custom.CTabFolder.onMouse(CTabFolder.java:1922)
at org.eclipse.swt.custom.CTabFolder$1.handleEvent(CTabFolder.java:288)
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.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java: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)
Name and version of the database you are using:
Oracle 10
The generated SQL (show_sql=true):
select
attributes0_.ATR_ID as ATR1_9_,
attributes0_.ATR_GRP_ID as ATR2_9_,
attributes0_.ATR_PER_START_DATE as ATR3_9_,
attributes0_.ATR_PER_END_DATE as ATR4_9_,
attributes0_.ATR_VGA_VAT_PET_ID as ATR5_9_,
attributes0_.ATR_VGA_VAT_ATT_ID as ATR6_9_,
attributes0_.ATR_VGA_VAT_UNT_ID as ATR7_9_,
attributes0_.ATR_ORG_ID as ATR8_9_,
attributes0_.ATR_VGA_VAT_ORT_ID as ATR9_9_,
attributes0_.ATR_VGA_VGT_GRT_ID as ATR10_9_,
attributes0_.ATR_VGA_VGT_ORT_ID as ATR11_9_,
attributes0_.ATR_VGA_VGT_PET_ID as ATR12_9_,
attributes0_.ATR_VGA_VGT_INT_ID as ATR13_9_,
attributes0_.ATR_VGA_DAT_ID as ATR14_9_,
attributes0_.ATR_ORDER as ATR15_9_,
attributes0_.ATR_VALUE as ATR16_9_,
attributes0_.ATR_TEXT as ATR17_9_,
attributes0_.ATR_DATE as ATR18_9_,
attributes0_.ATR_BLOB as ATR19_9_,
attributes0_.JN_USER as JN20_9_,
attributes0_.JN_DATE_TIME as JN21_9_,
attributes0_.ATT_DESCRIPTION as ATT22_9_,
attributes0_.RLA_ACCESS as RLA23_9_
from
OPS$ORACLE.ATTRIBUTES_VIEW attributes0_
where
attributes0_.ATR_GRP_ID=43
|
Login
FAQ
Search