Creating An Apache Derby Data Source In CF8

June 19, 2007 7:34 AM | Chris P.
Categories : ColdFusion,Apache Derby

I know other people blogged this. But, I'm working on BlogCFC Apache Derby Support. So, I want to chronicle the steps as I go.

From the "Add New Data Source" form on the data source screen in the CF8 Administrator, select the "Apache Derby Embedded" driver. Enter a name for your data source and hit "Add". On the next screen enter the same name in the Database Folder field. Click the button to "Show Advanced Settings". Enter "create=true" into the "Connection String" field. Submit the form.

It should look like this:

Now go hit the Derby docs and have fun!

Comments (4) | Print | Linking Blogs | 1387 Views

Related Blog Entries

Comments
[Add Comment]
Morgan Dennithorne's Gravatar Hi Chris, (Just for future referance) It looks like Adobe have simplified this. There's now a checkbox called 'Create Database'.
# Posted By Morgan Dennithorne | 8/21/07 1:26 AM
Shahryar's Gravatar Hey, is the info in this post still relatively accurate?
# Posted By Shahryar | 3/29/08 3:57 PM
Chris Phillips's Gravatar Shahryar,

Yes. I just tried it. You still have to put "create=true" in the connection string field.
Odd how they never made that easier with a button or something...
# Posted By Chris Phillips | 3/31/08 3:46 PM
Charlie Arehart's Gravatar I realize this post and these comments are old, but I wanted to follow up on something. Chris, you say in your last comment, when others have said there's a new "create database" checkbox, that you're finding "you still have to put "create=true" in the connection string field". I wonder: are you using the Apache Derby Embedded driver when setting up datasource in the CF admin? If so, the checkbox should be there and should not require additional connection string value. On the other hand, if you're using the Apache Derby Client driver in the Admin, then yes, I find it does not have the checkbox and you do need to add that checkbox. (You also need to have started the Derby Network Server, but that's an entirely different topic.) Hope that helps someone.

I'll be speaking on Derby in CF8 at this coming Adobe Max conference. I'll have lots more tips to share, some of which I already offer in a resource at http://carehart.org/resourcelists/derby_for_CFers/...,if readers here are interested in more on using Derby in CF.

Thanks for your work on the DerbyCFC, Chris. I have long mentioned that on the resource.
# Posted By Charlie Arehart | 8/1/08 11:55 PM
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.6.002.