How to execute sql query in sleep mode

Question

I need to select an entry from the users_roles table and I am using hibernate. but I don't want to make a separate class in java for this, therefore

I am thinking about using plain sql. I can do this, or I have to do a java class for this. because I just extract the role for example

select role from user_roles where email = abc@cdf.com

any eaxmple of this will be fine

+3

John Mar 19 '11 at 14:58

2 answers

, 538603, ; , , / , Hibernate ( ...). , , HQL (, , ), www.mybatis.org, sql.

0

Riccardo Cossu 19 . '11 15:23

Michael schubert · Accepted Answer · 2011-03-19T15:04:26+0000

Inside Hibernate, you should use the SQL-like Langauge HQL (Hibernate Query Language). It will look something like this:

From user_roles where email = abc@cdf.com

And retrieve the entire mapped object class for you.

edit: an alternative would be the following: Using native queries in Hibernate