In the sample code within the documentation @ hibernate.org; it uses Hibernate Transactions although the method only does a select query. Why is that needed since it is not making any changes to the DB ?

Thanks

Regards,

alistair

You should always use a transaction, always. There is in fact no such thing as "no transaction". Transactions are needed for correct transaction isolation. Search the forum, this has been discussed multiple times already.

Well I would be a little bit more strict. There are specific cases where tx are not needed.
But unless you don't know what you do, use tx, it's you friend.

The reason you need a transaction when querying is that if you do multiple queries, you want to be querying consistent data. You wouldn't want the data changing underneath you from query to query. Using a transaction ensures that a set of related queries will be querying consistent data.

I think my role on these forums is to provide more straightforward answers where the forum long-timers tend to be astoundingly terse. Of course, by the time I've answered as many thousands of posts FOR FREE as they have, I'll probably be worn down to a point of similar terseness :-D

Cheers!
Rob

Thank you for all your comments. I'll look for more details in the archives.

[quote="RobJellinghaus"tend to be astoundingly terse[/quote]
I'm offensed ;-)

Yeah, you look pretty offensed :-D
Cheers!
Rob