Steps
- Download the latest Java class file from Zentus
- Save downloaded file to Coldfusion8/web-inf/lib directory
- Rename to clean the numbers if you wish
- Restart the Coldfusion Service or reboot the server
- Log into Coldfusion Administrator and click on datasources
- Add a new datasouce and for driver, select OTHER
- For the JDBC url , enter jdbc:sqlite:\Users\xxx.db
- Where xxx.db is the sqlite database file
- Note: Use the full path of the fule in the JDBC Url minus the drive letter
- Driver Class is: org.sqlite.JDBC
- Driver name is :sqlitejdbc.jar
- Leave everything blank
- Submit and it should be registed....Congrats
2 comments:
I successfully created the ColdFusion Datasource. I have the following script on my webpage:
SELECT
id AS Ticket_Number,
summary AS Summary,
status AS Status,
created_at AS Created_At,
assigned_to AS Assigned_to
FROM tickets
WHERE status = 'open' AND assigned_to IS NULL
ORDER BY Created_At DESC
But when I go to my webpage, I get the following error
Error Executing Database Query.
not implemented by SQLite JDBC driver
The error occurred in C:/Inetpub/wwwroot/intra/SmartTV/UnassignedTickets/Tickets.cfm: line 201
199 :
200 :
201 :
202 : SELECT
203 : id AS Ticket_Number,
"line 201 is my cfquery line, but the post did not show it"
Post a Comment