Hi Christian

After trying the solution you suggested, the query formed by hibernate is below :

select
emircleari_.certificationID,
emircleari_.certificationVID,
emircleari_.EMIRClearingCategoryID,
emircleari_.ClearingCategoryRN as ClearingCategoryRN52_,
emircleari_.ClearingCategorySourceRN as ClearingCategorySourceRN52_,
emircleari_.ClearingScopeRN as ClearingScopeRN52_,
emircleari_.GeneralProductScopeDomainRN as GeneralProductScopeDomainRN52_,
emircleari_.GeneralProductScopeTypeRN as GeneralProductScopeTypeRN52_,
emircleari_.UpdaterUserID as UpdaterUserID52_,
emircleari_.versEfftvTS as versEfftvTS52_
from
EMIRClearingCategory emircleari_
where
emircleari_.certificationID=?

• and emircleari_.certificationVID=?
  and emircleari_.EMIRClearingCategoryID=?*

But the expected and working query is :

select
emircleari_.EMIRClearingCategoryID,
emircleari_.certificationId as certific1_49_,
emircleari_.certificationVID as certific2_49_,
emircleari_.ClearingCategoryRN as Clearing6_49_,
emircleari_.ClearingCategorySourceRN as Clearing7_49_,
emircleari_.ClearingScopeRN as Clearing8_49_,
emircleari_.GeneralProductScopeDomainRN as GeneralP9_49_,
emircleari_.GeneralProductScopeTypeRN as General10_49_,
emircleari_.UpdaterUserID as UpdaterU4_49_,
emircleari_.versEfftvTS as versEfft5_49_
from
EMIRClearingCategory emircleari_
where

• emircleari_.EMIRClearingCategoryID=?*