Null Pointer Creating SQLite Database

Question

Why do these two lines of code throw a NPE?

SQLiteDatabase db;
db = openOrCreateDatabase("TestingData.db", SQLiteDatabase.CREATE_IF_NECESSARY, null);

Stacktrace:

08-23 10:33:14.285: ERROR/AndroidRuntime(1001): Caused by: java.lang.NullPointerException
08-23 10:33:14.285: ERROR/AndroidRuntime(1001):     at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:203)
08-23 10:33:14.285: ERROR/AndroidRuntime(1001):     at org.*****.android.CopyOfSQLLite.data(CopyOfSQLLite.java:14)
08-23 10:33:14.285: ERROR/AndroidRuntime(1001):     at org.******.android.*****.****(****.java:200)
08-23 10:33:14.285: ERROR/AndroidRuntime(1001):     at org.********.android.****.onCreate(DashboardPage.java:25)
08-23 10:33:14.285: ERROR/AndroidRuntime(1001):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
08-23 10:33:14.285: ERROR/AndroidRuntime(1001):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627)

And why are you using the method with 3 parameters if you set the last one to null? There is also a method that only expects to parameters. (developer.android.com/reference/android/database/såqlite/…) — RoflcoptrException
– RoflcoptrException, Commented Aug 23, 2011 at 10:47

njzk2 · Accepted Answer · 2011-08-23 10:48:53Z

1

Your ContextWrapper does not have a base Context. Most likely you are not calling this method at the correct place, but I cannot say more without a little more code.

answered Aug 23, 2011 at 10:48

njzk2

39.4k7 gold badges72 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aroth · Accepted Answer · 2011-08-23 10:47:50Z

0

The nice thing about Android is that it is open source. So we can see that openOrCreateDatabase() is implemented like:

public SQLiteDatabase openOrCreateDatabase(String name, int mode, CursorFactory factory) {
    return mBase.openOrCreateDatabase(name, mode, factory);
}

The only way I can see this code throwing a NPE is if mBase is null. From your calling convention I assume your class is derived from android.content.ContextWrapper? If so, are you ensuring that the base context (mBase) is set when your class is instantiated? If you aren't, then that would be what's causing the problem.

answered Aug 23, 2011 at 10:47

aroth

54.9k22 gold badges142 silver badges178 bronze badges

Collectives™ on Stack Overflow

Null Pointer Creating SQLite Database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related