Creating Database in JDBC Sqlite

Question

I am using the SQLite driver from http://code.google.com/p/sqlite-jdbc/wiki/Introduction Examples shown in the above doc shows how to connect an existing database. In my application I need to create an SQLite database. How to do that? Is it sufficient to create a file with extension `.db`? Also is there a function called `createFile()`. If so how to use it? I googled and nobody is giving a clear answer.

Accepted Answer

SQLite creates new database file on first attempt to connect if file did not exist already.

So, simply use `jdbc:sqlite:filename.db` as JDBC connection string, and provided that you have permission to create `filename.db`, it will be created automatically. You can also manually pre-create this file with `0` size if you want.

Creating Database in JDBC Sqlite

Solution

Problem