well if its an attribute of the transaction, then we couldnt really make it per object instance. setting transaction attributes, like isolation levels and such, is a slightly different thing, which ultimately id want to stick on Transaction and SessionTransaction... (but even then, its not clear to me if the various DBAPIs really allow setting of transaction attributes on individual transactions and not just the connection overall).
it gets a little crazy with that since we are using connection pools. if the connection attributes change for a certain session, that would imply we would want to change them back when the connection is returned. but then what do we change them back to ? in reality ive never seen the need to be playing around with locking and isolation levels to that degree, and the hibernate docs also say "well usually you really shouldnt have to worry about locking...." anyway i agree the term "update" is clearer than "upgrade", im not really sure where they got that name from. On Sep 4, 2006, at 12:24 PM, Andrija Zaric wrote: > it will ensure that multiple queries produce the result consistent to > the one point in time, but that transaction will not modify tables, so > it doesn't have to put exclusive lock on them. > > oracle has that in "set transaction read only" -- you don't have to > wonder where i got it ;) > > useful for reports and stuff like that, where everything should 'fall > in their place'. as i said, this could easily be just plain stupid in > ORM. > > please don't get me wrong, i'm not asking for a feature, just putting > in extra idea while you still drafting. > > > On 04/09/06, Michael Bayer <[EMAIL PROTECTED]> wrote: >> >> On Sep 4, 2006, at 11:32 AM, Andrija Zaric wrote: >> >> > - will 'read' mean serializabile isolation level (like Hibernate >> docs >> > imply), or "read-only" (all reads during a transaction will produce >> > the same result)? If the former, maybe 'read_only' can be added >> as a >> > feature of transaction? >> >> how would "read-only" work exactly ? im not sure if i understand >> what it does. >> ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
