-----Original Message-----
From: James, Steven
Sent: Mon 7/11/2005 1:51 PM
To: user-java@ibatis.apache.org
Cc: [EMAIL PROTECTED]
Subject:
if i understand you you wish for the reads to get the same view if another
transaction is processing. eg if user a creates a connection then user b
does so as well if b modifies but does not commit then a should not see b's
data until commit.
If this is what you mean then you need to set the isolation level on the
transaction that is making changes. Your reader does not need a transaction..
Steve
-----Original Message-----
From: Florin Manolache [mailto:[EMAIL PROTECTED]
Sent: Mon 7/11/2005 10:32 AM
To: [EMAIL PROTECTED]
Cc: user-java@ibatis.apache.org
Subject: Re: How to set the connection read-only?
In my read-only transactions, I read data from multiple tables, and I want to
get a consistent view (I don't want other transactions which are not read-only
to modify data between 2 reads from 2 different tables). Setting the
transaction read-only is supposed to give hints to the database/driver that I
am not modifying anything, so it can perform transactions optimizations.
Basically what I need to do is to get a reference to the current connection
being used by DAOs and sqlMap and call setReadOnly(true) on it.
Thanks,
Florin
----- Original Message -----
From: Clinton Begin
To: user-java@ibatis.apache.org ; Florin Manolache
Sent: Saturday, July 09, 2005 11:59 PM
Subject: Re: How to set the connection read-only?
Florin,
I don't understand why you would do that. If you have a connection that's
read-only, why would you need a transaction at all? (or vice versa)
Cheers,
Clinton
On 7/8/05, Florin Manolache <[EMAIL PROTECTED]> wrote:
Is there a way to set the connection in the read-only state before starting
a transaction?
I'm using a mix of DAOs and sqlMaps in my application so I'm interested in
a solution for both of them.
Thanks,
Florin
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.