How to use key of MAP in Criteria Query?

Question

I have a Bean like this

Class TestA
{
    Map<String,TestB> testBMap;
}

Class TestB
{
    String data;
    ...
}

I want to fetch the TestA data along with the map testBMap where key ='test1'.

How can i do this using Hibernate.

Answer 1

The key must be the value of one of the persistent fields of TestB (let's says this field is names "foo"), so this code should work :

Criteria criteria = session.createCriteria(TestA.class, "a");
criteria.createAlias("a.testBMap", "b");
criteria.add(Restrictions.eq("b.foo", "test1"));
criteria.setFetchMode("a.testBMap", FetchMode.JOIN);
return criteria.list();