How to execute normal SQL query in Hibernate without HQL?

Question

I have a pretty complex Join query to select few items from DB, and it doesn't involve any Update required back to this table. Which is why, I don't want to use the HQL (Hibernate Query Language, instead I want to execute as a simple SQL query.

Is that possible to execute a Normal SQL - Join query which involves 3 different tables in hibernate? I use Java - Struts framework.

If you say it is not possible then I have to stick to HQL and I would post here the query for which I would need your help in writing down HQL based class(tables) creations and HQL based Query string.

Also, if you could please give me an example query with couple or 3 table Joins and how to set the Parameters for the SQL.

Nirav Prajapati · Accepted Answer · 2014-06-09 16:38:16Z

2

from below line of code you can use any Query with hibernate

its call Native SQL

session.createSQLQuery("SELECT * FROM table as a join table1 as b  on a.id = b.id ").list();

for more help go here

answered Jun 9, 2014 at 16:38

Nirav Prajapati

3,01529 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Gersh Over a year ago

Thanks Nirav. I am seeing problem while setting up Parameters. Do you have idea about assigning parameters for the SQL query? Can you show me some example on how parameters need to be set?

Nirav Prajapati Over a year ago

@Gersh :: which kind of parameter can you provide your Query so that i can help you

Gersh Over a year ago

Please see this link and try to suggest your opinion there. link

Gersh Over a year ago

I have used your opinion but the query gets failed at execution. Please the above link I posted.

Nirav Prajapati Over a year ago

@gersh :: check link i gave answer hope will help you

|

Nicola Baiocco · Accepted Answer · 2021-03-01 13:41:35Z

1

With JPA you can use entityManager.createNativeQuery(...)
With Hibernate there's session.createSQLQuery(...)

edited Mar 1, 2021 at 13:41

answered Jun 9, 2014 at 16:39

Nicola Baiocco

1568 bronze badges

Collectives™ on Stack Overflow

How to execute normal SQL query in Hibernate without HQL?

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related