With this SQLite JDBC library, you have to load the driver as follows: Class.forName('') Or: DriverManager.registerDriver(new ()) 4. Jdbc:sqlite:C:/work/product.dbAnd here is the syntax of database connection URL for memory database: Jdbc:sqlite:database_file_pathWhere database_file_path can be either relative or absolute path.
SQLite JDBC database connection URLThe SQLite JDBC driver can load a SQLite database from file system or creates one in memory.Here is the syntax of database connection URL for file system database: As of this writing, the latest version is 3.7.2 which corresponds to the jar file sqlite-jdbc-3.7.2.jar.Beside Java class files, the jar file includes SQLite binaries for Windows, Linux and Mac (for both 32-bit and 64-bit).Place the sqlite-jdbc-VERSION.jar into your classpath.Ģ. The download is categorized by versions, so browse a directory for a specific version you want: 3.5.9, 3.6.16, 3.7.2, etc.
Download SQLite JDBC driverYou can download the latest version of JDBC driver for SQLite here. Although there is no official JDBC driver library from there is one provided by – an XML Database Management System project. SQLite is a simple, small, fast, reliable, server-less, zero-configuration and no-installation SQL database library which is running in-process with the client application.