CF & 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 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF & SQLite
The error I get when trying to add an SQLite data source is: java.sql.SQLException: Timed out trying to establish connection ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF & SQLite
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 <[EMAIL PROTECTED]> wrote: > > The error I get when trying to add an SQLite data source is: > > java.sql.SQLException: Timed out trying to establish connection > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF & SQLite
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. >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 <[EMAIL PROTECTED]> wrote: >> >> The error I get when trying to add an SQLite data source is: >> >> java.sql.SQLException: Timed out trying to establish connection >> ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF & SQLite
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 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4