- Apache Derby

Using Squirrel To Connect To A Derby Database

Wed, 20 Jun 2007 20:39:00 -0700

Last post I went over simple instruction for creating a Derby datasource under CF8. So, I am just going to admit it... I am a GUI kind of guy. So, the first thing I wanted after I created a Derby database was a visual client to connect to and manage that database. I had heard SQuirreL mentioned on Ben's blog. So, I'm using that. The instructions found here will get you up and running with just a couple of notes. So, if you want to use the SQuirreL SQL client to manage your Derby databases, then follow those instructions keeping the following notes in mind.

When you are configuring SQuirreL for the Derby Embedded JDBC Driver, you can point it at the derby jar in your CF8 install. Mine, for example, was C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib\derby.jar.
When you are creating the Alias to your Derby database, use the full path to the folder ColdFusion 8 creates. Again, for example, I used jdbc:derby:C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\db\blogdev.
Important: You can only have one client connected to a Derby Embedded database (that includes ColdFusion). So, you will have to stop CF8 to get SQuirreL to connect. And you will have to disconnect SQuirreL and exit to allow CF8 to re-attach to the Derby datasource.

That'll get you connected. After that, you're on your own...

Creating An Apache Derby Data Source In CF8

Tue, 19 Jun 2007 07:34:00 -0700

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!

BlogCFC Derby Support

Sun, 17 Jun 2007 09:14:00 -0700

So, I managed to volunteer myself to code (if possible) Derby support into BlogCFC. I'm brand spankin' new to Derby. I managed to tweak the table create scripts enough to get them to run. That is as far as I have gotten. I hope to start looking into the scope of the project tonight. Who knows, maybe it'll be less work than I imagine. :-) However, if it should turn out to be difficult or I run into an issue that I am having trouble with, it would be nice to have someone who knows Derby at my disposal. So, if you have some experience with Derby and would like to help if I get stuck, then add a comment here. I'll keep you all up-to-date as I get into the meat of the project...