SQLiteOpenHelper not calling onUpgrade

[Alexander-Campbell]

Hello,
I have upgraded my version of SQLCipher from 1.1.0 to 2.0.8, in order to get this to work I require to call upgradeDatabaseFormatFromVersion1To2 on the 1.1.0 DBs. How I have tried to implement this is to increase the DB version and then in the onUpgrade function call the upgradeDatabaseFormatFromVersion1To2 function.

The problem I am having is the onUpgrade function is not being called when I create my SQLiteOpenHelper class. I have check the versions of the DB using getVersion(), they are correct. I have also manually called the upgradeDatabaseFormatFromVersion1To2 function on a 1.1 DB and when I import the DB it works fine.

Any ideas why the onUpgrade is not firing, I thought of function template changes, or maybe the order in which I am calling these functions.

[developernotes]

Hi Alexander-Campbell,

There are two things you should check, first verify that you are passing the new version number to the constructor of SQLiteOpenHelper. Note that it won't call the onUpgrade function until a request for either getReadableDatabase() or getWritableDatabase() is made. You will want to look into where you call either of those methods within your application. We also have a test that verifies this here.

[Alexander-Campbell]

Hello,
So in fact the events are firing correctly. What I think is raising the exception is trying to open the DB (with Cipher1.0.1) with the 2.0.8 libararies. This will happen before trying to call the upgradeDatabaseFormatFromVersion1To2 from the onUpgrade function in the SQLiteOpenHelper class.

What I have done is call the getWritableDatabase function if this throws an exception, then I call upgradeDatabaseFormatFromVersion1To2 and call again getWritableDatabase, this works but is not the ideal solution.

Is there any way to detect the SQLCipher version on a DB before calling the getReadable/WriteableDatabase ? That way I can know more exactly when to call the upgrade procedure.

thanks

[developernotes]

Hi Alexander-Campbell,

A read request would throw a SQLiteException - something like select count(*) from sqlite_master; should suffice. You could then trap the exception and handle your upgrade process.

[BharathiKasi]

hi all actually when you change the database version on
public className extends sqliteOnHelper{

className(Context context){
super(context, // your database name-- DATABASE_NAME, // you cursorFactory -- null, you current version -- 2);
}
}
so the version is match with older version then it won't invoke the method called
onUpgrade (SQLitedatase,int olderversion ,int newVersion)
if suppose you enter the new version then it wil invoke the onUpgrade method.
i am newer to android as of my knowledge i post this .
Thank you.

[developernotes]

Hi @BharathiKasi

Yes, increasing the version number supplied to the constructor argument of the SQLiteOpenHelper will trigger onUpgrade when requesting the database. If you have any further questions related to SQLCipher, please feel free to post them in our Community Discuss site here. Thanks!