<cfsilence>

Exploring Your DB With Eclipse 101 - Part 3

Posted At : November 21, 2007 10:47 AM | Posted By : todd sharp
Related Categories: Eclipse, Apache Derby

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.

Comments (3) |

Print |

Send |

del.icio.us |

Linking Blogs | 3298 Views

Comments

[Add Comment]

Have you tried any of the other DB plugins (SQL Explorer, Quantum DB)?

I've had good luck with Quantum and will have to give DTP a try.

# Posted By Jim Priest | 11/21/07 7:10 PM

I've not tried those - though they do look pretty slick. Do they have table editing/creation windows also? Bottom line for me with SQL is the more I can do with GUI the better. I'm comfortable writing SQL - but I just feel the GUI is quicker for most SQL stuff.

There are *so* many Eclipse plugins out there it's hard to keep up with all of them!

# Posted By todd sharp | 11/21/07 7:48 PM

Hi I have successfully used Quantum and DTP in the past. I personally prefer Quantum, I feel the GUI is the best.

# Posted By Firebubble Web Design | 7/21/08 7:12 PM

[Add Comment]