Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
ColdFusion & SQLite
Author: David McCan
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#267901
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
Author: Matthew Scott
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#261170
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
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#261169
----- 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
Author: Matthew Scott
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#261168
----- Excess quoted text cut - see Original Post for more -----
Author: Adam Ullman
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#256855
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 -----
Author: Denny Valliant
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#256067
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
>
Author: Adam Ullman
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#255947
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
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:48155#255944
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
|
May 24, 2012
|
Latest Fusion Authority Articles
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
