5 Replies Latest reply on Mar 12, 2009 12:11 PM by asookazian

    no hql query editor selected

    asookazian
    asookazian Mar 12, 2009 11:48 AM

      I have successfully written the following HQL query in the HQL editor and executed to get results:

      select er.equipmentRepairId, er.icomsworkOrderNumber, er.icomsworkOrderTechId from EquipmentRepair er, Equipment e
where er.equipment.equipmentId = e.equipmentId
and e.equipmentId = 1


      Why does it say "No HQL Query editor selected" in the Hibernate Dynamic SQL Preview view/tab?

      • 2685 Views
      • Tags:
        • 1. Re: no hql query editor selected
          asookazian
          asookazian Mar 12, 2009 11:49 AM (in response to asookazian)

          using JBDS 2.0.0.CR2

            • Actions
          • 2. Re: no hql query editor selected
            maxandersen
            maxandersen Mar 12, 2009 12:02 PM (in response to asookazian)

            doesn't it pick up the editor selectin when you start typing ?

              • Actions
            • 3. Re: no hql query editor selected
              asookazian
              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...

                • Actions
              • 4. Re: no hql query editor selected
                asookazian
                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?

                  • Actions
                • 5. Re: no hql query editor selected
                  asookazian
                  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


                    • Actions