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