|
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
ColdFusion & SQLite
I was wondering whether anyone has managed to connect SQLite to Coldfusion MX. There is a JDBCAdam Ullman 10/09/06 12:09 A The error I get when trying to add an SQLite data source is:Adam Ullman 10/09/06 02:33 A Off the hip, I'd say that it can't connect to your DB server.Denny Valliant 10/10/06 01:02 A Well the thing with SQLite is that it isn't actually a DB Server, so hence it doesn't run on a port.Adam Ullman 10/16/06 03:21 A > Well the thing with SQLite is that it isn't actually a DB Server, sMatthew Scott 11/21/06 08:17 A > Well the thing with SQLite is that it isn't actually a DB Server, soMatthew Scott 11/21/06 08:25 A I've done it with the precompiled drivers at zentus.com. I'm just writing up a blog entry on it. TheMatthew Scott 11/21/06 08:27 A I was playing around Smith and got a SQLite data source working. The steps I used are mentioned inDavid McCan 01/28/07 05:06 P
Author: Adam Ullman
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
Author: Adam Ullman
The error I get when trying to add an SQLite data source is: java.sql.SQLException: Timed out trying to establish connection
Author: Denny Valliant
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... On 10/9/06, Adam Ullman <a.ullman@edfac.usyd.edu.au> wrote: > > The error I get when trying to add an SQLite data source is: > > java.sql.SQLException: Timed out trying to establish connection >
Author: Adam Ullman
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.
Author: Matthew Scott
> Well the thing with SQLite is that it isn't actually a DB Server, so
Author: Matthew Scott
> Well the thing with SQLite is that it isn't actually a DB Server, so 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
Author: Matthew Scott
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
Author: David McCan
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
|
Mailing Lists
|
Latest Fusion Authority Articles
|
||||||
