Does prefetchPath retrieve data in the same transaction as the collection queried ?

Transactions are not started automatically during fresh fetches. If you want that, you should add the collection to the transaction before fetch it. However fetching always places read-locks on the rows affected. WRITES to those rows then have to wait till the locks are lifted, that's how SQLServer works. You either have to commit or rollback the transaction.

Wally wrote:

Does prefetchPath retrieve data in the same transaction as the collection queried ?

If the root collection is in the transaction, the other fetches are in the same transaction.

Thanks a lot to both.

My question was not very clear but Frans answer was exactly the one I was expecting.

Thanks a lot!