On 1 Sep., 20:57, Dario Fassi <[email protected]> wrote: > Hi, > > > By the way: I am using MVCC=TRUE. MULTI_THREADED=YES is no option for > > me because I have problems with the possible deadlock situation > > (discussed in some other threads). > > What's make you think that MVCC vs MULTI_THREADED settings will affect your > chances to get an DeadLock ? > > If I'm not missing something two connections can end in a DeadLock situation > in any mode as consequence of resource locking order only . > Mmh, I haven't thought very much (shame on me ;-) but I simply tried the diffrerent options. And the reproducable result is: MULTI_THREADED=YES => deadlock MVCC=TRUE => no deadlock
Maybe that's pure fortune that MVCC did not produce a deadlock up to now. Thanks for the Apache DBCP hint. It sounds quite interesting and I think I will give it a try. Uli > > Regards, > Dario. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
