Noel, Thanks for the link. But, I did not find anything on the order of the statements (but perhaps I missed it). Lets say that one connection is executing and has the lock, and two others are blocked temporarily. Then after the release, one of the other two will get access and perhaps lock the Database? But which one will get access? That is what I am trying to understand. Will the SQL statement that was submitted first get access (is it a type of queue), or is there no guarantee on this?
Thanks, -Adam On Oct 31, 1:08 am, Noel Grandin <[email protected]> wrote: > seehttp://www.h2database.com/html/features.html#multiple_connections > > > > > > > > Adam McMahon wrote: > > Hi, > > > Quick question. As I understand it, H2 handles the synchronization of > > SQL commands. If a number of SQL commands hit the database from a > > variety of connections, do they execute in the order that H2 receives > > them? If not, can a brief explanation be provided? > > > Thanks, > > > -Adam -- 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.
