How to read sqlite file stored in data/data directory in android

Question

In my android application, I am copying the sqlite database file to "data/data/com.mypackage/databases" at runtime.

I am using ormlite for database operations, but I'm not able to perform any databse operation (e.g. insert, retrieve, delete) because it is not getting any tables from the sqlite file.

However, when I copy that file in my SDCard everything works fine. I have verified that the file gets really copied in "data/data/com.mypackage/databases", which is the case.

Does anybody have any idea about how to read sqlite file stored in data/data directory using ormlite in android application?

stackoverflow.com/questions/9109438/…

Yaqub Ahmad
– Yaqub Ahmad

2012-10-11 09:03:21 +00:00
Commented Oct 11, 2012 at 9:03 — Yaqub Ahmad
– Yaqub Ahmad, Commented Oct 11, 2012 at 9:03

Naveen Kumar · Accepted Answer · 2012-10-11 05:06:43Z

1

select your file from data/data folder and pull the data base file in any location of your pc and simply open it with Firefox SQLite Manager

answered Oct 11, 2012 at 5:06

Naveen Kumar

3,8384 gold badges31 silver badges53 bronze badges

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

1 Comment

adi Over a year ago

Hey Naveen, I am not able to perform database operations in my android application when I am putting database file in data/data folder. I am getting sqlite exception that table entry not found for every table in database file.

Goofy · Accepted Answer · 2012-10-11 05:25:17Z

0

First of all if you want to read data/data folder from your device its not possible unless you r phone is rooted.

Second thing if you want to see the database in data/data of your emulator follow this:

go to DDMS Perspective.
select data/data/your package name/database/yourdatabsename
select that on the top you can find two options and one among them is pull you file.
save the file some where in your computer.
download sqlite browser by searching in google.
using the sqlite browser you can access your database.

hope it helps.

answered Oct 11, 2012 at 5:25

Goofy

6,12818 gold badges97 silver badges156 bronze badges

1 Comment

adi Over a year ago

Thanks Goofy... I have done all these steps.But I am getting sqlite exception while performing database operations in my application.

Collectives™ on Stack Overflow

How to read sqlite file stored in data/data directory in android

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related