Database processing stopped working on Android 2.2.1 (Desire HD 1.72.405.3)

Question

For some reason, the database processing solution described in this article does not work on HTC Desire HD after it has updated OTA to version 2.2.1 (1.72.405.3). He worked on Desire HD before the update, and I could not reproduce the error on real devices running 2.1, 2.2, and also in an emulator that runs all versions.

Unfortunately, you cannot create an AVD for an emulator running Android 2.2.1, and I tried ROM based on 2.2.1 (I have the usual usual HTC Desire), but my application works without problems on it. So the question is, using the Android SDK in some way, this was not supposed to suddenly cause a problem?

I know this is a very specific problem, but since there are more developers than I report the problem, as well as the fact that you cannot create AVD, I hope this issue is accepted and I hope someone knows that may cause a problem.

Here's the stack trace sent by the user to my Market account:

Caused by: android.database.sqlite.SQLiteDiskIOException: disk I/O error at android.database.sqlite.SQLiteDatabase.native_setLocale(Native Method) at android.database.sqlite.SQLiteDatabase.setLocale(SQLiteDatabase.java:2049) at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1917) at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:889) at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:168) at com.MyApp.DataBaseHelper.createDataBase(DataBaseHelper.java:81) at com.MyApp.InitialActivity.onCreate(InitialActivity.java:33) at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2797) at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1066) 

Related methods can be found in pastebin. Since only one hyperlink can be included, the link can be found in the comments below. Note that line 81 found in the stack trace is line 10 in pastebin.

Answer 1

I finally got my application for running on Android 2.2.1 on Desire HD. I did not have the opportunity to debug it personally to find out exactly what causes the problem.

One thought that came up was the hard-coded path to the database file. DB_PATH = "/ data / data / YOUR_PACKAGE / databases /";

I think it is possible that this path is not valid on Android 2.2.1 for Desire HD. I exchanged this path: Environment.getDataDirectory () + "/ data / YOUR_PACKAGE / databases /" + DB_NAME;

Try to indicate the problem when I had the opportunity to check on the phone itself. If someone checks this solution, let me know if he will allow it.

Answer 2

as well as a great answer from Björn, this link worked for me:

Link to AndDev.org

It seems you need to explicitly close return this.getReadableDatabase ();