jpa - Column Alias name not considered by Hibernate -


i tried run below hql. though have specified alias name columns, hibernate didn’t consider that.

here hql:

select et1.entitlementid a, et1.admtcid b,            et1.barcode c,et1.inactivedate d,           et1.iseentitlement e,et1.magstripnumber f,           et1.serialnumber g,et1.ticketbankind h  com.wdw.resmanagement.data.entity.admissioncomponententitlement et1  et1.inactivedate null , et1.serialnumber = :serialnumber  

corresponding sql generated hibernate:

select     admissionc0_.adm_enttl_id col_0_0_,     admissionc0_.adm_tc_id col_1_0_,     admissionc0_.brcd_vl col_2_0_,     admissionc0_.adm_enttl_inactv_dt col_3_0_,     admissionc0_.e_enttl_in col_4_0_,     admissionc0_.mag_strp_vl col_5_0_,     admissionc0_.serial_nb_vl col_6_0_,     admissionc0_.tkt_bank_in col_7_0_      res_mgmt.adm_cmpnt_enttl admissionc0_      (         admissionc0_.adm_enttl_inactv_dt null     )      , admissionc0_.serial_nb_vl=? 

i using oracle 10g database.

can know should change same alias name in sql (which hibernate generating) ?


Comments

Popular posts from this blog

tcpdump - How to check if server received packet (acknowledged) -