I want to write a note about how to enable SQLite at ColdFusion8 using JDBC Driver.
- Download the SQLite JDBC Driver
- Unzip it and get sqlite_ini.dll and sqlite.jar. Place them individually like followings:
sqlite_ini.dll => {CFroot}/runtime/jre/bin/
sqlite.jar => {CFroot}/wwwroot/WEB-INF/lib/ - Log in to CF Administrator and go to JAVA & JVM, then add ColdFusion Classpass:
{CFroot}/wwwroot/WEB-INF/lib/sqlite.jar - Restart ColdFusion 8 Application Server
- Log in to CF Administrator again and go to Datasource, then create a new datasource with database driver : other
- Setting is:
JDBC URL => jdbc:sqlite:/Full Path of the SQLite database
c.f) jdbc:sqlite:/C:/Development/test.sql
Driver Class => SQLite.JDBCDriver - Send and you would see the connection-status
Labels of resultsets has table names of SQLite database. So, souce codes should be followings:
<cfquery name="userNames" datasource="testUsers">
SELECT id, name
FROM users
</cfquery>
<cfoutput query="userNames">
#userNames.users.id# #userNames.users.name#<br />
</cfoutput>
ColdFusion & SQLite – ColdFusion Talk
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155
Message posted by Suzor – smithproject.org
http://www.smithproject.org/forum/posts/listByUser/16.page
Tags: ColdFusion, JDBC, RDBS, SQLite