So I just tried to check for some updates and mysteriously 'Software Updates' is no longer an option under 'Help' (or anywhere that I can find) in Eclipse.

Not funny....

Update: Jim Priest has the answer!

I wanted to throw together a quick summary for this short series to recap.

Part 1 showed you how to install the Eclipse Data Tools Platform (DTP) and set it up to explore Apache Derby Embedded databases by pointing it at the proper Derby JDBC driver. This post also showed how to create a new Derby database from DTP.

Part 2 showed you how to introspect the newly created database, create a new table, run an SQL query and create a ColdFusion DSN pointing to the new db.

I wanted to also point out that DTP is not limited to Apache Derby DBs. If you can get your hands on your favorite DB platforms JDBC driver you can follow the same steps in this series to point DTP at your database. I haven't fully tested this yet, but I intend to. It is very very cool to be able to do just about all of my development tasks within a single IDE. I'm loving Eclipse more every day.

Hope this short series was helpful to some folks out there. Drop a line if you have any suggestions.

In my last post I showed you how to download, install, configure and connect the Eclipse Data Tools Platform to an Apache Derby Embedded database. Now I'll show you how to use the tool to create a table and do some basic queries. I'll also show how to set up your ColdFusion DSN to point to this new DB.

I started looking into the Apache Derby Embedded database late last week as an alternative for future open source projects. The first major issue I had with them was the lack of a GUI tool for managing my schema. I feel pretty comfortable with SQL but I still like having a query browser/server administrator that lets me quickly edit/add tables and columns with a graphical user interface.