SQLite database file created from JDBC?

Question

I have created a SQLite database from Java. Now I want to know where it is stored physically on disk, so that I can push that file on to Android.

Aaron Digulla · Accepted Answer · 2010-10-18 12:07:40Z

3

You specified a database name as part of the JDBC connection URL. Look for a file with that name on your harddisk. Example:

jdbc:sqlite:test.db

-> look for test.db

answered Oct 18, 2010 at 12:07

Aaron Digulla

330k111 gold badges626 silver badges840 bronze badges

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

Comments

codymanix · Accepted Answer · 2010-10-18 12:09:44Z

1

SQLite usually produces one file with the extension .sqlite, but this is just convention, the extension can be anything.

As already was said, the code which opens the database spefifies the path where the file should be stored, so you have to look there.

answered Oct 18, 2010 at 12:09

codymanix

29.7k21 gold badges98 silver badges155 bronze badges

Thank you. Since I am not providing any path, the database was created at the package's location. :-)