NullPointerException with Android SQLiteAssetHelper

Question

In the development of Android applications I use Android SQLiteAssetHelper. The problem is that occasionally when accessing the database I get an error to the object NullPointerException in object DBQuery

public class DBQuery extends MyDatabase {
  private static MyDatabase dataBaseHelper;

  public DBQuery(Context context) {
        super(context);
        dataBaseHelper = new MyDatabase(context);
  }

  public static void closed() {
        dataBaseHelper.close();
  }

  public static int getFDay(int year) {
    Cursor cursor = database.rawQuery("SELECT offset FROM china_years WHERE year = ?",
        new String[] { Integer.toString(year) });

    cursor.moveToFirst();
    String yearS;
    try {
      yearS = cursor.getString(0);
    } catch (Exception e) {
      yearS = "0";
      e.printStackTrace();
    }
    cursor.close();

    return Integer.parseInt(yearS);
  }

  /* other queries... */    
}

MyDatabase class:

public class MyDatabase extends SQLiteAssetHelper {

   private static final String DATABASE_NAME = "db.sqlite";
   private static final int DATABASE_VERSION = 2;      
   public static SQLiteDatabase database;

   public MyDatabase(Context context) {
     super(context, DATABASE_NAME, null, DATABASE_VERSION);

     database = getReadableDatabase();
   }
}

UDP: Sorry, null object is 'database' in DBQuery class.

have u open Database before execute getFDay(int year); – Dixit Patel Jan 04 '13 at 08:44 — Dixit Patel, Jan 04 '13 at 08:44
I open db with database = getReadableDatabase(); – bloodvlad Jan 04 '13 at 08:58 — bloodvlad, Jan 04 '13 at 08:58

score 0 · Answer 1 · answered Jan 04 '13 at 09:10

0

Add Database name Like this & check that database is create or not

 private static final String DATABASE_NAME = "Test";

data/data/YOUR_APP_PACKAGE_NAME Location

answered Jan 04 '13 at 09:10

Dixit Patel

3,190
1
24
36

Database is created normally, but works with it is not stable, it is often the object DBQuery is null. – bloodvlad Jan 04 '13 at 09:21

score -1 · Answer 2 · answered Jan 04 '13 at 12:32

-1

You have to open your data base first. Than only you can perform operation on that.

answered Jan 04 '13 at 12:32

Manoj Fegde

4,786
15
50
95

SQLiteAssetHelper.getReadableDatabase() already takes care of opening the database. – Suragch Apr 11 '15 at 03:12

NullPointerException with Android SQLiteAssetHelper

2 Answers2

Linked