Try using SQLiteAssetHelper: https://github.com/jgilfelt/android-sqlite-asset-helper
On Thu, Jul 12, 2012 at 6:46 AM, vani reddy <[email protected]> wrote: > > HI, while copying the DB file from assets to the data/data folder it is > throwing the below error message > > 07-12 16:10:25.934: E/SqliteDatabaseCpp(9002): > sqlite3_open_v2("/data/data/your.spurtree.AlmanacSQLiteDatabaseAdapter/databases/tarnea_device.db", > &handle, 1, NULL) failed > 07-12 16:10:25.954: E/SQLiteDatabase(9002): Failed to open the database. > closing it. > 07-12 16:10:25.954: E/SQLiteDatabase(9002): > android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open > database file > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.database.sqlite.SQLiteDatabase.dbopen(Native Method) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:983) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:956) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:932) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > your.spurtree.AlmanacSQLiteDatabaseAdapter.AlmanacSQLiteDatabaseAdapter.checkDatabase(AlmanacSQLiteDatabaseAdapter.java:217) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > your.spurtree.AlmanacSQLiteDatabaseAdapter.AlmanacSQLiteDatabaseAdapter.initialize(AlmanacSQLiteDatabaseAdapter.java:70) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > your.spurtree.AlmanacSQLiteDatabaseAdapter.AlmanacSQLiteDatabaseAdapter.getInstance(AlmanacSQLiteDatabaseAdapter.java:102) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > your.spurtree.AlmanacSQLiteDatabaseAdapter.AlmanacActivity$1.onClick(AlmanacActivity.java:43) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.view.View.performClick(View.java:3110) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.view.View$PerformClick.run(View.java:11934) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.os.Handler.handleCallback(Handler.java:587) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.os.Handler.dispatchMessage(Handler.java:92) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.os.Looper.loop(Looper.java:132) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > android.app.ActivityThread.main(ActivityThread.java:4123) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > java.lang.reflect.Method.invokeNative(Native Method) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > java.lang.reflect.Method.invoke(Method.java:491) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:841) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:599) > 07-12 16:10:25.954: E/SQLiteDatabase(9002): at > dalvik.system.NativeStart.main(Native Method) > > > The above error is thrown on call of : > SQLiteDatabase.openDatabase(myPath, null, > SQLiteDatabase.OPEN_READONLY); > > but database is successfully copying. > > I referred the below link > http://code.google.com/p/almanac/source/browse/trunk/Almanac/src/it/almanac/AlmanacSQLiteDatabaseAdapter.java?r=56 > How to resolve this ,Please reply :) > > -- > Regards, > Vani Reddy > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" 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/android-developers?hl=en -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android Training in NYC: http://marakana.com/training/android/ -- You received this message because you are subscribed to the Google Groups "Android Developers" 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/android-developers?hl=en
