I think the original error means exactly what it says. The data source is called by a method that is not used by the driver that you are using. In particular, the execute(..) org.sqlite.jdbc3.JDBC3Statement . The source of this driver indicates that the method does nothing. It just gives you the error message you see.
However, I think you have another version of the SQLite java driver in your class path. sqlitejdbc-v056.jar that you posted cannot cause this error because it does not even contain the JDBC3Statement class. It is likely that CF is loading another different version of the driver (that is, in your class path).
In my tests, sqlitejdbc-v056.jar worked fine with CF10. Before adding this jar again, make sure that you remove all versions of the SQLLite banner from your CF class path and restart CF. Otherwise, CF will load them automatically anyway, and you will continue to receive this error message.
To make sure that you have deleted all banks, after restarting, try creating an instance of the main class. If the line below throws a "Class not found" error, you know that you have successfully deleted everything. Once you do this, go on to install sqlitejdbc-v056.jar .
<cfset obj = createObject("java", "org.sqlite.JDBC")> If you see this text, you still have a version of the jar in your class path.
Here is what worked for me:
- Created an empty
C:/temp/sqlite/products.db database C:/temp/sqlite/products.db - Uploaded by
sqlitejdbc-v056.jar to C:\ColdFusion10\cfusion\wwwroot\WEB-INF\lib - Reloaded CF
- Created by "Other" DSN
- DSN Settings
- DS Name: SQLite
- JDBC URL: jdbc: sqlite: C: /temp/sqlite/products.db
- Driver Class: org.sqlite.JDBC