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. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
