Exploring Your DB With Eclipse 101 - Part 3

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.

Exploring Your DB With Eclipse 101 - Part 2

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.

[More]

Exploring Your DB With Eclipse 101 (Including Derby DBs!)

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.

[More]

cfunited08

cfunited08

Calendar

Sun Mon Tue Wed Thu Fri Sat
    123
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Subscribe

Enter your email address to subscribe to this blog.

Tags

actionscript ajax blogging cfsnippets coldfusion flash forms flex misc model-glue off topic personal project learn sql

Recent Comments

Hosting Advice Needed
todd sharp said: Must have been on a box that I'm not on. Thank goodness too, because all of my sites (this blog, cf... [More]

Hosting Advice Needed
Oğuz Demirkapı said: No. And the tickets are still open in support system. :) I think they had a big outage and still ... [More]

Hosting Advice Needed
todd sharp said: Did they say what caused such a long outage? [More]

Hosting Advice Needed
Oğuz Demirkapı said: VPS is back after 13 hours. :) [More]

Hosting Advice Needed
Oğuz Demirkapı said: 12 hours now since the server is down. :( [More]

RSS


coldfusionbloggers

FullAsAGoog MXNA

Consumed By Feed-Squirrel.com