Database is not created in sqlite

Question

There is two database is already in my project and want to create a new database for some task but database is not created i think i am doing something wrong in my code please help me out this problem. Thanks.

public class LikeShareDbHelper extends SQLiteOpenHelper{
    static final int version = 10;
    static final String dbName = "LikeShareDB";
    static final String LikeAndShare = "LikeAndShareTable";
    static final String coluId = "id";
    static final String coluTask = "Task_id";
    static final String coluLike = "TLike";
    static final String coluComment = "TComment";
    static final String coluTSahre = "Tshare";
    static final String coluMySelf = "mtself";

    private static final String DATABASE_CREATE = "CREATE TABLE "
            + LikeAndShare + " (" + coluId
            + " INTEGER PRIMARY KEY AUTOINCREMENT, " + coluTask + " TEXT, "
            + coluLike + " TEXT, " + coluComment + " TEXT, " + coluTSahre
            + " Text, " + coluMySelf + " TEXT );";

    SQLiteDatabase db;
    private LikeShareDbHelper dbHelper;

    public LikeShareDbHelper(Context context) {
        super(context, dbName, null, version);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL(DATABASE_CREATE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        db.execSQL("DROP TABLE IF EXISTS " + LikeAndShare);
        onCreate(db);

    }


    public LikeShareDbHelper open() throws SQLException {
        db = dbHelper.getWritableDatabase();
        // dbHelper.open();
        return this;
    }

    // ---closes the database---
    public void close() {
        dbHelper.close();
    }


}

@deep-u have given permisson in android mainfest.xml file for external storage. — FarhaSameer786
– FarhaSameer786, Commented Sep 28, 2013 at 7:34
@deep-i have added my code i have sucessfully created database u just created like this... — FarhaSameer786
– FarhaSameer786, Commented Sep 28, 2013 at 7:47

FarhaSameer786 · Accepted Answer · 2013-09-28 07:39:25Z

Try like this ..more helpful for u

package com.databases;

import java.util.ArrayList;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

public class DataBaseHelper extends SQLiteOpenHelper {

    Context mContext;

    private static final String DATABASE_NAME = "Personal_Assistant_Chronical.db";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_DETAIL = "newContact";

    private static final String COLUMN_PERSON_ID= "personID";
    private static final String COLUMN_PERSON_NAME= "person_name";
    private static final String COLUMN_MOBILE_NUMBER = "mobile_no";
    private static final String COLUMN_LANDLINE_NUMBER = "lanline_no";
    private static final String COLUMN_FAX_NUMBER = "fax_no";
    private static final String COLUMN_EMAIL_ID = "email_id";
    private static final String COLUMN_PERSONAL_ADDRESS = "personal_address";
    private static final String COLUMN_WORK_ADDRESS = "work_address";

    private static final String CREATE_DETAIL_TABLE = "create table if not exists "
            + TABLE_DETAIL
            + "("
            + COLUMN_PERSON_ID
            +" INTEGER primary key autoincrement, "
            + COLUMN_PERSON_NAME
            + " VARCHAR(100) NOT NULL UNIQUE, "
            + COLUMN_MOBILE_NUMBER
            + " VARCHAR(100) NOT NULL , "
            + COLUMN_LANDLINE_NUMBER
            + " VARCHAR(100) NOT NULL, "
            + COLUMN_FAX_NUMBER
            + " VARCHAR(100) NOT NULL, "
            + COLUMN_EMAIL_ID
            + " VARCHAR(100) NOT NULL, "
            + COLUMN_PERSONAL_ADDRESS
            + " VARCHAR(100) NOT NULL, "
            + COLUMN_WORK_ADDRESS
            + " VARCHAR(100) NOT NULL); "
            ;
    private static final String TABLE_PERSONAL = "newPersonal";

    private static final String COLUMN_DATE_ID= "dateID";
    private static final String COLUMN_DATE= "fate";
    private static final String COLUMN_DIARY= "diary";

    private static final String CREATE_PERSONAL_TABLE = "create table if not exists "
            + TABLE_PERSONAL
            + "("
            + COLUMN_DATE_ID
            +" INTEGER primary key autoincrement , "
            + COLUMN_DATE
            +" VARCHAR(100) NOT NULL UNIQUE, "
            + COLUMN_DIARY
            + " VARCHAR(100) NOT NULL); "

            ;   


    public DataBaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        this.mContext=context;
    }

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

    }

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

        if (db != null)
            onCreate(db);
    }


        }

fasteque · Accepted Answer · 2013-09-28 07:38:35Z

0

Please elaborate a bit more your problem. You said "I think" to tell us the database is not created. What did you check to be 100% sure about that?

Also, do not use "id" but "_id". It is already defined for you by BaseColumns._ID.

answered Sep 28, 2013 at 7:38

fasteque

4,3498 gold badges42 silver badges53 bronze badges

3 Comments

fasteque Over a year ago

Ok just curious about what you did to check the database is not there. Did you try to write something an got an error? Did you try changing id to _id?

Deepak Over a year ago

ya i write _id instead of id and i am checking in ddms->data->project package name. there two old database is there but new which i am creating is not there.

FarhaSameer786 Over a year ago

@deep-just delete your both database by command promt and created again new database

Kanwaljit Singh · Accepted Answer · 2013-09-28 07:58:56Z

0

private static final String DATABASE_CREATE = "CREATE TABLE "
            + LikeAndShare + " (" + coluId
            + " INTEGER PRIMARY KEY AUTOINCREMENT, " + coluTask + " TEXT, "
            + coluLike + " TEXT, " + coluComment + " TEXT, " + coluTSahre
            + " Text, " + coluMySelf + " TEXT )";

Replace this code with your code. Hope its work.

answered Sep 28, 2013 at 7:58

Kanwaljit Singh

4,3872 gold badges21 silver badges22 bronze badges

1 Comment

Kanwaljit Singh Over a year ago

Or you can take help from this link. androidhive.info/2011/11/android-sqlite-database-tutorial

Rishabh Srivastava · Accepted Answer · 2013-09-28 10:02:53Z

0

Database onCreate method is called when the database is opened via getWritableDatabase....try doing it.

answered Sep 28, 2013 at 10:02

Rishabh Srivastava

3,7452 gold badges32 silver badges58 bronze badges

Collectives™ on Stack Overflow

Database is not created in sqlite

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related