Hibernate version:
2.1.7
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi!
Im working in an application with a seperate business tier. In this case the business logic must load all collections that will be needed by the web tier before returning. This means that the business tier should load all the data and return it already initialized to the presentation/web tier that is required for a particular use case. I have read that one solution is to call Hibernate.initialize() for each collection that will be needed in the web tier before the session is closed. But using this approach I will have to iterate in the entire collection calling Hibernate.initialize on each row to load the mapping collections.
I tried to use another approach turning of lazy loading at runtime as follows:

//iterates in the collection of mapped collection that the web tier will need
for (int i = 0; i < filter.collectionsToInitializeCount(); i++) {
//instantiate a new configuration object
Configuration c = new Configuration().configure();
//get the collection mapping from the XML mapping file
net.sf.hibernate.mapping.Collection col = c.getCollectionMapping
(filter.getCollectionToInitialize(i).toString());
//changes the "lazy" loading attribute of the collection mapping to false
col.setLazy(false);
//open a new session based on the new mapping
session = c.buildSessionFactory().openSession();
}

But the lazy loading that is originally "true" keeps "true" and the collection is not initialized. Is this approach correct? If so what is wrong with the code?

I am using this one in Hibernate 3:

private void turnOffLazy(Configuration cfg) {
cfg.buildMappings();
Iterator<?> iter = cfg.getClassMappings();
while (iter.hasNext()) {
PersistentClass persistentClass = (PersistentClass) iter.next();
persistentClass.setLazy(false);
Iterator<?> iter2 = persistentClass.getPropertyIterator();
while (iter2.hasNext()) {
Property prop = (Property) iter2.next();
prop.setLazy(false);
Value val = prop.getValue();
if (val != null && val instanceof Fetchable) {
Fetchable f = (Fetchable) val;
f.setLazy(false);
}
}
}
iter = cfg.getCollectionMappings();
while (iter.hasNext()) {
Collection collection = (Collection) iter.next();
collection.setLazy(false);
}
}

But not sure if it's working...