I was starting a small project that requires the use of SQLite, and the number of resources for where to put everything and how to connect up railo and the SQLite jar.

First thing you need to do is head off to www.zentus.com/sqlitejdbc and download the latest SQLite jar. After you download the jar file to put it into the lib dir of your rail/resin install. For other server engines (Tomcat/glassfish) where you put the jar file may vary.

Restart Railo so the changes take effect.

Once that is in place log into your Railo web admin and select datasources. Scroll down to the section where you create the data sourece and enter the name for your datasource and select JDBC - Other for the type.

create datasource

On the next screen complete the datasource information with the important section at the bottom. For Class use org.sqlite.JDBC and for DSN use jdbc:sqllite:/path/to/sqlite/db

Complete datasource

This entry was posted on May 16, 2011 at 11:10 PM and has received 795 views. There are currently 3 comments. Print this entry.