column sort via sql using rich:datatable

[aiquidie]

Hello everyone

I have a jsp page that paginates from database, that handles the pagination by adding where rownum between 1 and 20 to the sql.
I`ve extended javax.faces.model.DataModel

That`s why I have to make the sorting same way.
(by adding order by code to the sql)

how can I do that in my code

url of my war file :

http://netload.in/datei127519b9cf6a7ef12928e62f574bee33/RichFacesTemplate.war.htm