Creating inner query in hibernate

Question

how to add a set parameter() metheod inside the inner query in hibernate?

I have try to do like this but already have a errors

this is my code

Query query=session.createQuery("select eq.euipmentName,eq.type from Euipment eq where eq.id in(select euipment from Quotation qt where qt. supQuotation=:ids)");          
query.setParameter("ids",id);
list = (List<Euipment>)query.list();

my error is "-----Hibernate: select eq.euipmentName,eq.type from Euipment eq where eq. id in(select euipment from Quotation qt where qt. supQuotation=?) Unknown column 'qt.supQuotation' in 'where clause' ---- " — Tharaka
– Tharaka, Commented Aug 22, 2013 at 12:45
my error is --Hibernate: select eq.euipmentName,eq.type from Euipment eq where eq. id in(select euipment from Quotation qt where qt. supQuotation=?) Unknown column 'qt.supQuotation' in 'where clause'-- — Tharaka
– Tharaka, Commented Aug 22, 2013 at 12:46
Test your query on your database console....Then try using Hibernate — MayurB
– MayurB, Commented Aug 22, 2013 at 12:49

Joe Taras · Accepted Answer · 2013-08-22 12:44:47Z

5

I've done some corrections about your query: 1. qt. supQuotation has a space, I've removed 2. euipment in you sub query haven't alias, I add qt

String hql = 
    "select eq.euipmentName,eq.type " +
    " from Euipment eq " +
    " where eq.id in (select qt.euipment from Quotation qt where qt.supQuotation = :ids)";

Query query = session.createQuery(hql);          
query.setParameter("ids",id);
list = (List<Euipment>)query.list();

Tell me, if it's OK

If not OK, please post here the error, and check if you have put in hibernate mappping file your classes

answered Aug 22, 2013 at 12:44

Joe Taras

15.4k7 gold badges45 silver badges60 bronze badges

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

Comments

Ankur Lathi · Accepted Answer · 2013-08-22 12:34:25Z

1

From Hibernate Documentation:

Execution of native SQL queries is controlled via the SQLQuery interface, which is obtained by calling Session.createSQLQuery().

createQuery() creates Query object using the HQL syntax.
createSQLQuery() creates Query object using the native SQL syntax.

So replace createQuery with createSQLQuery for native SQL query.

answered Aug 22, 2013 at 12:34

Ankur Lathi

7,8865 gold badges41 silver badges54 bronze badges

6 Comments

Stewart Over a year ago

What gives the query away as being SQL rather than HQL ?

Tharaka Over a year ago

Dear sir I tried, but also have a exception, I dont know how to use a quotation and parentheses, is it rihgt?

Ankur Lathi Over a year ago

@Stewart: Check this link: stackoverflow.com/questions/4162838/…

Ankur Lathi Over a year ago

@tharaka: Please update your question with exception you are getting.

Ankur Lathi Over a year ago

@tharaka: Have you tested your query with DB Console?.

|

Prabhakaran Ramaswamy · Accepted Answer · 2013-08-22 14:11:45Z

0

Try with Criteria

Criteria c = getSession().createCriteria(Euipment.class, "e"); 
c.createAlias("e.quotation", "q"); // inner join by default 
c.add(Restrictions.eq("q.supQuotation", id));       
list = (List<Euipment>)c.list();

answered Aug 22, 2013 at 14:11

Prabhakaran Ramaswamy

26.1k10 gold badges61 silver badges65 bronze badges

Collectives™ on Stack Overflow

Creating inner query in hibernate

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related