Not able to open database file in SQLite manager plugin for eclipse?

Question

I downloaded the jar file and placed it in /plugins directory. Restarted eclipse as asked for eclipse to load new plugin. Opened file explorer and navigated to /package.name/databases/file.db but not able to open it in the plugin. It appears unclickable. What to do here? Check screenshot.

Answer 1

From the emulator unistall the app. Then in the code, when you create the database, name it with extension. For e.g. if your database name is MyDB, then write it as MyDB.db This will enable the Open File Icon on sqlite manager on eclipse.

Answer 2

As from your Screenshot it is clear that your database doesn't have an extension currently. Therefore it is not allowing to open the database file but if you can see here

You can delete the database from here using the "-" option delete both the database and .journal file.

Add .db extension where you are creating the ordersManager database and run the application again.(Remeber to create the database)

when you will again come to DDMS to see your database and click on ordersManager.db file the icon which i have circled will become enabled then click on it and you will be able to read data.

Also you can pull the database from device and use something like SQLLiteBrowser

Answer 3

Here are thr few useful links :

1) Link 1

2) Link 2

The mistake that you are doing is that you didn't mention the ".db" extension with your db name. Delete your previous db and name a new db with .db extention i.e. "Sample.db" try it i hope it will solve your problem.

Answer 4

You have to mark the database like you did in your screenshot but then you have to click the database icon in the top

also its better to place the plugin in the dropin folder because you haven't loaded it by a url

Answer 5

Try this download SQLite3 manager from this http://sqlitemanager.en.softonic.com/ . And install it.And pull your database (i.e. file.db ) from DDMS to now location and try to open it with using Sqlite3 manager.

And you will be able to see your database contents.

I think this is what you want.

Answer 6

Try this..

1. Download the Android Sqlite Manager here.

2. Add it to your eclipse > dropins Directory.

3. Restart eclipse and go to DDMS.

4. Select .db file in DDMS Perspective

5. click Sqlite Manger icon.

Now you're able to open the .db file.