Application Enhancements (Revision #1)

Schema Extraction & Scripting
------------------------------
1. (Oracle) Table Scripting: Added support for Table and Column comments
2. (Oracle) Added ability to Script CREATE, REPLACE, ALTER and DROP of Array Types, Table Types, Object Types and Clusters
3. (SQL Server, DB2) Scripting Table Foreign Constraints: Now supports ON DELETE and ON UPDATE clauses.
4. (SQL Server) Script Table CREATE - Support for ROWGUIDCOL
5. (Postgresql 8.0) Function Extraction: Parameter names are now extracted when generating a CREATE or CREATE/REPLACE statement.
6. (MySQL) Script Table CREATE - Support for ENUM and SET datatype
7. Table Scripting: Added "CREATE (Full)" which will script a Table CREATE for the table, constraints, indexes and triggers

Application
--------------------------
1. Aqua Data Studio Look and Feel: Made toolbars use rollover buttons, which also makes the toolbar a little smaller.
2. About Box: Added JDBC Driver tab which displays a list of available JDBC drivers in the JVM and the version numbers.
3. Memory Optimizations: Optimized the reclaiming of memory across query executions by the JVM which keeps ADS consuming less memory over time
4. Aqua Data Studio is now bundled with JRE 1.5 Update 4.
5. Added jConnect 6.0 JDBC driver and set as default driver for Sybase.
6. Added ".PKS" and ".PKB" to Script Filter defaults in File->Options->[General:General]->Script Filters

Server Registration
-------------------------
1. Server Registration: Support for setting Transaction Isolation Level in Advanced tab.
- TRANSACTION_NONE - A constant indicating that transactions are not supported.
- TRANSACTION_READ_COMMITTED - A constant indicating that dirty reads are prevented; non-repeatable reads and phantom reads can occur.
- TRANSACTION_READ_UNCOMMITTED - A constant indicating that dirty reads, non-repeatable reads and phantom reads can occur.
- TRANSACTION_REPEATABLE_READ - A constant indicating that dirty reads and non-repeatable reads are prevented; phantom reads can occur.
- TRANSACTION_SERIALIZABLE - A constant indicating that dirty reads, non-repeatable reads and phantom reads are prevented.
2. (SQL Server)Server Registration : Support for setting quoted_identifier, ansi_nulls, ansi_null_dflt_on, ansi_padding, ansi_warnings in Advanced tab.
3. (Sybase)Server Registration : Support for setting quoted_identifier in Advanced tab.
4. (SQL Server - ODBC, Informix - ODBC, Generic - ODBC) Register Server on Windows: now contains browse button to browse the available ODBC data sources.

Database Support
-----------------------------
1. MySQL 5.0 Support (requires 5.0.10 or above)
- Schema Browser: Added Constraints, Views, Triggers, Procedures and Functions
- Scripting DDL: Added Scripting CREATE/DROP for Constraints, Views, Procedures and Functions
- Visual Editing Schema: Added support to CREATE/DROP Views, Triggers, Procedures and Functions
- Visual Editing Security: Added User Database Privileges: Create View, Show View, Create Routine, Alter Routine, Create User, Execute
2. Support for Informix 10
3. Support for Sybase 15

Printing
-------------------------
1. Printing: Added new printing dialogs with extra capabilities and control to Query Anzalyzer, Procedure Editor and Explain Diagram.

Schema Browser
-----------------------------
1. (Oracle) Schema Browser: Added "Java Classes" folder to list all Java classes available in the schema.

Table Data Editor
---------------------------
1. Table Data Editor: Added a "Edit in Window" command to popup menu so users may edit CLOBs and large text fields with multi-line data.