9.0.5 FIX: Server Registration : ODBC Datasource browser for 64bit now lists 64bit sources. FIX: ER Modeler : Database Compare didn't have all the options that the Schema Compare had FIX: Save Results to Delimited Text would wrap http:// values with tag FIX: Oracle : Table Data Editor : If a compound key contains data type of RAW, then UPDATEs and DELETEs would not take effect FIX: Apache Derby : Fix on handling boolean to support version 10.6.x FIX: SQL Server : Added option for NOCHECK in DDL FIX: Sybase ASE : Script CREATE TABLE on default segment now quotes default since it is a keyword. FIX: Typo in Open API AQSqlFormatter.setUseTabIdent method ENHANCEMENT: Added Open API aqua.system.getProperty(), aqua.request.getRemoteHost() and aqua.request.getRemoteAddr() 9.0.4 FIX: ER Modeler : When comparing Model to Database never use Database name in fully qualified name, otherwise all objects are different. FIX: Table Data Editor openning from Schema browser doesn't have limit to 1000 FIX: DB2 LUW : Differentiated between ASC/DESC columns in an index & INCLUDED columns in the extraction. FIX: Apache Derby : Version 10.6+ queries comparing boolean columns can no longer use 0/1, must use 't' or 'f' now FIX: Query Window : CTRL-ENTER will auto-complete popup is up would not execute current statement. ENHANCEMENT: Enabled access to Swing/AWT in Open API. 9.0.3 ENHANCEMENT: Added option File->Option->Results->Grid Results->[Persist sort across execution] 9.0.2 FIX: Procedure Editor : Execution of procedure remembers parameter values of previous execution. FIX: nCluster : datatypes returning null type now made to varchar to minimize issues. FIX: I18N : Object Permission Dialog did not work on non-English interface because of I18N bug. FIX: Aqua Commands : parameter parser did not work in certain scenarios FIX: RunScript.sh/.bat : would not exist after execution of script. 9.0.1 FIX: Charts : Changed the method or repainting charts on AWT window. Paints smoother and prevents crash on unreliable Windows video drivers. 9.0.0 FIX: Merged 8.0.27 fixes FIX: DB2 iSeries : Extraction/Scripting of tables/views to include column system names FIX: OSX : OpenGL hanging bug which occured when you try to resize window after a query and grid results were enabled but the charts not shown. Occured because of FPSAnimator 9.0.0-rc-1.00 FIX: Merged 8.0.26 fixes FIX: ER Modeler : Now auto-generates names for new objects FIX: ER Modeler : You can now copy/paste regions and notes across models regardless of database type. FEATURE: Netezza : Native support for Netezza. 9.0.0-beta-3.06 FIX: Merged 8.0.25 fixes FIX: MS SQL Server : Schema Tree View : Disabled Triggers now have icon to indicate status FIX: Windows Chart Software Renderer : Handle to Windows Device context was not released when closing ADS. Launching and closing ADS about 1000 times would cause ADS GUI refresh issues. [Restart Windows] FIX: Pie Chart : Pie Chart label location calculation is much better now. 9.0.0-beta-3.05 - Internal Build 9.0.0-beta-3.04 FIX: Merged 8.0.24 fixes FIX: Drag & Drop of servers from Projects to Servers didn't work. FIX: Open API : Lowercased method .isTeraData() to .isTeradata() in AQMetaData FIX: Open API : AQUtil.htmlEncode() did not convert all characters correctly FEATURE: Open API : Added method .isNetezza() to AQMetaData 9.0.0-beta-3.03 - Internal Build 9.0.0-beta-3.02 FIX: Updated geo.jar for enhanced world map resolution. FIX: Save Results Dialog on OSX had button sizing issues. FIX: Sybase ASE 12.0 and below : Query Window : Change Database would fail because of [] quote identifier in DDL FIX: Open API : aqua.random.nextColor() now matches : http://en.wikipedia.org/wiki/List_of_colors ENHANCEMENT : Open API : Added method .getComment() to aqua.vcs -> AQRevision ENHANCEMENT : FEATURE: Server Registration Dialog -> Driver tab enhancements OPTION : Added File->Options->ER Modeler:[Enable Mouse Wheel Zoom] - [Invert Mouse Wheel] 9.0.0-beta-3.01 FIX: Query Window : If you query and sort grid results, then query a different result without the sorted column would cause grid result not to show for that query. FIX: AquaScript Editor : On Linux a Shift-F1 on a function woult open browser to JavaDoc incorrectly because of space in URL. FEATURE: AquaScript Editor : Lines with syntax error now give description of what the syntax error is. FEATURE: Server Registration Dialog : Added "Driver" tab to give more information on URL and driver parameters. 9.0.0-beta-3.00 - http://www.aquafold.com/d90/docs/ 8.0.27 FIX: DB2 LUW : Schema Browser - Security : Added Role and Group members node under Role FIX: nCluster : Schema Browser : List of schemas did not refresh if new schema created in query window FIX: nCluster : Visually Create Table now allows CHAR and VARCHAR without length. FIX: nCluster : Scripting CHAR didn't include length on nCluster 4.5. 8.0.26 FIX: Oracle : Explain Plan : Numeric nodes should have values right aligned. FIX: nCluster : Added filter to nCluster schemas for "nc_temp%" so that temp schemas are not displayed 8.0.25 FIX: Sybase ASE : Explain Plan line feed for German warning messages. FIX: Sybase ASE : UDDT DATETIME -> Export Tool FIX: MySQL : Alter Table GUI would not generate a Identity column change to remove the Identity FIX: Informix : VARCHAR(100,1) was using Precision/Scale and it should use Lenght/Scale FIX: Informix : Schema Script Generator should always default schema to : Just for Informix FIX: Generic JDBC/ODBC : connections for non-English User Interfaces would not display tables sometimes depending on database vendor and driver, becuase of non I18N of FIX : Visual Editing when [';' Statement Separtor] is enable should use the setting, except when it is a procedure/function/package FIX: Query Window : Max results field gets focus briefly after opening, causing problems for fast typers 8.0.24 FIX: Oracle : Package Editor : Toggle comments didn't work correctly FIX: SQL Server : Extracting constraints : Removed the permissions(objid) criteria on ms sql server queries. This was used when extracting constraints from tables and should not have been. FIX: SQL Server : Scripting Index DDL : Fix for INCLUDE columns not been duplicated, and minor fix to fillfactor. FIX: SQL Server : Scripting Table DDL : Added TEXTIMAGE_ON clause support FIX: Sybase ASE : Export Tool : didn't apply quote identifiers to UDDT of Date/Strings FIX: MySQL : Script DROP UNIQUE index syntax was incorrect FIX: ER Diagram Generator : Database Object comments with illegal xml characters would create .xed that wouldn't open. 8.0.23 FIX: Sybase IQ : Added support for "IQ UNIQUE" clause in table DDL FIX: Sybase IQ : DBSPACE extraction was using deprecated system catalog table FIX: Oracle : Fix for DDL generation on table, CHAR used on columns of type varchar2, char, nchar, nvarchar2 datatypes FIX: Informix : ER Model convertion on varchar(100,1) would convert to varchar(0) 8.0.22 FIX: Sybase Debugger : Second debug session would have connection disconnect. FIX: Server Registration: choosing SQL Server Single Sign On and then Sybase, doesn't re-enable the username/password FIX: Grid Results : Aggregate bar broken if SUM is not chosen FEATURE : Debugger : Parameter dialog now has menus to set NULL or DEFAULT to all parameters or selected UPDATE : Updated jConnect JDBC Driver 8.0.21 FIX : MS SQL Server : Debugger would not allow a Step Into a User Defined Function. FEATURE : MS SQL Server : Script Login now scripts password encoded FEATURE : MS SQL Server : Script Login now includes Script CREATE (Full) to include database users associated to Login FEATURE : MS SQL Server : Script Job now inlcludes full Job information such as steps. FEATURE : Sybase ASE : Script Login now includes Script CREATE (Full) to include database users associated to Login CHANGE : Query Builder : Execute Edit now uses the Max Results from the Query Builder 8.0.20 FIX: Schema Tree : Drag & Drop table/columns to editor. Broken in build 8.0.17, now fixed. 8.0.19 FIX: SQL Server 2008 : Extract Index with WHERE clause was not supported. 8.0.18 FIX: SQL Server : View in Excel, doesn't show values for Bit columns 8.0.17 FEATURE: Memory Monitor Dialog which is accessible by single click on botton right memory status indicator. PERFORMANCE: Informix storage information for Tables issues query that is now more optimized. FIX: DB2 LUW 8.1 and below : Schema Browser, procedure list would show empty list because one missing column in query. 8.0.16 FIX: Server Registration : ODBC datasource browser now includes User DSN from Windows Registry FIX: nCluster : Script table which inherits from other table will not script inherited columns for table. FEATURE: Grid Results : Added "View in Browser" to menu item FEATURE: SQL Debugger for Sybase ASE : added support for Sybase ASE 15.5 OPTION: Added option to datastudio.properties "editor.keybindings.completionShowAction" to allow to change keybinding for autocompletion 8.0.15 FIX: Sybase IQ : Time / Date columns would return "[Err]" because IQ doesn't return the column type name in the resultset for Time and Data columns. FIX: DB2 LUW : Added extracting and scripting of pctfree # table information as ALTER TABLE FIX: Sybase ASE : DDL Generation : Create table ddl where column has multi rows in catalog table but is not computed would make datatype length "null). Seems to happen on databases dumped in Sybase ASE 12.5 and imported to 15.0 FIX: DB2 iSeries : ER Modeler : Generate Script would always fully qualify Primary Key in DDL FIX: ER Modeler : ER Modeler : Relationship route is not saved in some cases FIX: Export Tool : Oracle 9i and above now supports "WITH CLAUSE" in the export data "SELECT" statement option PERFORMANCE: Table Data Editor : Performance problem when setting NULL on large resultsets. Aggregate bar would calculate with every cell change. OPTION: Sybase ASE : inverted default sybase quote_identifier option FEATURE: Oracle : Package Editor : Added support for .pck / single file opening and saving. FEATURE: Query Windows : When you reconnect, it now refreshes the list of databases and schemas FEATURE: Schema Browser : tree will now show users that belong to a role under db2 9.5 and above. FEATURE: Schema Compare : Schema compare now has option to include indexes/triggers on table comparisons. 8.0.14 FIX: Oracle : Added support for SYSASM role in Connect As FIX: DB2 iSeries : ER Modeler Table editor didn't support extend column properties, including identity column info. FIX: Sybase ASE : Object Search tool had a join condition missing in query for procedure body searches, which made search slow. FIX: Sorting in Grids for String now uses Collator instead of Comparator UPDATE: Installers now have Java 1.6.0_18 bundled, instead of Java 1.6.0_16. This is to resolve Windows 7 GUI issues. 8.0.13 FIX: Visual Editing was using option of [";" statement separator] which would cause procedure editing to fail. FIX: Allow .variable TIME/TIMEZONE format to specify fractions with up to nanosecond precision FIX: Quick Filter : Column filter popup would not scroll it the list was too big. FEATURE: Sybase ASE -> Added support for Execute Callable Statements for procedure with EXECUTE BIND OPTIMIZATION : Oracle : Extracting DBMSOUTPUT is now handled on server with annonymous PL/SQL block to increase extraction speed for large results. 8.0.12 FIX: ER Modeler print grid is wrong for scale other than 1:1 FIX: Schema Browser: Multiscript Indexes -- "null" is appended to name. 8.0.11 FIX: TeraData : Alter User would not put double quotes on password for changing password DDL FIX: MS SQL Server : Alter SQL Server Agent->Job would not display correct Email Alter user. FIX: PostgreSQL : Rules are now displayed under tables and views tabs in the schema tree. FIX: Query Analzyer : Chart : Script Full to New Window didn't include the ShowMarkers option, now does. FIX: Autocompletion sorting was using TERTIARY sorting. Causing _ to come before space. 8.0.10 FIX: Oracle : Query for columns of LOCAL TIMEZONE would return error for data. FIX: Sybase ASE : Minor fix to extraction of database groups. If a database was dumped and restored, the query would not show all groups. FIX: Sybase ASE : New jConnect driver no longer allows connection when password expired. Added change password functionality to Server Registration dialog on button right to password field. FIX: MySQL : Script Table CREATE (Full) would script Unique Indexes that were system generated to support Unique Constraints 8.0.9 FIX: (Sybase ASE 15) : View Database : Space Usage was merging Data and Unused together for Data size, and leaving Unused as zero. FIX: (Informix 7.3) : Object search for procedure bodies would fail. FIX: (MySQL) Table Data Editor didn't allow modification of TIMESTAMP column. FIX: Query Analyzer Window : Incremental Find hot key didn't work. 8.0.8 FIX: (MySQL )Auto Describe not working FIX: (SQL Server 2005+) Table Data Editor : Was unable to INSERT a XML value. FIX: (Sybase ASE) : Script CREATE on tables with computed columns that are very long would create a multi-line computed column and cause the column name to display as multiple columns of same name. UPDATE: (Sybase ASE) Updated jconnect6.jar JDBC driver to latest EBF patch. 8.0.7 FIX: Schema compare for functions and procedures needs to be compared based on parameter prototypes list, only when the database supports parameter overloading for the object of Function or Procedure. Otherwise procedures show up as different objects. FIX: Query Window - with MultiTab/SplitPane results - Openning windows, the odd numbered window open would focus on incorrect tab. 8.0.6 FIX: PostgreSQL : Script Foreign Key constraint, under rare circumstances, order of columns for the foreign key constraint did not match. FIX: Sybase ASE - Visual DROP of Login. If drop of login fails, ADS would report as successful. This is because of how Sybase ASE driver handles execution of stored procedures. 8.0.5 - FIX: Sybase ASE : Scripting constraint would include database everytime for referencing table. Now only when it is in another database. - FIX: Informix : Added syntax coloring on keywords : RETURNING, ELIF, RESUME, DEBUG, FILE, REPLACE - FIX: File->Options->Compare: compare option prompt label said "left", when it should have been "right" 8.0.4 - FIX: Oracle : Table CREATE Scripting now supports VARCHAR2(255 CHAR) format - FIX: PostgreSQL 8.3 and above: Added UUID datatype support. - FIX: DB2 Explain Plan : Column Names and Partition Columns values were displayed as Java Class names of the object. - FIX: Schema Script Generator : Disable option "Generate full script for tables (indexes etc)" if user chooses Trigger or Indexes individually - FEATURE: SQL Archive table now has sorting enabled. - FEATURE: DB2 9.5 and above : Now has suppprt for Roles in Schema Browser, Scripting, Visual Editing, Server Script Generator, Object Permissions and Security Manager. 8.0.3 - FIX: Informix 7.3 - Schema browser - Procedures were not listed - FIX: Oracle - TIMESTAMP TIMEZONE / LOCAL TIMEZONE columns are now retreived as strings so to include the timezone information - FIX: Disabling Auto Popup for autocompletion did not work for Windows 32bit. (Worked for Windows 64bit, Linux and OSX). - FIX: Oracle - query results with timestamp subtractions would result in [err] results for column data. Oracle drivers return INTERVALDS datatype. - FIX: SQL Archive : Delete Selected in SQL Archive would only delete one. - FIX: SQL History : window opens outside of the visible screen area if previous instance saved it that way. (Dual monitor switching) 8.0.2 - FIX: Grid Results Charts - If a function series was added and a "Merge Series Axes" option was chosen, then the chart would not refresh until the OK button was clicked. - FIX: Sybase IQ/Anywhere : When grouping by schema in Sybase IQ & Anywhere, we show schemas to be Users & Groups now. Reason: Groups can be an object owner. - FIX: Sybase IQ/Anywhere : Database schema nodes didn't refresh if new schema created. Required disconnect/reconnect. 8.0.1 - FIX: Autocompletion now handles Sybase Index Hints - FIX: TAB key does not move cursor to adjacent cell in the Table Data Editor - FIX: Quick filter was filtering numberic values as formatter values "commas" (eg 1,200,345) - FIX: Teradata connection type didn't allow for "Driver Params" in Server Registration->Advanced becaused it used "?" instead of "/" and "," as parameter separators in driver URL. 8.0.0 - FIX: Sybase ASE : Database Device DDL scripting didn't include the dsync option. - FIX: Sybase ASE 12.0 doesn't support @@unicharsize, so now using @@ncharsize - FIX: SQL Server : Job History dialog would not display history because of GUI refresh issue. - FIX: SQL Server : Minor GUI fixes in Restore Database dialog. - FIX: Reexecution of query with multiple sorted Pivot Tables, would not persist sorting on pivot table. - FEATURE: Server Registration : Oracle OCI, Sybase INI and ODBC browse dialog now have quick filter. 8.0.0-RC1 - FEATURE : ER Modeler : Find Dialog : Now includes indexes, columns, constraints and references. - FEATURE : Procedure/Package Editor now use Tab Title Format just like Query Window. - FEATURE : Added "Clear Document" action to Text Results and Message Results editor popup menu. - LOCALIZATION : Completed localization of new prompts for Japanese (all 21 languages complete). 8.0.0-Beta5 - FIX: Added File->Options->Registration Defaults for nCluster, DB2 z/OS and Teradata - FIX: nCluster : Performance problem with nCluster indexes extraction. - LOCALIZATION : Completed localization of new prompts to all languages except Japanese. 8.0.0-Beta4 - FIX: Scripting DB2 LUW Create Table with Identity/seed/increment by no cache from ER Model would fail. - FIX: nCluster : Fixed nCluster data types in ER modeler - FIX: nCluster : Added Views selection option to Query Builder for nCluster - FEATURE: ER Model : Copy will copy image to OS clipboard for pasting into Office and Email clients 8.0.0-Beta3 - FIX: Update from JIDE library 2.7.2 to 2.8.0 to fix minor UI bugs. - FIX: Oracle : Script Table Full with Default Parallel would not script NOPARALLEL clause. - FIX: DB2 XML Datatypes values where not extracted as XML text, but as java class names. - FIX: ER Modeler conversion : informix->mysql conversion sets auto_increment option - FIX: ER Modeler -> Generate Script ... need to add option "Tables: Use conditional drop" - FIX: Online Documentation was linking to ADS 7.5 ... now linking to 8.0 - FIX: Options dialog still defaults to 'General' regardless of last choice - FIX: Results Compare: Dialog for choosing results, now focus traversal with tab, shift-tab - FIX: Added support for Global Temporary tables in DDL Generation, Visual Editing and ER Modeler - FIX: Teradata : Script comments for tables and columns - FEATURE: Visual edit now supports create/alter database for Teradata. - OPTIMIZATION: (ER Modeler) Now able to open large 2000+ tables and 2000+ relationship models. - Also, added Window->Faster Rendering option. This renders dotted relationship lines as gray lines. (dotted are very slow because of Java 2D) 8.0.0-Beta1/Beta2 - See new features for 8.0 : http://www.aquafold.com/d80/docs/ 7.5.36 - FIX: DB2 LUW 9.7 and above : Added support for Global Temporary tables in DDL Generation - FIX: Oracle : Script Table Full with Default Parallel would not script NOPARALLEL clause. - FIX: DB2 XML Datatypes values where not extracted as XML text, but as java class names. - FIX: Re-Executing a query with a defined pivot grid and hidden headers would show refreshed pivot grid with headers. 7.5.35 - FIX: Table Data Editor : Now has the ability to defined unclonable columns for datatypes that are automatically generated by database. Added SybaseASE-timestamp and Informix-Serial 7.5.34 - FIX: MySQL : Visual Edit Table ->Constraints. Deleting of constraints were disabled. Now enabled. - FIX: Sybase ASE ... now use @@ncharsize and @@unicharsize to calculate lengh of nvarchar and univarchar length for server with different sizes. - FIX: ER Modeler DDL generation script for DB2 LUW Identity was not correct. 7.5.33 - FIX: Sybase ASE : Script Temporary Databases didn't include the TEMPORARY clause. 7.5.32 - FIX: Schema Compare : Indexes are now sorted by name so that the compare is a logical compare even if they were ordered incorrectly - FIX: ER Modeler->Generate Script on DB2 LUW : Scripting Table with Identity ALWAYS would cause exception. 7.5.31 - FIX: Sybase IQ : (12.6 and above) : Scripting Procedure. Some IQ installations (primarily upgraded installations) sometimes have zero length or padded blank values for sysprocedures.source which causes ADS to script a blank CREATE PROCEDURE block. 7.5.30 - FIX: Sybase IQ : (12.6 and above) Scripting Procedure would script compiled/unformatted create procedure code. Now scripts original code from system catalog sysprocedures.source. - FIX: SQL Formatter would not handle CASE correctly under certain scenarios and would break SQL - FIX: Disabled DriverManager.setLoginTimeout() because some JDBC drivers use this as a socket timeout. (Which is stupid, but we can't do anything about that) The DriverManager.setLoginTimeout() was initially set to prevent ADS from pausing for a long on a connection attempt that failed. 7.5.29 - FIX: Oracle : Query on Oracle Struct objects now converted to strings, such as RDF data. - FIX: DB2 iSeries : DriverMangaer.loginTimeout() is global. Set to 0 (zero) when attempting to connect to iSeries because of JTOpen bug 7.5.28 - FIX: DB2 iSeries : New JTOpen JDBC driver for DB2 iSeries has bug that uses DriverMangaer.loginTimeout() as a connection timeout. Workaround, ADS doesn't set LoginTimeout for DB2 iSeries. - FIX: DB2 Visual Explain would not work if user would change current schema to different then user login name - FIX: DB2 Visual Explain ... if explain tables don't exist on user schema, fall back on SYSTOOLS schema - FIX: DB2 Alter Tablespace was not extracting datafile size 7.5.27 - FIX: Schema Compare : Small memory leak fix - FIX: Table Data Editor: on Mac OSX selects first typed character - FIX: Table Data Editor: A cloned row of a cloned row would not retain data formats. 7.5.26 - FIX: Sybase ASE : Extract Table Check Constraint : Check constraint longer then 255 characters was truncated to 255. - FIX: Localization Mnemonics : Now avoids duplicate mnemonics in dialogs. 7.5.25 - MINOR CHANGE: OSX - Lowered acceleration on mouse scroll wheel for navigating editors. 7.5.24 - FIX: Schema Compare: Now sorts triggers by name in DDL generation to have closer and more acurate matches in the DDL text compare, subject to mis aligned triggers because of order. - FIX: DB2 iSeries : Execute Edit, case sensitive for table names was not working. - FIX: Import Tool : MySQL : Create Table from import tool would have initial values of "PREVIOUS" for datadir and indexdir which would prevent creating table. - FIX: Document Tab Pane : Having multiple windows open in multiple Vertical Tabs, and then clicking on a tab in one group would also select appropriate tab in other groups. 7.5.23 - FIX: MySQL : Script CREATE PROCEDURE & FUNCTION now includes in DDL : NOT DETERMINISTIC, CONTAINS SQL, READS SQL DATA, NO SQL, MODIFIES SQL DATA - FIX: DB2 iSeries : Execute Edit was always case sensitive on table names requiring upper case all the time. - FIX: OSX : Default key bindings for bookmarks on OSX didn't work, so changed to CTRL-Command-[M/Up/Down] 7.5.22 - FIX: Sybase ASE : Script Index truncated columns after 15 columns. - FIX: Bookmarks on Package/Procedure editors didn't work with the popup menus. 7.5.21 - FIX: Oracle : Executing or Debugging Functions/Procedures which had a return type of TYPE AS TABLE would fail. 7.5.20 - PATCH: OSX 10.5 Java 6 Update 4 has a bug which prevents ADS from launching. This ADS patch only includes patches to the JIDE libraries to work around the bug introduced by OSX 10.5 Java 6 Update 4. The JIDE patches dynamically determine the Java version to determine how to work around the bug. To apply and fix the bug you need to do the two following things : 1) Update your ADS installation with this patch. 2) On OSX copy you /System/Library/Frameworks/JavaVM.framework/Versions/A/Resources/MacOS/JavaApplicationStub to ... /Aqua Data Studio.app/Contents/MacOS/JavaApplicationStub - NOTE: This build does not have any changes to ADS. 7.5.19 - FEATURE: File->Options->Results->Save Results->[Maximum string length saved for Excel worksheet] / Default: 10240 7.5.18 - FIX: Query Window: Syntax Coloring: Disable comment coloring in bracket object identifier names. (eg: SQL Server: CREATE MESSAGE TYPE [tcp://BOOTES/TS_staging/send_phone_transaction_msg]) - FIX: Query Analyzer: Executing query with bracket object identifer that had // in the name, would interpret // as comment if // was set as client side comment. // are no longer identified as comments in [] quote identifiers. (eg: SQL Server: CREATE MESSAGE TYPE [tcp://BOOTES/TS_staging/send_phone_transaction_msg]) 7.5.17 - FIX: MySQL: Tinyint(1): MySQL JDBC driver java.sql.ResultSet.getObject() returns Boolean value for TINYINT(1) datatypes which is a bug. Used workaround with java.sql.ResultSet.getShort() which works. - FIX: Oracle: Openning Query Window would not refresh the current schema in combo box on initial openning. Only a bug in 7.5.16 with the new "post connection script" feature. - FEATURE: Informix: Create Table dialog, storage tab now has option for TEMP and WITH NO LOG. This allows a user to run Import Tool from Query Window popup menu, create temp table in Import Tool, import into temp table and access temp table in Query Window. - FEATURE: Query Window: Popup Menu now has Tools menu for Import Tool, Export Tool and Object Search which uses the same connection as the Query Window. - FEATURE: Export Tool: Now has option to export to Excel Worksheet 7.5.16 - FIX: Query Analyzer: If the native print method of the JVM/OS would fail, ADS printing would fail silently. - FIX: SQL Server 2005+ : VARBINARY(MAX) column datatypes where scripted as VARBINARY(-1) - FEATURE: Server Registration: Now has a "Script" tab, which allows user to enter an SQL Script that is executed each time a new connection is established. This allows user to SET connection settings for a server connection. (eg: SET ROLE, ALTER SESSION SET XXX). 7.5.15 - FIX: Server Registration: Oracle TNS and Sybase.ini Datasource lookup didn't work on Linux/OSX because of file separator was using Windows forward slash. - FEATURE: Table Data Editor: If only inserting rows, and no primary key is defined, then allow saving without primary key. 7.5.14 - FIX: MySQL Security Manager : Unable to drop user if list is grouped by username. - FIX: Query Window Parser: A double quoted string with a "//" in it where the option of "//" comment being a client side comment would cause the SQL statement to be truncated. This would only happen on invalid SQL statements, but would cause the SQL string to be incorrect in the Text Results if the option to dispaly SQL was enabled. - FIX: Execution Monitor: If execution monitor would popup warning dialog while user in a modal dialog, user would need to hit ESC to exit modal dialog to continue even though user could not see dialog if the execution monitor dialog was on top. - FIX: DB2 Table Visual editor dialog, storage tab, fixed label to "NOT logged initially". 7.5.13 - FIX: Save Results: button mnemonic for "Save to clipboard" was "c" which matched "Cancel". Changed to "b". - FIX: Query Window: Popup menu had label "Compile" for the action "Execute". Changed to "Execute". 7.5.12 - FIX: Editor: Anti-aliasing option didn't affect font of the line numbers of the editor. Now they do. - FIX: Explain Diagram: Force memory collection when closing window as large diagrams were causing large memory consumption over long term use. - FIX: DB2 Table Visual Editing and DDL generation: Added APPEND ON/OFF clause 7.5.11 - FIX: DB2 iSeries : connections with Driver Param need to create URL with ";" instead of ":" - FIX: Sybase ASE Storage Manager : Removed "Space Available" column from database tab as value was always "Unavailable". - FIX: Oracle Session Manager: Explain Plan on Current statement would not work if no schema was indicated and create/drop option was disabled. - FIX: Explain Diagram: Contained minor memory leak. - FIX: Import/Export Tool: Minor layout of GUI on OSX. 7.5.10 - FIX: Informix Table extraction queries have been optimized. Informix database with 54,000 tables in system catalogs would extract a single table in 10 minutes. - FIX: Editor : Replace functionality would replace twice sometimes is multiple windows of the same editor type were open. 7.5.9 - FIX: Informix Indexes extraction queries had a missing JOIN criteria which would produce a very slow query taking minutes in certain databases. 7.5.8 - FIX: Applied Text Results optimization fix to Text History Results. - FIX: Informix: Index Extraction: Optimized extraction query for performance, which was possibly slowing down Table->Script->CREATE - FIX: Results Compare progress bar was broken so it didn't allow you to cancel comparision. - FEATURE: Query Window: Added CTRL-SHIFT-; hot key to enable/disable [";" as statement separator] 7.5.7 - FIX: Text Results: Speed Optimizations. The new editor component introduced performance issues in Text Results for ADS 7.0. We have fixed the issues and increased performance even over ADS 6.5. Relative tests on a 100,000 rows SELECT for Text Results : ADS 6.5 == 18 seconds ADS 7.0 == 1 minute 3 seconds ADS 7.5 == 13 seconds - FIX: Query Builder: Default keybinding for Copy SQL is now Ctrl-Shift-C ... as Ctrl-C doesn't map since it is consumed by all other components - FIX: Query Builder: Mouse Click Menu on tables->Unselect all columns would not work - FIX: Query Builder: Loading new query build file on a different connection would not refresh database list in Add Table Dialog - FIX: Query Builder: Saving to file with column expression and alias combination would fail - FIX: Query Builder: On OSX, clicking on Table Entity Pane background would print harmless exception. Bug in OSX Java. Found workaround. 7.5.6 - FIX: Table Data Editor: Syntax coloring bug fix for sequential operation of clone, delete, clone, change primary key. - FIX: Export Tool: If SELECT statement had comments, they would be removed before execution. - FEATURE: Query Builder: Added support for BETWEEN operator in Quick Criteria Mode 7.5.5 - FIX: Oracle: Package Editor would fail to open, now fixed. - FIX: ER Modeler: Russian translation fix for dialog closing window. - FIX: Informix w/ Replication: Possible performance issue to Script->CREATE on tables in databases with replication. 7.5.4 - Internal Build 7.5.3 - FIX: Results Compare would fail on NULL comparison values - FIX: Editor Abbreviations from previous versions of ADS would not transfer over to 7.5 and would require recreation if there were more then one. 7.5.2 - CRITICAL FIX: SQL Server BIGINT datatypes: Large Numeric Values (greater then 16 million) would lose precision in data extraction. Values were converted from Long to Float and back to BigDecimal, which could loose precision. - FIX: ER Modeler/Visual Editing : Added support for length on binary/varbinary datatypes for SQL Server, Sybase ASE, Sybase Anywhere and Sybase IQ - FIX: Query Builder: When unchecking a row in graph entity, only remove the changed row. This bug is new in the 7.5 branch, and did not exist in version 7.0 or previous versions. The bug was introduced in the 7.5 code branch as part of the memory optimizations included in 7.5. For SQL Server BIGINT datatypes, ADS stores them are BigDecimal values, but the JDBC drivers return them as Long values. The bug would convert the Long values to Float and then back to BigDecimal values which would potentially loose precision values depending on the actual value. This would effect any data extraction on SQL Server with BIGINT datatypes. If you have any questions on how this may affect your systems please contact us at (architect@aquafold.com) This bug only effects the MS SQL Server database server, and does not effect others. 7.5.1 - FIX: Editor: Option to enable anti-aliasing was not working. - FIX: Editor: Abbreviation expansion would place cursor at beginning of the expanded on first row only. - FIX: ER Modeler: Sybase numerics labels didn't include precision and scale. ER (precision,scale) - FIX: Update to jInterop library to fix SQL Server Debugger Bug. Debugger for longer then 6 minutes at one time would sometimes disconnect debugging session. - FIX: Results Diff: Preview didn't expect nulls, and memory problem. - FEATURE: Double click on Execution Plan Grid and Properties Grid in Explain Diagram now displays in Text Dialog. - FEATURE: Local Permissions now use a dynamic tempdb name for SybaseASE as the tempdb is dynamic for logins - FEATURE: Added "';' Statement separator" option to File->Options->Scripts for each database to allow enabling on a per database basis. 7.5.0 - See new features here: http://www.aquafold.com/d75/docs/ 7.0.37 - FIX: (Oracle) Optimized Oracle queries for Table Extraction - FIX: (DB2 for LUW) GRANT and REVOKE Scripting was not working for Procedures and Functions - FIX: (SQL Server) Database Restore : running ADS on Linux would not allow UI to indicate restore file - FIX: (Sybase ASE) Visual Editor for Create Table had identity option enabled for all numeric fields except for "numeric". - FIX: (Sybase ASE) ER Modeler: Support for Sybase ASE IDENTITY parameter - FIX: (OSX) Checkbox renderer was messed up in Option Dialog for OSX - FIX: Table Data Editor : Truncation warning on numbers with large scale values is now removed as the warning was not correct. - FIX: Query Builder: Adding a table with "Auto Join" enabled will add a join for FK''s where the FK is to the same table - FIX: Query Builder: Opening query builder file saved in one language and opened in a different one would fail - FIX: ER Modeler: Indexed column order didn't match order is DDL. - FIX: ER Modeler: Unique clustered constraint fix for DDL generation - FIX: Schema Script Generator: title reflects database/schema for clarify on minimized dialogs. 7.0.36 - FIX: Removed internationalization for ansi_nulls etc. in connection dialog. - FIX: Query Analyzer: Executing a script with .setPivotResultSettings would not set saved Stacked Charts option. - FIX: OSX: ER Printing on OSX, fixed few minor repaint bugs. 7.0.35 - FIX: Sybase ASE: Script Procedure EXECUTE to a procedure with "bit" parameters would generate default values of "false" instead of "0" - FIX: Sybase ASE: Visual Create of Database Device would limit device number to 9 or below. - FIX: OSX: ER Modeler would not print on certain printers from OSX. 7.0.34 - FIX: Sybase IQ: ADS now provides APPINFO information for EXE so that sessions provide the name of the application. 7.0.33 - FIX: Memory Consumption - CPU Peak bug. If a query with a huge memory usage is executed, the ADS will cancel query to quit, but would pause application for an extended time with a high CPU usage. 7.0.32 - OPTIMIZATIONS: Minor memory optimizations accross the application. Hope to better performance over long term use of the application. 7.0.31 - FIX: Automate Morph to Lower/Upper would be incorrect when there was a comment containing an unclosed single quote - FIX: Sybase ASE: Table Data Editor: Enabled "sysname" datatype for editing. - FIX: Oracle & DB2: Scripting DDL to new window would not set current context of schema based on browser. 7.0.30 - FIX: Sybase ASE 15 : Support for Computed Columns in Table Extraction/Scripting - FIX: Custom Pivot Field Aggregate Functions didn't with Totals were enabled. - FIX: Grid results toolbar repaint problem (with cell aggregator). - FEATURE: DB2 iSeries: Added "Logical Files" folder to schema browser. 7.0.29 - FIX: Sybase IQ 12.5 - Schema Browser : Table constraints node used [] quote identifers for query which failed on 12.5 - FIX: Sybase IQ: Table Data Editor had datetime datatype columns disabled. 7.0.28 - OPTIMIZATION: Query Analyzer: Execution of queries ... calibrated performance and memory recovery. Seems that a 400ms memory recovery operation can take alot longer on older CPUs. Execution should be faster and more noticable on older machines. 7.0.27 - FIX: Sybase IQ 12.5 : Extract Index would fail because of [] quote identifier. Changed to "" - FIX: Oracle : Object Search: Searching for column names would potentially return duplicates are JOIN query would only join on TABLE_NAME and not OWNER. - FIX: Register Server: Configuration an Oracle connection for use with RAC would require a SID (although you could put space). No longer required. - FIX: MS SQL Server : Objects named with Asian charactersets would fail to extract because '' literals used in extraction query instead of N'' - FIX: Context Menu key on keyboard didn't trigger popup menu. - FIX: Table Data Editor: UPDATE or DELETE where the primary key was a Unique Index and one of the columns was Nullable, and the value of one was a NULL, ADS would make WHERE condition COLUMN=NULL instead of COLUMN IS NULL. 7.0.26 - FIX: Sybase ASE 11: Extract Index tried to get crdate of indexes, but column doesn't exist in Sybase ASE 11 - FIX: Sybase ASE 11: Script Database for ALTER and DATABASE would use KB number format. Sybase 11 only supports MB. - FEATURE: Table Data Editor: Added feature to provide table level transaction settings in the datastudio.properties file with this option and format ... tabledataeditor.settingtableoverwrite=MyDatabase.dbo.MyTable,{FULL_TRANSACTION | BATCH_TRANSACTION | THRESHOLD_TRANSACTION},2 + YourDatabase.dbo.YourTable,{FULL_TRANSACTION | BATCH_TRANSACTION | THRESHOLD_TRANSACTION},3 7.0.25 - FIX: Sybase ASE 12.5 : Detail View and Storage View for tables in temp databases now exclude segment name and use isolation 0 for queries to reduce contention - ENHANCEMENT: Script Detail Results: Persist column widths in script details results. 7.0.24 - FIX: Generating Full Script of Charts where the chart was Stacked Area Chart would not save chart type. - ENHANCEMENT: Script Detail Results: Added columns "Resultsets", "Rows Effected" and "Rows Updated" 7.0.23 - FIX: Auto-Describe now includes UNIQUE and CLUSTERED option in text description - FIX: Sybase ASE : Alter Table Dialog: Adding and Dropping columns at the same time would cause incorrect SQL statement. Adding columns or dropping columns in any single operation would be ok. - FIX: Table Data Editor: Would give a truncated data warning on paste when no truncation happend. - FIX: EXECUTE BIND for Oracle, no longer sets NULL value for user defined datatypes - FIX: Sybase ASE: Extracting procedures and functions in Sybase ASE on UTF-8 databases would add extra blank spaces. - FIX: Support for Table and Column comments in DB2 iSeries - FIX: Drag-n-Drop from cell of Grid results now uses displayed value instead of raw values for Numbers and Dates. - FIX: DB2 Session Manager: Didn't display current SQL for 9.0 and 9.5. - FIX: ER Modeler: Table Dialog: Delete key didn't DELETE row, now does. - FIX: Sybase ASE: Script Procedure CREATE. Certain procedures with over 15,000 lines on Sybase 12.0 server would be out of order. - FIX: Sybase ASE: Alter Database, recalculating size when changing size type was incorrect - OPTIMIZATION: Optimize free memory reallocation when executing queries and closing query windows. Also optimized memory on SVN Update and Commits. - FEATURE: Schema Script Generator: Added Inline Schema Script Comments option - FEATURE: Query Analyzer Results: Script Details: Added Server Execution Time - LOCALIZATION: Minor bug fixes - LOCALIZATION: Japanese Translation. Original translation was not good enough according to Japanese users. Now includes a complete and new translation which is very accurate and usable by users. - LOCALIZATION: Update - (Status: Review) : 100% : Spanish - (Status: Review) : 100% : French - (Status: Review) : 100% : Italian - (Status: Review) : 100% : Portuguese (Portugal) - (Status: Review) : 100% : Portuguese (Brazil) - (Status: Review) : 100% : German - (Status: Review) : 100% : Russian - (Status: Review) : 100% : Korean - (Status: Review) : 100% : Chinese (Traditional) - (Status: Review) : 100% : Chinese (Simplified) - (Status: Review) : 100% : Japanese 7.0.22 - FIX: Detail Views numbers are now formatted based on locale - FIX: SQL Server: Scripting binary datatype didn't include length - FIX: Sybase ASE: Export Date column would also put time - FIX: Sybase Any/IQ: Use "[" and "]" as quote identifiers for Sybase Any and IQ so they always work without set quoted identifiers - FEATURE: Table Data Editor: If no primary key, or unique constraint defined, TDE will look for a unique index to identify primary key columns. 7.0.21 - FIX: SQL Server Job History: job history columns shifting in GUI fixed. - FIX: DB2 iSeries, now uses SYSIBM.SCHEMATA for schema list queries instead of QSYS2.SCHEMATA. - FIX: Script EXECUTE for Oracle procedures with STRING datatypes now scripts (2000) with initial length. 7.0.20 - FIX: SQL Server Procedure Editor/Debugger would fail when procedure had a parameter with BIT datatype 7.0.19 - FIX: Parameterized Scripts: Multiple /* */ comments in scripts would sometimes prevent parameterized script from running. 7.0.18 - FIX: Inline Diff in editor was using HEAD copy for diffing in SVN. - FIX: Informix Scripting Table with storage with their is a fragment would include same table space multiple times. 7.0.17 - FIX: ER Modeler: View DDL generated from extracted view would script incorrectly - FIX: Generate ER Diagram Dialog: reverse selection button didn't extract correctly. - FIX: Oracle Debugger would fail when debugging procedure with parameter of type STRING - FIX: Query Window: Auto Describe would not display indexes and contraints in SQL Server and Sybase when user was not logged in as "dbo" - FIX: Oracle Package Editor on Body tab, Find Incremental didn't work. 7.0.16 - FIX: Removed C, K, G and M as keywords for syntax coloring. - FIX: Automate Introduce Columns, Qualified Columns and Value Stubs didn't work with quoted tables. - FIX: SQL Server: SQL Server Agent DBA Tool, Jobs Tab had labels for creating Login and not Jobs. - FIX: Oracle Debugger : Debugging packages on OSX would not break on breakpoints when running with "run" command. - FEATURE: Chart Options toolbar now has two buttons for Save Defaults & Reset Defaults. 7.0.15 - FIX: Sybase ASE 15: Schema Script Generator: Permissions for Functions were not scripted - FIX: Focus on query window editor after changing database in query panel through a pop down menu with arrow key navigation. - FIX: Sybase ASE: Scripting Table with Indexes, now scripts clustered indexes before other indexes. - LOCALIZATION: Minor Updates 7.0.14 - FIX: DB2 iSeries script properties where not configurable in File->Options->Scripts because they were not set. - FIX: Tab Compare lists the tab full name with file name now. - FIX: DB2 iSeries - Table extraction filtered on QSYS2.systables where TABLE_TYPE='T' ... now filters on (TABLE_TYPE = 'T' OR TABLE_TYPE = 'P') - FIX: Right click menu on results grid shows default hot key (ctrl+shif+k) for results compare even when the hot key has been redefined by the user - FIX: Don't show sybase explain plan I/O stats table if statistics IO not executed. - FIX: Conditional DROP for MySQL and Postgresql had syntax error - LOCALIZATION: Minor Updates 7.0.13 - FIX: Added number formatting for BigDecimal in Detail View - FIX: Optimized Queries for Sybase Table and Index Detail Views. - FIX: Show Changes in SVN History with filter enabled prevented show changes from working in some cases. - LOCALIZATION: Minor Updates 7.0.12 - FIX: Fixed wrong percentage during schema comparison if only some of the object types were selected. - FIX: re-execution of query, where there was a chart with two series and two different chart types, would not save chart types for both series accross reexecution. - FEATURE: Detail Views: Added number formatting to Detail Views - FEATURE: Detail Views: Added popup menu for enhanced copy - LOCALIZATION: Update - (Status: Review) : 99% : Spanish - (Status: Review) : 99% : French - (Status: Review) : 99% : Italian - (Status: Review) : 99% : Portuguese (Portugal) - (Status: Review) : 99% : Portuguese (Brazil) - (Status: Review) : 99% : German - (Status: Review) : 99% : Russian - (Status: Review) : 99% : Korean - (Status: Review) : 99% : Chinese (Traditional) - (Status: Review) : 99% : Chinese (Simplified) - (Status: Review) : 99% : Japanese - Complete review and rewrite in progress ... 7.0.11 - FIX: Saving properties when datastudio.properties was read-only would cause Storage Managers to not function - Fix: Right click mouse click on top left pane of Grid Results now also pops up menu - FIX: Sybase ASE: Detail View for Tables didn't display tables with size above 4gigs - FEATURE: Sybase ASE: Detail View for Indexes, added Created Date 7.0.10 - FIX: Minor spelling changes to I18N prompts - FIX: Sybase ASE - Server Registration - sybase.ini lookup, support for '(' and ')' tokens in grammer - FEATURE: Sybase ASE: Detail View for Tables & Indexes: Added storage information. 7.0.9 - FIX: Results Diff filter was displaying NULL values where no row should be. - FIX: Server Registration: ODBC Datasource browser didn't work. 7.0.8 - FIX: Results Diff filter was not working. - FIX: Garbage Collection button now also runs finalize. - FIX: Sybase ASE: Explain Plan Statistics IO, remembers split position and Total is now first row. - FIX: ER Diagram Generator is now a frame and can be minimized. - LOCALIZATION: Update - (Status: Review) Spanish: 99% - (Status: Review) French: 99% - (Status: Review) Portuguese: 99% - (Status: Review) Italian: 99% - (Status: Review) Portuguese (Brazil): 99% - (Status: Review) German: 99% - (Status: Review) Japanese: 99% - (Status: Translating) Russian: 54% - (Status: Translating) Korean: 58% - (Status: Translating) Chinese (Traditional): 50% - (Status: Translating) Chinese (Simplified): 75% 7.0.7 - FIX: Option Dialog property heights didn't calculate correctly for big fonts - FIX: Memory monitor bar was inverted for memory used. - FIX: Server Registration: Oracle OCI: Now has work on driver compatibility. 7.0.6 - FEATURE: Pasting into Table Data Editor text values that exceed datatype length, will now warn the user. - FEATURE: Procedure Editor and Debuggers: Execution Parameter Dialog now has a "Load" and "Save" button to allow the user to Save and Load values for parameters. - FEATURE: Sybase ASE: Explain Plan Statistics IO now has quick filter and aggregate calculator 7.0.5 - FIX: SQL Server : View GUI for Procedures, Functions, Views, would display blank if the CREATE DDL started with multiple comments, where the multiple comments were separated by an empty line with spaces - FIX: SQL Server: SQL Debugger would fail to login if the SQL Server is not listening on port 1433. - FIX: Alt- Mnemonics didn't work in dialogs. - FIX: Ctrl-] hotkey now pulls down tab list popup menu, now also displays hot key in tooltip. - FEATURE: Import Tool: Now supports empty last column values per row in the import file. - LOCALIZATION: Update - (Status: Review) Spanish: 99% - (Status: Review) French: 99% - (Status: Review) Portuguese: 99% - (Status: Review) Italian: 99% - (Status: Review) Portuguese (Brazil): 99% - (Status: Review) German: 99% - (Status: Review) Japanese: 99% - (Status: Translating) Russian: 29% - (Status: Translating) Korean: 37% - (Status: Translating) Chinese (Traditional): 50% - (Status: Translating) Chinese (Simplified): 50% 7.0.4 - FIX: SQL Server: SQL Debugger would fail to login if the registration used Windows Authentication or Single Sign On. - FIX: SQL Server: Scripting DDL for Procedure that user didn't have access to would give NullPointer exception error, now provides better error. - FEATURE: Sybase ASE: Explain Plan Statistics IO numbers are now formatted 7.0.3 - FIX: ER Modeler: Generate DDL Script was scripting DROP of Primary Keys, but no longer does this as the DROP TABLE handles this. - FIX: ER Modeler: Generate DDL Script dialog is no longer modal. - FIX: Informix functions and procedures now are listed in schema browser correctly, as before some were missing. 7.0.2 - FIX: Query Analyzer: Table completion didn't show schema name. - CHANGE: ER Modeler & Script Generator: Script Generation now scripts creation of table primary key embedded in CREATE TABLE statement. Previously, a separate statement caused issues for MySQL with auto increments that require primary key to be defined on auto increment columns. - FEATURE: Added Script CREATE & DROP menu items for Materialized Views for Oracle. - FEATURE: Sybase ASE: Explain Plan Statistic IO grid now has aggregator, and logical IO is first column. 7.0.1 - FIX: JIDE Library Update. Minor bug fix, which was not reproducable on - FIX: SVNKit Library Update. Bug fix to allow connections to SVN 1.5 Servers - FIX: Opening SQL file in script tree would not open a GenericSQLKit, just a plain text with no syntax coloring. - FEATURE: Added 2 options in RunScript to define encoding of input and output encoding - FEATURE: Sybase ASE Statistics IO grid for explain plan when executing with Show Execution Plan - FEATURE: Tab Coloring enhancements - LOCALIZATION: Update - (Status: Review) Spanish: 99% - (Status: Review) French: 99% - (Status: Review) Portuguese: 99% - (Status: Review) Italian: 99% - (Status: Review) Portuguese (Brazil): 99% - (Status: Review) German: 99% - (Status: Review) Japanese: 99% - (Status: Translating) Russian: 5% - (Status: Translating) Korean: 17% - (Status: Translating) Chinese (Traditional): 1% - (Status: Translating) Chinese (Simplified): 22% 7.0.0 - Release - Change: Tagged as release 7.0.0.RC.15 - FIX: Editor: Opening Editor with initial file would have an initial Undo buffer that would clear the full text. - FIX: Table Data Editor: foreground color of text for tabs was too light when the tab colors were user defined. - FIX: Editor: Find Next selection was not invoked by hotkey (CTRL-F3 on Windows/Linux and CTRL-CMD-G on OSX) - FIX: RunScript.bat/.sh was broken in RC.11, now fixed. 7.0.0.RC.14 - FEATURE: Added option to File->Option->General->Query Windows:Show File Name, Always, Never, When File Exists - FEATURE: Sybase ASE : Execution of query with Show Explain enabled with now also "set statistics io on" - FEATURE: Abbreviations, autocompletion now shows the Abbreviations in the autocompletion window as [Abbreviation - Expanded Text], instead of [Expanded Text - Abbreviation] - FEATURE: Copy to Clipboard now works for the HTML and XML editors in addition to the SQL Editor. - CHANGE: Disabled (temporarily) Syntax Coloring Copy to Clipboard because it disables the Paste Command - LOCALIZATION: Update - Spanish: 99% - French: 99% - Portuguese: 99% - Italian: 99% - Portuguese (Brazil): 99% - German: 96% - Japanese: 89% - Russian: 1% - Korean: 1% - Chinese (Traditional): 1% - Chinese (Simplified): 1% 7.0.0.RC.13: - FIX: Sybase ASE: Script to Window -> CREATE DEFAULT would remove double quotes on a default value if created with double quotes. - FEATURE: (Oracle) Detail View on Table Partitions have more information now. - FEATURE: Grid Results popup menu: Converted "Copy As ..." menu for Horizontal/Vertical to a custom dialog with options to choose Horizontal/Vertical, Delimiter, Quote Identifer and Enclosure. - FEATURE: SQL Editor: Added basic support for copy to clipboard in RTF. This gives you syntax coloring for pasting to Wordpad. 7.0.0.RC.12: - FEATURE: Enabled Evaluations 7.0.0.RC.11: - FIX: Sybase ASE: Script Table CREATE (Full), applied condition on table lock type to determine parameters max_rows_per_page & exp_row_size - FIX: Table Dialog: Adding new column and clicking on datatype wouldn't automatically create new empty row. - FIX: Pivot Charts: Would include totals and subtotals, no longer. - FIX: Query Window: Reexecution would not save position and settings for pivot and charts. - FEATURE: Query Window & Query Builder: The default current folder for openning and saving files is superseded by the mounted folder 7.0.0.RC.10: - FIX: Autocompletion now supprts table hints in SQL Server. ex: SELECT * FROM TABLE (NOLOCK) ^ - FEATURE: Tab Coloring: is now extended to Table Data Editor and Query Builder. - FEATURE: Tab Coloring: Added smarts to use black or white color depending on the background luminosity, And shading of non active tabs. - FEATURE: Abbreviations: Abbreviations are now saved in abbreviations.properties instead of datastudio.properties so they may be pre-defined and distributed independant of datastudio.properties. - FEATURE: Abbreviations: Autocompletion now also completes Abbreviations as long as you have one character typed, and it completes on the abbreviation text and not the Expanded text. - FEATURE: Tabs: Added CTRL-] as hotkey to pull down top right popup window for list of tabs. - FEATURE: Tabs: Added "Tab Title Name" option in server registration to allow expressions for naming tab titles when they open. - FEATURE: Import Tool: Added smarter auto-alignment of columns when importing file with column names. 7.0.0.RC.9: [Internal Build] 7.0.0.RC.8: Please see ... http://www.aquafold.com/d7/docs/index.html 6.5.12 - FIX: Sybase 12 and below, the Script DDL for procedures didn't work - FIX: Execute Edit in Oracle, where the explicit schema of a table is indicated in lowercase, but the actuall schema is in uppercase, and the current schema is different, would cause the execute edit to fail. 6.5.11 - FIX: SQL Server 2005: Object Permissions for Database Roles were not visible in Object Properties - FIX: Enabled Export Tool to support Generic JDBC/ODBC connections. [Doesn't always work depending on Driver quality] - FIX: PostgreSQL single/double quote bug in old procedural language syntax. - FIX: Sybase IQ/Any - Schema Browser wouldn't show one procedure if there were two, one in different schemas. - FIX: Informix - Script Index CREATE would place index columns in incorrect order. - FIX: Import Tool now supports importing numeric values in scientific notation (eg 1.1e03) - FIX: OSX 10.5 Grid Performance Bug - FIX: Memory check issue bug. Now more refined. - FIX: Import Tool: Having a decimal delimiter other then "." would generate numbers incorrectly for SQL since in SQL numbers always use ".". 6.5.10 - FIX: Save Results - Preview Tab would have incorrect syntax for Delimiter and QuoteIdentifier is either were double quotes. - FIX: (SQL Server 2005) - Scripting for User Defined Data Types, where numerics would script 0 for precision. - FIX: (SQL Server 2005) - Script Generator didn't script RULE constraints correctly - FIX: (SQL Server 2005) - Script Generator would script Trigger twice in certain cases. - FIX: (SQL Server 2005) - Script Generator would script Trigger and trim trailing spaces on line - FIX: (Sybase 15.0) - Added support for Function in Schema Script Generator in Sybase ASE 15.0 - FIX: (Sybase 12.0) - Schema Browser Database Roles don't show Groups, but shows Roles - FIX: (Oracle) Execute Procedure in Procedure editor would fail if paramter datatype was INTEGER - FIX: (Oracle) - Script Generator and Schema Compare would not script/compare triggers bound to views. - FIX: (Oracle) - Schema Browser would not script triggers on view when scripting CREATE or REPLACE. Alter View -> Compile would also remove the triggers. 6.5.9 - FEATURE: In Query Window, have a database combo box database change with a click, reset focus to the editor - FEATURE: SVN Support for SVN_ASP_DOT_NET_HACK - FEATURE: Added "Open In..." popup menu in the script tree - FIX: Table data editor fix - max length (length -1) - FIX: Fix problem when DebuggeeThread finishes (e.g. due to script error) before Debugger is ready, which doesn't reset toolbar. - FIX: Partial Fix for User Defined Data Types in Sybase ASE stored procedure exeuction - FIX: Fixed proc debugger user defined types support - FIX: Fixed postgres trigger scripting. - FIX: Fixed procedure debugger null parameters, which wouldn't script the parameter for execution - FIX: Fix for Sybase ASE column scripting when changing datatype in visual editing ... must include NULL or NOT NULL - FIX: Fixed columns for session manager 6.5.8 - FIX: Table Data Editor: max field length is not checked when modified with dialog. - FIX: (Oracle) Server Registration: Advanced Tab: Added "Use DBA_ views" as an option. - FIX: (Sybase ASE) Scripting DDL for Caches didn't script object bindings. - FIX: (SQL Server) Added support for Computed Columns for DDL CREATE of Tables. - FIX: (SQL SErver) Schema Compare on SQL Server without password saved and Windows authentication doesn't work. - FIX: (Sybase) Security Manager: Combo box with databases is not sorted. - FIX: (Sybase) script proxy table is not correct. 6.5.7 - FIX: (Oracle 9i) SQL Debugger when debugging on 9i on Linux would not allow breakpoints. - FIX: (Informix) Script CREATE User would not include statement separator. - FIX: Results Compare copy to clipboard only copied one value on modified values when option File->Option->Results->Grid Results->Clipboard Copy as default format was enabled. - FIX: Results Compare copy to clipboard would copy incorrectly when filtering. - FIX: TreeTable sections of DBA Tools now allow you to select all rows and copy to clipboard. - FIX: (DB2) Script Generator sort dependecy didn't take into account view dependecies on functions. - OPTION: File->Options->General->General:'/' at End of Line Terminates Statement. 6.5.6: - OPTION: Added to Grid Results popup menu "Copy All w/SQL" which will copy Data, Header, Rows and SQL to clipboard. - OPTION: Added option File->Options->General:Appearance:"Use anti-aliasing fonts for editors". - OPTION: Added option File->Options->SQL Editor:General:Editor Foreground Color. Also to Text, HMTL and XML Editor tabs. - OPTION: Added option File->Options->SQL Editor:General:Caret Insert/Overwrite Color. Also to Text, HMTL and XML Editor tabs. - FEATURE: (Oracle & Sybase ASE) Debugger now has "Copy" command in the editor popup menu - FEATURE: (Oracle & Sybase ASE) Debugger now has animated icon while debugging. - FEATURE: Procedure & Package Editor: Added Save Results action to save results just like Query Window. 6.5.5: - FIX: Pivot Grid: Added support for Filter Fields to be saved to Excel and for them to persist accross execution. - FIX: Table Data Editor: Fix the bug that prevented a length check in the changes in a table data editor - FIX: Table Data Editor: Syntax coloring didn't display spaces at end of value, which worked in 6.0. - FIX: (Sybase ASE) Debugger: Run to cursor on a line that is not valid will now print warning message in console and not run. - FIX: (Sybase ASE) Debugger: Fixed synch issue in debugger that would only occur sometimes while debugging procs on a server under heavy load. - OPTION: File->Options:General:Query Windows:Hide Results on Open - CHANGE: (Sybase ASE & Oracle) Debugger tab now contains username & servername 6.5.4: - FIX: (Oracle) Debugger: Was broken in previous build. 6.5.3: - FIX: (Sybase ASE) CREATE UNIQUE INDEX on Sybase ASE shouldn't script ignore/allow_dup_row - FIX: (Sybase ASE) Debugger: When Sybase returns 0 as line number, display in console and not move current run line. 6.5.2: - FIX: Table Data Editor: Clone action should copy the selected rows as a block instead interlaced one row at a time. - FIX: Save Results would not include delimiters in CSV. - FEATURE: Added to Window Menu: Show/Hide Editor Window - Ctrl-Alt-F6. - OPTION: Added Option File->Options:General:General:Query Window Divider Size. - OPTION: Added Option File->Options:Table Editor: Prompt for Ambiguous Columns, which allows to execute edit on multitable queries without prompting for ambigious columns. - OPTION: In Server properties under advanced tab, added Data warehouse mode: "Write/Read" or "Read". In Read only mode and "Execute Edit" will prompt the user to continue. 6.5.1: - FIX: Save Results wouldn't save settings for delimiter in the case the delimiter was not in the list. - FIX: (Windows) File->Options: Font Chooser on Windows would not select. - FIX: (OSX) Grid Results: if last column was extended to be wider then the scrollbar wouldn't allow the user to scroll over with mouse. - FIX: Auto-completion: Table list would popup after a table had completed and a space was used (ex: select * from mytable ^) - OPTION: Added "Procedure Editor" category to File->Options with "Package Compile Header & Body" option. 6.5.0: http://docs.aquafold.com/ads/6.5/features_6_5.html 6.4.96 - FIX: (Oracle) Index Script CREATE on functional indexes would not script expression in position of column name. - FIX: (Sybase ASE & Oracle) Debugger : Stepping action was not threaded and would cause a pause in the application while step processed. - FEATURE: (Sybase ASE & Oracle) Debugger : Status line while debugger running now includes "Step Line" and "Step Time" 6.4.95 - FIX: Minor auto-completion fixes. - FEATURE: Grid/Pivot charts: Now has option for grouping values in pie chart. - FEATURE: Table Data Editor: Added "Reconnect" button to allow a user to reconnect in case the connection has been closed. - FEATURE: Grid Results popup menu now has "Save Cell To File" primarily to save BLOB/CLOB data. - FEATURE: (Sybase ASE & Oracle) Debugger: Editor Popup Menu: Added "Goto current line" 6.4.94 - FIX: (Oracle) Procedure/Package Editor: Added support for PLS_INTEGER. - FIX: Grid & Pivot results: Popup Menu Script Full to New Window now opens new window with same database and schema. - FIX: Query Window: Re-execution when a Line Chart was laid out didn't retain the Line Chart - FIX: Query Window: Execute with parameters: The Alt-E and Alt-A mnemonics in Parameter dialog didn't work. - FIX: Save to Excel now converts date older then 1900-1-1 to strings, since Excel doesn't support dates this old. - FIX: Package Editor/Debugger when executing package with functions & parameters that overload because of the same function names, the parameters where not correct. - FIX: Query Analyzer: Autocompletion & SQL Formatter - added support for CTE syntax and a few other bug fixes. - FEATURE: Results Diff: Now has option to select Source & Destination results. - FEATURE: Query Window: Pie Charts now include percentage. - FEATURE: Export Tool: Added "Decimal Symbol" option for numeric values. - FEATURE: Object Search: Added support to search multiple databases at once. - FEATURE: "Morph to delimited list" now supports multiple delimiters for destination - FEATURE: Added File->Options->Results:Text Results:Display Warnings. - FEATURE: Added File->Options->Results:Text Results:Margin Character Length. - FEATURE: (Sybase ASE & Oracle Debugger) Added to popup menu "Run To Cursor" - FEATURE: (Sybase ASE & Oracle Debugger) Added to toolbar the "Profile" option which will list all steps and the time each step takes. - FEATURE: (Sybase ASE & SQL Server) Schema Browser: Added support for Database Link and Remote Server visual editing and DDL generation. 6.4.93 - FIX: Options:Results:Alternate Color Readded option to choose colors for alternating color in Grid Results - FIX: OSX : Query Analzyer window popup menu didn't have the extended actions. - FIX: Query Analyzer: Client Statistics and Script Details result panel has the graph button enable and it shouldn't - FIX: Schema Browser: Doing a Delete on a server and then hitting ESC would still delete the server. - FIX: Query Analyzer Clone: When in a Debugger, Query Analyzer Clone would not open a query window with the same connection. - FIX: Pivot Grid Results: Show Sub Totals now defaults to false - FIX: (SQL Server) Script CREATE table, the column default wouldn't put the constraint name. - FEATURE: Options:Results:Text Results: Added Display Column Header option - FEATURE: (Sybase ASE, SQL Server, Oracle, DB2): Table Properties dialog now contains Referencing-Referrenced Objects - FEATURE: (SQL Server & Sybase) Schema Browser: Security Node, added Remote Server support with DDL Scripting. - FEATURE: (Oracle/SybaseASE) Debugger: The breakpoints grid are now sorted by line number of the breakpoint - FEATURE: (Oracle/SybaseASE) Debugger: Current line is now blue instead of gray so it isn't confused by a comment - FEATURE: (Oracle/SybaseASE) Debugger: Breakpoint grid popup menu now has "Goto" to move focus of the editor to the breakpoint - FEATURE: (Oracle/SybaseASE) Debugger: Step execution is now threaded so the application doesn't pause on long operations. - FEATURE: (Oracle/SybaseASE) Debugger: Added support for "Max Results" - FEATURE: (Oracle/SybaseASE) Debugger: Added to status bar "Step Time" to indicate the amount of time it is taking for the current step. 6.4.92 - [b.2053] - FIX: Save Results: Save to Excel would create files that Open Office 2.1 and above would not display cell values. - FEATURE: Sybase ASE: Schema Browser Tables Detail View now has "Estimated Row Count" - FEATURE: Debuggers and Procedure Editors, the Parameter Dialog now has support for Excel like copy and paste like the Table Data Editor, so that a user can copy all the values of the parameters, save them to a file and then copy and paste them back anytime the procedure is executed. 6.4.91 - [b.2022] - FIX: Formatter: The characters "::" and "||" would break up a token. - FIX: (Sybase ASE) Connecting with user with default database that was inaccessible prevented login. - FEATURE: Query Builder: F5 key is now mapped to Execute - FEATURE: SQL History: SQL Header file now contains USER_NAME(OS User) and HOST_ADDRESS(Ipaddress). - FEATURE: Launching browser now uses OS default for Windows. 6.4.88 - [b.2006] - FIX: (PostgreSQL) Schema Browser: system fuctions parameter where not listed. - FEATURE: (Oracle/Sybase ASE) Debugger now persists parameter values accross execution even if it is modified externally. - FEATURE: (Oracle) Debugger: Added support for debugging Packages. - FEATURE: (Oracle) Session Manager: Added "Long Ops" tab to add support for long operation status. 6.4.87 - [b.1972] - FIX: Table Data Editor: Inserted rows, date values where displayed in incorrect format 6.4.86 - FIX: (Oracle & Sybase ASE) SQL Debugger: Now places execution into the SQL History. - FIX: (Sybase ASE) Query Window: If application level "Show Execution Plan" was enabled and a full script execute occured, the show plan would also take effect as a second execution of the same query, effectively executing the query twice. - FIX: (Sybase ASE) Save Results to Excel for bit datatype now uses 0/1 instead of false/true - FIX: (Oracle & Sybase ASE) SQL Debugger: If procedure was changed externally to debugger, the debugger will reload before execution - FEATURE: Subversion Show History Revision file items now has option to Revert to selected revision 6.4.85 - FIX: (Oracle) Schema Script Generator for Packages and Package Bodies when saving to single file per object would overwrite each other. - FEATURE: (Sybase IQ) Detail Panel View for Indexes now contains "Index Type", including the properties dialog. - FEATURE: (Sybase ASE) SQL Debugger variable and watch panel now have Ctrl/Cmd-F hot key to find in table. 6.4.84 - FIX: Query Builder didn't show system tables. - FIX: Open File Dialog SQL Filter not working - FIX: (Sybase ASE) SQL Debugger: Parameter dialog on executiong where the parameter was a date didn't allow you to enter a date that worked - FIX: (Sybase ASE) SQL Debugger: Execution Monitor no longer monitors debugging session - FEATURE: (PostgreSQL) Added support in Schema Browser for PostgreSQL to have parameters for Functions/Procedures - FEATURE: (Oracle) SQL Debugger - FEATURE: (Oracle) Jobs support in the Oracle Instance Manager - FEATURE: Tools->Object Search: Now allows you to search any database for objects. 6.4.83 - FIX: Editor Find/Replace would not save history of searches - FIX: Introduce Columns would introduce them qualified - FIX: (Sybase ASE) SQL Debugger: Canceling a debug session now longer prints results. - FIX: (Sybase ASE) SQL Debugger: Toolbar now includes: database, schema, user, spid and debug spid - FIX: (Sybase ASE) SQL Debugger: Now saves parameters across executions. 6.4.82 - FIX: Table Data Editor: Filtering would prevent the deleting or modifying of rows. - FIX: (Sybase ASE) Scripting a CREATE on a table that had UDT datatypes for columns would script columns duplicated. - FIX: (Sybase ASE) SQL Debugger: Now supports execution of procedures with Default values and Nulls. - FIX: (Sybase ASE) SQL Debugger: parameter variables that changed during debugging would not be reflected in variable tab. - FEATURE: (Sybase) SQL Debugger: Added to toolbar the "Debug Query Window" that allows the user to execute commands while debugger is running, including SELECTing from temp tables - FEATURE: (Sybase) SQL Debugger: Added support for default values on any parameter. - FEATURE: (Oracle) Tablespace Properties dialog now has Space Usage tab to display usage. - FEATURE: (SQL Server) Database Properties dialog now has Space Usage tab to display usage. - FEATURE: Save Results: Excel Format: Sheets are now named "Grid Results", "Pivot Results", "Charts" - FEATURE: Detail View for Table Columns now resembles the describe results. - FEATURE: (SVN) Added "Branch/Tag" and "Merge" command - FEATURE: (CVS) Added commands "Branch", "Merge", "Switch" and "Tag" 6.4.81 - FIX: (Oracle : OSX) Alter User on OSX would not allow you to change the quota of a user. It would generate the incorrect SQL. - FIX: (Sybase Debugger): Debugging procedure with numeric parameters would fail. - FIX: (Sybase Debugger): Stopping the debugger would do a continue without breaking till the end. Now the procedure stops. - FIX: (Sybase ASE): Script Procedure CREATE didn't include "sp_procxmode 'dbo.ShowProc1', 'Unchained'" to indicate transaction mode. - FIX: (SVN) Checkout new project from root node would not work. - FIX: Save Pivot Table results would save the aggregate function as "sum" everytime. - FEATURE: (SVN) Added "Switch" command to SVN. 6.4.80 - FIX: Editor: Editing a Read-Only file would not allow you to edit in the editor. - FIX: Table Data Editor: Resizingn of columns after save was different then the initial column widths - FEATURE: Added a File->Options:Query Windows: Reuse Editor. [Double click on a tree to open file in the current editor tab] - FEATURE: (Oracle, SQL Server, Sybase) Added to popup menu for triggers in schema browser an option to Enable/Disable triggers. - FEATURE: (Sybase ASE) Database Properties dialog now has a "Usage" tab to display a graph of usage. 6.4.55 - FIX: Procedure Editor & Sybase Procedure Debugger: When executing and parameters are prompted the cell edited will overwrite data on initial keystroke. - FEATURE: Subversion: Added action "Move" and "Rename" in the action popup menu, allowing users to "Move" or "Rename" a file or folder. - FEATURE: (Sybase IQ) Server Registration Advanced Tab now has option for "Query Temp Space Limit". - FEATURE: (Sybase ASE) Index Dialog now supports options for "allow duplicate" and "ignore duplicate" - FEATURE: Added to "Window" menu the item "Show/Hide Panel Toolbar" to be able to show/hide the right aligned toolbar in the main frame for viewing details. 6.4.54: - FIX: Save Results: EOL was sometimes incorrectly used, EOL errors and sometimes failure to save - FIX: Save Results: Save to INSERT would not use the user defined Table Name. - FEATURE: Scripts Browser: Added the ability to create folders and to drag and drop mount points from folder to folder for organization. - FEATURE: (Sybase IQ & Sybase Anywhere) Server Registration: Added to advanced tab the option to enable/disable "quoted_identifiers" on the connection. - FEATURE: (Oracle, Sybase, SQL Server) Storage, Security and Session Manager: Added Quick Filter for TreeTable list item tabs. - FEATURE: (Oracle, Sybase, SQL Server) Session Manager now has option on toolbar to enable color syntax of sessions by status. - FEATURE: (Sybase) Procedure Debugger: Added to Schema Browser, the procedure node popup menu now have an option to debug the procedure. - FEATURE: (Oracle) Registering Oracle with Thin-Drivers using the "Oracle" connection type, now allows you to connect to Oracle RAC and Oracle Connection Manager by entering into "Host" value: Oracle Connection Manager Examples ------------------------------------- (description=(address_list=(address=(protocol=tcp)(port=1610)(host=webHost))(address=(protocol=tcp)(port=1521)(host=oraHost)))(connect_data=(INSTANCE_NAME=orcl))(source_route=yes)) Oracle RAC Examples: ------------------------------------- (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PRIMARY_NODE_HOSTNAME)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=SECONDARY_NODE_HOSTNAME)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DATABASE_SERVICENAME))) (DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx)(PORT=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1526)))(CONNECT_DATA=(SERVICE_NAME=somesid))) 6.4.53: - FIX: Sybase Role permissions in Role Properties was incorrect under certain circumstances. - FIX: SVN and CVS delete operation now also delete the filesystem files. - FIX: MySQL "User Properties" dialog now allows you to change the database permission combo box so you can see permissions. - FIX: Enabled Ctrl-Shift-K keybinding for Word Match feature in editor. (this will complete a word based off of previous words in the editor) - FEATURE: Added Option File->Options->General:General:Disable Drag and Drop in Editor. This prevents the droping of text into the editor. - FEATURE: Script Table CREATE (full) for MySQL Tables now includes ENGINE option - FEATURE: Schema Diff Tool & Schema Script Generator include storage for MySQL now includes ENGINE option. 6.4.52: - FIX: Printing would not obey the margins. - FEATURE: Informix Script Table CREATE now contains LOCK MODE & CREATE (Full) contains LOCK MODE and EXTENT - FEATURE: Schema Diff tool now has option to script Storage on tables for compares. - FEATURE: Database script may now be executed from the command line with the syntax: Usage: runscript[.bat | .sh] "-cMy Connection" "-fc:\myscript.sql" "-oc:\myscript-out.txt" "-uusername" "-m100" "-htrue" - connection [-c] - [required] Identifies the connection name. - filename [-f] - [required] File name of the script to execute. - output file [-o] - [optional] File name for the text output. Standard out is used if not defined. - username [-u] - [optional] Username to use for login. If not indicated, then the saved username will be used. - password [-p] - [optional] Password to use for login. If not indicated, then the saved password will be used. - maxResults [-m] - [optional] Max Results in any given query resultset. - binaryToHex [-h] - [optional] true/false in option to convert hex to binary. 6.4.51: - FIX: Show/Hide browser didn't persist the browser tab select before the hide. - FIX: Server script generator generated DDL in an incorrect order of dependencies. - FIX: Grid Results: Quick Filter on a specific column sometimes wouldn't work. - FEATURE: SVN history now has popup menu option to "Compare Revisions" with a interface like "Directory Diff"s - FEATURE: SVN Update: When a file is conflicted, a Compare to local revision will show the differences between the local copy and head revision 6.0.21: - FIX: (Sybase) : Sybase Storage Manager: List of Cache would display incorrect size on caches bigger then 4 gigs. - FIX: (Sybase) : Sybaes Storage Manager: Device usage was incorrect in the case the server was setup with a 4k page size. - FIX: (DB2) : Visual Explain: If the current schema context in a query window was changed, then Execute Explain would not work. - FIX: If File->Options->Statement Separator whas changed to ";" then the Visual Editing dialogs would not apply changes, instead the user would get an error. - FEATURE: Query Analyzer Window: Added in Server menu "Query Analyzer Clone", allowing a user to open multiple tabs in the Window frame as long as it is on the same server. - FEATURE: Schema Browser filtering on Object Folders is now applied to the Schema and/or object name defined in the advanced tab. So, if the schema and object name are defined then the filter will be applied to the schema and object name instead of just the object name. 6.0.20: - FIX: (SQL Server) - Script Procedure where the procedure had a comment block before the definition with 1 or more line feeds seperating the comments and definition, would not script correctly. - FIX: (MySQL) - Scripting a Primary Key or Foreign Key constraint as a separate and individual script would generate the DDL incorrectly. - FIX: (PostgreSQL) - Script Procedure CREATE and executing Procedures with $$ syntax: Minor bugs - FIX: Procedure/Package Editor: If the connection of the editor was dropped, and a compile was executed, it would warn that the connection was closed, but any subsequent compiles would report successfully. - FIX: Procedure/Package Editor and Image Viewer: One window resize, made the bottom panel fixed width and top resizable. - FIX: SQL Editor: Comment Block with space between ending "*" and "/" would cause unclosed comment. Example: "/* **** */". - FEATURE: Added aqua script command ".saveResults" and ".saveLastResult" with the following syntax ... 6.0.19: - FIX: (Oracle) File->Options->Results Format: Added TIMESTAMP for Oracle - FIX: (Oracle) Register Oracle Database: Added support for LDAP in this format Host: ldap://xx.yy.zz Port: 389 SID: cn=OracleContext,dc=world/y5 - FIX: (Sybase ASE) - Session Manager now works for users that don't have sa_role - FIX: (Sybase ASE) - Create Database Dialog sometimes would generate a blank SQL statement. - FIX: (Sybase Any & IQ) - Script Table CREATE which had columns with User Defined Datatype would script with base datatype - FIX: (Sybase Any) Extract methods on database with BLANK PADDING ON would script with spaces in datatype name - FIX: (Oracle) Schema browser and Script Table didn't support GLOBAL TEMPORARY tables. - FIX: (Sybase Any & IQ) Schema Browser and Script Table didn't support GLOBAL TEMPORARY tables. - FIX: Query Analyzer Clone: Now keeps the same divider location as the previous window. - FIX: Application icon has been changed to a higher resolution. - FEATURE: Export Tool: Now has option to indicate the Date quote identifier. - FEATURE: AutoCompletion: File->Options->Scripts-> Now has options "Quote Identifier for Object Table Completion" and "Quote Identifier for Column Table Completion", which will allow auto-completion to complete object/column names to be quoted on completion. 6.0.18: - FIX: Editors: Key bindings for Duplicate Line/Selection changed to Ctrl-K (Cmd-K on OSX) 6.0.17: - FIX: (OSX) - Text/XML/HTML Editors - Preview in browser didn't work on OSX. - FIX: Editors - Added Shift-DELETE to cut current line, and CTRL-L to duplicate current line or selected text 6.0.16: - FIX: (Oracle) - Script DDL on foreign key constraints contained an incorrect "ON DELETE" clause if there was no action set initially - FIX: (Sybase) - Syntax Coloring in Editor: Added "STATISTICS" - FIX: (Sybase) - Script DDL on NONCLUSTERED INDEX with ALLOW_DUP_ROW now explicitly adds ALLOW_DUP_ROW into DDL - FIX: (Sybase) - Script Permissions didn't always get all the permissions (under unreproducable scenarios) 6.0.15: - FIX: Unable to rename an Editor Tab - FIX: Table Data Editor: Fill Up/Down where the initial value is NULL would fill a string value of "(null)" - FIX: (Sybase ASE) Script Table CREATE with foreign key that references table in a different database then the table, the foreign key would not be scripted. - FEATURE: (DB2) Support for DB2 Kerberos Authentication 6.0.14: - FIX: (PostgreSQL) Script CREATE (Full) on a table would script an index that was bound to the primary key. 6.0.13: - FIX: Query Windows: Execute Edit: Doing and Execute Edit on a statement that wasn't a SELECT would still execute the statement. - FEATURE: Added File->Options:General:General:[Display Splash Screen] to give the user to disable the splash - FEATURE: (Oracle) Schema Browser Scripting: Added support to script CREATE & DROP for Database Links 6.0.12: - FIX: (SQL Server) Extract & Script database user: Optimize the query which didn't perform well on databases with many users. - FIXL SQL History: In some cases Oracle drivers didn't return the current database and would cause SQL History not to save statements. 6.0.11: - FIX: Tab Labels: Label names are no longer truncated with "..." in the center of the label name. - FIX: Procedure & Package Editor Tab Labels: Now have the initial tab name - 6.0.10: - FIX: Script Generator: Sort Dependency would return a "null" error message. - FIX: (Sybase Anywhere) Script Procedure CREATE would pad procedure name with spaces. - FIX: (Sybase) Script Database CREATE: Now recreates DDL in the same format initially used to create the database to maintain logical positioning. - FIX: (Sybase) DBA Tools: Storage Manager: Now calculates size with @maxpagesize instead of @pagesize 6.0.9-RC1: - FIX: Query Builder: Clicking on a shortcut would not clear the old criteria values if the cell editor in the cell was still open - FIX: Sybase Anywhere/IQ: Alter Table Dialog would modify the table by using the user name as the schema regardless of the schema owner - FIX: Schema/Directory Diff: The initial diff of the files and objects would not take into consideration "Ignore Case" - FEATURE: Query Builder: Shortcut buttons now have in the popup menu "Add selected to query", "Overwrite query with selected" - FEATURE: (DB2) Script Generator: Added support for "Enable Identity Insert" for GENERATED columns 6.0.8-RC1: - FIX: Options Dialog: If a value was changed but the cell editor was open and the "cancel" button was clicked, then the editing value would reappear when the Option Dialog was reopenned. - FIX: Import Tool: Not selecting a table would still allow the user to proceed. A table selection to import into is now required. - FEATURE: (Sybase) Script Server Login DDL now includes fullname, passwdexp, minpwdlen, maxfailedlogins and auth_mech. - FEATURE: (SQL Server) Script Server Login DDL now includes sid and encriptopt. - FEATURE: Server Registration: Advanced tab: Added "Enable db filters for query window" to allow the filtering of databases in the query window 6.0.7-RC1: - FIX: (Generic JDBC/ODBC) after executing a statement/script the database would reset to the first one - FIX: (Oracle) Query Window: Changing current Schema didn't use double quotes on schema name, so schemas with case and numbers would not work. - FIX: (SQL Server): DBA Tool: Session Manager: Session name was always 'Process ID' + (background) and not user name - FIX: (Sybase): DBA Tool: Session Manager: Session name was always 'Process ID' + (background) and not user name. - FIX: (Sybase): DBA Tool: Session Manager: Current database was always 'master' - FEATURE: Added File->Options->General:[Query Window: Show File Name] which determines if the currently open file name is displayed in the tab name. 6.0.6-RC1: - FIX: (Oracle) Schema Browser: Package Functions & Procedures: Script->Object:EXECUTE BIND would not work. 6.0.5-RC1: - FEATURE: SQL History: Added "Database" column to identify the database the database the query was executed in. - FEATURE: Grid Results: NULL values are now in italics to distinguish between "(null)" string and "(null)" value. - FEATURE: File->Options->General:History:Enable SQL History Archiving. This will archive SQL History instead of deleting them. The SQL History is archived into \.datastudio\history\archive 6.0.4-RC1: - FIX: Sybase DBA Tools: Storage Manager: Databases with size usage greater then 4gigs would show a size of zero. - FIX: Auto-completion: column completion imidiately after a "/", "+", "-" and "*" would not complete - FEATURE: Table Data Editor: NULL values are now in italics to distinguish between "(null)" string and "(null)" value. - FEATURE: File->Options->SQL Editor:[Syntax Coloring:Enable Bold]. This option allows the user to enable/disable boldness in the keywords. - FEATURE: File->Options->General:[Difference Tool]. Added options "Ignore Leading Spaces", "Ignore Trailing Spaces", "Ignore Embedded Spaces", "Ignore case" as options for comparing. 6.0.3-RC1: - FIX: Table Data Editor: Added option in File->Options:Table Editor: "Transform '(null)' to NULL value when pasting from clipboard". This option provides the ability to set the behavior on how to handle text values of '(null)'. This allows a user to copy/paste within the Table Data Editor and to keep NULL values. - FIX: SQL Formatter: Line break after comma would happen after commas in functions calls - FIX: Could not open Image Viewer from Toolbar if there were no Query Windows open. - FEATURE: Query Builder Shortcuts - File->Options:General:Query Builder [Shortcut Persistance] = {None, Application, Query File}: Determines if the shortcuts in the Query Builder are saved within a query file, as a global list of shortcuts, or not at all. - Added to popup menu of shortcuts "Move Right", "Move Left" and "Properties" - Properties for Shortcuts now allow the renaming of the shortcut, setting a keybinding and indicating if all tables are to be cleared - FEATURE: Auto-Describe: Constraints now contain columns, referenced table/columns and check text. - FEATURE: Editor: and Edit menu: Added "Goto Line" action with Ctrl/Cmd-G keybinding. This allows the user to goto a specific line in the editor. 6.0.2-RC1: - FIX: Oracle Session Manager: Lock Tab: Tree was not showing icons. - FIX: SQL Server: Editing a Procedure with a comment before the procedure where the comment was more then 4096 bytes would cause exception - FIX: Options: Key Mapping: Changing a keystroke on a profile would be saved and used correct, but would display correctly in the tree list. - FIX: F5 key shortcut to execute query window was not working as in previous versions of ADS. Added this back. - FEATURE: Added File->Options:General:Difference Tools:Ignore Spaces. Which indicates whether the right/left trimming of lines before comparing. - FEATURE: Schema Diff Tool now show progress while extracting initial objects for better progress display. - FEATURE: Directory Diff Tool: Now added a filter option to filter results - FEATURE: Options: Key Mapping: Double click on action will edit the shortcut for quicker access 6.0.1-RC1: - FIX: SQL History: The start/end date was always the current date even though the dates were stored correctly. - FIX: [Sybase ASE]: Import Tool: The schema combo box now contains the "guest" as a schema option to allow importing temporary tables. - FIX: Table Data Editor: "Insert Date Only" would insert next day if current time was after 12noon. - FIX: [Generic JDBC/ODBC] Schema Browser didn't apply filters. - FIX: [Sybase ASE] Import Tool: Exporting from a SELECT statement with an alias would display the column name as the label instead of the alias. - FIX: Application: If a single Query or Editor window is open with a file and then closed, the application header still has the file name in it. - FIX: ER Diagram Frame: with L&Feel of Aqua Data Studio(Stylus) would have the "Layout:" and "Entity View" labels in Gray. - CHANGE: Oracle Package Editor: Selecting a function/procedure in the combo box doesn't highlight anymore just goes to the first character. - FEATURE: Added a Splash Screen - FEATURE: Table Data Editor: If the results are truncated then the bottom right box of the status bar indicates the Truncation with coloring if enabled. - FEATURE: Table Data Editor: Current focused cell now has black border like Excel/OpenOffice. - FEATURE: Table Data Editor: Added "Copy" and "Paste" to Edit menu and popup menu 6.0.0-RC1: http://docs.aquafold.com/ads/6.0/features_6_0.html 4.7.1: FEATURE: Query Builder: Add Table Dialog popups up when initially opening the Query Builder FEATURE: Query Builder: Add Table Dialog is now modeless so that the user can add tables and work on the Diagram pane at the same time FEATURE: Query Analyzer Permissions: (SQL Server & Sybase): Now permissions are not applied to SQL statements on temporary tables and tables in the tempdb FIX: Query Builder: When a statement is executed, if a cell value in the columns pane was being worked on but not commited then it would not apply to the execution of the query. FIX: Query Builder: Added tables which had matching tables in other schemas would have the columns added from the other schemas into the graph as well. FIX: Query Builder: Creating a second JOIN criteria between two tables didn't work if the variables are (a,b) in table 1 and (b,a) in tables. The second drag-and-drop was ignored. FIX: Query Builder: FULL OUTER JOIN on MySQL, Oracle 8i and Sybase was not generating complete SQL FIX: Query Builder: WHERE Criteria for SQL statement now has correct paranthesis for all AND and OR statements FIX: Script Generator: Now sorting constraints by type, then name to make diffs of schemas easier to do. FIX: Script Browser: F5 would not refresh. FIX: Script Browser: Did not have the ability to display files without an extension. In File->Options->General:Script Filters a "*" may be added to include files without extensions FIX: SQL Formatter: Uppercase Keywords would not uppercase AS, CASE, THEN and ELSE FIX: (Sybase) Table Data Editor: If a SELECT is done on a table with no primary key or unique constraint, but has a unique index, ADS would not use it as a primary key. FIX: (DB2) Query Window Syntax Coloring: Added keywords COLLECT, SAMPLED and DETAILED FIX: (Oracle) Session Manager: Sort order in Session Stats was not saved between refreshes. 4.7.0: CHANGE: Tagged current build as 4.7.0 FEATURE: Visual Query Builder: Added new query builder which may be accessed through the main application toolbar and the popup menu in the schem browser 4.6.17: FEATURE: (DB2) SQL Statement Execution. All "--" comments are removed from SQL statements except for CREATE PROCEDURE, FUNCTION and TRIGGER before execution regardless if they are client or server side comments FIX: Grid Results: copy to clipboard would add a line feed after last line. FIX: (Oracle) Script Generator: If a foreign key constraint was created on a reference table column which had an Index created on the column before the primary key constraint was created, then the reference column would not appear in the CREATE CONSTRAINT statement. 4.6.16: FEATURE: (Oracle, DB2) Query Window: There is now the ability to change the current schema. The toolbar now has a combo box with a list of schemas. Changing the current schema will change the context for auto-completion and the context of the database. FEATURE: Syntax Coloring: Added an option in File->Options:Editor for coloring numerics. Default syntax color of numerics is magenta. FEATURE: Editor: Added an option in File->Options:Editor for enabling/disabling auto-brace matching. Default value is enabled. FEATURE: Schema Browser: - Added the ability to mount different folder locations into the schema browser, so that users can mount shared directories to share folders. - Added ability to rename a Server connection in the Server Properties - When deleting a folder with connections in it, ADS will notify the user that all connections and sub folders must be removed before proceeding. - Added the following Key Bindings to the schema browser functionalities - CTRL-INSERT: Connect - CTRL-DELETE: Disconnect - SHIFT-INSERT: Register Server Clone - ALT-ENTER: Server Properties - ENTER: Will expand/collapse current node FEATURE: (DB2) Schema Browser: Added "Materialized View" node to display a list of Materialized Views and the columns and indexes of the views FIX: (Oracle) Script Generator: Now includes the PUBLIC schema. FIX: (Sybase and SQL Server): Query Analyzer: Executing an UPDATE statement with an "exists" clause would set the Statement.setMaxRows() limiting the rows modified. FIX: (Sybase and SQL Server) Permissions: INSERT statements on temporary tables avoided permissions 4.6.15: FEATURE: Queray Analzyer: Optional popup confirmation dialog for uncommitted transactions now warns if a UPDATE or DELETE statement is executed without a WHERE clause FEATURE: Parameterized Scripts: option to define a default value for a parameter in a parameterized script Example: SELECT * FROM DEPARTMENTS WHERE DEPARTMENT_ID = &id=10 Example: SELECT * FROM DEPARTMENTS WHERE DEPARTMENT_ID = &id='' Example: SELECT * FROM DEPARTMENTS WHERE DEPARTMENT_NAME = '\&name='John Doe'' Example: SELECT * FROM DEPARTMENTS WHERE DEPARTMENT_NAME = '\&name=John' FIX: Query Analzyer: Script parser: Statement with a quoted string that contained a linefeed,GO,linefeed would be split into two statements FIX: Parameterized Scripts: Parameter names with special were allowed, they are no longer allowed and are terminated if the name contains any character other then a-z/A-Z/0-9. FIX: Parameterized Scripts: Execute Edit now supports parameterized scripts FIX: Query Analzyer: Auto-Completion where a column was in a function with more then one parameter would cause the auto-completion to always complete with tables. FIX: Procedure Editor: A "--" client side comment in a quoted string would through off the parser. FIX: (Oracle) Create Table Dialog: Foreign keys would be created as DISABLED. (bug introduced in 4.6.10) FIX: (Oracle) Schema Browser: Foreign Key constraint sometimes had double identical values. FIX: (Oracle) Table Data Editor: SQL Generator for Date modifications now use TO_DATE('','YYYY-MM-DD HH24:MI:SS') instead of TO_DATE('','YYYY-MM-DD HH12:MI:SS PM') to prevent a syntax error when running ADS in Japanese locale 4.6.14: FEARURE: Schema Browser: Servers that don't have their passwords saved. When a user connects and specifies a username and password, ADS will now hold the username and password in memory until the user disconnects or closes ADS. The username and password will be used when openning a query window, tool or scripting. FEATURE: Added File->Options:General:Prompt for commit when auto-commit is OFF which will determine whether the application will prompt the user to commit if rows are modified and auto-commit is not enabled. FEATURE: (Oracle) Session Manager: Added column to session tab for SPID. FEATURE: (Oracle) Session Manager: Added in toolbar the MAXIMUM number of processes FIX: Query Analzyer: Executing a CallableStatement with .executeCallableQuery would not print out sql warnings. FIX: Parameterize Scripts: An "&" in a single quoted string without a leading "\" where it is not the first character in the single quote, a parameter dialog would prompt for a variable. FIX: (Oracle) Profile Dialog: editing or viewing profile would not set the "Expire in" correctly. FIX: (Oracle) Security Manager: User tab: Added columns "Locked Date" and "Expired Date" FIX: (Informix) Create Table Dialog: (Bug Introduced in 4.6.10) Prevented from creating table with VARCHAR/NVARCHAR because it required a precision and scale value 4.6.13: FEATURE: (Oracle) Session Manager: Added in toolbar the ACTIVE, INACTIVE and MAXIMUM number of sessions FIX: (SQL Server, Sybase, Sybase Any): ADS would not use the Statement.setMaxRows() to trunace rows because of a driver bug. This caused performance issues when quering on a table with large number of rows, even if the Max Rows was set to a low amount. ADS now analyzes the query and only uses Statement.setMaxRows() with statements that have a SELECT statement. FIX: Parameterized Scripts: Client Side Comments are now not replaced or prompted for when executing script FIX: Parameterized Scripts: Parameter Dialog: parameters were not in order of occurance. FIX: Parameterized Scripts: Parameter Dialog: multiple parameters of the same name in a quoted string incorrectly replaced the values FIX: Parameterized Scripts: Parameter Dialog: Cancelling on the dialog would still execute the script. 4.6.12: FIX: Query Analzyer: Executing a statement when "Auto Commit" enabled, "Commit" and "Rollback" are not re-enabled after query completes. 4.6.11: FEATURE: Options:General: Added "SQL Server Quoted Identifier (Default)" and "Sybase Quoted Identifier (Default)" so the user may define the default value when registering a Sybase or SQL Server FEATURE: Query Analyzer: Parameterized Script: Ability to execute scripts with defined parameters. Parameters are defined by a leading "&". Parameters in quotes need to be escaped by "\". Example: SELECT * FROM DEPARTMENTS WHERE DEPARTMENT_ID = &id Example: SELECT * FROM DEPARTMENTS WHERE DEPARTMENT_NAME = '\&name' - Query Window toolbar: added "parameterized scipt" toggle button. - Options:Query Analyzer - Added option to specify default value of "Parameterized Script" for each database. FEATURE: (Oracle) Session Manager: Added USERNAME to the Session columns and the Grouping toolbar button. FIX: Query Analyzer: Query statment with a "--" server side comment at the end of the statment would prevent "Execute Edit" from executing. FIX: SQL Formatter: Formater didn't format statements wit "~" in it. FIX: SQL Formatter: Added "PLAN" as a keyword for line breaks. FIX: SQL Formatter: RIGHT, LEFT, OUTER, JOIN and ON where no uppercased when Uppercase Keywords option was on. FIX: Schema Browser: Performance increase on expanding nodes with large lists. UI event update only fired once for all items, instead of firing event for each new node. FIX: (Oracle) Schema Browser: Optimized queries for folders Tables, Package Bodies, Package Functions & Procedures and Parameters. FIX: (Informix): Script Procedure/Function: Scripting Functions & Procedures with a script separator of ";" would include two ";" at the end of the CREATE statement. FIX: (Informix): Auto-commit being disabled would prevent the user to change the current database. FIX: (Informix): Extract Index: Informix 9.3 and above only supported 8 columns in index when up to 16 are supported. FIX: (PostgreSQL): Script CREATE Table: Tables with varchar columns without column size definition would script as "varchar(-5)" FIX: (Sybase): Constraint Scripting & Script Generator: Scripting Table w/ Constraints would generate CREATE INDEX for unique constraints. FIX: (Sybase): Script CREATE TABLE: Binded defaults were not scripted as a separate bind statement. FIX: (Sybase): Script Generator the order of CREATE DEFAULT and CREATE TABLE were not in the correct order. FIX: (Sybase): Script CREATE Table now contains LOCK DATAROWS, ALLPAGES, DATAPAGES syntax FIX: (SQL Server): Script CREATE TABLE: Binded defaults were not scripted as a separate bind statement. FIX: (SQL Server): Script Generator the order of CREATE DEFAULT and CREATE TABLE were not in the correct order. 4.6.10: REQUIREMENT: This build now requires Java 1.5, before update verify ADS is being run by Java 1.5 in Help->About:System:java.version UPDATE: Upgraded to JGraph Library 5.7.4.5 and JGraphLayout 1.2.2 FEATURE: Table Data Editor: Option in Options:General:Table Data Editor - Option to disable transaction requirements for table data editor. Some Informix databases my have transactions disabled. User may disable transaction requirements at own risk. FEATURE: Server Registration: Generic JDBC connections: When browsing file selection for drivers, user may now select multiple files at a time with Control-Click. FEATURE: (Oracle) Oracle DBA Tools now use threads and delayed tab quering to increase UI response time in case of long running meta data queries, and prompts user with "Searching ..." messages. FEATURE: (SQL Server 2005): Schema Browser: Added folders for Synonyms, System Views, Assemblies, XML Schema Collections, Asymmetric Keys, Certificates and Symmetric Keys FEATURE: (SQL Server 2005): Schema Browser: Added Schema name to objects in Datatypes, Rules and Defaults FIX: Export Tool: When exporting a table (not a resultset) ADS will prequery (select count(*) from table) to get a total count of rows to be exported to make an exact estimate to completion. FIX: Server Registration: Components on General Tab would not resize with the window size. FIX: Schema Browser: Drag-n-Drop of servers from groups to groups didn't work since the new Shortcut Toolbar. FIX: Import/Export Tool: Average Row Time and Estimated time was calculated without fractions of a millisecond which had less time accuracy. Now time is calculated with 1/1000 of a millisecond accuracy. FIX: (Oracle): Script Constraint defintions, added support for Constraint state keywords ENABLE/DISABLE, RELY/NORELY and VALIDATE/NOVALIDATE FIX: (Oracle): Schema Browser: Previously didn't display tables based off of Object Types. FIX: (SQL Server 2005): Schema Browser, Logs only contained date. Now has full log. FIX: (Sybase): Openning a query window with no database context selected in schema browser now sets database to the user default. FIX: (SQL Server, Sybase, Sybase Any): Query Window Max Results affected UPDATE/INSERT statements row max modifications because of Driver bug. Workaround now fixes issue. FIX: (Informix): Table Script CREATE definition. VARCHAR and NVARCHAR datatypes with reserve values (ex: VARCHAR(3,1)) would be scripted with incorrect length values. FIX: (Informix): Script Generator: Scripting Functions & Procedures with a script separator of ";" would include two ";" at the end of the CREATE statement. ADDED: SwingX Library by Sun Microsystems (http://swinglabs.org) Source/License: http://download.aquafold.com/download/libraries/swingx/ 4.6.9: FEATURE: Server Registration: Oracle Connections: SID option: Service Name is now allowed by appending "SERVICE:" in front of the value, in which case ADS will use the new URL ServiceName format jdbc:oracle:thin:@//host:port/servicename. FIX: Oracle Connections: In build 4.6.8 I changed the connection URL to use the format jdbc:oracle:thin:@//host:port/servicename which prevented connections in certain scenarios. Now reverted back to old format. FIX: SQL Server 2005: - Database Visual Editing/Scripting: If a log file had a MaxSize = MAX_INT then the log file would not be included. - Triggers Schema browser/Scripting: Would not be visible or scriptable if the schema was not "dbo" FIX: Save Results: XML Format: Added encoding for ><&"' characters 4.6.8: FEATURE: Oracle DBA Tools - Added DBA Tools for Oracle including: Instance Manager, Storage Manager, Rollback Manager, Log Manager, Security Manager, Session Manager, SGA Manager and Server Statistics - Application Menu bar now provides a list of Oracle DBA Tools. - Schema Browser context menu now contains Oracle DBA Tools menu for Oracle connections. FEATURE: Query Analyzer Permssions by Server Type {Production, Development & Test}. - Default Permissions: Added File->Options->Permissions to set the default permissions to a server connection by server type. - Server Connection Dialog: Added Permissions Tab to specify Query Analyzer permissions. Permissions are set by selecting Server Type, and are modifiable after server selection. - Query Analyzer: SQL execution is restricted depending on server permissions. FEATURE: Register Server: Username and Password may now be external application which provides the username or password in the StdOut. To specify an external application, wrap the value with a "~`" at the beginning and "`~" at the end of the value. Example: On Windows, the username or password value can be ~`cmd /c more "%HOMEPATH%\username.txt"`~ where username.txt has the username or password in it. Note: On Unix you may not execute scripts because the JVM has problems retreiving the StdOut when running a command shell (sh, bash), but binary executables work FIX: Toolbar Shortcuts: Allow shortcuts from any node FIX: (DB2) Table Data Editor: Enabled editing for LONG VARCHAR data types. FIX: (Sybase) Extraction: In some cases Unique Constraints where not extracted. FIX: (MySQL) Extraction: Procedure & Functions with 0 parameters where the parameter brackets have a space in between Example: "( )" would not extract 4.5.16: FEATURE: Server Registration: Added button next to the Port field which will do a socket connection test on the host and port specified. FEATURE: SQL Formatter Options: Options Dialog now has a tab for the SQL Formatter options, including an option to allow for formatting to happen without the prompting the dialog each time. FEATURE: Visual Editing & Scripting for Storage & Security: Added quoted identifiers to SQL generation. FEATURE: Options->Scripts: Added "Visual Editing Quote Identifier" option to enable/disable quote identifiers in SQL generation while using Visual Editing. CHANGE: Options->Scripts: Changed options into grouped grid layout. FIX: Grid Results/Table Data Editor: HTML Text values where rendered as HTML in the cell of the grid. FIX: Syntax Color: '|' would not terminate keywords and prevent coloring of the keyword. FIX: Auto-Completion: A line comment that is after a table name where there is no space between the table and the comment would not include the table in autocompletion (Ex: FROM MYTABLE, YOURTABLE-- This line comment) FIX: Table Data Editor: Save Refresh wouldn't refresh (Bug Introduced in build 4.5.15) FIX: (Oracle) Show Execution Plan on AutoCommit:disabled: Executing wouldn't warn user transaction would be commited if the Explain Plan needed to CREATE/DROP the plan_table FIX: (Sybase Anywhere): Script CREATE View, Trigger and Procedure would use the systriggers.trigdef and sysprocedure.defn catalog view to extract the trigger source instead of the systrigger.source and sysprocedure.source table. The source was formatted slightly different. Source is now extracted from systrigger.source and sysprocedure.source FIX: (Sybase Anywhere 9): Unique and Check Constraints would script CREATE statements incorrectly under certain circumstances. FIX: (PostgreSQL 8.1) Security Permissions: Added support for the new makeaclitem() signature so that permissions would be supported. 4.5.15: FEATURE: Query Window: Added "Format Current Statement" and "Format Script" commands to automate menu. FEATURE: Table Data Editor: Added status bar which displays the format pattern of the current selected cell. Pattern is no longer displayed in the cell when editing a NULL value. FIX: Convert Binary to Hex: [File->Options->Results]: Blobs where not being converted to hex, only other binary datatypes FIX: Save Results: Saving to Excel Spreadsheet was limited to 32,767 rows. Increased to 65,536 and rows are broken up into sheets. 4.5.14: FEATURE: Auto-Completion: Added support for SHOW CREATE TABLE Syntax FEATURE: SQL Formatter: Added support for indenting Sub-Select statements FEATURE: (SQL Server 2005): Added schema folder to schema browser in database objects FIX: Table and Column drag-n-drop to editor was not working (broken after build4.5.10) FIX: Query Panel now shows all databases in combo box, and are not filtered the same as the schema browser FIX: (Oracle): Oracle JDBC driver sometimes returns Date value for Timestamp column. ADS was returning Err. FIX: (SQL Server 2005): Schema names other then dbo(database owner) where not showing up. Changed from using USER_NAME() to SCHEMA_NAME() in 2005 4.5.13: FEATURE: SQL Formatter: Added option to wrap line after X number of characters in a line. - Added option to align indent on AS and align on JOIN FEATURE: Application frame now saves maximized status when exiting and restores it at startup. FEATURE: (PostgreSQL): Added to Schema Browser a Procedure folder to list functions with a VOID return. FEATURE: (DB2): Support for Nicknames. Added support to schema browser and for DDL scripting. FIX: Syntax Coloring: Single quoted strings incorrectly colored when preceeded by '-' (Ex: tdate-'01/01/2001') FIX: Grid Results: CTRL-Click on a column to select where the columns were moved around would cause the wrong column to be selected. FIX: SQL Formatter: SQL Statements which had column names starting with ORDER or GROUP would result in an empty string. FIX: (DB2) Syntax Coloring: Added keywords: MATCHED, OVER, PARTITION and Functions: ROW_NUMBER FIX: (Informix): Script Table: Decimal and Floats didn't have precision/scale values. 4.5.12: FEATURE: Added support for Object Filtering in the Schema Browser. In the Server Registration under the Filter tab, there is now the ability to add filters to folders with wildcards. FEATURE: Added Wildcard filtering to Schemas and Folders in the Server Registration. *=wildcard, ?=any character FIX: Grid Results: Rearranging the column locations and then coping to clipboard would leave the data in the original order, but the headers in the new order. FIX: (Oracle): Editing source of Procedures/Packages where a '?' was in a quoted string and a commnet block had a single quote (with no matching quote) would save the '?' as ':1'. Disabled in Oracle JDBC driver EscapeParsing with Statement.setEscapeProcessing() to fix this issue. 4.5.11: FEATURE: (Oracle): Storage Support ... - Visual Editing storage support for Tables, Indexes and Clusters. - Scripting support for storage for Tables (CREATE (Full)), Indexes (CREATE) and Clusters (CREATE). FIX: SQL Formatter: Now the statement separator is preserved instead of being replaced by GO. FIX: Import Tool: Now takes into consideration files which only use carriage returns to separate lines (Mac) FIX: Shortcut Toolbar: Renaming button would rename the path so shortcut wouldn't work properly FIX: (Oracle): Procedure Editor: Executing a procedure in a package with a parameter of type REF CURSOR would fail. 4.5.10: FEATURE: Shortcut Toolbar: Added support to drag a database as a shortcut. When openning the query it will go to the database and open a query window to that database. FIX: Query Window Animated Icon: On OSX and on Java 1.5 on other OSs, after executing a query the CPU time for ADS was still high because of a Thread bug in Java related to animated icons. Found work around. FIX: Script Formatter would append the last character of a script as a new statment if the last character in the script was a line feed. FIX: Shortcut Toolbar: Clicking shortcut will browse to server node, but will not expand the node, so it will not open a connection if the node is a server node. FIX: Table Visual Editor: Changing datatype from VARCHAR to NVARCHAR (or vice versa) with the same length would not generate a change. FIX: (Informix 10): Extracting Table with columns having "default ''" would fail because Informix 10 stores it as NULL. 4.5.9: FIX: Opening a Query Analyzer with a Toolbar shortcut didn't allow the user to execute a statement. FIX: Opening a Query Window didn't allow a user to execute a query (related to animated icon for tabs) 4.5.8: FEATURE: SQL Formatter: Added SQL Formatter that will format SQL statements according to specify parameters defined in an options dialog. - Added menu items "Format Current Statement" and "Format Script" - Added hot keys CTRL-B to format current statement and CTRL-Shift-B for format script FEATURE: Short Cut Toolbar: Added Shortcut Toolbar. The empty, right side of the application toolbar accepts drag-n-drop actions. If the user drags a server from the schema browser into the toolbar it will create a button/shortcut to that server. If the shortcut is clicked, the application will automatically browse to that server and open a query window to it. FEATURE: Status bar: Application status bar now contains the path that is selected in the schema browser FEATURE: Editor: Copy and Cut action when there is nothing selected will perform the action on the current line. FEATURE: Query Analyzer: Added an animated icon to the tab of the query window when a query is executing. FEATURE: (SQL Server, Sybase, Sybase Anywhere, PostgreSQL, MySQL) Query Window: Added Connection ID to window toolbar. FIX: Auto-Completion: Added support for HAVING clause which would through the parser off FIX: Grid Results: Selecting all column values with CTRL-Click on column would not allow you to copy to clipboard FIX: (SQL Server) Query Window: If auto-on-all schemas was enabled and user was not database owner the description of the table would have the username as the schema name instead of dbo. FIX: (Oracle) Schema Browser & Extraction: NVARCHAR2 lengths were defined as byte length, not character length. FIX: (Oracle) Schema Browser & Extraction: Declared NUMBER datatype without precision or scale was scripting as (22,0) when it should be defined at all to define unlimited value. 4.5.7: FEATURE: (MySQL 5): Added support for bit datatype FEATURE: (Sybase Any): Schema browser, added Events folder to support events. FEATURE: AutoCompletion: Added support for multi table column completion on aliased sub queries with multiple columns. Ex: "select SubTab.^ from (select * from table1, table2) SubTab" FEATURE: Added Option in File->Options:Grid Results[Copy to clipboard as default]. When coping numeric data to the clipboard, the numeric values will be copied completely instead of the formatted value is results format in case the format truncates data. FIX: AutoCompletion: Now supports Unicode characters (was broken with new parser) FIX: Cycling through tab windows with CTRL-TAB would not reset focus to editor FIX: Export Tool: Now does not right trim string values. FIX: (DB2): Converted almost all SYSIBM schema reference to SYSCAT references in extraction to better support DB2 variants other then DB2 for LUW(Linux/Unix/Windows) FIX: (Oracle): Extract Trigger was not appending the WHEN clause 4.5.6: FEATURE: (Oracle) Auto-Completion: support for PUBLIC synonyms in the table list FIX: Auto-Completion: Column context was wrong when query contained '!' FIX: Script Generator: (Introduced in build 4.5.4) Would fail to extract tables without primary key. FIX: Table Data Editor & Query Results: String results now do not get right trimmed. FIX: (DB2 8.2): Stop removing CR/LF from queries in Visual Editing. FIX: (DB2): Visual Editing: Added support detailed error messages. FIX: (SQL Server) Change Database in query panel and the schema browser would fail if "Set Quoted_Identifier" is disabled in the Server Properties. FIX: (MySQL) Scripting Table CREATE Full would generate an extra CREATE INDEX for the primary key. FIX: (MySQL) Visual Editing now uses backtick quote identifier. FIX: (MySQL) Added "`Object Name`" quote identifier option to Import/Export tool, Script Generator and File->Options->Scripting 4.5.5: FEATURE: Added CTRL-Y hot key to Delete Current Line FEATURE: Grid Results: - Column width and height are now calculated using the font metrics, which allows more flexible font settings. - Ability to highlight rows by selecting row columns. - Ability to select all cells in a column by clicking on column with CTRL hit pressed. - Added secondary column sorting capability. FIX: Auto Completion: Fixed more column context bugs. FIX: Syntax Coloring: Comments of // and -- with a leading character word, the word would be colored as the comments. FIX: Save Results: If data format of Excel is selected and the file browse is activated to select a file name without an extesion, .txt is appended to the file instead of .xls FIX: (Sybase) Script Table CREATE(Full): If table would have more then one trigger, it would add the trigger create to the script more then once. FIX: (Sybase Anywhere) Schema Browser: Didn't take into consideration case sensitive schema owners. If user logged in as dba instead of DBA and SybaseAny server was configured for case-sensitive comparisons objects would not be listed 4.5.4: FEATURE: Options->Results Format: Added the option of "[None]" so that the results are displayed in raw values. UPDATE: Updated to libraries JGraph 5.7.2, JGraphLayout 1.2.1.3, JGoodies 1.3.1 and L2FProd 0.2 FIX: Save Results: HTML format of data didn't have a closing ">" on terminator. FIX: Query Results: Added seconds to the default format of and Time/DateTime datatypes FIX: (DB2): Query Analyzer: Syntax coloring added for vendor keywords of ASSOCIATE, LOCATORS, IF, ELSEIF, LEAVE, LOOP, REPEAT, UNTIL, RESIGNAL, SIGNAL, WHILE, DO FIX: (DB2 8.2): Query Execution: Stopped removing CR and LF from queries, because IBM fixed the bug in 8.1 where queries failed when statement had a CR or LF in it. This allows the saving of formatted query text in CREATE VIEW. FIX: (Sybase 11.5): Scripting Tables & Indexes didn't work because of lack of support for index_colorder() by Sybase 11.5 FIX: (DB2): Execute edit didn't extract primary key on a SELECT where schema name didn't match because of case sensitivity FIX: (Informix) Import/Export/Save Results - Changed date/datetime format to work under any DBDATE formatted connection (ex: EXTEND(MDY(7,22,1999), YEAR to SECOND)+13 UNITS HOUR+59 UNITS MINUTE+0 UNITS SECOND) 4.5.3: FEATURE: Enhanced Auto-Completion: Rewrote SQL Statement parser to support more complicated SQL syntax. - Auto-completion now supports UNION (and UNION ALL) queries. - Auto-completion now supports subqueries. - Auto-completion now supports ANSI JOINS and all modern JOINS at any depth. - Auto-completion now supports aliased query tables (eg SELECT SUBTABLE.* FROM (SELECT * FROM MYTABLE) SUBTABLE) - Auto-completion now supports for "where table.column=table." completion. - Auto-completion now supports column completion on tables/views with spaces in it with [] and "" quote identifiers. FEATURE: (Oracle) Query Window Auto-Describe: Added Table and Column Comments to description FEATURE: File->Options->Appearance:[Editor Background Color]: Added option to set the background color of the editor. FIX: Procedure Editor: The adding of "Save Query" made the procedure editor require a file to save to everytime a proc was compiled if there was no file defined. FIX: Script Generator: Ordered the creating of constraints in order of Primary Key, Unique, Check and Foreign Key, and Dropping in reverse order. FIX: (SQL Server) Script Procedure EXECUTE: Variable declarations didn't contain length, precision and scale FIX: (Informix) Import Tool: Importing into a datetime column, ADS would format the date with a trailing ".0" which would cause a syntax error. FIX: (Sybase) Index Scripting & Script Generator: Scripting Table w/ Indexes would generate CREATE INDEX for Indexes that were supporting constraints. These indexes are automatically created and dropped with the constraint, so this is now removed. 4.5.2: FEATURE: Procedure Editor: Added "Save Query" button to toolbar. FIX: (Oracle) Visual Edit & Scripting of View: Column aliases in the CREATE & CREATE OR REPLACE were not added. FIX: Query Results: Numeric fractions were truncated to 3 decimal values. 4.5.1: FIX: Script Generator didn't take into account multiple tables with same names but different case. FIX: Visual Editing for DB2: Now uses double quote identifiers to generate SQL to support case sensitive object names. 4.5.0: PACKAGING: Tagged current build as 4.5.0. PACKAGING: Created new installation packages and bundled with JRE 1.5 Update 4 FEATURE: Visual Table Editor: Added support to rename column on Informix. 4.0.18: FEATURE: Postgresql 8.0 Function Extraction: Parameter names are now extracted when generating a CREATE or CREATE/REPLACE statement. FEATURE: Script Generator - Ability to turn on Identity_insert values [SET IDENTITY_INSERT ON] (SQL Server, Sybase) FEATURE: Import Tool - Ability to turn on Identity_insert values [SET IDENTITY_INSERT ON] (SQL Server, Sybase) - Added the option "Object Quote Identifier" so the user may specify the option. The default value is the value specified in File->Options->Scripts. FEATURE: Export Tool - Ability to turn on Identity_insert values [SET IDENTITY_INSERT ON] (SQL Server, Sybase) - Added the option "Object Quote Identifier" so the user may specify the option. The default value is the value specified in File->Options->Scripts. FEATURE: Script Table CREATE - MySQL - Support for ENUM and SET datatype values - MSSQL - Support for ROWGUIDCOL FEATURE: Visual Explain Diagram: Added "Save Image As" which allows the user to save the Diagram to JPG or PNG image format. FEATURE: ER Diagram Generator: Added to the tools menu "ER Diagram" which allows a user to extract tables and views from a database to generate and manipulate an ER Diagram. FEATURE: Visual Table Editor Oracle: - Ability to ALTER columns. Supports the ability to change the name, datatype/length, nullable and default value. (8i doesn't support renaming of columns) DB2: - Ability to ALTER columns. Supports the ability to change the datatype to VARCHAR or the length of a VARCHAR column. (This is the only ALTER column DB2 supports) SQL Server: - Ability to ALTER columns. Supports the ability to change the name, datatype/length, nullable and default value. - Support for ROWGUIDCOL Sybase: - Ability to ALTER columns. Supports the ability to change the datatype/length, nullable and default value. (Sybase doesn't support renaming columns. Sybase 11 doesn't support renaming and changing datatypes) Sybase Anywhere: - Ability to ALTER columns. Supports the ability to change the name, datatype/length, nullable and default value. (Sybase Anywhere doesn't support the ability to change a NOT NULL to NULL) Informix: - Ability to ALTER columns. Supports the ability to change the datatype/length, nullable and default value. (Informix doesn't support renaming columns) PostgreSQL: - Ability to ALTER columns. Supports the ability to change the name, datatype/length, nullable and default value. (PG 7.3/7.4 doesn't support of changing datatypes. PG7.2 doesn't support changing datatypes or NULLs) MySQL: - Ability to ALTER columns. Supports the ability to change the name, datatype/length, nullable and default value. - Support for ENUM and SET enumeration values. FEATURE: Visual Editing (Oracle): Added support to CREATE/ALTER/DROP Clusters. FEATURE: Visual Editing (Oracle): Added support to CREATE/ALTER/DROP Array Type. FEATURE: Visual Editing (Oracle): Added support to CREATE/ALTER/DROP Table Type. FIX: MySQL Table CREATE Script: Default values where not being quoted with single quotes. FIX: MySQL Table Creating/Editing and Scripting: Didn't support precision and scale for INT datatypes and decimal/numerics. 4.0.17: FEATURE: Options: Added to File->Options->Results->[Convert binary to hex] which will convert all binary data retuned by query results to Hex values (This does not include BLOB or CLOB data). Default is set to TRUE. NOTE: MySQL users require the JDBC driver version 3.0.10 and above. FEATURE: Drag&Drop: Added support for drag-n-drop support for Indexes into the query window FEATURE: Query Analyzer for Oracle: Execute Explain while auto-commit is disabled and the explain table CREATE/DROP feature is enabled. Now displays a warning telling the user that the current transaction will be committed. - Also added option File->Options->Visual Explain->[Display Commit Warning] to allow the enabling/disabling of the warning. FEATURE: Save Results: Added a "Save to Clipboard" button to allow the user to save the result to clipboard instead of to file. Change "Ok" to "Save to File" FEATURE: Script Generator: - Ability to go back and redo a script generation after it has completed or been cancelled. - Added support to script to preview window where a user can copy to clipboard. FEATURE: Import Tool: - Ability to go back and redo an import after it has completed or been cancelled. - Added support to script INSERT statements to preview window where a user can copy to clipboard. - Options Tab: Date&Time combo box: added "dd/MM/yyyy:hh:mm:ss" and "dd/MM/yy:hh:mm:ss" as options. Date combo box: added "dd/MM/yyyy" and "dd/MM/yy" - Saves current options, so that the next import the options will default to the last import. FEATURE: Export Tool: - Ability to go back and redo an export after it has completed or been cancelled. - Added support to export to preview window where a user can copy to clipboard. - Options Tab: Date&Time combo box: added "dd/MM/yyyy:hh:mm:ss" and "dd/MM/yy:hh:mm:ss" as options. Date combo box: added "dd/MM/yyyy" and "dd/MM/yy" - Saves current options, so that the next export the options will default to the last export. FIX: Print Dialog: Now the ESC and ENTER keys are bound to the Ok and Cancel buttons. FIX: MySQL 5.0 (requires 5.0.6+)Constraint Extraction/Scripting: Scripting didn't extract foreign key columns because MySQL didn't provide them until 5.0.6. Fix requires MySQL 5.0.6 or above. FIX: MySQL 5.0 (requires 5.0.10+): Added Support for Triggers in the schema browser, visual editing and extraction/scripting. FIX: MySQL Script Table: decimals were not scripted with precision and scale. FIX: OSX 10.4: Look and Feel name was changed from "Mac OS X" to "Mac OS X Aqua" which caused ADS to incorrectly set the default Look and Feel to the Aqua Data Studio Look and Feel. FIX: Informix Scripting: Table CREATE(Full) was extracting the last trigger in the database, not the trigger for that table. 4.0.16: FEATURE: Query Analyzer & Procedure Editor: You may now drag and drop files from the Operating System desktop or file manager/ finder into the editors to be loaded. FEATURE: Query Results in Query Analyzer & Table Data Editor: Results of numbers and date are now formatted in accordance to the current locale (Regional Settings); FEATURE: Import Tool, Export Tool, Script Generator: Model dialogs are converted to a full frame which allows the minimizing and maximizing of the tool window to allow the continued use of ADS, which the tool runs. FEATURE: Script Generator: Option tab now has option to "Sort By Dependency", which will order the CREATEs taking into consideration object dependencies. FEATURE: Script Generator: Option tab now has option to "Include blank line between statements", which will place a blank line between statements in the script generated. FEATURE: Printing: Added new printing dialogs with extra capabilities and control to Query Anzalyzer, Procedure Editor and Explain Diagram. FIX: Sybase Script Index CREATE or Table CREATE (Full): Now supports ignore_dup_key, sorted_data, ignore_dup_row in the index CREATE statement. FIX: Query Analyzer: Execute Edit would not execute if a single table SELECT had a table name followed by a tab that is not extended. FIX: Script Generator: Setting plaform option to Windows wouldn't convert LF in the body of procedures to CR/LF when writing to file. FIX: Schema Browser (Sybase, SQL Server, Sybase Anywhere): Table/View columns where not sorted by ColumnID. 4.0.15: FEATURE: 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. FEATURE: Server Registration (SQL Server): Support for setting quoted_identifier, ansi_nulls, ansi_null_dflt_on, ansi_padding, ansi_warnings in Advanced tab. FEATURE: Server Registration (Sybase): Support for setting quoted_identifier in Advanced tab. FEATURE: About Box: Added JDBC Driver tab which displays a list of available JDBC drivers in the JVM and the version numbers. FEATURE: Procedure Editor Toolbar: Added "Open Script" button to the toolbar to allow a user to load the script for creating or modifying a procedure FEATURE: Upgraded JGraph 3.2 to JGraph 5.6.1 FIX: Script Generator: Changed the DROP statements to script in reverse order of the CREATE statements FIX: DB2 Syntax Coloring: Added MERGE and MATCHING to DB2 syntax coloring keywords. 4.0.14: FEATURE: Script Generator: Allows user to Script the CREATE and DROP definitions of all/selected objects in a database, including INSERTs of data - Accessibility in Tools Menu -> Script Generator and Schema Browser Popup Menu Tools -> Script Generator FEATURE: Oracle Schema Browser: Added "Java Classes" folder to list all Java classes available in the schema. FEATURE: Oracle: Added ability to Script CREATE, REPLACE, ALTER and DROP of Array Types, Table Types, Object Types and Clusters CHANGE: Added ".PKS" and ".PKB" to Script Filter defaults in File->Options->[General:General]->Script Filters FIX: DB2 Script "Execute Bind": Sometimes would order parameters in the incorrect order. FIX: Oracle: Result columns with nested tables didn't display correctly. FIX: Text in Properties Dialog for Function, Procedure, Package, Package Body, Rule, View and Trigger is now copyable able to the clipboard. FIX: Text in Preview SQL tab in Visual Editing Forms is now not editable. FIX: Query Editor: Multi-Line comments were not completely syntax colored as quoted strings FIX: Oracle Editor: Added "ELSIF" keyword to syntax coloring. 4.0.13: FEATURE: Sybase: Added support for jConnect 6.0. All that is required is to download and include the jConnect driver in the ADS classpath. FEATURE: (All Databases) Table Scripting: Added "CREATE (Full)" which will script a Table CREATE for the table, constraints, indexes and triggers FEATURE: (DB2, SQL Server, Sybase Anywhere, PostgreSQL, Informix) Proc Editor: Added "Execute Procedure" which allows user to execute the procedure currently being worked on. FIX: DB2 Script Table CREATE: Constraint definitions sometime included info from other schemas. FIX: Oracle Table Editor: Now shows GENERATED and USER DEFINED constraints. FIX: Oracle Table Editor: Extracting Primary Key and Updating table data from a SELECT statement where the table name doesn't use the same case values in the name is now fixed. FIX: Oracle Schema Constraint Browser: Now shows GENERATED and USER DEFINED constraints. FIX: Oracle Server Registration (OCI Connections): Added detailed information when JDBC driver doesn't match Oracle Client Libraries. FIX: PostgreSQL Script Function CREATE/REPLACE: Added support for IMMUTABLE | STABLE | VOLATILE - CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT - | SECURITY INVOKER | SECURITY DEFINER FIX: Register Server: Passwords with a space as the last characters had space removed when saved. 4.0.12: FEATURE: Memory Optimizations: Optimized the reclaiming of memory across query executions by the JVM FEATURE: Query Window for DB2 8.x: Warning messages now also contain the full descriptive messages. FEATURE: Register Server on Windows: (SQL Server - ODBC, Informix - ODBC, Generic - ODBC) contains browse button to browse the available ODBC data sources. FEATURE: Oracle Table Scripting: Added support for Table and Column comments FEATURE: Oracle Table Scripting: Added "CREATE (Full)" which will script a Table CREATE for the table, comments, constraints, indexes and triggers FIX: Query Results: SQL Server: If a query execution returned an error and warnings the warnings were not displayed. FIX: Generic ODBC: Connecting to Navision database server would not allow to open a query window. FIX: Oracle Script Table CREATE: User defined check constraints with names starting with "SYS_C" were not scripted. FIX: Oracle Schema Constraint Browser: User defined check constraints with names starting with "SYS_C" were not listed. 4.0.11: FEATURE: Proc/Func Editors for SQL Server, Sybase Anywhere, DB2, PostgreSQL and Informix - Schema Browser: Popup menu on Folder nodes: Procedures, Functions contains "Create XXX in Editor" to open new editor. - Schema Browser: Popup menu on nodes: Procedure, Function contains "Edit XXX in Editor" to open editor for editing. - Editor allows user to create and modify procedures, functions within a tabbed editor similar to the Query Analzyer - Editor displays any compilation errors in a grid list. Double clicking on an error will highlight the appropriate line in the editor. (PostgreSQL required latest JDBC driver for correct line numbers: http://www.aquafold.com/download/jdbc-drivers/Postgresql/ ) FEATURE: Query Window for DB2 8.x: Error messages now contain the full descriptive messages. FEATURE: Query Text/History Results: Status bar now contains "[Truncated by Max Results]" if any of the resultsets are truncated by the maximum results FIX: DB2 Explain Plan: Missing icon for TQUEUE operation. TREE_EXPLAIN_SPOOL FIX: Informix Table Check Constraint Scripting: Check constraints with check text greater then 33 characters would produce multiple copies FIX: Informix Query Results: TEXT database was retreived as hex values. FIX: Syntax Coloring: Any string aligned with a quoted string not separated by a space was colored as a quoted text even if it wasn't in the quotes (eg firstname+'lastname') 4.0.10: FEATURE: Oracle Proc Editor: Added "Execute Procedure" which allows user to execute the procedure currently being worked on. FEATURE: Query Text/History Results: Status bar now contains resultset and row count FIX: Query Grid Results: Sorting on a string text column where all the data is the same didn't perform very well 4.0.9: FEATURE: Oracle Editor for Procedures, Functions, Packages and Package Bodies - Oracle Schema Browser: Popup menu on Folder nodes: Procedures, Functions, Packages, Package Bodies contains "Create XXX in Editor" to open new editor. - Oracle Schema Browser: Popup menu on nodes: Procedure, Function, Package, Package Body contains "Edit XXX in Editor" to open editor for editing. - Editor allows user to create and modify procedures, functions, packages and package bodies within a tabbed editor similar to the Query Analzyer - Editor displays any compilation errors in a grid list. Double clicking on an error will highlight the appropriate line in the editor. 4.0.8: FEATURE: MySQL 5.0 Support - Schema Browser: Added Constraints, Views, Procedures and Functions - Scripting DDL: Added Scripting CREATE/DROP for Constraints, Views, Procedures and Functions - Visual Editing Schema: Added support to CREATE/DROP Views, Procedures and Functions - Visual Editing Security: Added User Database Privileges: Create View, Show View, Create Routine, Alter Routine, Create User, Execute FIX: Table Data Editor for Oracle: Doing an Execute Edit on a fully qualified table . where schema case-sensitivity doesn't match, ADS will not allow to edit the table. FIX: Sybase Extract Table: Extracting tables with columns having comments would return multiple columns of the same column having the comments. FIX: Sybase Schema Browser & Constraint & Index columns Exctraction: Browsing and Extracting on a different users objects (other then dbo) would not show up. FIX: MSSQL Server Schema Browser & Constraint Exctraction: Browsing and Extracting on a different users objects (other then dbo) would not show up. FIX: MSSQL Table Exctraction: Extracting on a different users tables (other than dbo) would not show up. FIX: Query Results: If "Query Stats" are disabled and "Always display record count" is enabled, line feed formatting isn't always correct. 4.0.7: FEATURE: Query Analyzer: Added "Reconnect" button to the toolbar. Ability to reconnect if the connection has been lost. FEATURE: Text Results: Added to SQL Statement and Error message the script line number location in the script FEATURE: Text Results: Syntax Coloring for error messages and SQL statements FEATURE: Options: Added to File->Options->Results 1)Enable Syntax Coloring 2)Color for SQL Statements 3)Color for Error message FEATURE: Query Analyzer: Database combo box is now filtered according to Registration Filter. FEATURE: Results: Added new "Script Details" results, which may be enabled with the last button on the applicatin toolbar. Provides a list all statements executed in a script with an icon representing whether the execution was successfull, failed or with warnings. Also includes the SQL statement, message and beginning and ending line numbers. A double click on an item will highlight the statement in the editor. The results column contain the number of resultsets and number of rows returned in the format X (Y) where X=#resultsets and Y=#rows 4.0.6: FEATURE: Visual Explain Tree - Added to popup menu "Save Column Positions" to allow the customization of the position of the explain node columns FEATURE: Option: Added to File->Options->Results:[Message Results] - Ability to enable the clearing of the message results prior to execution FEATURE: Query Analyzer (Sybase): Errors Results now have Msg: X, Level: Y, State: Z ... Server: ServerName, Procedure: schema.procedure, Line: A FIX: Schema Browser for DB2: Columns where not sorted by physicall order. FIX: Schema Browser for Sybase Any 9.0: Constraints node didn't list constraints. FIX: Oracle 9i/10g Server Registration: Advanced tab, driver parameters didn't work. FIX: Schema Browser (SQL Server) - Sorted Jobs and Operators node 4.0.5: FEATURE: Grid Results: Popup menu now has "View As Text" to view multi-line CLOB/Text values FEATURE: Tools Menu: added "Explain Whiteboard" to allow activation of WhiteBoard without adding Explain plan. FEATURE: Explain Tree Results (Grid Results/Whiteboard): Added color coding support, including ability to enable/disable coloring in popup menu. FEATURE: Scripting Table Foreign Constraints (DB2, MSSQL Server): Now supports ON DELETE and ON UPDATE clauses. FEATURE: Visual Editing for Oracle: Now supports multi-case object names by using Quoted Identifiers. FIX: Explain Diagram: Property-Value table columns are not resized each time the user selects a different node in the diagram. FIX: Schema Browser (Sybase): Store Procedures are now displayed as . instead of just FIX: Schema Browser (Sybase, SQL Server, Informix): Triggers are now sorted FIX: MySQL Schema Browser & Scripting: Added support for objects with names containing "-" in them. 4.0.4: FEATURE: Grid Results: Enabled the drag-n-dropping of selected cells. FEATURE: Table Data Editor: Added a "Edit in Window" command so users may edit CLOBs and large text fields with multi-line data. FEATURE: Visual Explain WhiteBoard: Right-Click Popup menu on Visual Explain results now have an extra item "Add to Whiteboard" - The whiteboard allows users to compare explain plans. The plans may be moved/removed with the popup menu on the caption of each explain plan FEATURE: Visual Explain Color Coding for Critical Path, Critical Node and Critical Operations. The Explain Diagram now has support for color coding ... - Critical Path: This colors the critical path which is determined by the costliest sub-node of each node. - Critical Node: This colors the top 3 costliest nodes in the entire path. - Critical Operation: This colors the costliest operations. Level_1 = Cartesian Joins; Level_2 = Full Table Scans; Level_3 = Sorts FEATURE: Visual Explain Options: 1. Moved Visual Explain Options from Results tab to new "Visual Explain" tab 2. Added options for default value of Color Critical Path, Critical Node and Critical Operation for Oracle, DB2 and SQL Server 3. Added options to specify background/foreground colors for nodes in Critical Path, Node and Operations FIX: Oracle Schema Browser: Procedures & Function nodes under Package and Package Bodies didn't refresh with the "Refresh" command. FIX: Oracle EXECUTE BIND: Executing a Procedure with a REFCURSOR parameter that was of both IN and OUT value would through exception. FIX: Oracle EXECUTE BIND: Executing a Procedure with a IN/OUT REFCURSOR would not print resultset correctly. FIX: Enabled "Display SQL" didn't display the SQL in the Messages Results. Also, now SQL displayed only has a top line separator of "---------------" FIX: File Mnemonics: Added _M_ to "Mount Directory" and _U_ to "Unmount Directory". FIX: Grid Results: Columns with no names would not have correctly calculated widths. For columns with no names, the name "column[colposition]" is now displayed. 4.0.3: FEATURE: Save Results: HTML Formatted Results: Hyperlinks are now wrapped with to create hyperlinks in the HTML document. FEATURE: Options: Added File->Options->Results:[Script Execution:Stop On Error] which determines whether the execution of a script stops if an error occurs on a query execute. FEATURE: Visual Explain: Tree table (grid) results now have tooltips for each explain node. FEATURE: Visual Explain: Diagram nodes now have more detailed information. FIX: SQL Server: Scripting Functions,Procedures&Triggers: In certain cases Scripting would not work if the name of the proc or function was too long. FIX: Save Results to Excel Format: Data in cell is now stored as correct datatype for numbers, dates, times and boolean values. FIX: Save Results to Delimited Data: {tab} and {space} separators were not saved correctly. 4.0.2: FEATURE: Aqua Data Studio Look and Feel: Made toolbars to have rollover buttons, which also makes the toolbar a little smaller. FEATURE: Options:Text Results: Added in File->Options-Results:Text Results the ability to enable and disable the display of the SQL statements executed in the text results (Default is FALSE). FEATURE: Save Results: Enhanced Save Results to have the following new features: 1. After clicking the save button of the Save Results dialog, the dialog is closed and the user is not notified that the data is saved. 2. The options of the last save results are stored and used for the next save results. 3. The path of the last saved results is automatically set in the file path when activating a save results dialog. 4. Ability to save results to an Excel Worksheet 5. Ability to save results to INSERT statements 6. Ability to include the SQL Statements in the results 7. Saving the results to HTML and Excel will use the File->Options->Results:Grid Results for alternating background colors 8. Added the ability to include the row count in the results 9. Added the ability to save the results of an explain plan 10. Enhanced the look and formatting of the HTML document saved 4.0.1: FIX: Informix Registration Dialog: Driver Properties didn't work. 4.0.0: Package Release: Updated all JDBC drivers to latest versions from vendors. Updated JRE to version 1.4.2_07 Updated added License directory to include files with licenses for JDBC drivers from vendors and libraries used by ADS. 3.7.24: FEATURE: Register Properties Dialog: Now has an advanced tab. - Advanced tab has driver properties for all database types where a user may specify driver parameters - Advanced tab has Characterset combo box for Sybase. FEATURE: Register Properties Dialog for Sybase Anywhere now has Database field so user may specify the database to connect to. FIX: MySQL Results for tinyint(1) would return as [Err]. 3.7.23: FEATURE: MS SQL Server 7.0 & 2000/5 - Added Windows Authentication - Added Option: "Windows Single Sign-On" option to allow a user to login using Windows Authentication with the currently logged in username/password of the Windows OS. (Only supported on Windows OS) - Added Option: "Windows Authentication" option to login using Windows Authentication with the specified username/password. (Only Windows Authentication Option supported on non-Windows platforms (Linux, OSX, etc) - Requires latest jTDS Driver 1.0 with ntlmauth.dll (http://www.aquafold.com/download/jdbc-drivers/jTDS/) - copy jtds.jar to location (\lib\jtds.jar) - copy ntlmauth.dll to root ADS directory (\ntlmauth.dll) FIX: MySQL 4.1 Schema Browser for Table didn't show columns and indexes. FIX: MS SQL Server Registration: Host name for instances now supports "hostname\instance" in addition to "\\hostname\instance" FIX: MS SQL Server Schema Browser & Query Analyzer db combo box: Now only lists the databases which the user has access to. 3.7.22: FEATURE: Schema Browser for Oracle: To Package and Package Body nodes, added functions and procedures to allow the browsing within the package and to script EXECUTE and EXECUTE BIND TESTING: Tested database version support for Oracle 10g, DB2 8.2, Postgresql 8.0, Sybase Anywhere 9, MySQL 4.1 (5.0-Alpha), MS SQL Server 2005 FIX: Schema Browser Drag-n-Drop: Added ability to drag-n-drop Procedures, Functions and Parameters to Query Window. FIX: MySQL Schema Browser: 4.1/5.0 - Process Info List didn't show the list of processes. FIX: SQL Server 2005 Schema Browser/Constraint Extraction: Didn't list or extract check constraint. FIX: Sybase Anywhere 9 Schema Browser/Constraint Extration: Didn't list or extract check constraint. 3.7.21: FEATURE: Variable Binding: Query Scripts: Added 3 client side commands to support execution of stored procedures with variables binded to parameters. - Added commands variable, print, println and executeCallableQuery. (Use Procedure->Script Object->EXECUTE BIND to generate example syntax) - .println (.print) - Syntax: .println { variable_name | 'text value' }, ... n - .variable - Syntax: .variable datatype [, value] - .executeCallableQuery - Syntax: .executeCallableQuery 'parameter_name[, ...]', { CALL ( ? { , ? ... } ) } { ? = CALL ( ? { , ? ... } ) } FEATURE: Schema Browser: Script Procedure: Added Script EXECUTE & EXECUTE BIND FIX: SQL Server: Table Editor: Generated date formats with "YMD", which didn't work in all locales. Format is now set with SET DATEFORMAT FIX: Execute Edit: Didn't work when query contains character "�" (eg Stra�e (street)). This character becomes "SS" when converted to uppercase. FIX: Sybase Anywhere 9: Extract Constraints didn't work. FIX: Postgresql: Drop Function sometimes didn't work, depending on whether the parameters were extracted in the correct ordering. 3.7.20: FEATURE: Oracle Visual Editors for View, Trigger, Procedure, Function, Package and Package Body: Added "Show Errors" button to display errors for source of invalid object FIX: SQL Server: Show Explain Plan: When Show Explain Plan was enabled and a multi-result select query was executed, not all resultsets were displayed FIX: Main application title still contained last file openned even after last query window was closed. FIX: Scripts Browser: Showed all files. Now only shows files with extensions defined in File->Options->General FIX: Sybase: Executing Procedure which returns row counts and an error message produces a "getUpdateCount" error message instead of the actuall error message. FIX: SQL Server: Table Data Editor: UNIQUEIDENTIFIER columns are now editable. FIX: DB2 Function/Procedure Scripting: Added support for external functions/procedures FIX: SQL Server: Introduce Value Stubs: Months in the date were zero based. Changed to one based. 3.7.19: FEATURE: Dialog Windows: Converted border of Titled Borders from single black line to Etched Borders for a better look. FEATURE: Message & Confirmation Dialogs: Now have Mnemonics enabled for hot key actions. FEATURE: History: Selecting text into Query Window now selects all of the selected statements and not just the current statement FEATURE: History: Added "Save Script" toolbar button which saves all currently selected statements into a file. FEATURE: Application & Query Toolbars are now 16x16 size. FEATURE: Text Results Options: Added "Always display records effected" as an option which will display "records effected" even if Display Query Stats are off. FEATURE: Script Browser: Folders and Files are now sorted FIX: Text Results: When 'Display Query Stats' are OFF the Record Count results prints extra line feed. FIX: Sybase Index Extraction: On HP/Unix: Unique and Clustered flags not retreived. The ANDing of Hex values doesn't work on Sybase HP/UNIX. Converted queries to use ANDing decimal values. FIX: MS SQL Server & Sybase Anywhere: Extraction of Procedure/Function. Trimming spaces from procedure lines could cause problems if line doesn't end with line feed FIX: Grid Format of NULLs: NULL value formatting was not being displayed in Grid Results. FIX: Query Analyzer: Alt-D hot key only worked for the last query window openned FIX: Query Analyzer: Multi-Panel View - CTRL-E didn't work while in a results tab FIX: Grid Results: Sorting for numeric/date data types was broken in build 3.7.18 3.7.18: FEATURE: Editor: Added Windows shortcut keys for Cut: Shift+Del / Copy: Ctrl+Ins / Paste: Shift+Ins FEATURE: Table Data Editor: Added refresh button to only refresh the data, but not save. [In case the Max Results is changed] FEATURE: Table Data Editor: Inserting Date/Time and setting NULL now affects all selected cells, not just the current. FEATURE: Import/Export Tool: Added "yyyyMMdd" and "yyyyMMddHHmmssZ" date/datetime formats FEATURE: Query Analzyer & Popup menu: Added CTRL-SHIFT-DELETE short-cut for Clear Document. FEATURE: Table Data Editor: Added File Menu with Hot-Keys FIX: Table Data Editor & History Toolbars: Changed Toolbar button/icon to 16x16 instead of 20x20 FIX: Script Index CREATE: Multi-column Index would omit columns after the first one. FIX: Grid Results: Formatting of Grid Results was broken in build 3.7.15 FIX: Import Tool: Informix 7.3 doesn't support quoted qualified columns FIX: Query Analyzer in MultiTab results: Fixed focus of components as CTRL-TAB cycles through query windows. FIX: Unclosed single and double quotes in server side comments caused parser to disregard statement separators. fixed. (was fixed in 3.5.13, reintroduced in 3.7.1) FIX: Displaying of Query Stats: Added "Command was executed successfully" into the query stats to be enabled/disabled, which is displayed when a statement is executed and zero records where modified FIX: Import Tool: Importing files with spaces between comma separated columns (eg: column1, column2) would add a space to the beginning of column string data. FIX: Schema Browser: Oracle Packages, Package Bodies and Java Sources. Queries are now based on ALL_OBJECTS. FIX: Option "Do Not Prompt to Save For New Scripts": was not working when opening and creating new files. FIX: Sybase Indexes: Extracting and Viewing didn't work for non-capitalized Indexes. 3.7.17: FEATURE: Query Analyzer: Added option in File->Options->[General] to enable MultiTab query results where the editor is the first tab and the results come after. FEATURE: Window Menu: Added option to enable the toggling of the current Query Analyzers MultiTab/SplitPane mode. FEATURE: CTRL-1 HotKey: Cycles through Query Window Results FEATURE: CTRL-ALT-(RIGHT/LEFT ARROW) Focus back and forth between the Tree View and the Query Tab View FEATURE: Grid Results: Popup menu, added "Copy w/ Headers", "Copy w/ RowCount" and "Copy w/ Headers & RowCount" to allow the coping of the selected text with the headers and a row count column FEATURE: Grid Results: Added option in File->Options->[Results] to specify alternating colors in grid results, including the option to set the background and foreground colors of the alternate row. FEATURE: Query Editor and Text/History/Message Results: Added "Clear Document" option in the popup menu to clear all document text. FEATURE: Text Results: Added option in File->Options->[Results] to enable/disable the displaying of the Warning headers along with the Warnings. FEATURE: Query Analyzer Window: Added Window Menu with options to Hide/Unhide the Query Toolbar and Query Results. FEATURE: Query Analyzer: Openning a Query Analyzer window will automatically set the current database according to the database selected in the schema browser FEATURE: Application: When closing the application the Dialog prompt to Save files will also have "Discard All". FEATURE: Closing Query Windows: Added option in File->Options->[General] to allow the ability to specify if ADS prompts a user to save a modified query window that doesn't have a file associated with it. FEATURE: Popup menu on Query Analyzer tab now includes "Close All" and "Close Others" FEATURE: Window Menu: Added option to Hide/Show application toolbar (CTRL-F8) FEATURE: Schema Browser: Added to popup menu "Refresh" - F5 to allow a user to refresh the node without collapsing/expanding the node FEATURE: Schema Browser: Added to popup menu "Script Object -> SELECT (*)" to Tables to generate a SELECT statement with '*' as the fields instead of the column names listed. FEATURE: SQL Server Query Analyzer: When openning a new query window, the connection will be set by default to the default database assigned to the user. This will only be overridden if the user currently has selected a different database in the schema browser. FEATURE: SQL Server Query Analyzer: When openning a new query window, the connection will be set by default to the default database assigned to the user. This will only be overridden if the user currently has selected a different database in the schema browser. FEATURE: Editor: Auto-Comment: If a text selection is made, the CTRL-/ will do a block comment around the selected text, instead of a line comment FEATURE: To Upper/To Lower: If no selection is made then the command will apply toUpper/toLower to the current word based on the caret position. FEATURE: Morph to Upper/Lower: The toUpper/toLower now do not change single or double quoted text CHANGE: Introduce Value Stubs: For MS SQL Server and UniqueIdentifier datatypes, the value stub is now NEW() instead of ''. FIX: Auto-Complete on Synonym columns stopped working after build 3.7.7 FIX: Auto-Complete: Bug which caused auto-completion to only show "Please Wait ..." and nothing else, now fixed. 3.7.16: FEATURE: Auto Completion: Supports customization of auto completion in File->Options->[Editor] ... Auto Popup, Auto Popup Delay, Instant Substitution, Maximumn Pane Size, Minimum Pane Size FIX: Default for Instant Substitution in Auto Completion is now false FIX: Auto Completion: Tab key now closes completion window after completing if there is only one item in the window. FIX: Import/Export and Save Results Dialog: Added [Default] item for encoding types. FIX: Sybase: Database Devices: Support for Visual Editing and Scripting of devices larger then 2G. 3.7.15: FEATURE: Option Dialog - Converted option settings to PropertyPanels FEATURE: Syntax Coloring: Supports coloring of System Tables. FEATURE: Syntax Coloring (File->Options->[Editor]): Added ability to enable/disable and set the syntax color for keywords, vendor keywords, datatypes, functions, system tables, comments and quoted strings FIX: Execution of empty string when trying to change database on databases which don't have the concept of databases. FIX: Generic JDBC/ODBC Connections: .setMaxRow() is not supported by some JDBC/ODBC drivers (SQLite) which caused ADS to fail on queries. FIX: After closing last query window, give focus to Schema/Script Browser. FIX: Postgresql: Script Function or Visual Edit Function incorrectly generated parameter type definition for datatype varchar by placing a '()' after the varchar. FIX: Schema Tree: Move (Drag/Drop): You may now move servers to the root 'Database Server' node. FIX: SQL Server/Sybase: Script Alter and Alter of Procedures/Functions which had comment blocks before the CREATE statement would not work. 3.7.14: FEATURE: Postgresql 8.0 - Visual Edit User/Role: Added permission options for tablespaces FEATURE: Option Dialog: Changed the Tabbed View to an Outlook Tabbed View (aka Firefox/Intellij Option Dialog Look) FEATURE: Auto-Reconnect: Implemented Auto-Reconnect for Schema Browser, Visual Editing and SQL Scripting. (Postgresql requires latest JDBC driver, and Informix is not supported by Driver) FIX: Oracle Schema Browser Table Node: Filtered Tables that start with BIN$ for Oracle 10g which are the tables in the Recycle Bin FIX: Oracle Scripting Constraints: Added constraint state to the DDL which was being omitted for primary key, unique and check constraints. FIX: Query Stats: Added hot key to enable/disable ALT-SHIFT-R; FIX: Oracle Export Tool: Timestamp columns with precision would cause export to not work. FIX: Large Resultsets/Out of Memory: ADS now has error checking for running out of memory while quering for very large resultsets FIX: Editor: Find & Replace would replace multiple times according to how many times it had been used, which cause problems if the find string was a substring of the replace string. 3.7.13: FEATURE: Added File->Options->[Results] tab with 4 options: Max display size of columns, Display Query Stats, Max retrieval size of BLOBs and Max retrieval lines of CLOBs FEATURE: Added File->Options->[Editor] tab with 3 options: Expand Tabs to spaces, Number of Spaces in Tab expand and Size of Tabs. These settings allows for automatic Tab/Space conversion in the Editor FEATURE: Syntax Coloring: Added Keywords for security related SQL statements FEATURE: Postgresql 8.0 - Tablespaces: Added support for tablespaces: Schema Browser, Visual Editing and Scripting DDL CHANGE: DB2/Sybase/MS SQL Server Schema Browser - Dependancies Node: Converted the Dependant Object Node to the actual object node so the objects have context sensitive menus and object icons CHANGE: Applied refactoring to source to enhance speed of key function calls and streamline database support infrastructure for new databases and database versions. FIX: Oracle Scripting Foreign Keys: Added constraint state to the DDL which was being omitted. FIX: Oracle Schema Browser: Added the "PUBLIC" schema folder in the schemas. FIX: Oracle Visual Editor for Users/Roles: System Privilege list is now specific to the database version 8i/9i/10g FIX: Oracle Visual Editor for Users/Roles Object/Column Permissions: Tables/Views/Columns have the appropriate index/references columns for User/Role and version type of database FIX: MS SQL Server Visual Editor for Object Permissions: Separated Scalar and Tabular functions for permissions. FIX: Index View Properties: Was displaying the datatype of the column incorrectly. FIX: DB2 Schema Browser - Dependancies Node: Added query to include Procedures that are dependant on the table FIX: Query Analyzer: Quering and displaying large BLOBs would lockup ADS. 3.7.12: FEATURE: Visual Editing for Security: DB2: Users, Roles, Object Permissions, Column Permissions Informix: Users, Roles, Object Permissions, Column Permissions MySQL: Users, Object Permissions, Column Permissions Oracle: Users, Roles, Profiles, Object Permissions, Column Permissions Sybase Anywhere: Users, Roles, Object Permissions, Column Permissions Sybase: Logins, Server Roles, Users, Roles, Object Permissions, Column Permissions MS SQL Server: Logins, Server Roles, Users, Roles, Object Permissions, Column Permissions Postgresql 7.4/8.0: Users, Roles, Object Permissions [Column Permissions not supported by Postgresql] Postgresql 7.2/7.3: Not Supported FIX: SQL Server schema browser, column node: Was displaying length of NCHAR and NVARCHAR twice the size. FIX: Postgresql: Added support for Implicit Case-Sensitive schema objects 3.7.11: FIX: Mac OSX Look and Feel - Background of application was beening set to light gray. FIX: Informix Synonyms mapped to objects in different database: Added support in displaying them in the schema browser, scripting the SQL and added to auto-completion. FIX: Schema Browser for Oracle/Sybase Anywhere - Sorting Procedure and Function folder. FIX: MS SQL Server Query Results: values of tinyint columns where being displayed incorrectly. 3.7.10: FEATURE: Schema Browser - Drag-n-Drop: User may now move or copy (CTRL-Down) a server registration from folder to folder by dragging and dropping a server registration node. FEATURE: Schema Browser - Drag-n-Drop: User may now drag-n-drop a Table/View or Column from the schema browser to the Query Window. (ALT-Down will add item with a ", " prepended) FIX: SQL Server Case Sensitivity: Stored Procedure & Function schema extraction and visual editing didn't work on SQL Servers with case sensitivity FIX: Informix Queries on System Catalogs now explicitly query on the informix schema (eg informix.systables) FIX: Informix Syntax Coloring: Added RESOURCES, STATISTICS, HIGH, MEDIUM, SUBSTR 3.7.9: FIX: CLOB data type: Multi-Line CLOB values were converted to single line values in Text Display and Import/Export Tool. FIX: Table Editor for Postgresql - Numeric & Decimal types now support Precision and Scale. FIX: Script Table CREATE for Postgresql - Numeric & Decimal types now support Precision and Scale. FIX: MySQL & Postgresql: Import/Export Tool and Table Data Editor now escapes backslash to a double backslash when generating string values in INSERT statements 3.7.8: FEATURE: Browsing the Schema & Script browser with the keyboard will automatically scroll the pane to the selected entry. FEATURE: Visual Table Editor for Sybase: Added ability to drop columns FEATURE: Scripting Columns for Sybase: Added ALTER and DROP columns FEATURE: Look and Feel: Added optional command line parameter called ads.forcelaf which allows users to set their own look and feel with command line option of "-Dads.forcelaf=" FIX: Table Editor for Oracle OCI connections: Didn't set the correct database and schema which prevented the creation of a table FIX: Execute Explain (CTRL-Shift-Enter): was treating all comments as client side comments which removed Oracle Hints before execution. FIX: Generic Schema Browser: Schema Filter wasn't working. 3.7.7: FEATURE: Export Tool: Tool allows user to export data results from query or table into delimited data or INSERT statements. FEATURE: Schema Popup Menu: Now has Tools->Import/Export menu item for context sensitive import/export functionality. FEATURE: Import/Export Tool: Scripting INSERT statements now has an optional statement separator for the script. FEATURE: Import/Export Tool: Scripting INSERT statements now use the configured scripting options for identifiers and statement separator FIX: View/Alter Table for DB2: Identity value was displayed incorrectly for columns with a column check constraint. FIX: Syntax Coloring for Postgresql: Multi-line/Single quoted text is colored as if it was not single quoted for support of CREATE Procedure syntax coloring 3.7.6: FIX: MS SQL Server Script & ALTER View: Views over 4000 characters were trucated. FIX: DB2 Column Check Constraints: Column check constraints created with GENERATED ALWAYS AS (CHECK) were not being scripted. FIX: Look and Feel: Setting a Look and Feel not supported (e.g. Windows LaF on Linux) would prevent ADS from starting. FIX: Visaul Editing Dialogs: Mapped the BACKSPACE ("Delete" on OSX) key to delete columns. 3.7.5: FIX: Import Tool: Import was removing "[" and "]" from strings in certain cases. FIX: Table Editor [MSSQL Server]: UNIQUEIDENTIFIERS were not being single quoted when generating SQL statement FIX: FIX: Block Syntax Coloring: Block Syntax Coloring was not terminating on "**/". CHANGE: Query Analyzer Window: Now contains the name of the connection in the title. CHANGE: Added ALT-D hot key in Query Analyzer window which gives focus to the Database Combo Box to remove the need to use the mouse to change database. 3.7.4: FIX: Create/Alter Table: Combo Boxes in detailed column info were not editable, such as "Default" FIX: Import Tool: Negative numbers for numeric columns were being imported as positive values FIX: Authentication Dialog when making a connection on registered servers without passwords saved, the username was disabled. 3.7.3: FEATURE: OSX Look and Feel: Added the ability to change the application font for the OSX look and feel. Default of Lucida Grande size 11 FEATURE: Schema Popup Menu now has the option "Query Analyzer as ..." which will prompt the user for a username/password before openning a connection for the Query Analyzer. FEATURE: Schema Browser Table Node: Popup Menu now has the option "Table Data Editor (Top 1000)" to easily edit table data without writing SELECT statements and execute edit. FIX: Oracle w/ Oracle 10g JDBC Drivers were getting the time of a DATE field truncated. FIX: Stored Procedure Extraction: If Stored Procedure contained parameters with an opening '(' and no space before the procedure name, the '(' was truncated. 3.7.2: FEATURE: Integrated the Netbeans Editor v3.6 from v3.32 FEATURE: Added ALT-X hotkey to map to Execute FEATURE: Auto-Completion is now threaded. Long running auto-completions display popup with "Please wait" until completed, with the ability to cancel. (Feature in new Netbeans Editor v3.6) FIX: Double Clicking on the last word in the text doesn't highlight (Fixed in Netbeans Editor) FIX: Block Syntax Coloring: Block Syntax Coloring was not displaying correctly if a '/' was in the block comment. FIX: PostgreSQL: Resultset returns NULL for CIDR datatypes. 3.7.1: FIX: Import Tool: The reported number of records imported on the status tab was one higher then actually imported. FIX: Import Tool: Files with a blank line at the end of the file displayed a blank line in the sample record grid. FIX: Import Tool: If CR/LF not included as part of the last line, the last character is truncated. FIX: File->Options[Format] -> DataType formats where limited to the list. FIX: Parser: If server side comments for "--" was enabled and disabled for "//" and a single quoted "/" was in the comments, the comment was truncated CHANGE: Added the APPLICATIONNAME, PROGNAME and HOSTNAME connection parameters to SQL Server and Sybase connection types so process info displays what application is being used. 3.7: CHANGE: Changed Version 3.5.25 to 3.7 for Packaged Release 3.5.25: FEATURE: Visual Editing for Storage: DB2 8.1: Tablespaces, Containers Oracle: Tablespaces, Datafiles, RedoLogs, Rollback Segments, Controlfiles, Archive Logs MSSQL Server: Databases, Backups Sybase: Caches, Dump Devices, Database Devices, Databases Informix: Databases MySQL: Databases PostgreSQL: Databases FIX: Reading of SQL Scripts in Unicode-16bit didn't work FIX: DB2 Schema Browser: Stored Procedure & Functions are now sorted FIX: MS SQL Server Import Tool: If User didn't have access to any database the tool would not work. FIX: DB2 8.1 Schema Browser: Some fix pack versions of 8.1 return the schema with padded spaces. FIX: Oracle XMLType: Added support for XMLType. Requires xdb.jar and xmlparserv2.jar 3.5.24: FEATURE: DB2 Sequence Support: Schema Browser, SQL Scripting and Visual Editing FEATURE: Import Tool: Allows to add a new table while importing using the column info of the imported file FEATURE: Edit Menu: Added Redo and Select All commands FIX: OSX: Key mappings for Redo, Undo and Select All use the Apple Key instead of the CTRL key 3.5.23: FEATURE: Visual Editing for Sequences, Synonyms/Aliases, Defaults, Rules and Data Types 3.5.22: FEATURE: Visual Editing for Indexes, Stored Procedures, Functions, Views, Triggers, Packages and Package Bodies FIX: Added "Double Precision" as a datatype for Sybase. Visual Table Editor and Result Formatting. 3.5.21: FEATURE: Visual Table Editor: Added more error validatation FEATURE: Visual Table Editor: Added autocompletion to the combo boxes. FIX: Table Data Editor would hold an open transaction after a "Save Refresh" until the window was closed. Fixed. FIX: Informix: Script Table CREATE: Default Values for CURRENT on DATETIME/INTERVAL didn't have the extended date fractions FIX: MySQL: Table Extraction now supports PRIMARY KEY constraints for Table Data Editor, Visual Table Editor and Table Scripting 3.5.20: FEATURE: Visual Table Editing: You may now CREATE, ALTER and DROP table from the popup menu on the schema browser FEATURE: Postgresql: Added System Views and System Functions to separate user and system objects. FEATURE: Syntax Coloring: Added more keywords support for all databases. FEATURE: Scripting Table CREATE now supports Default Values FEATURE: Scripting Table Columns are now supported {CREATE, ALTER and DROP} FEATURE: Scripting Postgresql - Script CREATE OR REPLACE FUNCTION added FEATURE: Scripting refined to support visual editing FIX: Informix schema browser & extraction failed to extract "char(x) not null" datatypes FIX: Informix queries on datatypes of "datetime hour to second" failed FIX: Informix datatime variations: formatted correctly and allowed to edit on Table Data Editor 3.5.19: FEATURE: DBA SQL Scripting: Scripting on Storage, Security and Management Objects. FEATURE: About Dialog: Adding 3 tabs: System, Fonts and Charsets. 3.5.18: FIX: Fixed CLOB results display support for all database types. Also enabled Table Editor support for CLOB datatype on appropriate datatypes. FIX: Informix: Scripting Trigger would script the trigger body out of order. FIX: Query Text Results panel would turn grey after Describing a table and then executing a query. 3.5.17: FEATURE: Import Tool: Added date format preview on Option Tab and added variety of formats FEATURE: Import Tool: Added combo box of file column names in the Table Column table or the Format Tab FEATURE: Encoding: Added new encoding support for scripts and results "Big5 - (Big5, Traditional Chinese)", "Big5_HKSCS - (Big5 with Hong Kong extensions, Traditional Chinese)", "EUC_JP - (JISX 0201, 0208 and 0212, EUC encoding Japanese)", "EUC_KR - (KS C 5601, EUC encoding, Korean)", "GB18030 - (Simplified Chinese, PRC standard)", "GBK - (GBK, Simplified Chinese)", "ISO2022JP - (JIS X 0201, 0208, in ISO 2022 form, Japanese)", "ISO2022KR - (ISO 2022 KR, Korean)", "SJIS - (Shift-JIS, Japanese)", "TIS620 - (TIS620, Thai)", FIX: PostgreSQL 7.3+ - Scripting, Auto-Completion/Automation didn't work on certain tables which had columns/indexes removed from them. FIX: PostgreSQL 7.3+ - Scripting CREATE of a Trigger Function would fail with new JDBC driver. FIX: PostgreSQL 7.4+ - Schema Browser - Moved information_schema. to system table folder 3.5.16: FEATURE: Added 'Window' menu which allows to show and hide the server browser, grid results and query toolbar. FEATURE: Import Tool: Added time/performance statistics to status tab. CHANGE: Forced the 'Auto On All Schema' settings to OFF on all databases. FIX: Import Tool: Made demlimiter editable so any delimiter can be specified. FIX: If only grid resuls and execution plan is enabled, then the execution plan results were always selected after execution. Fixed FIX: Auto-Completion on SELECT statement. If a column name that ended with "FROM" was in the SELECT statement, columns after that would auto-complete. Fixed FIX: Query results for Oracle CLOBs didn't display correctly. Fixed FIX: Table Editor didn't allow modifications of Oracle CLOBs. Fixed 3.5.15: FEATURE: Added Data Import Tool in Tools menu. FEATURE: Sybase Schema Browser: Added Storage folder which contains Database Device, Dump Device and Cache browser folders. CHANGE: Connection Dialog: Changed the "Sybase 12.5 - TDS 5.5" title to "Sybase 11.x-12.5 TDS 5.5" CHANGE: Save Results Dialog: Changed "Double quote values" check box to a combo box to specify "Quote Identifier". Values will be quoted and characters in value matching the quote identifier will be escaped. FIX: Auto-completion wasn't working when table name or alias ended with line feed. Fixed 3.5.14: FEATURE: New and Enhanced Look And Feels: Enhanced Default 'Aqua Data Studio' Look and Feel. Added 'Aqua Data Studio - 3D' and 'Aqua Data Studio - XP' Look and Feel. Look and Feel may be changed in Option->Appearance[Tab] FEATURE: Visual Explain Diagram: On the tree-grid results of a explain plan you may right-click on the results for a menu that allows the user to bring up a new frame with a diagram representation of the explain plan. FIX: Visual Explain Tree: Fixed color of tree and made tree expandable and collapsable. 3.5.13: FIX: Unclosed single and double quotes in server side comments caused parser to disregard statement separators. fixed. FIX: Execute Current was not sending Server Side Comments to the server. Comments on Stored Procedures would be lost by Execute Current on creating a procedure. FIX: Informix 7.3: 1) Schema Brower: Removed functions and datatypes which are not supported by 7.3. 2) Trimmed whitespaces returned on object names. 3) Fixed scripting of stored procedures which didn't work on 7.3, and polished scripting of tables, view and indexes FIX: Postgresql: Added REPLACE, RETURNS and RENAME keywords to syntax highlighting. FEATURE/FIX: Extended "Auto on all Schemas" to include table autocompletion. "Auto on all schemas" will autocomplete on all schemas for both tables and columns. FIX: "Auto on all schemas" - Changed default to OFF instead of ON for all databases. 3.5.12: FEATURE: Added new connection type of "Informix 7.x-9.x - ODBC" to support Informix through an ODBC datasource. Also, renamed "Informix Dynamic Server 9.3" connection type to "Informix 7.x-9.x" FIX: Sybase: Script Table was not scripting the "NOT NULL" section of a column correctly. Fixed. 3.5.11: FEATURE: Options -> Added support for enabling whether the schema browser displays the Server Type on the browser {Production/Test/Debug} Option->General Tab includes a check box to enable this feature. The default value is disabled FEATURE: Options -> Added Optional support for ";" statement separators. Option->General Tab includes a check box to enable this feature. The default value is disabled. 3.5.10: FEATURE: SQL Server Named Instances - When registering an SQL Server you may specify in the Hostname text the name of the SQL Server and the Instance name in the format \\ServerName\InstanceName without a port to enable an Instance connection. NOTE: This requires the latest jTDS JDBC Driver from http://www.aquafold.com/download or jtds.sourceforge.net FIX: Grid Formatting of Nulls - Nulls on the grid were not displaying according the the set format FIX: Saving Results - Formats of grid results are now saved in the same manner as displayed FIX: Sybase 11.0.x-11.4 - Fixed Schema Browser for Indexes, Constraints, Processes, which didn't display the objects. FIX: Sybase 11.0.x-11.4 - Fixed Scripting of Tables, Indexes and Contraints - This version of Sybase doesn't support CASE statements in SQL or index_colorder() built-in function. 3.5.9: FIX: Oracle 8.0.6 doesn't support the SYS_CONTEXT() method to get sessionid, which was causing ADS to fail on results. Fixed by using GUID instead of sessionid 3.5.8: FEATURE: Results Formatting. Option dialog has formatting tab to specify the formatting of numbers and dates FEATURE: Schema Browser Filters: Filters for Schemas/Databases and Database Objects FIX: Changed "Sybase ASE 12.5 - TDS 4.5" text in connection dialog to "Sybase ASE 11.x-12.5 - TDS 4.5" FIX: Infrequently the text results panel becomes grayed out and unusable, mades some changes to hopefully prevent this. 3.5.7: FIX: DB2 Visual Explain - Fixed query that retreived DB2 explain data, which was causing incorrect visual explain. FIX: DB2 Visual Explain - Fixed retreiving of explain data resultset bug which occured in DB2 8.1 Fix Pack 2 3.5.6: FIX: Execute Explain now defaults results to the explain plan FIX: Schema Browser Table Columns - Data type precision and scale in the schema browser columns and column autocompletion window now are formatted correctly according to CREATE TABLE syntax. FIX: DB2 Explain Plan - fixed tree display which was not displaying the tree correctly. FIX: Explain Plan - Added a subtree and node cost column, with the cost column including the percentage of the total cost. FIX: Explain Plan - Prioritized columns in order of importance. 3.5.5: FIX: Fixed Visual Explain for "MS SQL Server - ODBC" connections which didn't work. FIX: Visual Explain for Oracle - moved columns Cost, Cardinality and Bytes to beginning FIX: Fixed "Execute Explain" for MS SQL Server which didn't work. FIX: If there are any errors while processing Explain information, the errors are displayed in the text/message results FIX: OSX - CTRL-Click would not open popup window as right click, but CMD-click would. Changed so CTRL-Click opens popup and CMD-Click doesn't 3.5.4: FEATURE: Support for Visual Execution/Explain Plans (with Tree-Grid results) for Oracle, DB2 and MS SQL Server FIX: DB2 8.1 Registration: Chaned the default port text to 446 instead of 50000, which is the port the JDBC driver attempts to connect to if a port is not included. FIX: Changed the layout manager of the Multi-Grid query results to have a better look. FIX: Removed Unicode JDBC parameter from MySQL Connections 3.5.3: FEATURE: DB2 8.1 Schema Browser - Added "Containers" node to the tablespace node to display containers of a tablespace. Added "Management" node to top level which contains detailed information on Connection and Lock information. FEATURE: Added support to script objects to Current Window, New Window and Save As to a file. FIX: MySQL Connections : Added unicode support by passing unicode and UTF-8 parameters to JDBC connection FIX: Table Editor did not work when editing on a SELECT * FROM SCHEMA.TABLENAME. It would contruct the table name incorrectly in the UPDATE, INSERT and DELETE statements FIX: Server Registration: Server Type and Script mount was not being saved when Registering a new server or server cloned. FIX: Server Registration: You may now register a server even if you are not able to connect to the server. ADS will prompt the user with the message ... "A connection to this server has failed. Do you wish to register anyway?" FIX: Informix connections do not set the username and password on connection if they are blank, to support trusted connections. 3.5.2: FEATURE: Register Server - Now able to define whether a Server is of type [Develop, Test and Production/Live], which will provide the appropriate icon for the server in the schema browser and query windows. FEATURE: Register Server - Ability to mount a scripts folder that can be browsed in the schema browser under the registered server, so that scripts can be accessed easier, and associated to a specific server. FIX: Auto-Completion now supports ansi-join syntax "table1 join table2". FIX: Auto-Completion now supports Quoted Identifiers 3.5.1: FEATURE: Added cancel granularity in the prepare text of a query. Cancelling a query while preparing text will cancel immediately. FIX: The Table Editor now uses the quoted identifiers and schema when generating SQL for changes, when appropriate. FIX: MySQL table editor - Enabled ability to edit columns with the TEXT, TINYTEXT, MEDIUMTEXT and LONGTEXT datatypes FIX: MS SQL Server table editor - Enabled ability to edit columns with the NTEXT datatypes FIX: Introduce Value Stub values for dates and time are now the current date and time. 3.5: CHANGE: Changed Version 3.0.29 to 3.5 for Release 3.0.29: FIX: OSX CTRL/Apple Hot Keys - All CTRL hots keys are now mapped to Apple hot keys. The CTRL-C/X/V/Z and Delete keys in the editor work correctly FIX: Query analyzer - double clicking on a word containing underbar characters doesn't highlight the entire word 3.0.28: FEATURE: Scripting - Added Scripting for Sequences on Oracle and Postgresql FEATURE: Scripting - Added Scripting for Packages and Package Bodies for Oracle FEATURE: Support for Synonyms & Aliases in Informix & DB2 ... Describe, Table Editor, Auto-Completion and SQL Automation now supports Synonyms/Aliases FEATURE: Added following Option settings: 1. History - Option for specifying the max # of lines in the text history results 2. History - Option for specifying the max # of lines in the text message results 3. Scripting - Option for identation size on scripting DDL and DML 4. Scripting - Option for Statement separator {GO, /} in multi statement DDL and DML scripting 5. Scripting - Option for specifying the Quote Identifier for objects in the DDL and DML scripting "",[] 6. Scripting - Option for Fully Qualifing object with schema in DDL and DML scripting 7. Comments - Option for specifying which comments are Client & Server Side Comments: --, // or /* */ FIX: Saving a file when closing a Query Window would fail. Fixed. FIX: Saving a file with Save As or creating a new file, would not append a default 'SQL' extension if the user didn't specify an extension. 3.0.27: FEATURE: Scripting - Added Scripting for Databases on Sybase, SQL Server, Informix, Postgresql and MySQL FEATURE: Informix - Added KEYWORDS to syntax coloring ... RENAME, MODIFY and TO FEATURE: Save Results - Added option to allow user to specify the line-divider to be 'Windows (CR/LF)' or 'Unix (LF)', with 'Windows (CR/LF)' being default on Windows and Unix on all other platforms 3.0.26: FEATURE: Scripting - Added Scripting for User/Group(Roles) for Sybase, MS SQL Server and Informix FEATURE: Scripting - Added Scripting for Defaults/Rules on Sybase and SQL Server and Rules on PostgreSQL FEATURE: Oracle 9i - Support for the new TIMESTAMP/TZ/LTZ data type FIX: Execute Edit worked on the entire current statement. Now, it works on the selected text first ... and the current statement if nothing is selected 3.0.25: FEATURE: Scripting - Added Scripting for Synonyms/Aliases on DB2, Informix and Oracle. FEATURE: Schema Browser Synonym/Alias Node - Added the name of the corresponding object to name of the node FEATURE: Data Type Scripting on DB2, Informix, Sybase Anywhere, Sybase, SQL Server, PostgreSQL FEATURE: Schema Browser Data Type Node - Added the name of the corresponding base datatype FEATURE: Syntax Coloring - Added keywords for Synonym/Alias/Data Type scripting FEATURE: Syntax Coloring - Added a more complete list of keywords for MySQL FIX: Informix Server Registration - If database registered was not sysmaster, then Query window would not open. FIX: Sybase Stored Procedure Parameter node didn't show parameters of the stored procedures. 3.0.24: FEATURE: Sybase Anywhere - Added 'System Tables' and 'System Views' nodes to the Schema Browser on Sybase Anywhere. FIX: Sybase Anywhere - Column and Table names are trimmed for metadata queries in auto-completion and schema browser for Sybase ASA 6.x 3.0.23: FIX: If a script is being modified and another script is double-clicked for open, there is no prompt to save the current script. FIX: The first click on grid results column now sorts the column in ascending order instead of descending. FIX: If no Primary Key or Unique Constraint is defined on table being edited, then user is not prompted to select one FIX: "Message" Results tab did not have the display set to the last appended message in the document. Now display is always set to the bottom. FIX: Build 3.0.22 introduced bug which didn't allow the saving of results ... FIXED FEATURE: Added support for Openning and Saving files in different Encoding types FEATURE: Added support for new Encoding types for Saving Results and Files, to include all of the following ... "ASCII - (American Standard Code for Information Interchange)" "Cp1250/Windows-1250 - (Windows Eastern European)" "Cp1251/Windows-1251 - (Windows Cyrillic)" "Cp1252/Windows-1252 - (Windows Latin-1)" "Cp1253/Windows-1253 - (Windows Greek)" "Cp1254/Windows-1254 - (Windows Turkish)" "Cp1257/Windows-1257 - (Windows Baltic)" "ISO 8859-1 - (Latin Alphabet No. 1)" "ISO 8859-2 - (Latin Alphabet No. 2)" "ISO 8859-4 - (Latin Alphabet No. 4)" "ISO 8859-5 - (Latin/Cyrillic Alphabet)" "ISO 8859-7 - (Latin/Greek Alphabet)" "ISO 8859-9 - (Latin Alphabet No. 5)" "ISO 8859-13 - (Latin Alphabet No. 7)" "ISO 8859-15 - (Latin Alphabet No. 9)" "KOI8-R - (Russian)" "UTF-8 - (8-bit Unicode Transformation Format)" "UTF-16 - (16-bit Unicode Transformation Format)" 3.0.22: FEATURE: Performance - Memory consumption decreased by ~33% on Queries and Speed Increased on Queries. FEATURE: Scripting - Added Scripting for Indexes and Constraints, including constraints for Table Scripting FEATURE: Syntax Coloring - New Keywords related to Constraint and Index Scripting FEATURE: Schema Browser Top Index Node - Added the name of the corresponding table to name of the node FEATURE: Schema Broswer Index Node - Added columns node to specify the columns in the index and sorting order FIX: DB2 Schema Browser - Table Index Node did not include all indexes. FIX: Query Analyzer Popup Windows were being reclosed when closing ADS, causing a double prompt to save working data. FIX: Top File Menu (Automate) - Converted Mnemonic to "A" - "Execute Parse" hot key changed to Ctrl-Alt-A FIX: Current Result Tab was not saved on requeries when "History Text" is the currently viewed tab 3.0.21: FIX: Printing on OSX failed to print FIX: When closing a query window and prompted to save the file, if Save As is selected but then cancelled, the query window will closed. Now the window does not close. FIX: Changed Query Timer format in Query Analyzer to hh mm ss FIX: Changed the default max history for SQL history to 5 (from 0) 3.0.20: FEATURE: Added Constraint Node in the Schema Browser (under the table node) for Informix, MySQL, Oracle, PostgreSQL, Sybase Anywhere FEATURE: Added Print capabilities from the Query Analyzer. You may print SQL Scripts and SQL results with the CTRL-P hot key 3.0.19: FEATURE: Query Analyzer Window - Allows user to open a separate frame window for Query Analyzer FEATURE: Text Result History - a text result panel which displays continues to append the text results to the previous results FIX: When saving query results, the encoding used is saved as the default encoding for future saves. FIX: Introduce Columns, Qualified Columns, Value Stubs on SQL Server and Postgresql didn't work when operating on a table that wasn't owned by the user logged in. 3.0.18: FIX: PostgreSQL 7.2.x - Script SELECT, CREATE and DROP didn't work 3.0.17: FEATURE: ADS now support DBMS_OUTPUT for Oracle by displaying the output in the text results. You may enable/disable it on the main toolbar FEATURE: Full support for PostgreSQL 7.3 and above FIX: Table Editor didn't work on PostgreSQL 7.3 and above. FIX: Made the top toolbars non-floatable. FIX: Select All and Copy to clipboard from grid results didn't work very well with large resultsets. FIX: ADS was not cancelling any running queries when exiting. ADS now cancels all running queries before exiting. 3.0.16: FEATURE: When executing a query, the status bar now includes a [real] time elapsed executin time of the query. FEATURE: Optimized the speed and memory of query execution with text results. Text results take up less memory and display much faster FIX: When registering a Server, the server name allowed users to specify special characters. The server name must be a valid filesystem name. This would cause ADS to fail. ADS now prompts the user. FIX: Table Editor for MySQL 4.0 didn't work for tables that were not all uppercase ... because of MySQL's case sensitivity. 3.0.15: FIX: Option Dialog didn't come up if there was a problem retreiving Fonts from the OS (specifically on OSX). FIX: Table Editor on SQL Server had editing of the TEXT datatype disabled ... now it is enabled 3.0.14: FIX: SQL Server and Sybase allow for Databases with Spaces, but ADS didn't support them ... now ADS supports them. FIX: DDL Trigger scripting for Sybase didn't retreive full source for large triggers. FIX: DDL Trigger scripting for Microsoft SQL Server didn't retreive full source for large triggers. FIX: DDL Procedure & Function scripting for Informix didn't retreive full source for large sources. FIX: DDL & DML Scripting for Views didn't work for Sybase FIX: DDL & DML Scripting for System Tables on MS SQL Server didn't work. FIX: Removed Square Icon from first column of the grid results that specified the grid was not sorted. 3.0.13: FIX: DDL Scripting for Microsoft SQL Server Functions and Stored Procedures. CREATE and ALTER didn't work. Now Fixed. 3.0.12:- FEATURE: Trigger, Procedure and Function nodes in Schema Browser now support DDL scripting for CREATE, REPLACE, ALTER and DROP FEATURE: Schema Browser: Top level Trigger Folder now contains Trigger nodes with the Table name which the trigger is on. 3.0.11:- FEATURE: Table Editor now supports UNIQUE constraints. If there is no Primary Key, then a UNIQUE constraint is used for setting the primary keys. FEATURE: View Node in Schema Browser now supports SQL DML and DDL for SELECT, CREATE and DROP FEATURE: Sorted the Database/Schema Object Nodes in the schema browser in a consistent manner across databases in priority of important (Tables, Views, Synonyms/Aliases, Indexes, Triggers, Procedures, Functions ...) FEATURE: Informix Schema Browser: Added Function and Top Level Indexes Folder FEATURE: Postgresql Schema Browser: Added Function and Top Level Indexes Folder FEATURE: MS SQL Server Schema Browser: Added Top Level Indexes and Triggers Folder FEATURE: Sybase Schema Browser: Added Top Level Indexes and Triggers Folder FEATURE: Sybase Anywhere Schema Browser: Added Top Level Indexes and Triggers Folder FIX: Table Editor on Sybase only allows a save once, and then fails on any other attempts. FIX: Script Parser removed comments within quotes (eg 'LK--%', the parser would remove --%'), now fixed. FIX: Generic-JDBC driver - Schema Browser would not show Tables and Procedures if the database didn't support Schemas, now fixed 3.0.10:- FIX: Script Table Create on Oracle didn't always put the precision and scale for NUMBER data type FIX: Account for null JDBC Driver MetaData when connecting to a server 3.0.9: - FEATURE: Table Node in Schema Browser now supports SQL DML and DDL scripting for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER and DROP FEATURE: Auto-Describe now supports Identity info for databases supporting Identity data type. FIX: Informix 7.3 - Index folder for tables in Schema Broswer did not show the Indexes. 3.0.8: - FEATURE: Execute Edit / Table Editor - Now supports PUBLIC Synonyms for Oracle FEATURE: Column Auto-completion now supports PUBLIC Synonyms for Oracle. Table Auto-completion will NOT display PUBLIC Synonyms because there are too many default defined PUBLIC Syononyms by Oracle. FEATURE: SQL History 3.0.7: - FEATURE: Table and Column Auto-completion now has support for Synonyms. FEATURE: Table Editor/Execute Edit now supports Synonyms. If you execute edit on a Synonym it will edit the table the Synonym maps to FEATURE: Auto Describe now supports Synonyms FEATURE: Introduce Columns, Qualified Columns and Value stubs now support Synonyms FIX: In 3.0.6 if you tried to close the application it would not close. [Only if you downloaded an early build] FIX: If Table Editor is invoked on a SELECT statement which doesn't select the Primary Key, then execption was thrown when trying to save changes. Warning is now displayed. FIX: Removed debugging info being printed on console/terminal window 3.0.6: - Windows Authentication and Trusted Connection support: - New connection types. SQL Server 2000 - ODBC, SQL Server 7 - ODBC and Generic - ODBC. With these connection types - you may connect to SQL Server using Trusted Connections FIX: In Table Editor, if a cell was changed, then cleared, then changed again, the data would be set to null 3.0.5: - FEATURE: Added "Select All" to the popup menu of the Grid Results which selects all the rows in the grid FEATURE: While executing a script or statement, the status bar now shows more detailed status of the status of the execution FEATURE: The initial focus at application startup is now the schema tree FIXED: "Copy" in the popup menu of the Grid Results only worked when there was one grid result. FIXED: If OS Environment doesn't contain USER_HOME variable then ADS would not be able to save any settings and would not run. ADS now prompts the user to set the USER_HOME FIXED: OSX - The header on the Grid column looked funny. Fixed, and also changed icon to a black arrow. 3.0.4: - FIXED: Informix column auto-complete was padding the name to 18 characters. Now the column name is trimmed. FIXED: MySQL v 4.0 database names are case sensitive, and 3.x are not. Made ADS current database support for MySQL case sensitive. FEATURE: Opening a Query Analyzer window sets the current database to the database currently being browsed on the schema tree. FEATURE: Tabs now have an X button to close an individual tab 3.0.3: - Added Copy command to right-click menu on Grid results. - When auto-commit is enabled, the commit and rollback buttons are now disabled. - Made result pane smarter. If message tab is the current tab but no messages then show text or grid. If grid is current, but has no results, then show text or message tab. - Added all SQL92 Keywords to Syntax Coloring for all databases types - Testing the Query Analyzer cancel button on sample databases. Trying to cancel a query while waiting on the database server to return from an executeQuery() command. Oracle 8i/9i - WORKS Postgresql - WORKS Sybase Anywhere - WORKS Informix - WORKS Sybase - WORKS MS SQL Server 7.0 - WORKS MS SQL Server 2000 - WORKS MySQL - doesn't cancel DB2 7.1 - doesn't cancel DB2 8.1 - doesn't cancel - Added Option to change the font of the SQL Editor - Shell scripts, change the line: ADS_HOME=. into: ADS_HOME=`dirname $0` for datastudio.sh and datastudio-bundled.sh - Fixed SQL Server and Sybase schema resolution. If .TABLENAME doesn't exist, then use dbo.TABLENAME - When Register a MySQL Server, the default database is set to 'mysql' if one is not specified - Display error when unable to change current database. - Support for Informix 7.3 by not quering on sysxtdtypes table for schema extraction - OSX - File->Exit (Alt-F4) is now File->Quit (Meta-Q) on OSX - OSX - Made the default fonts for OSX: Editor: Monaco/10 Text:Monaco/10 Grid:Helvetica/12 which are more readable - OSX - Buttons in dialogs now look like OSX buttons for OSX Look and Feel - OSX - Buttons in dialogs are now centered for OSX Look and Feel. 3.0.2: FIXED: Sybase Table Editor only worked on tables with all UPPERCASES. FIXED: Fixed some more issues with connecting to Sybase database with Roman-8 character set. FIXED: Postgresql TEXT datatype was not editable. 3.0.1: Enabled Execute Edit button to enable the Table Data Editor --- Start 3.0 --- DB Support ------------- 1. Native Support for Informix Dynamic Server 9.3 2. Native Support for Sybase Anywhere 8.0 Options -------------- 1. Ability to select which fonts to use in the application 2. Ability to specify Look and Feel of the application, including native OSX Look and Feel 2. Ability to specify the default behavior on saving passwords for registered servers Register Server ---------------- 1. Allow multiple file selection with the browse button and to save the previously selected directory for Gen-JDBC. 2. Option to not save password ... (this does not store the password on disk or memory) 3. Added Driver Parameter Option for Sybase 12.5 and Sybase Anywhere, this is to be used when connecting to a Sybase Server with Roman 8 Character set with a driver param of ?charset=iso_1 SQL Writing Automation ------------------ 1. Introduce Select Stmt - This will insert a new SELECT statement and place the cursor to the table postion 2. Introduce Insert Stmt - This will insert a new INSERT statement and place the cursor to the table postion 3. Introduce Update Stmt - This will insert a new UPDATE statement and place the cursor to the table postion 4. Introduce Delete Stmt - This will insert a new DELETE statement and place the cursor to the table postion 5. Introduce Columns - This will insert a list of columns for the tables in the current query 6. Introduce Qualified Columns - This will insert a list of fully qualified columns for the tables in the current query. If the tables are aliased the the table name will be the alias. 7. Introduce Value Stubs - This will insert a list of value stubs for the columns of the tables in the current query. '' for CHAR values, 0 for numeric values and NULL for all others. 8. Comment Statement - This will comment out the current statement by wrapping with /* */ 9. Comment Line - This will comment out the current line with a // 10. Uncomment Comment - This will uncomment the current comment, by removing the /* */, // or the -- slash comments 11. Morph To Upper Case - This will convert the current statement to upper case 12. Morph To Lower Case - This will convert the current statement to all lower case. 13. Delete Word - Ctrl-Backspace will now delete the current word Query Analyzer -------------- 1. Ability to have files with no extension show up in the script browser (currently exceptions are thrown) 2. Right-click Query Analyzer analyzer should open on the server even if a child is selected just like server properties. 3. Have the subsequent queries select the tab that was previously selected. So if Grid is selected and a query is executed then the Grid tab is now selected. 4. SQL Prediction puts ( ) for set values in an UPDATE Statement ... ( ) removed 5. If "Text Results" are disabled and a query is executed which does not return any results, then set the focus to the "Messages" Tab. 6. Added Syntax Coloring for all Built-in Functions with dark green 7. Ability to sort table columns. You may sort grid results by clicking the column, alternating between ascending, descending and no-sort. 8. Added Query Analyzer Clone (Ctrl-Shift-Q) - This will open a new Query Analyzer with a new connection using the same settings as the current Query Analyzer 9. Grid Results - You may now select individual cells, individual rows by row number and columns by column header 10. Added Row #'s to the rows in the grid 11. ADS now sets the .setMaxRow() on a Statement before executing an SQL Statement 12. Stop Button now works on long running queries on the database server. Installer & Packaging ---------------------- 1. OSX - Packager and Launcher - You may now launch the OSX installed application by double clicking on an icon. Save Results ------------------------------------------------ 1. When selecting a file and there is no extension, an extension will be added according to what data format is currently selected. ".txt" for delimited text, ".html" for HTML and ".xml" for XML files Choose Server ------------------ 1. Refresh the servers when openning the Dialog. Miscellaneous -------------- 1. Ability to hide the left browser panel 2. Remember the "last SQL Directory opened" for mounting directories, saving results and saving files Bugs ------------- 1. Bug: The text results page loses text clarity if scrolled horizontally 2. Bug: Ctrl-Describe has an alignment problem on "smalldatetime" 3. Bug: Syntax Editor: UPDATE "update EMPLOYEE set EMPLOYEEID=1, FOLDERID=2, NAME='d' where " the quoted text is not red 4. Bug: Describe Query when there is no query generates a stack trace 5. Bug: Quoted text with N for NVARCHAR (eg: N'My Text') doesn't make the quoted text red. fixed. Schema Browser -------------- 1. If you right-click on the schema window it popups up the window but doesn't select the node. 2. Oracle - Display management and other folders even if the user doesn't have access to them. 3. Added Folder for Triggers to Sybase 4. NOTE: Generic-JDBC Connections don't refresh the metadata. It seems most drivers do this because of performance reasons. I can't change this :( This is driver specific. --- End 3.0 --- 2.0.7 : Sybase IQ returns (null) datatype on some queries which causes the ADS Query Window to hang. Fixed RAW datatype in Oracle were not displayed correctly. Fixed 2.0.6 : Passwords larger then 23 characters failed to encrypt. Fixed. 2.0.5 : Mounting a directory with files that didn't have extensions caused a stack dump. Fixed. 2.0.4 : Removed AS keyword from Sybase specific code so that the Sybase connections work with Sybase 11.9. Sybase 11.9 does not support this keyword 2.0.3 : Converted LEFT JOINS to TABLE1, TABLE2 join formats in schema queries for Sybase so that it would work for Sybase 11.9. Also, fixed minor bug on field-autocompletion for Sybase. 2.0.2 : Changed Font of the Grid Table to Courier New, so that it displays Chinese Characters. 2.0.1 : Fixed: Generic-JDBC - Auto-Completion - Some generic jdbc drivers did not auto-complete on columns, such as ODBC-Access. Now Fixed. 2.0: --- Start 2.0 --- Database Support ----------------- 1. Added support for TDS5.5/jConnect5.5 for Sybase 2. Added support for JDBC-OCI driver for Oracle Query Analyzer ----------------- 1. Changed "Run" text to "Execute" text 2. Mapped F5 key to "Execute". CTRL-E and F5 both execute the current script 3. Added "Execute Current" (Statment) mapped to CTRL-ENTER hot key. This will execute the statement the cursor is located on. 4. Added "To Upper" and "To Lower" commands to allow user to quickly convert the highlighted text to upper or lower case. 4. Changed hot-key for "Cancel" to Ctrl-Backspace. (Ctrl-Pause never worked :)) 5. Added option to allow user to specify the max number of rows fetched per resultset 6. Added ability to set the Auto-commit to ON or OFF 7. Added ability to 'Commit' and 'Rollback' a transaction from each connection window 8. Added ability to set the Autocompletion to ON or OFF 9. Added ability to set the "Auto on all Schemas" feature, which allows the ability to query for a tables columns across all schemas not just the current one. 10. Ability to refresh the autocompletion cached schema in case the user changes the schema structure 11. Ability to do a Find in the text results of a query. Set focus on the results panel and then hit Ctrl-F and the find dialog will prompt for the text to search the results 12. Ctrl-D for auto describe now describes all the tables for the current query and shouldn't need the user to highlight the table Menus ----------------- 1. Added "Describe" and "SQL Prediction" to the query menu 2. Added "New Server Group" and "Delete Server Group" to server menu Toolbars ----------------- 1. Button tooltips also display the hot-key for that actions ( e.g. Execute (Ctrl-E) ) Options Dialog ----------------- 1. Default Values a. AutoCompletion, Auto on all Schemas, AutoCommit, Max Results 2. Scripts: Ability to specifing filter for scripts (.sql, .proc) Script Browser ----------------- 1. Scripts displayed are now configured according to the extesions defined in the Option Dialog General ----------------------- 1. Added filter for Scripts (defined in the options dialog) in the Open Script and Save Script file chooser dialog boxes Packaging ----------------------- 1. Removed Shell Scripts (.sh) from Windows installation 2. Updated Shell Scripts for Linux, Solaris and OSX Script Engine ---------------- 1. Ability to print out binary data in HEX format in SELECT statements Schema Browser ---------------- 1. Added parameter folder for Oracle stored procedures and functions. 2. Changed query for Oracle sessions to query on v$session instead of v_$session Generic JDBC ---------------- 1. Added support for AutoCompletion on tables and columns. The AutoCompletion only queries on the current database and schema. 2. Added the ability to load drivers dynamically by specifying the driver jars at registration Server Properties ---------------- 1. Made database server properties editable. 2. Server Properties is editable even a child node of the server is selected. Bug/Feature: Optimized the Encryption/Decryption of passwords to speed up the expansion of Server Groups in the schema browser --- End 2.0 --- 1.5.8 : Fixed: Postgres Schema - Schema precision and scale definition for numeric types where incorrect. Now Fixed. 1.5.7 : Fixed: Generic JDBC connection - Unable to connect to the Mckoi database, because of driver registration implementation. Made registration/connections to generic drivers more flexible. Now Fixed. 1.5.6 : Fixed: Query Analyzer - If the text results in the "Text Result" tab of the Query Analyzer is selected, copied and pasted into Notepad or other text editor the linefeeds are lost. Now Fixed. 1.5.5 : Fixed: Postgres 7.3 - Support for displaying Unicode characters. 1.5.4 : Fixed: Postgres 7.3 - Views, Users, Groups and other folders in schema browser are not displayed (It seems 7.3 meta data schema has changed). Now Fixed. 1.5.3 : Fixed: Generic JDBC/Interbase - Generic JDBC connection for Interbase didn't work. Now fixed. 1.5.2 : Fixed: Postgres 7.3 - Table in schema browser are not displayed. Now Fixed 1.5.1 : Fixed: SQL Server column auto-completion to query all tables in the current database and not to filter on schema. This bug only affects users who are logged into a database as a user who does not own the schema he/she is working on. --- Version 1.5 --- 1. Feature: Support for DB2 7.2 and 8.1 2. Feature: Support for Sybase 12.5 3. Feature: Support for Postgres 4. Feature: Support for Generic JDBC 5. Feature: Added support for detecting JRE version to make sure users use jre 1.4 and above to run Aqua Data Studio 6. Bug fix: A double-click on text in the editor would not select the text. fixed. --- Version 1.1.3 --- 1. Feature: Changed Tar packaging so that shell scripts and java is untarred with +x mod set to true 2. Bug fix: Changed all SQL Server Catalog queries to lowercase. In SQL Server configurations with case-sensitivity set to true the catalog queries would fail because the columns in the queries were in caps. 3. Bug fix: When using AutoCompletion and selecting to complete a column with the ENTER key while typing a TABLE.COLUMN definition, the TABLE.COLUMN definition would be replaced only with the COLUMN. Fixed. --- Version 1.1 --- 1. Feature: Added support for asynchronous query execution. You many now cancel a query at any time or execute multiple queries from different windows at the same time. 2. Bug fix: SQL Server schema browser showed all columns with nchar and char types with incorrect size. If you can't access your database you will need to re-register the server. 3. Bug fix: Encoding of encrypted password was incorrect, which cause decrypting of some passwords not to work. In this case you could not connect to your server. 4. Bug fix: Moved all /bin files to root directory for easier understanding of installation and execution of the application