Hi,

I have a query.

I am using criteria query where I am using order by clause.
criteria.addOrder(Order.asc("name")) .addOrder(Order.asc(String.valueOf(Integer.parseInt("id"))));

The problem is : In my database, I have a table and one column ID is there which is varchar.
Values in that column are 82, 502, etc.

Whenever I use the above query it sorts the column accordingly, but I want 82 to be selected. As the column is in varchar, so its giving the problem. Kindly suggest something.Its highly urgent.


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html