How to create a SQLite Database in Android using the API

Question

I am unable to create a new Database using the API

SQLiteDatabase.openOrCreate(String path,CursorFactory Factory);

When I am using this API, it's throwing an exception

Unable to open database file

Please help me how to fix this exception.

database = SQLiteDatabase.openDatabase(uri.getPath(), null,SQLiteDatabase.CREATE_IF_NECESSARY); — Prachi
– Prachi, Commented Mar 2, 2011 at 5:36

Josh Lee · Accepted Answer · 2011-03-02 05:49:12Z

2

Suppose you want to create table "Settings" table and "myDB.db". Use this class to create DB and tables

public class MyDbConnector extends SQLiteOpenHelper {
    private static final String TAG = "MyDbConnector";
    public MyDbConnector(Context context) {
        super(context, "myDB.db", null, 3);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
      db.execSQL("CREATE TABLE " + Constants.TABLE_SETTINGS + " ("
              + Constants.TABLE_SETTINGS_FIELD_KEY + " TEXT PRIMARY KEY, "
              + Constants.TABLE_SETTINGS_FIELD_VALUE + " TEXT);"
              );
    }
}

And to Read/Write in DB use,

SQLiteDatabase db = new MyDbConnector(this).getReadableDatabase(); //To read tables in DB
SQLiteDatabase db = new MyDbConnector(this).getWritableDatabase(); // To write something in DB

edited Mar 2, 2011 at 5:49

Josh Lee

179k39 gold badges278 silver badges282 bronze badges

answered Mar 2, 2011 at 5:44

Jignesh Dhua

1,4821 gold badge14 silver badges31 bronze badges

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

2 Comments

Prachi Over a year ago

I want to open the Database without using the SQLiteOpenHelper Class..is it possible to open/create a database without using the OpenHelper Class?

Jignesh Dhua Over a year ago

There are easy way to do same thing, than Why you want to open Database without SQLLiteOpenHelper?

Robert Massaioli · Accepted Answer · 2011-03-02 05:27:52Z

0

I think what you want is this function: getWritableDatabase()

answered Mar 2, 2011 at 5:27

Robert Massaioli

13.5k7 gold badges59 silver badges75 bronze badges

2 Comments

Prachi Over a year ago

But how to use this method for creating a new database??

Robert Massaioli Over a year ago

@Prachi: Maybe I should have made it clear that you will have to instantiate a SQLiteOpenHelper object first and then you can call that function. Just look at the constructor for that class to see what you need to give it: developer.android.com/reference/android/database/sqlite/…

Collectives™ on Stack Overflow

How to create a SQLite Database in Android using the API

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related