ColdFusion & SQLite

I was wondering whether anyone has managed to connect SQLite to Coldfusion MX. There is a JDBC driver for Coldfusion but I just can't seem to get it working properly. Any help would be greatly appreciated. Adam

The error I get when trying to add an SQLite data source is: java.sql.SQLException: Timed out trying to establish connection

Off the hip, I'd say that it can't connect to your DB server. Are you sure it's running, and on the ports the driver expects? I haven't done SQLite, so I really don't know, but it's a place to start... > > The error I get when trying to add an SQLite data source is: > > java.sql.SQLException: Timed out trying to establish connection >

Well the thing with SQLite is that it isn't actually a DB Server, so hence it doesn't run on a port. It's just a DB file that is read by C or python traditionally but I found a JDBC driver for it. ----- Excess quoted text cut - see Original Post for more -----

----- Excess quoted text cut - see Original Post for more -----

----- Excess quoted text cut - see Original Post for more ----- I've done it with the precompiled drivers at zentus.com. I'm just writing up a blog entry on it. The gist is that you need the jdbc driver and compiled binary for your platform. The JDBC URL usually contains an IP and port, but with sqlite it's a file path. Example: jdbc:sqlite:/var/www/html/sqlite_test/testdb There are suggestions at sqlite.org for securing the db file, storing it outside of the webroot, etc. I'm just fooling around to see what works. I found some weirdness with different versions and creating tables, other than that it works fine. Matthew Scott Quod Scripsi, Scripsi

I've done it with the precompiled drivers at zentus.com. I'm just writing up a blog entry on it. The gist is that you need the jdbc driver and compiled binary for your platform. The JDBC URL usually contains an IP and port, but with sqlite it's a file path. Example: jdbc:sqlite:/var/www/html/sqlite_test/testdb There are suggestions at sqlite.org for securing the db file, storing it outside of the webroot, etc. I'm just fooling around to see what works. I found some weirdness with different versions and creating tables, other than that it works fine. Matthew Scott Quod Scripsi, Scripsi

I was playing around Smith and got a SQLite data source working.  The steps I used are mentioned in their forum and probably have enough hints for using the JDBC driver with CFMX: http://www.smithproject.org/forum/posts/listByUser/16.page Otherwise, I think you should be able to the SQLite ODBC driver with CFMX (which is easier to setup).   I have always used the SQLite DB browser tool to create the tables and then used PHP for the server side web stuff.  If they open source Smith then I will convert that project to CFML. Best, David