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 Use alias in query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Use alias in query" Watch "Use alias in query" New topic

Use alias in query

fabian verbeek
Ranch Hand

Joined: Oct 20, 2012
Posts: 52

I'm new in hibernate and i would like concat 2 fields and put in an alias
like this i mysql:

SELECT CONCAT(a,b) AS c from table ORDER BY CONCAT(a,b)

How can i use this in the query hibernate

Query q = session.createQuery("FROM table order by ?");

thanks for your help
I agree. Here's the link:
subject: Use alias in query
It's not a secret anymore!