[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Does loading a nested object use >1 database session/connect

If I do a non-lazy load of a object with sub-objects I know there will be multiple sql selects executed. My question is: do each of these selects execute in their own DB session or do they share one. I always assumed that a single Hibernate Session used a single database session/connection no matter now many queries it needed to populate a nested object. I've been told this isn't the case and that each additional query for a nested object gets its own database session. Can anyone tell me which one is true? BTW my application is throwing Oracle 00018 out-of-session errors which is why this comes up. Thank you. Brian Tarbox View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4013791#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...