Log Message:
Update to SQL Workbench/J build 119.

Build 119 (2016-01-31)

Enhancements

 * It's now possible to display the column's data type in the
   header of the result table
 * When importing all files from a directory, WbImport now
   provided pre-defined variables with the filename
 * It's now possible to configure auto-saving of external files
   independently from auto-saving the workspace.
 * A new command WbMessage to display a simple message is available.
 * It's not possible to search text in all open editors
   (Tools -> Search all tabs)
 * For some DBMS, the DbTree and DbExplorer now show the
   dependencies between objects
 * For DB2/iSeries table and column comments can now be retrieved
   from the system catalogs instead of using the JDBC driver.
 * For Postgres it is now possible to manually control transactions
   using BEGIN .. COMMIT when the connection is set to autocommit
 * The list of tables in the DbTree is now sorted to work around
   bugs in JDBC driver that do not properly sort the list of tables
 * For DBMS that support it, two new modes have been added
   to WbImport: -upsert and -insertIgnore using native "UPSERT"
   functionality if available
 * For Firebird the SQL source of external tables is now generated
   correctly.
 * An new command WbGenerateImpTable is available to infer
   the structure of a table from an import file
 * The command line parameter -vardef has been deprecated and
   replaced with -variable and -varFile
 * It's now possible to provide tags for each connection profile.
   The quickfilter will then use the defined tags for filtering
   the displayed profiles.
 * Connection parameters specified on the command line now have
   precedence over the properties defined through a Liquibase
   defaults file (specified through -lbDefaults)
 * It's now possible to enable the use of Oracle's DBMS_METADATA
   for source code retrieval for different types of objects
 * The tooltip shown for result tabs can now be configured
   (Options -> Data display)
 * For the internal SQL formatter, it's now possible to
   configure the case in which data type names are written
 * A new action to run all SQL statements up to the cursor
   position is available
 * The error dialog that is displayed when running a script can
   now be configured to also include the error message or the
   statement that failed
 * Improved display of packages in the DbTree for Oracle and
   Firebird

Bug fixes

 * Showing rowcounts in the DbTree did not work for DB2
 * "Generate Delete Script" for a selection of rows in
   the result did not display the generated script.
 * When reloading the whole DbTree while a node was selected,
   would show elements (e.g. tables) twice
 * CREATE TABLE statements were not formatted correctly
   if the name consisted of quoted and unquoted parts
   (e.g. unquoted schema and quoted table name)
 * The error dialog when running running multiple statements
   was not displayed on Linux if the option "Include error message"
   was selected in the "SQL Execution" options
 * Improved the performance when retrieving table definitions
   and table source for Oracle
 * For Postgres, rules defined on a table where shown twice
   in the generated DDL script
 * Retrieving additional column information in the DbExplorer
   failed on SQL Server if a non-standard database collation
   was used
 * The DDL for constraints or comments where identifiers
   required quoting was not correct
 * The formatter would not process statements correctly where
   a sub select using function calls in the WHERE clause was
   used in a JOIN condition
 * When using "Remove Comments" for a connection profile,
   the error position inside a statement was not shown correctly
   for some DBMS
 * For Oracle, when using "Trim CHAR data" and editing tables
   where the primary key column was defined as CHAR, updating
   the result did not work.
 * Toggle comment did not toggle correctly when some lines were
   already commented and some not
 * The messages shown when using conditional execution with
   WbInclude did not properly include the variable name or value
 * For Oracle the tablespace of materialized views was not shown
   in the generated SQL (Fix contributed by Franz Mayer)
 * It was not possible to work with SAVEPOINTs correctly
 * Table definitions for tables with VARCHAR columns were not
   displayed for Oracle
 * Disabling the check for read-only columns did not work
   for all JDBC drivers
 * WbCopy now stops with an error if -targetTable is specified
   and -sourceTable is used to specify multiple tables
 * For DB2 the names of PK constraints where not properly
   qualified with a schema if needed
 * Sometimes using "Execute current" would not correctly
   identify the current statement and run the first statement
   from the editor
 * WbImport using -insert,update did not work for multi-column
   primary keys when not all PK columns where part of the input
   file
 * When a variable value contained the prefix and the suffix of
   the variable pattern, using such a variable would result
   in SQL Workbench/J locking up
 * Reloading a trigger source in the DbExplorer's trigger panel
   did not work
 * For Oracle the source of a trigger that had a trailing space
   in the name was not retrieved
 * For Oracle the position of errors in regular (non-PL/SQL)
   DDL statements was not shown
 * When starting SQL Workbench on a headless system, using
   "java -jar" using the -script parameter did not work
   any longer
 * For SQL Server 2000, retrieving the source of a view did not
   work
 * For SQL Server, generating "dummy DML" for tables with "bit"
   columns did not work
 * For MySQL the option "on update" for a default value was not
   shown in the generated SQL source for a table

Build 118 (2015-08-16)

