3.15 released on 2023-08-13

V 3.15 (13.08.2023)
– ENH : the licensing system has been completely changed, simpler trial mode

– ENH : New Driver 3.7.1 from InterSystems IRIS 2023.1 added
– ENH : Flat Look and Feel updated to 3.1.1 (https://github.com/JFormDesigner/FlatLaf) – Windows 11: rounded popup borders
– FIXED: Constraints are back again for db diagrams
– ENH : objectnames are only quoted if required
– ENH : the licensing system has been completely changed


3.13 released on 2023-03-03

  • ENH : SQL Editor : More new IRIS keywords are hightlighted, e.g. for new Windows Functions https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_windowfunctions
  • ENH : SQL Editor : New code completion for “SET OPTION”
  • ENH : SQL Editor : New Generic CodeCompletion provider for all other databases than IRIS\CACHE e.g. MS SQL SERVER
  • ENH : TableViewer : Rebuild Index works now for IRIS. This is executed with %NOLOCK %NOJOURN
  • ENH : TableViewer : Tune Table works now for IRIS.
  • ENH : TableViewer : New Tune Table with %RECOMPILE_CQ: will recompile the cached query classes using the new Tune Table statistics.The new action
  • ENH : New Driver 3.6.1 from InterSystems IRIS 2022.2 added
  • FIXED: SQL Editor : Connection handling for the SQL Editor has been improved. Each SQL Editor uses only one “private” connection.
  • Querying the namespace objects created a second public connection. This caused the editor to open more slowly. This is now fixed. The editor now only needs one database connection.
  • A public connection is now only created when navigating in the server navigator. The server navigator uses its own connection, independent of any open editor.
  • ENH : Windows setup works now with lowest privileges.
  • FIXED: Scriptmanager : Scrollbars in Scriptmanager window fixed.
  • FIXED: ServerNavigator : Connectionhandling is now faster
  • ENH : Setup : Setup comes now with asigned uninstaller, so the “unknown publisher” message is gone by unstalling SQL DATA LENS
  • Setup can now be executed in non administrative mode
  • ENH : Flat Look and Feel updated to 3.0 (https://github.com/JFormDesigner/FlatLaf)
  • ENH : Many internal libs upgraded

3.12 released on 2022-09-18

  • ENH : SQL Editor : Min\Max\Avg\Sum values are calculated on selection in tablegrid
  • ENH : SQL Editor : Sorting performance in grid improved
  • ENH : From table results the new option “Copy pretty formatted” is available
  • ENH : More visible connection details for IRIS, eg. using shared memory, server local, and more…
  • FIXED: Open TOP 1000 rows of a table produce in some situations invalid sql statement
  • ENH : TableViewer : Performance improvments for SQL Server connections

3.10 released on 2022-07-18

  • POI dependency log4j-1.2.17.jar removed
  • FIXED: StoredProcedures: Generation of CALL scripts for SPs correctly recognizes parameters and resultset metadata

3.9 released on 2022-07-11

  • New Driver 3.3.1 from InterSystems IRIS 2022.1 added
  • ENH : Added support for TRINO. https://trino.io/
  • ENH : Added support for MariaDB. https://mariadb.org/
  • FIXED: NullPointer fixed while connecting to PostgreSQL
  • Connection name in Statusbar include now the specific icon for the connection type

3.8 released on 2022-05-08

  • FIXED: Showing Stored Procedures if the option “Show Systemobjects” isn’t selected (=ignoring system objects)

3.07 released on 2022-04-31

  • FIXED: Test Connection for none InterSystems databases fixed (JDBC)
  • FIXED: QueryCloud: Downgrade to H2 databae version 1.x to fix some incompatibilities with the QueryCloud handling
  • ENH : Some internal libs upgraded

3.06 released on 2022-04-30

  • SQL DATA LENS contains now an updater for full automatic-updating with tiny update patches

3.05 released on 2022-04-28

  • Upgrade to runtime 11.0.14.2
  • Many internal libs upgraded
  • Open MS Excel works now nativ again
  • EXE Files are now signed!
  • new ms sql driver dll: mssql-jdbc_auth-9.4.1.x64.dll

3.04 released on 2022-02-19

  • New jave runtime 11.0.14 with many bugfixes and performance improvemets integrated
  • Default font changed to “JetBrains Mono” for better reading experience (https://www.jetbrains.com/lp/mono/#key-features)
  • Many internal libs upgraded
  • Driver updated to H2 Database Engine 2.1.210 (h2-2.1.210.jar)

What’s new in release 3.03?

3.03 released on 2022-02-06

This release contains some smaller general fixes and improvements

  • Many database driver updated
  • New build in sql formatter

What’s new in release 3.02

3.02 released on 2021-12-27

This release contains some smaller general fixes and improvements

  • Some smaller fixes for IRIS like new Keywords LOAD DATA added
  • IRIS improvment: For IRIS Server the iboot.log, messages.log, journal.log and alerts.log can be displayed
  • Driver added for InterSystems IRIS 2021.2 Preview (intersystems-jdbc-3.3.0.jar -> JDBC Version: IRIS JDBC (Version: 2019.1.0.999) from InterSystems IRIS [IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2021.2 (Build 617U) Thu Dec 9 2021 InterSystems IRIS Version 2021.2.0.617 xDBC Protocol Version 65 Beware of an old driver info!!! -> InterSystems IRIS JDBC (Version: 2019.1.0.999)

What’s new in release 3.01

3.01 released on 2021-11-07

This release contains some smaller general fixes and improvements

  • ServerNavigator : Copy connections details for JDBC included; Send connections details for JDBC included
  • ServerNavigator : JDBC Connections dialog shows example URLs
  • Driver updated to MS SQL Server 9.4.0 (mssql-jdbc-9.4.0.jre11)
  • MS SQL Server: Windows authentication fixed

What’s new in release 3.0

3.0 released on 2021-10-17

  • New Look and Feel Flat Light and Flat Dark integrated

  • HiDPI support improved. The system scale factor is configured on the OS level and so the the per-monitor DPI is supported. Configured as scale factor in Display Settings system dialog
  • Shipped with a minimized private JRE (based on JetBrains JDK 11)
  • Improved connection testing
  • Improved SQL formatting

Release notes in detail

- Rename: Caché Monitor is now -> SQL Data Lens :-)

- ENH  : TableViewer     : Shows more details for IRIS DB Server
- ENH  : ServerNavigator : Improved connection testing
- ENH  : ServerNavigator : Stored Procedures are loaded async
- FIXED: ServerNavigator : Expanding node while already connecting doesn't start more tries to connect

- ENH  : SPViewer        : 
For Stored Procedures SQL Data Lens create CALL scripts based on the Metadata.
But SQL Data Lens can also
- create a SELECT script for calling a Stored Procedure by using %ODBCIN for each result column
- create a SELECT script for calling a Stored Procedure by using %INTERNAL for each result column
- create a SELECT script for calling a Stored Procedure by using CAST( col as VARCHAR(255)) for each result column
This functions can helb to find and identifiy data type problems within your Stored Procedure

- ENH  : SQL Editor      : Restoring scrollbar position after reload
- ENH  : SQL Editor      : Column completion fixed
- ENH  : SQL Editor      : Hyperlink navigation from connectionname in Statusbar to Server Navigator
- ENH  : SQL Editor      : Refresh grid result is now executed while fetching data
- ENH  : SQL Editor      : Auto Save session state fixed, ordering is restored
- ENH  : SQL Editor      : Improved Syntax highlighting
- ENH  : SQL Editor      : Improved SQL formatter

- ENH  : Better positioning of dialogs main window
- ENH  : New Look and Feel Flat Light and Flat Dark integrated from https://github.com/JFormDesigner/FlatLaf
- ENH  : Improvements for supported dark mode
- ENH  : Intercell spacing for all table components removed
- ENH  : SQL DataLens ist shipped with a minimized private JRE (based on JetBrains JDK 11)
- ENH  : HiDPI support improved. The menu item is removed. The system scale factor is configured on the OS level.Now the per-monitor DPI is supported. Configured as scale factor in Display Settings system dialog
             (https://blogs.windows.com/windowsdeveloper/2016/10/24/high-dpi-scaling-improvements-for-desktop-applications-and-mixed-mode-dpi-scaling-in-the-windows-10-anniversary-update/#Q70zmTwpp7rCw8gC.97)

- ENH  : Driver updated to MS SQL Server 9.2.1 (mssql-jdbc-9.2.1.jre11)
- ENH  : Driver updated to PostgreSQL 42.2.19 (postgresql-42.2.19.jar)   (https://jdbc.postgresql.org/download.html)
- ENH  : Driver updated to H2 Database Engine 1.4.200 (h2-1.4.200.jar)
- ENH  : Driver updated CsvJdbc - added support to DBF Files
- ENH  : Driver added for InterSystems IRIS 2021.1 (JDBC Version: 2021.1.0.215)

- ENH  : "Open in Excel" feature improved
- ENH  : Export improved: "Save query result to File" ignore read error. So the process doesn't stop and continue on next value