Adobe Air SQLError: ‘Error #3119: Database file is currently locked.’, details:’null’, operation:’execute’

For the longest time I was having issues with this Adobe Air Error and its description, the main issue is that the “details” for this error are “null”. We do get the description that the database is locked but no details on file name where the error occur or line number.

If you do a search in the Adobe documentation you will get a pretty blank line after the error:

3119 Database file is currently locked.

To solve the issue once and for all what the error means is that you have a connection open to make changes to the database and you have opened a new connection to make more changes to the database. So there are 2 solutions

1. Use the first connection to make your second updates
2. Close the first connection and then you can use the new connection

Main entry continued

One thought on “Adobe Air SQLError: ‘Error #3119: Database file is currently locked.’, details:’null’, operation:’execute’”

  1. This post is old but as it’s coming up second on Google search I’m adding this comment here in case someone else needs the answer.

    I thought you meant two connections on my own code. That was driving me mad, I only had one SQLConnection object open in my code.

    … and then I realized I had another program connected to that SQLite database. It’s a database browser, I opened it so I could visually inspect what my Actionscript code was doing to my data. It turns out you cannot have multiple instances of SQLite databases open at the same time. I closed my database brower and voila! My Actionscript code started to work again.

    Thanks for the answer though, it was very helpful.

Comments are closed.