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

    no hql query editor selected

    asookazian

      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?

        • 1. Re: no hql query editor selected
          asookazian

          using JBDS 2.0.0.CR2

          • 2. Re: no hql query editor selected
            maxandersen

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

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

                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

                  nevermind, this does it:

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