User`s guide

SQLite JDBC for Mac OS X
2-165
If Database Explorer is docked, click the Close button ( ) to close all database
connections and Database Explorer.
Connect to SQLite using the JDBC connection command line.
When using the command line, you do not have to set up a data source with Database
Explorer. You can use the command line to pass all the required parameters for
connection.
1
Create a URL string using the format jdbc:subprotocol:subname. The jdbc
part of this string stays constant for any JDBC driver. subprotocol is a database
type. In this case, subprotocol is sqlite. The last part of the URL string is
subname. For SQLite, this contains the location of the database. For example, your
string is jdbc:sqlite:dbpath, where dbpath is the full path to your SQLite
database on your computer.
2
Connect to the SQLite database by using the database function. Enter the full
path to your SQLite database dbpath for the first argument, or leave this argument
blank and include the full path in the URL string URL. Enter your user name
username and your password pwd, or leave these blank if your database does not
require them. The fourth argument is the driver Java class object. This code assumes
the class object is org.sqlite.JDBC. The last argument is the URL string URL.
conn = database(dbpath,username,pwd,'org.sqlite.JDBC','URL');
3
Close the database connection conn.