Use sqlite database from Android app resources

Question

I've started Android programming recently so bear with me :)

I develop an app which has all of its content stored in database.sql file. I've implemented a subclass of SQLiteOpenHelper and added database.sql to my project assets.

public class DBHelper extends SQLiteOpenHelper
{
public DBHelper (Context ctx)
{
  super(ctx, "database.sql", null, 1);
}
}

This thing doesn't work. I just get an exception every time I try to do smth with DB :(

What's the exception being thrown?

Anthony Forloney
– Anthony Forloney

2009-12-12 23:30:57 +00:00
Commented Dec 12, 2009 at 23:30 — Anthony Forloney
– Anthony Forloney, Commented Dec 12, 2009 at 23:30

Alex Waddell · Accepted Answer · 2009-12-15 15:33:41Z

4

You have 3 choices when you want to create a database locally in Android; hopefully they will support deployment directly from the APK soon. The database needs to be in a specific location :

/data/data/YOUR_PACKAGE/databases/

you can download the database and write it to the database folder from a known Net location.
you can create the database using code.
you can copy the database from your assets folder to the database folder (doubles space required).

Also see http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/

answered Dec 15, 2009 at 15:33

Alex Waddell

1967 bronze badges

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

Comments

nico · Accepted Answer · 2009-12-12 23:13:20Z

1

You need to override onCreate and onUpdate as well, have a look to google's example here

answered Dec 12, 2009 at 23:13

nico

1,7481 gold badge9 silver badges8 bronze badges

7 Comments

Kostia Dombrovsky Over a year ago

I did that. I just didn't post it here because they are just stubs in my app.

nico Over a year ago

What exception are you getting?

Kostia Dombrovsky Over a year ago

I get "table mytable doesn't exist"

nico Over a year ago

Well that means you got an issue with your SQL queries. First check the query you wrote for creating the DB in the onCreate method. Since your using sqlite, have a look to the .sqlite file to check the state of your DB

Kostia Dombrovsky Over a year ago

No the problem is that an empty database is created in onCreate method instead of using my database from assets

|

Collectives™ on Stack Overflow

Use sqlite database from Android app resources

2 Answers 2

Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related