Transactions required for read only ?

santony · **Joined:** Thu Sep 30, 2004 2:14 am **Posts:** 3

1. Apart from factors like phanton read ( isolation level ), I m wondering if one is expected to use Transactions for a query operation.

2. In case of a query, what happens when one rolls back the transaction.

3. Also with respect to Clob, am I expected to be within the transactional context when I do the query ?

4. Can I close() the session before I access the Clob object ?

--sony

christian · **Posted:** Sat Oct 02, 2004 3:34 pm

This has been discussed to death. Always demarcate Transactions, no matter if you read or manipulate data. There is also a (very) long answer you probably don't want to hear.

jw3525 · **Joined:** Sat Aug 28, 2004 4:15 pm **Posts:** 61

I'd like to hear it.

michael · **Posted:** Thu Dec 02, 2004 6:03 pm

Search the forum, it has already been discussed extensively.