this is my hbm file


the description is AccountImpl class is mapped with a table named account having properties
parantAccount of type Account (in the same table )
set of accounts as children

in table some columns are
id is primary key
parentId is foreign key to the same table as this table have accounts that can be a parent account or child of some other account

thats why i put an object parentAccount of type AccountImpl and a set children having objects of AccountImpl in AccountImpl as hbm dipicts all


the issue is if from within application i call this with lazy="false" it fetches all of the records in account table coz of parent child relationship

but when i set lazy="true" or doest not set the lazy attribute.
from within application call it works but when i call the same function from dwl it throws an exception 'session closed or no session is available'

coz i am trying to get children on the basis of parentCode as


the exception is



as i m using hibernate with spring so i m using this filter
as

Hi Curious,

Error comes because, you try to get the child list after the session is closed.
Initialize your childs object manually, if you are using Criteria,
i.e)

Session s = hibernateTemplate.getSessionFactory().openSession();
child = s.createCriteria(Account.class)
.createAlias("parentAccount","p")
.add(Restrictions.eq("p.code",code)).list();

Hibernate.intialize(account.getChildren());
s.close();

Hope this helps!!!!

as in ur given suggestion
initialize is a function of hibernateTemplate but how can i pass account.getChildren() to it as i hvnt any 'account' here

please explain the idea u mentioned here

Hi Curious,

In the class Hibernate, you have a method called initialize(Arg), Pass your collections which want to load....I'm not talking about your Spring reference variable hibernateTemplate