File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Hibernate challenge: Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate challenge:" Watch "Hibernate challenge:" New topic

Hibernate challenge:

kenny lomax

Joined: Jan 26, 2008
Posts: 2

I am trying to convince my colleagues to transition to Hibernate instead of using plain SQL and JDBC.
To convince them of Hibernates merits, they would like one of their pet database problems resolved in Hibernate:

imagine 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 HQL I would be really happy, as we can then move to Hibernate

Thanks everyone,
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

The easiest way is to create a SQLQeury through Hibernate and not use HQL, so the query will look exactly like the one you would have in JDBC, but with a lot less code to write and maintain.


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: Hibernate challenge:
It's not a secret anymore!