Using SQLite with Railo CFML Server

Posted by Quinn Madson | Posted in | Posted on 5:56 PM

1

I've been building a web app that analyzes data from an application called Ultimate Racer used to control the race track circuit for slot car racing. Ultimate Racer conveniently keeps all of it's data in a SQLite database.

However, getting the SQLite database to work with Railo was a little problematic so, I'm documenting the process here in the event that I need to do it again or someone else is googling how to make it happen.

First, you need the SQLite JDBC driver for Railo. I ran into a bunch of dead links so, I dropbox'd the file here: http://dl.dropbox.com/u/472577/sqlite-jdbc-3.7.2.jar

Place the JAR in your Railo installation under: /PATH/TO/RAILO/lib/ext/sqlite-jdbc-3.7.2.jar

Restart Railo after copying the driver. Go into the Railo Web Administrator and go to "Datasource".

Put in the name of your datasource, for type select Other - JDBC, and click Create.


Scroll down to Class and type in: org.sqlite.JDBC
For DSN type in: jdbc:sqlite:/PATH/TO/SQL/DB/FILE



Click Create and you should be all set.





Comments (1)

Thanks for this - been trying to get my Raspberry Pi working with Railo and Sqlite and your post was vital