I want to sort the list of entity bean returned by finder methods based on more than one columns. In short want to do 'order by' on more an one column. I want to pass the column names to be sorted in the finder method as arguement and use the same in the order by clause. I am working in WSAD 5.1 and we are using EJB 2.0 in our project. Following is my finder query select object(o) from ClaimNoteEntity o where o.isClaim=?1 order by =?1 asc ,=?2 desc It gives compilation error at '=?1' phrase of the query. Can u give some solution to get it working    More>>