Coldfusion 10 and Sqlite - can it work?

I have a current CF9 app that uses sqlite for some small database interactions.   To get this working, the latest sqlite driver (sqlitejdbc-v056.jar) had to be put in the Jrun/lib directory. In CF10, with Tomcat replacing JRun (and there's still no "SQLite" datasource type in the admin), I'm trying to find out: a) if I can still use the SQLite databases with CF10 and b) what's needed to get the datasources connected in CF10 Any help/insight at all would be greatly appreciated.   Thanks!

> I have a current CF9 app that uses sqlite for some small database interactions.  To get this working, the latest > sqlite driver (sqlitejdbc-v056.jar) had to be put in the Jrun/lib directory. > > In CF10, with Tomcat replacing JRun (and there's still no "SQLite" datasource type in the admin), I'm trying to find out: > a) if I can still use the SQLite databases with CF10 and > b) what's needed to get the datasources connected in CF10 I haven't actually tried it, but CF 10 supports adding database drivers just like CF 9 did. You can read the exact steps in the online documentation: http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf3639b1-7fe6.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite

----- Excess quoted text cut - see Original Post for more ----- onsite Thanks Dave!  I'll give that a try!

>onsite > >Thanks Dave!  I'll give that a try! Got it working by installing the driver in C:\Coldfusion10\cfusion\lib.   The documentation would have you believe that I should have installed it in cf_root/lib.  Translated literally for me that would have been:   C:\Coldfusion\lib\[driver].  In the CF10 default file structure, however, there is no cf_root/lib directory. The top level directories under cf_root are: cfusion, jre, config and uninstalll.