Tool Reviews

Oracle

1.  TOAD (Quest) www.toadsoft.com

Tool of choice for all database development and monitoring.  Having used this tool for 6 years, I find that this tool with the DBA module presents the ideal toolset for getting stuff done timely.  It has an easy to use interface for the GUI based DBA.

2.  SQL Developer www.oracle.com/technology/products/database/sql_developer

Good supplemental tool to keep around for some additional processing power when TOAD is not cutting it.  This is a relatively new piece of software that is still evolving and its acts as such.  Check for updates frequently.  Its java-based GUI is easy on the eyes but can be a memory hog.  All processing happens at the session level rather than threads so running a long processes are not ideal.

Java

1. Eclipse www.eclipse.org

Open source tool providing the user with much more than just a standard Java IDE.  This is currently my tool of choice  since development is quick, easy and convenient.

2. Netbeans www.netbeans.org

I have not used this tool much but will be in the future since the Java CAPS IDE is moving from a closed design environment to a more mainstream tool in future versions.

Page updates

2008-01-16

Java CAPs: Architecture - design patterns for a successful EAI solution

Java CAPs: Web Services - implementation do's and don'ts

Java: JDBC Stored Proc Calls - sample code for JDBC implementation

Oracle: HS Connectivity Setup - ODBC connectivity setup on a Windows database

Oracle: Orakill - kill process for those hard to kill Oracle processes.

Oracle: PL/SQL and JSP - implementation of a Java stored procedure using PL/SQL

Oracle: Queues - Advanced queuing setup