(Hope this is an appropriate topic for this forum.)
I'm currently researching tools to help speed up the
java development process, and I was wondering what, if any, DB development tools other java developers are using? I'm primarily interested in tools which support DB2 on OS390. I only mention this because I know a few products, like Embarcaderos's RapidSQL don't.
The sorts of features I'm thinking of would include:
-visual query designer
-the ability to run,
test, debug SQL
-browsing and editing tables
-table creation
-viewing table relationships: foreign keys, indexes, etc.
-loading and unloading data
Basically, any functionality that would ease the programming development cycle, as it relates to databases.
So far I've examined DBArtisan, and WinSQLPro. DBArtisan is powerful, but perhaps overkill for a java developer. WinSQLPro seems OK, but I was wondering if there are other useful products I'm overlooking. For what it's worth, I might also add that we are not deveoping EJBs. We are primarily developing data accessor objects which encapsulate
JDBC functionality for JSPs,
Servlets, etc..
Thanks,
Kevin