This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Learn to fish with a useful tool for database development Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Learn to fish with a useful tool for database development" Watch "Learn to fish with a useful tool for database development" New topic
Author

Learn to fish with a useful tool for database development

chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1996
    
  19

Here's a tip for all you Java developers working with Oracle or MySQL databases.

At least once a week a question pops up here on the JDBC forum, where it is clear that people have no idea how to run their SQL directly on the database, or how to inspect their tables directly, or how to explore stored procedures etc.

So in the spirit of teaching you guys to fish, can I recommend you go off to:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

and download Oracle's free SQLDeveloper tool.

This is a combination of database browser, IDE for SQL and PL/SQL, data-modeller and DDL generator for Oracle software developers. It's easy to set up, easy to use and best of all free of charge.

This will give you the ability to try out your SQL to make sure it works e.g. before posting queries here, to explore your data and your stored procedures, and generally understand what's happening on the database side of your Java/database applications. Who knows - you might even start to enjoy it!

And for those of you outside the Oracle family, it can apparently be used with other databases such as MySQL as well, although I haven't tried this myself:

http://total-bi.com/2011/07/using-sql-developer-with-mysq/

And yes, I know that Eclipse plugins will do a lot of this stuff, but it seems nobody is using them around here.


No more Blub for me, thank you, Vicar.
Sumit Bisht
Ranch Hand

Joined: Jul 02, 2008
Posts: 330

Thanks Chris for sharing the information!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Learn to fish with a useful tool for database development