Exploring Your DB With Eclipse 101 - Part 3

Posted By : todd sharp Posted At : November 21, 2007 9:47 AM Posted In: Eclipse, Apache Derby

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.

4301 Views Send Print Comments (3)

Comments (3)

Subscribe to Comments Add Comment

Jim Priest's Gravatar 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 on: 11/21/07 7:10 PM

todd sharp's Gravatar 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 on: 11/21/07 7:48 PM

Firebubble Web Design's Gravatar 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 on: 7/21/08 7:12 PM
Add Comment

  • Calendar

    << March 2010 >>
    Sun Mon Tue Wed Thu Fri Sat
     123456
    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.