disable sqlite in the admob api

342 views
Skip to first unread message

Julian Avram

unread,
Apr 11, 2012, 10:52:10 AM4/11/12
to Google AdMob Ads Developers
My app has a webview and the webview uses an sqlite database. All
works fine without admob.
After adding admob, the app will crash when the webview attempts to
connect to the sqlite database with:
SQLiteException: error code 5: database is locked

Of course everything works properly when the app doesn't use sqlite.
Just wondering is there some setting I can
use for admob not to use sqlite?

Julian

JDTheProgrammer

unread,
Apr 11, 2012, 11:26:33 PM4/11/12
to google-adm...@googlegroups.com
As far as I understand, your conflict is arising due to Admob and Webview using the same database.

But I dont think so that it works that way.

Admob will have its own database and Webview uses its 
own database for the purpose of caching urls and files.

I have fiddled lot much with applications using both Webview and Admob.
I never came across this issue.

May be you should put the stacktrace in here so that 
we can identify and figure out what is causing the problem 

Julian Avram

unread,
Apr 16, 2012, 6:03:15 PM4/16/12
to Google AdMob Ads Developers
I/SqliteDatabaseCpp(15282): sqlite returned: error code = 5, msg =
statement aborts at 1: [PRAGMA journal_mode=TRUNCATE] , db=/data/data/
com.phonegap/databases/webview.db
E/webcoreglue(15282): *** Uncaught exception returned from Java call!
W/System.err(15282):
android.database.sqlite.SQLiteDatabaseLockedException: error code 5:
database is locked
W/System.err(15282): at
android.database.sqlite.SQLiteStatement.native_1x1_string(Native
Method)
W/System.err(15282): at
android.database.sqlite.SQLiteStatement.simpleQueryForString(SQLiteStatement.java:
161)
W/System.err(15282): at
android.database.DatabaseUtils.stringForQuery(DatabaseUtils.java:813)
W/System.err(15282): at
android.database.DatabaseUtils.stringForQuery(DatabaseUtils.java:801)
W/System.err(15282): at
android.database.sqlite.SQLiteDatabase.setJournalMode(SQLiteDatabase.java:
1060)
W/System.err(15282): at
android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:
996)
W/System.err(15282): at
android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:
962)
W/System.err(15282): at
android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:
1043)
W/System.err(15282): at
com.phonegap.Storage.openDatabase(Storage.java:153)
W/System.err(15282): at com.phonegap.Storage.execute(Storage.java:61)
W/System.err(15282): at
com.phonegap.api.PluginManager.exec(PluginManager.java:112)
W/System.err(15282): at
android.webkit.WebViewCore.nativeTouchUp(Native Method)
W/System.err(15282): at
android.webkit.WebViewCore.nativeTouchUp(Native Method)
W/System.err(15282): at android.webkit.WebViewCore.access
$3900(WebViewCore.java:55)
W/System.err(15282): at android.webkit.WebViewCore$EventHub
$1.handleMessage(WebViewCore.java:1378)
W/System.err(15282): at
android.os.Handler.dispatchMessage(Handler.java:99)
W/System.err(15282): at android.os.Looper.loop(Looper.java:137)
W/System.err(15282): at android.webkit.WebViewCore
$WebCoreThread.run(WebViewCore.java:728)
W/System.err(15282): at java.lang.Thread.run(Thread.java:856)
Reply all
Reply to author
Forward
0 new messages