On 8/14/07, Michael Lackhoff <[EMAIL PROTECTED]> wrote:
> Only question: Is it really possible to call rollback as a class method
> or do I have to call it on the specific object that started the transaction?

You have to call it on the database handle that started the
transaction.  If all of your objects  (within the same request) use
the same database handle, there is no difference.  A rollback affects
everything on that database connection.

> >> How do I manipulate the "isolation level"?
> >
> > It depends on your database.  What database are you using?
>
> SQLite, but if at all possible I would set it in some generic way with
> RDBO because I might well change the database in the future.

Since the syntax can vary a bit from one database to another, there
isn't a truly generic way to do it.  I don't use SQLite, but there's
some information on how to set this on the pragma page:
http://www.sqlite.org/pragma.html

- Perrin

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to