Hello

I am trying to convince my colleagues to transition to Hibernate instead of using plain SQL and JDBC.
To convince them of Hibernate's merits, they would like one of their pet database problems resolved in Hibernate, and for it to be fast..

A database table with three columns: NAME (string), ID(long), DESCRIPTION(string)

The task is to retrieve all those entries in the table whose description cell contains a (string representation of an) integer (some will contain words and other non integer strings) and to order the resulting collection of rows.
If anyone could please tell me how to do this, with good performance, with HQL I would be really happy, as we can then finally move to Hibernate :)

Many thanks
Kenny

Hi kennylomax,

I'm not yet a Hibernate expert (about 4 months experiance) but I don't think this kind of problem is something Hibernate is aiming to solve, to be honest. Your best shot at getting that kind of information quickly from the database is to come up with a stored procedure, or perhaps cache the entire contents of the table permanently so you can do it fairly quickly in Java?

Another idea - why not add a column is_number that you set every time you update a row. Queries would be fast as anything then, the only cost is on insert/update having to check if DESCRIPTION can be parsed as an Integer.