0 Replies Latest reply on Feb 9, 2007 1:01 PM by btarbox

    Does loading a nested object use >1 database session/connect

    btarbox

      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