0 Replies Latest reply on Aug 17, 2010 9:08 PM by iamcootis

    Is it possible to have a synchronous and asynchronous db connection

    iamcootis Level 1

      I am using an SQLlite database and calling all my queries synchronously. All, but one of the queries is fast, so I was wondering if I could call that one query asynchronously. I created two sqlConnections, one called sync and another async. After making the asynchronous call, I called a synchronous query and got this error:

       

      SQLError: 'Error #3119: Database file is currently locked.', details:'', operation:'execute'

       

      Do asynchronous queries always lock the database? Is it not possible to call more than one query at a time? How does this work for all asynchronous calls? Are the queries queued up and called one at a time?