Derby Datasource: Embedded or Client

I attended CFUnited 2009 last week and I had a really great time. The last presentation that I attended was "Using Apache Derby, the Open Source Database Embedded in ColdFusion 8" by Charlie Arehart. I went to this presentation partly because I am interested in learning more about Apache Derby and partly because I try to catch at least one Charlie Arehart presentation per ColdFusion conference.

As usual for Charlie, the whole presentation was well delivered and packed with useful information. Most significant for me, however, was the difference between the two kinds of Derby datasources.

[More]

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
Ahh, that makes sense. Yeah, I had no idea what the difference was. I just assumed that Embedded was the one I needed to use.
# Posted By Ben Nadel | 8/20/09 12:46 PM
Yep. That was what I thought as well.

So what do you use to create your tables in a Derby database? The question came up during the presentation and I could only think of: DataMgr, ColdFusion 9 ORM, write SQL DDL by hand. Did I miss any good options?
# Posted By Steve Bryant | 8/20/09 1:15 PM
Steve, thanks for the post. That clears it up for me. I was just wondering about this the other day when I was poking around the administrator.
# Posted By Jason Dean | 8/21/09 9:48 AM
Yeah, they don't explain it well. I'm glad Charlie had researched it and provided such good information.

I wish I could make it to CFinNC to see you present!
# Posted By Steve Bryant | 8/21/09 3:15 PM
This was useful. Thank you.
# Posted By Caden | 5/18/12 2:33 PM
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.