smithproject.org

I have a Sqlite database file that I am using with a PHP project. I thought I would see if I could get Smith working with it. This is how I got it working (after some searching and study):

These instructions for SQLite on Eclipse were helpful:
http://wiki.eclipse.org/index.php/Connecting_to_SQLite

-- Basically, download the JDBC driver package for windows (javasqlite-20060714-win32.zip) from here: http://www.ch-werner.de/javasqlite/

-- From the zip file put the sqlite_jni.dll file into the Smith project JRE's bin directory. The driver requires this file to be in the java library path.

-- Put the sqlite.jar file from the zip file into the Smith wwwroot\WEB-INF\lib directory.

-- Start or restart Smith and go to the data sources page in the admin window.

-- Enter values along these lines:
-- a name for your database
-- JDBC URL: jdbc:sqlite:/c:/Tools/smith/wwwroot/sqlite/myfile.db
-- JDBC Driver full class name: SQLite,JDBCDriver

The JDBC URL is the file location.

Hope this helps someone.

Suzor

Thanks Suzor!

Link to JDBC driver package for SQLite is now added to Smith Project download section.