[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Does loading a nested object use >1 database session/connect
btarbox
do-not-reply at jboss.com
Fri Feb 9 13:01:04 EST 2007
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#4013791
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4013791
More information about the jboss-user
mailing list