I am new to Hibernate, can anyone help me with this query

SELECT B
FROM FavoriteNotice A, Notice B
WHERE A.comp_id.noticeId = B.noticeId
AND A.comp_id.siteminderId = 'johndoe'

The above select is the query which returns me a notice object.
Now this notice object has 3 Hashsets which get data from other tables.
Now i want to load the data of 1 hashset in this query itself thereby over-riding the lazy attribute

The attributes in the Notice class which i want to load is "noticeTenors". And this NoticeTenor class has in turn two hashsets namely "refTradeTypes" and refcurrencies" which also have to be loaded.


So in short ... i have a Notice class and it has a list of NoticeTenors. And each NoticeTenor has multiple trade types and multiple currencies. I want to load all of these in one query (overriding the lazy attirbute using HSQL).

How do i do this.

Hi Vinod

You can use something called as 'Fetch' join to override the lazy loading of aggregates.

Look at this http://www.hibernate.org/117.html and search for eager fetching.

HTH,
-Nilesh

I kindly suppose you using inner join fetch in your hql.

I kindly suppose you using inner join fetch in your hql,more help plese refer hibernate reference.