This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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:
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: