ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James, Steven" <Steven.Ja...@logicacmg.com>
Subject Re: How to set the connection read-only?
Date Mon, 11 Jul 2005 12:59:22 GMT

-----Original Message-----
From: James, Steven
Sent: Mon 7/11/2005 1:51 PM
To: user-java@ibatis.apache.org
Cc: florin@ecstend.com
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..


-----Original Message-----
From: Florin Manolache [mailto:florin@ecstend.com]
Sent: Mon 7/11/2005 10:32 AM
To: cbegin@ibatis.com
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. 


  ----- 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?


  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)


  On 7/8/05, Florin Manolache <florin@ecstend.com> 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.


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.

View raw message