[android-developers] how to avoid the creation of journal file in android.

[Animesh kumar bhadra]

Hi All,

I read through these two links:-

   1.
   
http://stackoverflow.com/questions/10046596/android-sqlite-journal-how-to-disable
   2.
   
http://www.android-app-market.com/sqlite-optimization-in-android-programming-sqlite-optimization-in-android-apps.html

and wanted to implement these and avoid the creation of journal file.

Here is my code:-

public void onOpen(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.rawQuery("PRAGMA journal_mode=DELETE",null);
        System.out.println("EventsData.onOpen()");
        super.onOpen(db);
    }
which is according to option 1 listed above, i also tried OFF in place of
DELETE in the above query.

also as per the second option i did this:-
private void addEvent() {
        SQLiteDatabase db = events.getWritableDatabase();
        ContentValues values = new ContentValues();

        db.beginTransaction();
        try {
            for(int i = 5; i < 10; i++){
                values.put(TIME, System.currentTimeMillis());
                values.put(TITLE, "MyString "+i);
                db.insertOrThrow(TABLE_NAME, null, values);
            }
            db.setTransactionSuccessful();
        }finally{
            db.endTransaction();
            events.close();
        }
    }

but in both the case the journal file is getting created, can anyone please
let me know why is this happening and how can i avoid it?

Any help will be appreciated.

Regards,
Animesh K. Bhadra.

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en