creating a database and default data

Question

I would like to insert a default data in my sqlite database.

this is what i did:

private static final String DATABASE_CREATE_position = "CREATE TABLE position(latitude VARCHAR(20), longitude VARCHAR(20), address VARCHAR(100))";

@Override
public void onCreate(SQLiteDatabase db) {
    // Create the table
    db.execSQL(DATABASE_CREATE_position);   

    ContentValues defaultPos = new ContentValues();
    defaultPos.put("latitude", "40.604398");
    defaultPos.put("longitude", "-3.709002");
    defaultPos.put("address", "Avenida del parque ");   

    db.insert("position", null, defaultPos);

    db.close();

}

But the database is empty, where is the mistake?

gezdy · Accepted Answer · 2012-12-27 15:06:42Z

4

solution :

private static class DatabaseHelper extends SQLiteOpenHelper {

    DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {           
        db.execSQL(DATABASE_CREATE_position);

        db.execSQL("insert into position (latitude,longitude,address) values (40.604398,-3.709002,'Avenida del parque ')");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    ....

answered Dec 27, 2012 at 15:06

gezdy

3,3322 gold badges17 silver badges14 bronze badges

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

Comments

dmason82 · Accepted Answer · 2012-12-27 15:24:37Z

1

Get rid of the db.close() in your onCreate() function and it will insert just fine from the test code I wrote around yours. Otherwise it throws an IllegalStateException and states that the database isn't open.

answered Dec 27, 2012 at 15:24

dmason82

3994 silver badges5 bronze badges

Collectives™ on Stack Overflow

creating a database and default data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related