CREATING SQLITE DATASOURCE IN COLDFUSION

To create a SQLITE datasource in Coldfusion

Steps

1. Download the latest Java class file from Zentus
2. Save downloaded file to Coldfusion8/web-inf/lib directory
3. Rename to clean the numbers if you wish
4. Restart the Coldfusion Service or reboot the server
5. Log into Coldfusion Administrator and click on datasources
6. Add a new datasouce and for driver, select OTHER
7. For the JDBC url , enter jdbc:sqlite:\Users\xxx.db
1. Where xxx.db is the sqlite database file
2. Note: Use the full path of the fule in the JDBC Url minus the drive letter
8. Driver Class is: org.sqlite.JDBC
9. Driver name is :sqlitejdbc.jar
10. Leave everything blank
11. Submit and it should be registed....Congrats