Hi,

I am getting a list of Document objects with this query :

"from Document as d where d.id in (:ids)"

id is the ID in the document table and is mapped to a Long
ids is an Array of Long

My question is : how to get the results in the same order than in the array given as parameter? Is it possible with HQL?

Thanks

Thomas

that stuff is db dependent, you need to process the result your self or just do this *AFTER* you have run the query (otherwise you will get multiple selects):

foreach id in ids
doc = session.get(Document.class,id);

that would also do the trick.