I would very strongly advise you against doing this. There is
no guarantee that the binary database file will be compatible across
Android version and much less across all custom ROMs.
On Tuesday, March 13, 2012 6:00:16 AM UTC+8, Halil Enver Soylu wrote:
>
> I have a 5MB database. I split it into <1MB chuck files.
> application merges these files and creates its database.
>
> However it works in some Android phones, and does not works in others. I
> tried almost dozen of code example in blogs. everytime I got same result.
> App's platform vers. is 1.5 so it is not about platform vers.
>
> According to logs of phones that application crushs, app creates copies db
> file from Assets to database. then when it attempts to get a query for the
> first time, it crushs and gives that error:
>
> 03-11 01:11:34.111 I/Database( 4516): sqlite returned: error code = 11, msg =
> database corruption at line 46886 of [42537b6056]
> 03-11 01:11:34.111 I/Database( 4516): sqlite returned: error code = 11, msg =
> database disk image is malformed
> 03-11 01:11:34.111 D/AndroidRuntime( 4516): Shutting down VM
> 03-11 01:11:34.111 W/dalvikvm( 4516): threadid=1: thread exiting with
> uncaught exception (group=0x40018560)
> 03-11 01:11:34.111 E/AndroidRuntime( 4516): FATAL EXCEPTION: main
> 03-11 01:11:34.111 E/AndroidRuntime( 4516):
> android.database.sqlite.SQLiteDatabaseCorruptException: database disk image
> is malformed: , while compiling: SELECT Names FROM MYTABLE WHERE SayfaNo = 1
>
>
> and here is my codes that copies asset files into database
>
>
> String[] dbFiles = myContext.getAssets().list(ASSETS_DB_FOLDER);
> OutputStream myOutput = new FileOutputStream(DB_PATH+DB_NAME);
> for(int i =0; i < dbFiles.length; i++)
> {
> Log.i("FFLOG","COPYDB:"+dbFiles[i]);
> InputStream myInput =
> myContext.getAssets().open(ASSETS_DB_FOLDER+"/"+dbFiles[i]);
> byte[] buffer = new byte[1024];
> int length;
> while ((length = myInput.read(buffer)) > 0) {
> myOutput.write(buffer, 0, length);
> }
> myInput.close();
> }
> myOutput.flush();
> myOutput.close();
>
> please help me!!!!
> if there were a problem about database file or query SQL code, it would
> not work in some phones. So, it is not about db file or query. I am looking
> for a solution for 2 weeks please help me
>
--
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
