No nested transactions. See more at http://www.sqlite.org/lang_transaction.html
But there is extensive handling of concurrency and locks http://www.sqlite.org/lockingv3.html There is also sqlite3_busy_timeout which I can be added to handle concurrency with resonable retry timeouts. --- bill lam <[EMAIL PROTECTED]> wrote: > I tested and found database file is not exclusively locked by a process in > that > two processes (J instances) can access the same database file concurrently. > Does > sqlite actually support multi-user access. > > in the verb > apply=: 4 : 0 > exec 'begin transaction;' > [...] > > it does not check for existing transaction, does sqlite support nested > transaction? > > -- > regards, > bill > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
