CODEWITHSUNDEEP
androidsqlite
Muhammad Maqsoodur Rehman
Muhammad Maqsoodur Rehman

Reputation: 34287

How to access an existing sqlite database in Android?

So far we have developed apps in android that create database on runtime. We like to know how can we access a pre-built or existing database/sqlite file in our android app? Please provide detail

Upvotes: 32

Views: 80496

Answers (4)

Arunendra
Arunendra

Reputation: 2194

Use this for accessing database in application : 

Context context = getApplicationContext();
context.getDatabasePath(DataBaseHelper.database_Name);

Upvotes: 0

Andres Felipe
Andres Felipe

Reputation: 684

I have followed the same road and found two issues:

  1. Include the _id field on any table you create and make sure it is part of the columns to return when you query any table.

  2. You may run into an error like Failed to open the database. closing it.. This is because we are copying the database from an existing file instead of creating tables on top of a db created by the sqlite android API and the table android_metadata may not exist. For creating it just run the following query on your db:

    CREATE TABLE android_metadata (locale TEXT);

    And add the corresponding locale, for example en_US

Upvotes: 3

James
James

Reputation: 14121

First copy your SDCARD and give it's path in the variable "DBNAME" in the following example. it will be something like "/sdcard/persons.db" if you are directly pulling it to sdcard.

Upvotes: 0

Trevor Johns
Trevor Johns

Reputation: 15782

Take a look at the documentation for android.database.sqlite.SQLiteDatabase.

In particular, there's an openDatabase() command that will access a database given a file path.

SQLiteDatabase db = SQLiteDatabase.openDatabase(path, null, 0);

Just specify the path to your database as the path variable, and it should work.

Upvotes: 41

Related Questions