Hi Charlie, Thank you kindly for this. I was actually in the process of working this out for myself because I was sure it could be done because I'd seen Derby embedded in web applications running under Tomcat before and was certain it would also run with CF. I had actually got as far as getting the connection to succesfully verify, but appreciate you posting the blog entry and other links. The 1-minute Derby Query Manager in particular is going to be a massive help. :-)
All the best, Andrew. On Fri, 24 Apr 2009 08:42:10 +1000, charlie arehart <[email protected]> wrote: > > Hi Andrew, yes, you could implement Derby in embedded mode in CF 7, or as > you note, you could instead run it in its server mode and have a CF DSN > point to that. It's just that for CF 7, it's not provided for you by > Adobe > but instead you need to go get it from the Derby site, and then to sue > the > embedded mode you'd need to point CF's classpath at the derby directory. > > Fortunately, there's an article that was done during the CF8 beta and > while > it doesn't specifically mention installing it for CF7, it does talk about > how to get and install it (even for CF8) because the version embedded in > CF > is a little old. There's also at least one blog entry on the topic of > using > Derby with CF7: > http://nagpals.com/blog/post.cfm/installing-apache-derby-database-on-coldfus > ionmx-7-0-2 > > Once installed, things really work the same way in CF 7 as in CF 8, > whether > using the embedded or network server. The difference is simply that Adobe > embedded the needed jars within CF (both in terms of the files in > directories within CF and in terms of pointing CFs classpath at those > directories so that a call to an embedded DB just "works" automatically.) > > Hope that's helpful. > > Some will know that I'm also a bit of an evangelist about Derby for > CFers. > Besides a talk I did at Max (link to the recording at > http://www.carehart.org/blog/client/index.cfm/2009/3/2/using_derby_video), > I > also have a resource page at > http://www.carehart.org/resourcelists/derby_for_CFers/. There's also a > Derby > group (kind of languished) on the CF community site: > http://www.coldfusioncommunity.org/group/derby. > > /charlie > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf > Of Andrew > Sent: Thursday, April 23, 2009 1:16 AM > To: cfaussie > Subject: [cfaussie] Apache Derby & CF7 > > > Hi, > > As I understand it, CF8 has derby embedded (although as yet I haven't > used it). Is it possible to embed a derby database inside a CF7 app? > > Or alternatively, if I start derby in server mode, and create a JDBC > connection to it from CF7, that'll work won't it? > > I'd try this all out myself but I'm a bit "time poor" at the moment. > If anyone has gone through the process and can tell me if it'll work > or otherwise, that would be greatly appreciated. > > Regards, > Andrew. > > > > > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
