Open DB connection from an IntentService Constructor

Question

When trying to open up a DB connection via the normal mechanism a `nullpointerexecption` is thrown at the point `dbhelper.getWritableDatabase`. The problem seems to stem from the `IntentService` context I am passing in. ``` public AnalysisService() { super("AnalysisService"); Log.d("ANALYSIS_SERVICE", "Service started"); try{ db = new DBAdapter(this) db.openDB(); }catch(Exception e){ Log.d("ANALYSIS_SERVICE", Arrays.toString(e.getStackTrace())); Log.e("ANALYSIS_SERVICE", e.toString()); } } ``` The `db.open` method is executed here: ``` public class DBAdapter implements Database { protected Context context; protected SQLiteDatabase db; private DatabaseHelper dbHelper; public DBAdapter(Context context) { this.context = context; Log.e("DB_ADAPTER", "CREATED"); } /** * Opens a database connection. * @return * @throws SQLException */ @Override public DBAdapter openDB() throws SQLException { dbHelper = new DatabaseHelper(context); db = dbHelper.getWritableDatabase(); //NULLP EXCEPTION THROW…

Accepted Answer

You're setting the context too early in the `IntentService` lifecycle.

Override `onCreate` and set it there:

```
@Override
public void onCreate() {
    super.onCreate();
    Log.d("ANALYSIS_SERVICE", "Service started");
    db = DatabaseFactory.getDefault(this);
}
```

Then open the database connection in `onHandleIntent`:

```
@Override
protected void onHandleIntent(Intent intent) {
    // Logging
    Log.d("ANALYSIS_SERVICE", "Intent handled");

try {
        db.openDB();
    } catch (Exception e) {
        Log.d("ANALYSIS_SERVICE", "Unable to open database");
        e.printStackTrace();
    }
}
```

Open DB connection from an IntentService Constructor

Solution

Problem