[Looking for Charlie's main web site?]

Problem creating Derby DSN? It's a bug in CF8 Standard

Note: This blog post is from 2009. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.
Here's some important news I've not seen shared elsewhere. We occasionally hear of people having problems creating Derby datasources in the CF Admin. They report that they get taken to the "other" datasource page by mistake. I've done some digging and can report the root cause: it's a bug in CF 8 Standard. You don't see the problem if you run the Developer or Enterprise edition, whether running standalone or multiserver (or "multi-instance"). It only happens on Standard (which only supports a standalone/server deployment.)

I think this is why it's been so confusing to resolve. Instead, I've seen all kinds of guesses as to the root cause. The challenge is that if you don't have a Standard license, you can't see how things work in Standard. Fortunately, I have one and just ran a test and can confirm this.

How I've demonstrated the problem

I started out on Enterprise (same on Developer), and in the CF Admin chose to create a new datasource, choosing "Apache Derby Embedded" in the "select a valid driver type", and it took me to a page asking just for the "Database folder" where the Derby DB would live, and it offered the optional "create database" checkbox. That and a description field were it. This is indeed what one SHOULD see for a Derby Embedded DSN.

But when I switched my CF license (clicking the blue "i" icon at the top right for the System Information page) to use a Standard license key, and repeated the steps above, I was taken instead to the "other" driver page, where one is prompted to enter a JDBC URL, driver class and name, and many other things that would clearly confuse someone trying to use Derby. What a shame.

Does NOT affect those adding a Derby Client DSN

I'll add that this does NOT happen when choosing the "Apache Derby Client" driver option, even in Standard, which is odd. (And again, it doesn't affect those using Enterprise or Developer edition, even if they're using the Server/Standalone mode that's closest in implementation to Standard.)

What's this Derby thing anyway?

If you're not familiar with the difference between Derby Embedded and Client, or indeed don't know much about Derby at all (the Apache database embedded in CF 8) and may wonder why one may bother to try to use it, you can check out various Derby resources I have offered on my site, including most recently a talk I gave at Max 2008, the recording of which is available here.

Bug report filed

This problem of redirecting to the wrong page seems, then, to be clearly just a bug in CF 8 Standard. I've just filed a bug report on the CF wish form, which I discuss more here for those not familiar with it. Let's hope that perhaps this is addressed in the Centaur release.

For more content like this from Charlie Arehart: Need more help with problems?
  • If you may prefer direct help, rather than digging around here/elsewhere or via comments, he can help via his online consulting services
  • See that page for more on how he can help a) over the web, safely and securely, b) usually very quickly, c) teaching you along the way, and d) with satisfaction guaranteed
On a slightly unrelated note, I used Derby for the first time last week and was able to get it set up with ease thanks to your Derby resource page! Much appreciated.
# Posted By Ben Nadel | 3/2/09 4:05 PM
Thanks for the kind regards, Ben. Nice for me to be able to repay the favor, for all your great resources. :-) Cheers.
# Posted By Charlie Arehart | 3/2/09 4:43 PM
Glad to see someone with some influence report the bug. I reported this via the adobe website months ago and never heard a thing.
# Posted By David Sparkman | 3/3/09 3:12 PM
Wow, what a shame, as I and others have sought an explanation for it, but since the bug base is not searchable, we'd not find it if someone had reported it previously. :-(

Oh well, hopefully people may find this (though that's no guarantee). Anyway, thanks for the kind regards.
# Posted By Charlie Arehart | 3/3/09 5:33 PM
Copyright ©2020 Charlie Arehart
Carehart Logo
BlogCFC was created by Raymond Camden. This blog is running version 5.005.
(Want to validate the html in this page?)

Managed Hosting Services provided by
Managed Dedicated Hosting