Skip to content
This repository was archived by the owner on Mar 28, 2019. It is now read-only.

Using a SQLite Browser Tool

Jump to bottom
Steven Davelaar edited this page Apr 1, 2016 · 2 revisions

There are various free GUI tools on the market that let you browse through the data of a SQLite database, execute SQL statements and inspect and modify table structures. A popular tool is the DB Browser for SQLite.

To use such tools is pretty straightforward, you install it, run it, and then open the database file of the SQLite database you want to inspect. So, all you really need to know is the location of your SQLite database file that gets created on the fly when running your application. AMPA makes this easy for you, if you change the AMPA log level to FINE, the fully qualified path to the database file will appear in your log window in JDeveloper:

[INFO - oracle.adfmf.application - DBPersistenceManager - oracle.ateam.sample.mobile.v2.persistence.manager.DBPersistenceManager] SQLite database path: /Users/sdavelaar/Library/Developer/CoreSimulator/Devices/1BC7EF2F-6846-4D82-9F6C-B756AA77CCE5/data/Containers/Data/Application/51793315-6B94-45A3-ABD3-215EC46C4DE7/Documents/HrMcsDemo.db

You can then open this file in your favorite SQLite browser tool:

Note that for these tools to work, the database should not be encrypted. Encryption of the database is configured in the mobile-persistence-config.properties file:

db.encryption=false

On a Mac, you might need to copy the file first to a visible folder before you can select it in your browser tool. The Library folder in the user directory of a Mac is a hidden folder. To view hidden folders in the Finder, you can follow these steps, or just use the Go -> Go to Folder menu in the Finder.

Clone this wiki locally