Enhancements

 * Added support to include computed columns for MySQL 5.7
   in the generated CREATE TABLE source
 * The source and target connection for WbCopy, WbSchemaDiff
   and WbDataDiff can now be specified on the command line when
   starting the application. In that case it's not necessary to
   provide them to the respective commands
 * A new action to run all SQL statements in the editor starting
   from the cursor position is available
 * It's now possible to use OS environment variable or Java
   properties in the username of a connection profile.
 * For Postgres, "COPY .. FROM stdin" with the data after the
   statement is now supported
 * It's now possible to define external tools to format SQL
 * For decimal values WbExport now supports the parameters
   -fixedDigits and -maxDigits.
 * It's now possible to enable editing (and running)
   the generated SQL source code in the DbExplorer directly.
 * For Oracle, messages from dbms_output are now always shown
   if a procedure is started using EXECUTE regardless of
   the setting of "set serveroutput"
 * Added some basic support for SAP HANA.
 * For Excel imports, the option -stringDates=true retrieves
   Dates as formatted strings and converts them using
   the date/timestamp format specified in the WbImport command
   rathr then reading a converted value from the Excel file.
 * For Excel exports, the start location where the data should
   be written to in the excel file can now be specified using
   the -offset parameter
 * The application to be used for displaying the logfile can now
   be configured.
 * WbSchemaReport has a new (boolean) option -writeFullSource
   to write a valid CREATE VIEW statement to the XML output
   in case the DBMS does not store the complete SQL
 * Results can now automatically be refreshed either through
   an annotation or through the context menu of the result tab
 * The macros in a group can now be sorted alphabetically
 * The quoting of the null values for text exports can now
   be enabled through the option -quoteNulls
 * The quoting of the header for text exports can now be enabled
   through the option -quoteHeader
 * The statement at the cursor position can now be copied directly
   into the clipboard (Code Tools -> Copy current statement)
 * For Oracle, the partitions of a materialized view are now
   shown in the source code
 * WbImport and WbCopy (including the DataPumper) can now be
   used to insert data into a view
 * For tables without a primary key, unique indexes that contain
   nullable columns are no longer considered when generating
   DML statements
 * For Vertica tables and views from the schema "v_internal" are
   now show in the DbExplorer (contributed by Tatiana Saltykova)
 * It's now possible to define the terminator string for
   "Copy Code Snippet" through the config property
   "workbench.clipcreate.codeend"
 * Macros and macro groups can now be excluded from
   the popup window

Bug fixes

 * The menu to select data from referenced/referencing tables
   in a result set was disabled when switching to the DbExplorer
   and back to the SQL panel
 * -syncDelete with WbCopy did not work if alternate key columns
   were specified using -keyColumns
 * Fixed retrieval of stored procedures for DB2 on AS/400
   (thanks to Francesco)
 * Fixed detection of update columns for multi-table result sets
   when the name of the PK columns is not uniuqe in the result set
 * For Firebird the source code for procedures with multiple out
   parameters was not generated correctly.
 * For PostgreSQL, SQL statements to create the comment for
   functions with OUT parameters were not generated correctly.
 * When running a single command in batch mode, the error status
   was not returned correctly to the operating system
 * WbExport no longer uses the GUI defaults for decimal digits.
   The default is now to always export all digits, unless
   the new -maxDigits parameter is used
 * For MySQL, when multiple tables with the same name in different
   databases had triggers defined, all triggers where visible
   for each table in the DbExplorer
 * When importing multiple files using -usePgCopy and one file
   generated an error, the previous import was not committed
 * WbConnect would prompt for a password for profiles with
   an empty password even if "Save password" was enabled
 * No parameter prompt was shown for INOUT parameters when
   running procedures using WbCall
 * Implemented a workaround for an Informix driver bug where
   index information for the wrong table was returned
 * Double quotes in column values were not escaped properly
   when creating a JSON export
 * When switching between views and tables in the DbExplorer
   the foreign key tabs were no longer shown for SQL Server
 * Compile errors for Oracle's PL/SQL where not always shown
   correctly
 * Parameters for SQL Workbench commands with nested single
   and double quotes that included SQL comments were not
   evaluated properly
 * Fixed restoring of the window position when using multiple
   monitors
 * Generating the SQL source for computed columns did not work
   for SQL Server 2000
 * The SQL source for inherited tables in Postgres was not
   generated correctly.
 * The SQL source for sequences for SQL Server was not generated
   correctly.
 * "Create DDL script" in the DbExplorer would generate
   the source code for sequnces twice
 * Nano (or micro) seconds from timestamp values where not
   displayed correctly
 * When opening a file, it is now checked if the selected
   encoding matches the one from the file
 * Each time when reloading a result that uses the @WbMacro
   annotation, the macro sub-menu would be added to the context
   menu again
 * For Informix, default clauses for columns were not generated
   properly in the DbExplorer
 * For Informix, index definitions were not always displayed
   correctly
 * Overloaded functions and procedures where not handled
   correctly by WbSchemaDiff
 * For Postgres the wrong DROP FUNCTION statement was generated
   if a function contained OUT parameter
 * Scripts that contained statements including character
   literals with a backslash were not always parsed correctly.
 * When WbImport did not find any matching columns, the error
   message did not include the (faulty) source file
 * Fixed the display of the profile tree with large fonts
 * The DataPumper did not work if source and destination had
   a different number of columns
 * The generated WbCopy command in the DataPumper was not
   correct when a query was used as the source
 * XLSX export did not work if the output file was specified
   without an extension
 * Fixed some issues with restoring the window position on
   multi-monitor systems
 * Fixed some issues where the alternate delimiter was
   incrrectly used when running scripts through WbInclude
 * When importing multiple Excel files with WbImport using
   the -sourceDir argument, only the first file was imported
 * The abbreviated WbInclude using @ only worked with Oracle
 * The minutes for columns of type "timestamp with time zone"
   where not always displayed correctly in Oracle
 * Oracle's autotrace did not work in console mode
 * Using pgpass for Postgres connections did not work in console
   or batch mode
 * WbProcSource would not show the code for a packaged procedure
   in Oracle
 * Fixed some problems in the SQL formatter that would lead
   to invalid SQL syntax
 * XSLT transformations failed when the output filename didn't
   include a directory
 * Disabling "Filter while typing" in the DbExplorer was not
   possible
 * -targetConnection and -referenceConnection for WbSchemaDiff
   and WbDataDiff were broken