hi,
i am using java with hibernate . i want to run a hibernate order by query thru java.
i have written the query in hibernate.hbm.x ml file. the query is as follows:
query:
SELECT distinct a.process_id, a.name name, a.category_id,c .parent_id
FROM tbl_process_mas ter a, tbl_category c where (lower(a.name) like :searchString or lower(a.descrip tion) like :searchString or
lower(a.meta_ta g) like :searchString...