[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

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

[Kostya Vasilyev]

http://www.sqlite.org/pragma.html#pragma_journal_mode


The OFF journaling mode disables the rollback journal completely. No
rollback journal is ever created and hence there is never a rollback
journal to delete. *The OFF journaling mode disables the atomic commit and
rollback capabilities of SQLite*. The ROLLBACK command no longer works; it
behaves in an undefined way. Applications must avoid using the ROLLBACK
command when the journal mode is OFF. *If the application crashes in the
middle of a transaction when the OFF journaling mode is set, then the
database file will very likely go corrupt.*


Are you sure you want to do this?

-- K

2012/6/7 Animesh kumar bhadra animesh.bhadr...@gmail.com

 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

-- 
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