This content has been marked as final.
Show 5 replies
-
1. Re: no hql query editor selected
asookazian Mar 12, 2009 11:49 AM (in response to asookazian)using JBDS 2.0.0.CR2
-
2. Re: no hql query editor selected
maxandersen Mar 12, 2009 12:02 PM (in response to asookazian)doesn't it pick up the editor selectin when you start typing ?
-
3. Re: no hql query editor selected
asookazian Mar 12, 2009 12:06 PM (in response to asookazian)well it's working now (after I put the focus in the hql editor and hit spacebar). and I clicked on various tabs and other windows/apps. not sure how the original behavior occurred...
-
4. Re: no hql query editor selected
asookazian Mar 12, 2009 12:09 PM (in response to asookazian)This is the native query that was generated:
select equipmentr0_.EquipmentRepairID as col_0_0_, equipmentr0_.ICOMSWorkOrderNumber as col_1_0_, equipmentr0_.ICOMSWorkOrderTechID as col_2_0_ from boBETS.dbo.EquipmentRepair equipmentr0_, boBETS.dbo.Equipment equipment1_ where equipmentr0_.EquipmentID=equipment1_.EquipmentID and equipment1_.EquipmentID=1
When I exec the following query in SQL mgmgt studio, I see the column names in the header of the result pane:select equipmentr0_.EquipmentRepairID, equipmentr0_.ICOMSWorkOrderNumber, equipmentr0_.ICOMSWorkOrderTechID from boBETS.dbo.EquipmentRepair equipmentr0_, boBETS.dbo.Equipment equipment1_ where equipmentr0_.EquipmentID=equipment1_.EquipmentID and equipment1_.EquipmentID=1
Is it possible to tweak it so that we see the actual column names in the header of the Hibernate Query result rather than 0, 1, 2? -
5. Re: no hql query editor selected
asookazian Mar 12, 2009 12:11 PM (in response to asookazian)nevermind, this does it:
select er.equipmentRepairId as equipmentRepairId from EquipmentRepair er, Equipment e where er.equipment.equipmentId = e.equipmentId and e.equipmentId = 1