Adobe-Runtime-Support
Adobe-Runtime-Support copied to clipboard
With Air51.1.1.3 I can no longer open CustomSQLConnection databases
My app stores important information in a SQL database (flash.data.SQLConnection) located in in applicationStorageDirectory.
This previously worked fine with Air 50.2.4.3 however after updating to Air 51.1.1.3 the databases can no longer be opened, and show message: Error #3138: File opened is not a database file.
Remaking the database works and I can use it for that session, but on the next load I can not reopen them and the error appears again.
After some testing I found the databases can still be opened repeatedly if they arent encrypted: dbConnection = new SQLConnection(); dbConnection.openAsync(dbFile);
However, with encryption they can not be reopened a 2nd time: dbConnection = new SQLConnection(); dbConnection.openAsync(dbFile, SQLMode.CREATE, null, false, 1024, encryptionKey); -> Error #3138: File opened is not a database file.
Likely related, it seems that also the EncryptedLocalStore is no longer functioning in a similar way? Values can only be stored for the current session, and the next time the app opens they are all reset.
Has something changes here? So far I have just tested this on Windows.
I need to update to 51.1.1.3 soon due to the iOS Chinese language issue so this is making me a bit nervous.