aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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: 1770
    
  14

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: 329

Thanks Chris for sharing the information!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Learn to fish with a useful tool for database development