Hibernate Community • View topic - Hibernate equivalent to select * from my

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate equivalent to select * from my_tableID in('1','2')

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

sudhakarbe

Post subject: Hibernate equivalent to select * from my_tableID in('1','2')

Posted: Fri Oct 08, 2010 5:47 am

Newbie

Joined: Tue May 11, 2010 6:38 pm
Posts: 5

Hi All,
I am trying to emulate the following query in Hibernate

Sql Query

Code:

select * from ORDER_HISTORY_SCR_VIEW where REFERENCE_ID in ('MOSU0002','MOSU0003')

Result:

Code:

 ID                   Status  
 =======      ======  
 MOSU0002       completed  
 MOSU0003       completed  

But the issue is when i try this with Hibernate
HQl:

Code:

Criteria crr = session.createCriteria(MyTable.class); crr.add(Restrictions.in(columnPropertyName, errorOrdersFilterList)); System.out.println(crr.list());

Result

Code:

   ID                   Status  
   =======      ======  
   MOSU0002       completed  
   MOSU0002       completed  

Issue: It fetches the same row twice .
Why is this anamoly ...................

Could any one post the solution

Top

bcramer0515

Post subject: Re: Hibernate equivalent to select * from my_tableID in('1','2')

Posted: Fri Oct 08, 2010 8:48 am

Newbie

Joined: Wed Oct 06, 2010 12:49 pm
Posts: 8

I had to figure out how to use the "IN" clause the other day. The solution for me was to use the HibernateTemplate's findByNamedParam method.

So for your example, it would be something like this (where "OrderHistory" is the name of your entity class):

Code:

List<OrderHistory> orderHistoryResults = null;
HibernateTemplate ht = getHibernateTemplate();
String[] params = {"listParam"};
Object[] values = {"MOSU0002","MOSU0003"};
orderHistoryResults = ht.findByNamedParam("from OrderHistory h where h.referenceId in (:listParam)", params, values);

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum