Changelog and release notes of Caché Monitor, from the first public 0.x builds for Caché 5.2 to the last release under this name in April 2020. The notes are reproduced as they were written at the time, including their original wording.
Newer releases. Everything after version 2.96 is published as SQL DATA LENS. See what's new in SQL DATA LENS for the current release notes.
Milestones
2.96 (April 2020): IRIS 2020.1 driver, Query Cloud with InterSystems IRIS. Last Caché Monitor release.
ENH Driver updated to SQLlite 3.30.1 (sqlite-jdbc-3.30.1.jar) (https://bitbucket.org/xerial/sqlite-jdbc/downloads/9
ENH Driver updated to PostgreSQL 42.2.11 (postgresql-42.2.11.jar) (https://jdbc.postgresql.org/download.html)
ENH Driver updated to InterSystems IRIS JDBC (Version: 2019.1.1.612)
Version 2.94 04.01.2020
ENH No installed Java runtime required! Caché Monitor is now shipped with a private JRE (Java Runtime Environmet).
ENH change Time format with fractions
FIXED some minor fixes like remove memory leaks
FIXED date handling in sql history
Version 2.93 13.08.2019
ENH Native Intersystems IRIS support added (specific features like GlobalViewer and many more, known from Cache)
ENH Show Stored Procedures for JDBC Connecions
ENH Some refactoring, like removing old starting\stopping action for local Caché services
ENH Server Navigator: Caché CPF Files are available at the management node
ENH SQL Editor : For Caché & IRIS the PID is in Statusbar
FIXED SQL Editor : holding the F5 key down (or press SHIFt+ENTER) starts the same statements multiple times, thats fixed now
FIXED ClassBrowser : many fixes
ENH Server Navigator: Caché & IRIS Connectino property "Show system objects and namespace" is now splitted in two options: "Show system objects" and "Show system namespaces"
ENH Driver updated to H2 Database Engine 1.4.199
ENH Driver updated to Microsoft JDBC Driver 7.2 for SQL Server (Version: 7.2.2.0)
ENH Driver updated to InterSystems IRIS JDBC (Version: 2018.2.0.999)
ENH Driver updated to MySQL 8.0.16
ENH Driver updated to SQLlite 3.27.2.1
ENH Removed driver for Caché version 2009.1, 2010.1, 2017.1 (2017.2 is still there! 😉
ENH Server Navigator: columns in tree show now detail information about datatypes, pks and nullable
ENH TableViewer : More details about global storage per table on the storage tab
ENH TableViewer : Some smaller ui improvments
ENH HiDPI font scaling factor reduced
FIXED Bugfix function "Import Caché & IRIS Connections"
FIXED Bugfix function "Bulk export wizard"
FIXED general UI fixes: , e.g. Title handling in main frame
FIXED disconnect works also on subnodes from Server\Connections
ENH Date\Time UI improvments, e.g. display format is configurable
FIXED Refresh on Stored Procedure View
Version 2.92 27.01.2019
ENH Caché Server Properties: Option "Don't use %SYS namespace" renamed to "Don't query for Caché namespace list"
FIXED if the Cache Server Connection Property "Don't query for Caché namespace list" was selected, the namespace was not expandable
FIXED Query Editor some smaller bugfixes
ENH New DB Driver : Caché 2017.2
ENH New DB Driver : Caché 2018.1
Version 2.91 07.01.2019
ENH Internal library refactoring
ENH cache.cpf file handling improved
ENH Third party libraries updated (e.g. POI 4.0.1)
FIXED Fixed first call on table add to querycloud
FIXED MS SQL Server JDBC Driver: Login Dialog pay attention on integrated security (windows)
INFO Querycloud - can't use integrated security with MS SQL Server
ENH Driver updated to SQL Server 6.0 (6.0.8112.200)
ENH Driver updated to MySQL 8.0.13
ENH Driver updated to PostgreSQL 42.2.5
ENH Driver updated to H2 1.4.197
ENH Driver updated to UCanAccess 4.0.4 (A pure Java JDBC driver for Microsoft Access database files)
ENH Driver updated to MS Excel - Simple, POI based JDBC driver for XLS/XLSX files (sqlsheet-6.7.jar)
FIXED Working with local file based databases (like Access), the Login Dialog pay attention on this and doesn't show
ENH CsvJdbc: Connect to a ZIP File with *.csv File within.
ENH SQLlite JDBC Driver added
ENH New icons added to identify connection type (Caché, CSV, ...). Important: The symbol für the Caché Server are green cubes
ENH SQL Editor : MouseWheel zoom optimized
ENH QueryCloud: CSV handling in QueryCloud improved -> Create VIEW or COPY to TABLE (DragDrop CSV Files to QueryCloud Node or select "Add CSV File to QueryCloud..." via context menu
ENH Favorite handling implemented, some bugfixes added
ENH element sizes in trees increased, some ui stuff in tree for a more cleaner look and feel
ENH Scriptmanager: double click handles only *.sql file in Caché Monitors editor, all ther files are handled external by the default app
ENH Scriptmanager: The fastfile preview feature shows fpor more file type previews
ENH DB Driver : IRIS Intersystems JDBc Driver added
Version 2.85 31.07.2017
ENH Improved Server\Connection dialog
FIXED Open Query Editor for a Csv Connection (Menu: "File" -> "Create CSV Text connection")
ENH New config dialog for the "QueryCloud"
ENH Improved QueryCloud data view and management
ENH In QueryCloud loaded driver can viewed on the Connection dialog (Server Manager)
ENH "View Metadata" only works with connected objects, a message about that behavior is displayed if not connected
FIXED Server Navigator: Some databases doesn't list catalogs\schemas. For that type of connections Caché Monitor show "default" nodes in tree to allow to navigate.
ENH DB Driver : Update CsvJdbc driver to version 1.0.31
ENH Connection testing improved
FIXED TableViewer : Set filter by context menu works now with columns that have to be quoted (IdentifierQuoteString)
FIXED TableViewer : MaxRows is set to 1000 on first startup
ENH Max memory set up to 2Gb for the windows exe
ENH DB Driver : Caché 2017.1 driver updated to 2017.1.1.111
ENH Grid : Improved cell selection
Version 2.83 21.04.2017
ENH DB Driver : Caché 2016.1 driver removed
ENH DB Driver : Caché 2016.2 driver added
ENH DB Driver : Caché 2017.1 driver added
ENH New function for testing server connectin on Server\Connection dialog
Version 2.82 15.01.2017
FIXED In the final release the wrong konfiguration folder was used. ".cm_beta" instead of ".cm". Please update to this version to get your configuration.
Version 2.81 08.01.2017
(Windows only)
ENH New search possibility in all grids with new searchbar
ENH Searching in sql history
ENH More details on the error dialog about db vendor code and state
ENH Improved connection handling, while connecting a progress bar shows the background process.
FIXED Grid : GridHeader (row number) are not always in sync with the rows from content. It shows while scrolling in bigger result like > 100000 rows
ENH Grid : Create SQL for Grid results improved (copy as Insert, copy as update, e.g.)
ENH SQL Editor : New Combobox for selecting text scaling like 100%, 200% and so on
ENH SQL Editor : View the column's data type in the header tooltip of the result table
ENH SQL Editor : SQL statement is visiable on result tab via tooltip
ENH SQL Editor : "Open in Excel" copy Grid data direct into MS Excel without export to file\import to file
ENH SQL Editor : A SQL statement can be saved direct to file via "Execute to file". This feature works with limited memory because it is designed to directly write the rows from the database to the export file without buffering in memory.
FIXED SQL Editor : connecting a disconnected sql editor update the titles now correctly
FIXED some minor fixes like memory leaks
FIXED SQL Editor : "Session snapshots" opens in some situations a connection to get namespace metadata while the editor is still disconnected
FIXED SQL Scanner : In some situations SQL Scanner doesn't work
ENH TableViewer : The table size can be calculate via Task -> "Calculate size for all tables"
ENH TableViewer : UI improvments to see more columns details with one click, like infos about Primarykey-Columns, ForeignKey-Columns and special Caché specific details about Caché internal Datatypenames, selectivity and more
ENH Server Navigator: Selection concept changed to improve user experince and get more control at what time information are fetched from server and detail data are shown. Important: please consider that you have now select detail data via double clicking or selection "open" via context menu.
Version 2.80 24.06.2016
Renamed and refactored context menu, some functions grouped within menu "Tasks":
FIXED various : MaxRows limiter can be removed
FIXED Preferences : Not all preferences was saved in cm_prefs.dat
FIXED Login : On long running login process two wating dialogs coming up
ENH New dashboard start page
ENH Source Browser : Icons for different source types Navigation improved, drill down via double click on folder (not finished yet!)
ENH StoredProcedures: Stored-Procedures-System objects are no longer displayed if the option "show System objects" is deselected on Server defintion
ENH TableViewer : View the table row count in top grid.
New function to get the current row count for ALL tables with one click
Execute tunetable for selected tabel(s)
Execute tunetable for current namespace Syntax highlighting for View Source and Table ddl Messaging of current running processes improved e.g. current loaded rows Execute "Script as -> Create" on a view creates now the "CREATE VIEW" with the source of the view Error on getting a value, doesn't stop retrieving the entire result. Just the error value is set to NULL
ENH More metadata details are localy cached and reused e.g. on Codecompletion for perf reasons
ENH Localy cached metadata are now saved as zip file to improve performance
ENH DataInspector : Syntax highlighting for JSON content. Some smaller improvments in viewing content in DataInspector
ENH SQL Editor : new function - escape date dialog
ENH SQL Editor : For running queries less cpu cyles are used to update the UI
ENH SQL Editor : Multi result view improved. Between each table a splitter is available
ENH SQL Editor : Format SQL respect a text selection and format only this string
ENH SQL Editor : new parameter "ui.maxoptwidth" to set the max width in pixel for optimizing table column max width based on data
ENH SQL Editor : Code completion has now the option to select all columns from a table
ENH SQL Editor : Script table as CREATE, INSERT, SELECT direct from (selected) editor text
FIXED SQL Editor : In some situations closing a tab haven't ask for saving
FIXED SQL Editor : In some situations wrong row count is displayed in status bar
ENH SQL Editor : New feature "Session snapshot" allows to make a quick restart. After stop and start again Caché Monitor all SQL Editor tabs with content and connection infos are restored. When the user quits Caché Monitor, unsaved files and open SQL Editor's from last session will be automatically restored on next launch. The user won't be asked to save unsaved files as he quits Caché Monitor. This can be disabled by setting "ui.remember_session=false" in config.properties
FIXED Server Navigator: Emtpy schemas are removed if setting metadata.removeEmptySchemas=true
Version 2.79 30.03.2016
ENH SQL Editor : Code completion shows for columns the table name
ENH SQL Editor : More context infos in status bar
ENH SQL Editor : Timing informations improved
ENH SQL Editor : Faster result loading
FIXED some minor fixes like memory leaks
FIXED TableViewer : Faster result loading
ENH Preferences : Preferences like last Window position, Max Row count and so on are on Windows no longer saved in Win-Registry. The data are now loacted in a file called: cm_prefs.dat
ENH CM Notepad : The Caché Monitor "Notepad" is something like a visible Clipboard. You can copy\paste text data. All data are automatically saved and restored on startup.
ENH SQL Editor : "Save result..." is now executed in a own thread. THis is better for larger results > 1Mio rows
ENH Notepad : Caché Monitor has now a new feature called "notepad". This is just something like a simple "notepad" a small visible clipboard ;-). The user haven't worry about saving\loading the content
FIXED TableViewer : Error "Invalid Column EXTENTSIZE) fixed on tablelist. Caché 2008 and before dosn't have informatino about EXTENTSIZE within calls details
ENH TableViewer : Loading data (and other long running tasks) are cancellable
Version 2.78 24.03.2016
ENH SQL Editor : For Caché connections the table remarks as listed in code completion popup
ENH SQL Editor : Affected rows (rowcount) are visible in statusbar
FIXED Server Navigator: Sometimes not all tables are loaded (same table name in diff schemas) Please use "refresh" in ServerNavigator to refresh the local cached metadata
FIXED Server Navigator: Caché linked Tables are visible via "linked icon"
Version 2.77 22.03.2016
FIXED Permanent wait cursor in script manager
FIXED On startup the import connection wizard popup only when Server Navigator is empty
FIXED Caché connections import has only shown local Caché server installations
Version 2.76 19.03.2016
ENH Prevent multiple running instances of Caché Monitor. On Windows Caché Monitor search for a running instance on startup and if one found bring it to front.
FIXED Open connection before load metadata \ CPF File
ENH Server Navigator: "Close" on a server node execute the same action like "Disconnect"
ENH Server Navigator: "Refresh" on a table node improved, local cached metadata will be deleted
ENH H2 Database support included
FIXED some minor fixes like memory leaks
ENH Server Navigator: New data node "Security" with User and Role detail lists
ENH Server Navigator: New feature: "QueryCloud"!
ENH TableViewer: More details about Tables like extentsize, classname, external tables and more caching for table meta data to improve performance
ENH Server Navigator: List of SQL Gateway connections
ENH All server\network calls are cancellable
FIXED Cursor navigation within Tablebrowser
ENH Working with CSV files in QueryCloud
ENH Server Navigator: Open CSV files in QueryCloud via Drag&Drop. Just Drag&Drop your files from Windows file explorer into ServerNavigator.
ENH Server Navigator: Open text files in SQL Editor via Drag&Drop. Just Drag&Drop your files from Windows file explorer into SQL Editor to open.
ENH DB Diagrams : The database diagrams feature is now also available for JDBC connections
ENH Server Navigator: Removed Caché driver before version 2010.1. If you still need older Caché driver you can download from here http://www.sql-monitor.de/pub/addon_old_drivers.zip You have to extract the zip folder into \lib
FIXED Server Navigator: Add a Caché Server, press OK without a selected driver results in the problem that the dialog disappear silently without adding the server
ENH New Function: Copy tables between Cache and JDBC Connections
FIXED SQL Editor : if "Code completion auto-popup" is set to on, after typing "." or "," the codecomplition popup is automatically displayed
Version 2.75 21.12.2015
ENH !! Require Java 8 runtime !!
ENH Include many database driver, no driver download required
ENH Available as a comfortable Windows Setup package
ENH Caché Monitor try to download Java 8 database driver, if no one found the older versions are transparently downloaded and used
FIXED On the Export Wizard Dialog the file type can now seleced for bulk export (not for Home Edition!)
ENH New function "Create MS Access connection" via file menu to add a ms access db to server navigator and that file to query it via SQL
ENH Microsoft SQL Server: Support for Windows Authentication (on Windows system cause of required dll)
ENH New Parameter metadata.cache.deleteonexit allows to config Caché Monitor to delete all local saved metadata on program exit. By default this is set to FALSE. So you have to active delete cached metadata to refresh e.g. the Namespaces list
ENH More detailed messages if there a problem downloading database driver files
FIXED Sometimes the catalogs from JDBC databases was not properly listed
ENH Faster open query editor
FIXED View Caché Version information on the "Import Caché Connections" dialog
ENH Import local ODBC Connections analyze the driver DLL to find the right database driver
ENH Namespace: A Remote namespace is marked with a special "linked" icon in server navigator Namespaces that are not available can not expanded and are marked with a red X on the icon
ENH New option on the edit server dialog called: : "Query remote namespace" this is selected by default and means that remote namespace are listed
ENH New option on the edit server dialog called: : "Check namespace availability" this is deselected by default and means that the availability of remote namespace are checked\not checked
FIXED Drag Drop in Server Navigator for Java 8 fixed
FIXED Loaded and cached Namespace information are now synced and used in server navigator and for the namespace detail view
ENH New parameter cache.loadNamespacesFromCPF to switch namespace loading to the cache.cpf file!. If this is set to true if you want to load the Namespaces from cache.cpf File. This can maybe improve the performance if you have a lot of defined namespaces but you lost information, like the the namespace availability or the info about a local or remote namespace.
Version 2.74 20.10.2015
FIXED SQL Editor : Code completion for generic JDBC connections like MS SQL Server, MS Access is now working
FIXED SQL Editor : Code completion is working if the SCHEMA is NULL
FIXED TableViewer : JDBC Column info is no longer editable
ENH Server Navigator: Shows Server Version infos for generic JDBC connections
ENH DB Diagrams : The tablename of the table where the diagrams are saved into can be configured by setting the property diagrams.tablename in config.properties
ENH On all tables : Selection improvements like "select all" on click upper left corner, "select column" on table header click
ENH On all tables : Last selection of option "Fit width based on data" or "Fit width based on data header" are saved and the last selection is reused
ENH SQL Editor : With the config param ui.useAccessStyle=true you can enable e.g. the exclamation mark for the execute button
FIXED Server Navigator: On the Edit\Add Server dialog by default the frist driver is selected
ENH Server Navigator: Moving Server and groups via drag and drop within the Server Navigator implemented (you can do this also by CTRL+C,CTRL+X and CTRL+V)
ENH Database Driver : Caché Monitor checks current running Java version and is it Java 8 the Java 8 database driver are loaded
Version 2.73 21.06.2015
FIXED SQL Editor : Open editor on generic JDBC connections like MS SQL Server, MS Access sometimes hangs without a message
FIXED Caching : "New query" dialog and Server Navigator has shown sometime wrong schemas cause the the hashing algo hasn't enough elements be be unique.
ENH Clear all cached meta data by using "Refresh" on a folder node in Server Navigator
Version 2.72 17.06.2015
FIXED SQL Editor : Script Table is now working also if just the table name in editor is selected
FIXED SQL Editor : ComboBox "Isolation Level" shows the correct isolation level from database and list only available
FIXED SQL History : Running Caché Monitor with Java 8 result sometimes in an emtpy SQL history frame
ENH The function "Import Caché Connections" allows now to import all locally in Caché Server Manager registered connections (Before this change only locally installed Caché Server are listed). The import can now be done via multi selection
ENH Caching improved: Namespace and schemas are now saved in folder "\.cm\metatmp\\...". Server roundtrips are minimized to improve entire Caché Monitor performance on large server and\or for small network connections.
Version 2.71 26.03.2015
ENH Server Navigator: All connecions in Server Navigator can now be import\exported from\to a file. To find via File menu
ENH Script Manager : New Action "Open the file with the associated app"
ENH History Manager: Some handling improvements (e.g. auto expand on node, double click open an editor if needed)
ENH History Manager: SQL Statements are now colored
ENH History Manager: New icons in tree are used for better navigation
ENH SQL Editor : For long running SQL Statements the first row are now displayed in shorter time
FIXED Profiling : Display the SQL Stats for selected namespace. Previously only stats from %SYS are available
ENH Profiling : SQL Statements are now colored
ENH Profiling : Via right click in SQL statistics table the selected sql statement can be opened in new editor
ENH Main toolbar added for faster access to some action like e.g. "new query" and more
FIXED SQL Editor : Is working now with MS Access
ENH SQL Editor : closable result tabs
ENH Viewing Database Metadata improved
Version 2.70 06.03.2015
FIXED SQL Editor : open more than one query editors on same connection config
ENH Caché 2015.1 driver added
ENH View meta data for jdbc Connections, via conext menu on node "View metadata"
ENH Show licenseid on manage license dialog
Version 2.69 22.02.2015
FIXED Context menu on table tree node cleaned
FIXED loading node for columns nodes removed
ENH Downloading of driver files improved, check file size after download and inform user if there a problem.
ENH License file can also be placed in cache monitors install folder
ENH simpler license purchsing process 😉
ENH Result limit is observed on MySQL
Version 2.68 08.02.2015
ENH Some updates for Java 8
ENH View Key symbol in table header for PK columns (is not working in SQL Editor)
ENH DataTable\Grid : many small improvement in view and change handling
ENH SQL Editor : Font Zoom via CTRL + Mouse
ENH DataTable\Grid : Font Zoom via CTRL + Mouse
ENH Loading configuration file config.properties from user home folder and merge the data with the configuration file from Caché Monitor installation folder. This make Caché Monitor updates easier, and prevent lost user changes
ENH Driver path in config.properties can set fix to local files. Even if the driver_repository is set to WEB
ENH ServerNavigator: move and copy Server and Groups via CTRL-X\CTRL-C\CTRL-V
ENH ServerNavigator: refresh without selection reload the entire tree
ENH At application startup the ServerNavigator definition file is backed up into user home\\.cm folder
ENH First support of HiDPI screens like a apple retina display (for screens with 3k or 4k resolution)
ENH More clean and consistent icons usage
ENH Generic JDBC Connections supported for MS SQL Server, MS ACCESS and Windows Azure and more!
FIXED minor bugs
Version 2.62 23.09.2014
FIXED No function for Ok\Cancel Buttons on the edit server dialog
Version 2.61 09.09.2014
ENH Memory usage optimized. Tab close handling improved, Memory was not always released while closing tabs
ENH All meta data can be scripted to a CREATE TABLE script, e.g. execute a stored procedure and create a script for a table from that meta data
ENH Query Analyzer : New (context) menu function "clear messages" on message tab
ENH Query Analyzer : New function "Auto clear messages", if checked (default) the old message are deleted
ENH With a new paramter in config.properites quoting column name for scripting can be configured. The default is sql.scripting.quotealways=false, set it to true to quote all columns names
Version 2.60 16.08.2014
FIXED Open SQL Files from script manager sometimes ends up with damaged UI
ENH Server Navigator shows columns for Views\Tables in tree
ENH New driver version for Caché 2014.1.1.702 uploaded
ENH New meta data info panel on server node, available via context menu on server node "Show server metadata..."
ENH Global Browser: Support of $LB format and split values accordingly
ENH Global Browser: Enhanced loading speed.
ENH Stored Procedure Viewer: Shows more details about the result-type of a SP, like Columns and infos about IN\OUT\INOUT params
ENH Stored Procedure Viewer: Via context menu a CALL Statement for SP can be created with parameter and more. This "script" is opened in a query editor for execution.
ENH Show execution plan first checks whether the server side class exists, regardless of the setting "create server side helper classes". If the class doesn't exists and the setting "create server side helper classes" is disabled, viewing the execution plan is stopped. If the class exists and the setting "create server side helper classes" is disabled, viewing the execution plan is processed.
ENH Grid: On all grids the metadata of a result is available via context menu "Show Metadata"
ENH Grid: More copy functions via context menu "Copy selected", "as Text", "as SQL Update", "as SQL Insert", "as SQL Delete"
Version 2.59 23.07.2014
ENH New functions in Server Navigator: ‘Send Server by email' and ‘Add Server by email' With this new feature it is very easy to send and receive registration data via email.
FIXED Start a evaluation of Caché Monitor is available again on register ‘Request a trail'
Version 2.58 22.06.2014
ENH The export bulk wizard open destination folder after the export job has ended
ENH Record dialog shows required fields (NOT NULLABLE) in red
ENH Export to different formats improved, like export to Microsoft Excel (97-2003); Excel Workbook (XLSX); HTML; JSON; OpenDocument; SQL; XML
ENH Rename Caché connection import function from "Auto register Caché Server" to "Import Caché connections"
ENH New Function: "Import Caché ODBC connections"
ENH New Icon! 🙂 A new symbol for Caché Monitor
ENH New context menu "Save result and open..." on all UI grids available. This will open the file with the associated application.
FIXED Switch between database tables refresh the title
FIXED Unnecessary server roundtrips removed while switching between database tables
FIXED TableViewer : Refresh in context menu fixed
FIXED TableViewer : New context menu "open in new tab", this function is also available via double click on a DB Table\DB View node
ENH "Don't use %SYS namespace" renamed to "Don't query Caché for namespaces"
Version 2.57 14.05.2014
FIXED The data in Data Inspector refreshs after selecting a NULL Value
ENH CLOB\BLOB Handling in Table and in Viewer improved. New CLOB\BLOB Edit Window from Table and in Recorddialog available.
FIXED New Record dialog fixed. On some installation it was not possible to open this dialog.
FIXED The new entered table name is used via Copy Table action
FIXED Some table context menus hasn't worked properly if called from tree
ENH If the DataInspector is visible the value of selected cell is autom. displayed
FIXED NULL Value marker fixed
ENH The menu entry: "SELECT first 1000 rows" execute the query immediately
Version 2.56 15.04.2014
ENH The namespaces query don't need any longer access to the "%SYS" namespace.
ENH Class Browser : For Caché >= 2014.1 the same Sourcecode as in Studio is listed.
FIXED Global Browser: Recognize node subsripts type (numeric\alphanumeric) improved
ENH Global Browser: Icons added to visualize different node types, e.g. root, last node ...
ENH Root group can be renamed
FIXED Rename a group\server refreshs the tree on server navigator
ENH New Record dialog is available. This dialog shows columns in rows. Each Grid in Caché Monitor can open this Record Dialog via context menu.
ENH TableViewer : The new ‘Storage' Tab list the storage information about a table, like global name and global size
ENH Number format can be changed in config file, e.g. by default format.number=####.######## But Caché Monitor do always format based on the decimal digits definition on the column meta data If you dont want to format than select format.number=UNFORMATTED
ENH Workspace seetings are saved on exit an reload on startup. So CM remember on the window position and state (docked\undocked).
Version 2.55 06.04.2014
ENH Support of Java 8
ENH TableViewer : Tables\Views are grouped by schemas
ENH TableViewer : Prefetch of meta data to improve performance\minimize user waits (metadata.prefetch=true)
ENH TableViewer : Empty schema will not be displayed by default (metadata.removeEmptySchemas=true)
ENH Query Analyzer : Schema ComboBox removed, CodeCompltion work on all schemas by default
ENH Query Analyzer : Some code completion improvements for column lists
ENH "Sources" node works with more Caché versions
FIXED Error while driver download via transparent proxy: java.net. ProtocolException: Server redirected too many times (20)
FIXED Source-, Class- and GlobalViewer shows the item count on registertitle and in tree
Version 2.54 01.04.2014
FIXED ArrayIndexOutOfBounds Exception
ENH Open current class in Caché Studio
ENH The Caché Studio version that is called via Caché Monitor is selectable
ENH Some code completion improvements: More Caché keywords in completion and coloring, Some code completion display additional information for keywords and functions, Icons visualize the completion type e.g. Table, Column, Schema, Index etc, Type column shows the primary key, datatype and nullable property, Optimizer hints are listed with additional information, Caché SQL functions are listed
ENH New Driver Version: 2014.1.0.591
FIXED Disconnect a server close all sub panels
FIXED License management improved
Version 2.53 22.01.2014
ENH New Bulk Export Dialog allows to save current- and load previos selections of Tables
ENH Install license process improved; license is also now visible in about dialog
ENH Server Navigator: The server version number can be viewed in Server Navigator tree. This is toggled via Menu "Show version".
ENH TableViewer: New context popup menu entry: "SELECT first 1000 rows"
ENH TableViewer: New context popup menu entries: "Script Table as "SELECT", "INSERT", "CREATE"
FIXED "Sources" node works with Caché databases prior version 2013
Version 2.51 12.01.2014
ENH Database Diagrams: More key constraints are be determined and visualized in diagram
ENH Database Diagrams: Exported keys are marked with special icon
ENH Table Browser - List imported\exported keys on new tab called "References"
Version 2.50 05.01.2014
Database diagrams graphically show the structure of the database. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.
Each database diagram you create is stored in the associated database. The first time you click on the Database Diagrams folder of a database, you ask to "Create required objects to manage diagrams in this namespace?".
If you choose Yes then a table would be created in your database and you will be able to work with database diagrams. If you modify any table outside the diagram editor, the changes will automatically be updated in any saved diagrams. You can open database diagrams to view or edit the diagram's structure. To open a database diagram in Server Navigator, expand the Database Diagrams folder.
Click the name of the database diagram you want to open. You can create an image of a Database Diagram and copy it to another application. To copy a diagram image to the Clipboard open a Database Diagram.
Right-click a blank area and choose Copy Diagram to Clipboard. Please note this is a early draft of that feature! Maybe not all is working as expected. If you find a issue please send a mail to me with a description. Thank you!
ENH New polished Interface design. For a clear and consistence user interface design many icons are changed and checked for a consistency use. Some menus renamed so e.g. the "New Query Analyzer" menu is renamed to "New Query" also with a new icon for this action. Also the application icon is changed from a server magnifying glass with to a blue cube.
ENH New! Database Diagrams For any database, you can create as many database diagrams as you like; each database table can appear on any number of diagrams. It is not an error, but just a permission seeking dialog to create a database table that is necessary to work with database diagrams. If you choose No then no table will be created and you will not be able to work with database diagrams.
ENH Query Analyzer : CTRL+ENTER for execute query in
FIXED Optimized table column width for data
ENH Class Navigator : Classes source code is now in xml
ENH Table Navigator : double click on a table in tree opens a new Table Editor for the selected table
ENH The "Routines" node is renamed to "Sources" because in the future all sourcecode with hin cache will be available from here.
ENH Faster scrolling in tables
Version 2.09 06.11.2013
FIXED Processlist : On a Caché 2014.1 Server selecting a process and view the variable details ended with a java.lang. ClassCastException: java.lang. Integer cannot be cast to java.lang. String
FIXED Navigation between Processlist and Lock Viewer improved
ENH Global Browser : Nodes to read can be limited by setting a max nodes value. and more
Version 2.08 05.11.2013
ENH Routine Browser : Routine List and Sourcecode for selected routines are displayed.
ENH Class Browser : Shows Sourcecode fragment for selected class.
ENH Globals Browser : Global browse and navigate are improved
ENH Caché 2014.1 support
ENH Analyze and find local installed Caché Server improved
Version 2.07 17.10.2013
ENH Server Navigator: Driver download is cancelable via progress dialog
ENH Class Navigator : Selection of target folder for classes export is available
ENH Class Navigator : Class delete need to be confirmed by user
ENH Class Navigator : New function: Import classes (incl. auto compile)
ENH Class Navigator : New function: Copy classes (incl. auto compile) between server \ namespaces
ENH Class Navigator : New function: Compile class
ENH Table Navigator : Export Table works now also on a selected table node within Server Navigator. Before this the user have to select a export table on the detail panel.
ENH Tested with Java 1.7.0_45
ENH License Evaluation\Activation: Proxy Server can be configured
ENH New Feature: Log File Manager
ENH Script Navigator : Threading issue while file preview fixed
Version 2.06 08.10.2013
ENH Drag&Drop for Server and Server-Groups moving within the server navigator
ENH Server Navigator with a toolbar to shows important actions
ENH A trial license for evaluation of Caché Monitor Professinal can now requested online via Manage-License Dialog.
ENH New Script Navigator for easy working and navigation with many (sql)scripts.
ENH Query Analyzer - shows file path from current file in status bar
Version 2.05 15.09.2013
ENH Data Inspector shows Data in additional views as XML and HTML. Just plain text, binary or a image views was already available
ENH double click on table cell open the data inspector view
ENH The "Database Viewer" shows information about the databases on the selected Server. This Viewer is a new node type in Server. Navigator as a child node from the Management node. Listet are information about the Database name, the Location of the CACHE.DAT file and Size of the database in megabytes
ENH Export classes
Version 2.04 03.09.2013
ENH FileOpen-Dialog restore last used directory
ENH FileOpen-Dialog shows preview of file content
ENH Query Analyzer - Save\restore splitter position
ENH The cache.cpf file can be viewed for selected server Check Tools-Menu -> "View Server cpf file ..."
ENH Table Browser - Save\restore splitter position
ENH Query Analyzer - Search\Replace and Goto Line Dialog
ENH Caché Monitor checks on startup for available updates
Version 2.03 20.08.2013
ENH Encypted passwords
ENH Open Cache Terminal on selected Server
ENH Open Windows-Explorer on Caché Monitor homefolder
ENH Auto driver download
ENH Include Caché 2013.1 driver support
ENH Code folding in SQL Editor between the batch seperator GO
ENH Save\restore frame size and position
Version 2.02 24.07.2013
copied into the federated namespace, the data remains in their original namespace. To do this, open up your "source" namespaces one by one and select the individual tables in TableViewer (select "tables" in server navigator to open),
choose the federated namespace and all done! You can now connect to the federated namespace e.g. via Query Analyzer and query your tables. Warning!Please be careful if you execute a "DROP TABLE" or just delete operations on a "mapped table", the original data will be deleted!!Hint: To remove a table (class) from the federated Namepace, just delete die class! Do not execute a drop table!Read more about Extended Global Reference an how it works:
http://docs.intersystems.com/cache52/csp/docbook/DocBook.UI. Page.cls?KEY=GGBL_structure#GGBL_str_extrefsThere are some restrictions in this version:
ENH Hex View improved
ENH New feature: "Navigate to last selected object", please see: Start Screen
ENH Rename Server Groups
ENH The tablename for "Copy table" action can be changed
ENH New feature: "Auto register Caché Server" Check Tools-Menu -> "Auto register Caché Server ..." With this feature you can very straightforward create a Server registration from any your local Caché installation. All data that Caché Monitor needs for working with Caché are automatically imported, including the right driver... you have just to enter the password.
ENH Class Browser shows no system classes (‘%')
ENH New feature: Open Caché Studio from Caché Monitor on selected Server Check context menu on Server and Tools-Menu
ENH New Feature: "mapped tables" and "federated namespace" With this version you can write sql queries across namespaces! ... ok in fact you cannot 😉 but Caché Monitor support this request with a the idea of a "federated namespace". I got quite some people asking for an option to query some tables from different namespaces on sql statement. Rather than doing some obscure SQL pre-parsing trickery I will introduce a way of mapping tables from different namespaces into a new virtual/federated namespace, a unified namespace, lets call it a "federated namespace". How does this work? Caché Monitor creates copies of the meta data in the federated namespace and use the Extended Global Reference to map the data. All this on done automatically. The function in Caché Monitor is called "Create mapped table". To try this feature I recommend to create a new empty Namespace (and database for this namespace), e.g. called "CM_FEDERATED" as the federated namespace. All tables you want to JOIN in a query must be "mapped" in this namespace. "mapped" means that only the meta data of the tables are right click on the selection and choose "Create mapped table". You get asked about the destination namespace,
DefaultStorage is required for mapped tables
The table name has to be unique in the federated namespace
FIXED RoutineList fixed
FIXED Driver selection fixed
Version 2.01 16.07.2013
ENH Query Analyzer - better clear type\font support
ENH Query Analyzer - Completion improved
ENH Minimum SplitterSize removed
ENH DataInspector shows Images
ENH Import for Blob datatype improved
FIXED Some Edition checks changed
FIXED Table scripting don't quote table name
Version 2.00 30.06.2013
The biggest change first: Now there are different editions of Caché Monitor, e.g. a free community edition called "Home" and two commercial editions. The differences between these editions in detail:
Home Edition : Support only connections to Caché Servers that are on the same maschine (localhost)
Developer Edition : Supports until 3 Server in the Server Navigator
Professional Edition: Supports unlimited Server in the Server Navigator
ENH Kill Database locks within Caché Monitor
FIXED Bug in script parser prevent executing create\drop procedure. When creating a stored procedure it is necessary to use a delimiter other than the semicolon because Cache Monitor does not know if a semicolon inside the stored procedure ends the procedure or a single statement inside the procedure. Because of that, the Statment seperator is now "GO" like in MS SQL Server Management Studio.FIX 1: if you now select a statment the parser is no longer executed, just the selected statement is "as is" send to Caché. FIX 2: Cache Monitor has switched (back) to statement separator "GO"!
FIXED F7 shortcut for execute the next statement fixed
ENH New message are always in top row of the message panel
ENH Connection Dialog shows information about WebSrvUrl that comes from Caché Server
ENH Server Navigator: New feature for sorting Server and Groups : Server Navigator: Sort order changed: Server comes before Groups in Server Navigator
FIXED Cancel login dialog reset message and stops wait bar
ENH tested with java 1.7.0_15
FIXED Copy Server create only one copy of server entry
ENH While deleting a group the user get ask, if the Group contains sub groups or servers
ENH Textoutput in QueryAnalyzer is optimized and show content only up to 255 characters! For more content please use Grid output
FIXED All results (ResultSets) from a StoredProcedure are now listet, e.g. call Sample. PersonSets(‘A','NY') in SAMPLE Namespace show now both ResultSets.
ENH Caché Monitor comes with driver for Caché 2012.2; 2011.2; 2010.1; 2009.1; 2008.2 and 5.2 The path separator in config.properties is changed so it should now works on linux. You can add more driver if needed.
ENH The Driver list are sorted.
ENH Based on the decimal digits definition on each columns are the value now formated
Version 1.68 (beta) 21.11.2012
FIXED processlist: Show process vars for PID
FIXED processlist: Navigation:Show PID in locktable
FIXED processlist: Show process vars for PID by row selection changed
FIXED locktable : Navigation:Show PID in processlist
FIXED All tables rowheader, min size fixed
FIXED variable substitution in query analyzer
Version 1.67 (beta) 19.11.2012
FIXED NullPointerExceptions in com.intersys.* classes
added links to the Help menuitem
online update checker in help menu
Caché driver 2012.2.0.638 included and set as default
older Caché driver removed
Version 1.66 (beta) 27.07.2012
Caché Monitor is now running with Java 7
Version 1.64 (beta) 05.04.2012
FIXED TableViewer - Editing\deleting function fixed
FIXED TableViewer - If you make a table editable and selecting another table, editable mode is set to false again
FIXED TableViewer - Refresh bug in RowHeader fixed
FIXED TableViewer - The Color for NULL values are now a system color
FIXED TableViewer - Fixed handling with tables with a dot in name
FIXED TableViewer - Import Table, Export Table and Save Results clarified. Save Result is on every Table available and saves the Result from this table Export Table saves the entire table data into file Import and Export is only available in the TableViewer (with the context menu on the top table)
ENH TableViewer - The Import Table function added. Cache Monitor can import data from csv files
Version 1.63 (beta) 07.03.2012
FIXED TableViewer - Bug in filter functions from context menu is fixed
FIXED TableViewer - Tables was in some situations editable
FIXED ALL - RowHeader\Row numbers are back
FIXED ALL - Display of some datatypes fixed: Date / Timestamp / Time / Datetime
Version 1.62 (beta) 24.10.2011
ENH TableViewer - Data not automatically loaded on Table Editor of performance reasons
ENH TableViewer - Data automatically loaded limited to TOP xxx be default of performance reasons This solution is working faster with handmade SQL mappings in Cache
ENH TableViewer - Create DDL Script added
ENH TableViewer - Source View for DDL Script added
ENH TableViewer - Default TableMenu added to all popupmenus
ENH Query Analyzer - Create DDL Script added
ENH Query Analyzer - Font antialiasing activated
FIXED Query Analyzer - Copy to table fixed
FIXED Caché Monitor application folder name can contain spaces. Please test on linux, i've done a test only Win 7
Version 1.61 (beta) 15.08.2011
Known limitations:
ENH TableViewer working in readonly and foreward only mode to improved performance
FIXED DataInspector - HexView: to many scrollbars, some of them removed
FIXED Viewing blob data in Data Inspector
FIXED NullPointer if server side class creation is disabled
ENH JDBC can be place in many JAR files, this feature is required for Cache 2011
double click on table headers boundry to automatically adjust the column widths to accommodate the longest data will result in fetching ALL data from the database table!
rownumbers are missing
open query analyzer action from task pane opens only at the second click
on some dialogs the text ist wrong/missing
integer values are show with decimal point
Version 1.60 (beta)
Known limitations:
New Docking Framework
Cache Monitor handles simultanius open panels
New SQL Editor
Change default namespace to "SAMPLES" because since Caché 200x using %CACHELIB result in parsing error.
FIXED Insert User\Pwd dialog in some situations fixed
creating server side helper classes is by default disabled and can be enabled at the server config dialog
new postions of Metadata and SQL history panels
FIXED clear cached client data save now the new values
FIXED filtering system objects pay attention to the systems schemas
FIXED canceling query stops wait indication
Support for Windows 7 Look and Feels, e.g. for JXTaskPane
FIXED Data Panel: Max Chars not saved, overide max rows
Some small enhancements in sql profiler
FIXED SQL Profiler shows query plan and sql statements
Open Systemmanagement Portal & Open Cache Documenation by right click on server nodes
FIXED NullPointer by open the systemmanagement portal on disconnected server node
FIXED Column width in SQL History fixed
FIXED SQL Area in SQL History added
FIXED Messages are no longer truncated
Driver can be configured for each registered server
double click on table headers boundry to automatically adjust the column widths to accommodate the longest data will result in fetching ALL data from the database table!
rownumbers are missing
open query analyzer action from task pane opens only at the second click
Version 0.58
Sql script variable substitution supports the definition of complex default values
Sql script variable substitution can be disabled
FIXED Textoutput of query analyzer fixed
FIXED Some more tooltips for toolbar buttons added
Version 0.57
After reconnect in query analyzer, the new pid is updated and displayed in titlebar
Sql script execution with variable substitution supports the definition of default values
Version 0.56
Reformat Code: Upper case keywords
Reconnect button in query analyzer
Sql script execution with variable substitution support
Better statement finder at cursor position
While statement execution on the message panel the executed statement and execution time is listed
Rendering of some datatypes in table improved, e.g. Time
Version 0.55
"Open file" bug in Query Editor fixed
Reformat Code recognize more Cache keywords and can now beautify Caché specific SQL statements with special keywords like %ID
Open SQL Docs using Server from SQL Editor and not the selected Server in Server Navigator tree
Open Caché (Web)Documenation is working with Caché 2009.1
TableView: Read data is executed only the first time the panel is selected
Version 0.54
Link added to Caches SQL docs in Query Analyzer
New Profile features: PTools are now implemented in profile window
Cached Queries are now listed under Performance node
TYPE_FORWARD_ONLY error in data view window fixed
Column control is on each table control enabled
Detail Data View is refreshing after changing cell selection in the same row
Version 0.53
Data Export function is now working in Query Analyzer
Missing class added, so the login dialog is working
after connecting to a server tree node is expanded
Version 0.52
Data Export function added from SQL Workbench/J
‘s are now colored in tables in light grey
some icons added/changed
after disconnect and changing some settings and reconnect now the NEW settings are used
support for cache server version "200X"
error log shows the used driver (version)
Function "remove server group" in server navigator fixed
Version 0.51
General
Global Viewer is now working. Dont't use it on big globals, currently there is no limit!
The Table-Viewer have now more filter functions from the context menu (look at the Data Panel and use right click on table).
Faster startup
Version 0.50
General
This version requires Java 6
Because of using Java 6, Caché Monitor can now start the system default Webbrowser. The first features that uses this are:
The System Management Portal & Caché Documentation can easily started from selected server
In the new designed Class opens the Caché Class Documentation
Caché Monitor 0.50 uses some new Controls-Sets from SwingX, these are now updated to version 0.9. That brings brand new features and better handling and System Look&Feel, nicer login dialog ;), smarter search in some controls e.g. in Tables and much more...
New designed View viewer - Information about views are displayed like the Tables Viewer it does. So you can see data and metadata, also the definition SQL for the view
New designed Class view
Enable the execution plan TreeView, since Version 0.41 i think, only the HTML Version works, sorry
In some situations with old Caché JDBC Driver the Query Analyzer is not open properly. This bug is fixed.
Version 0.41
paintIcon -> catch Nullpointer for mac / Joy 😉 please give it a try
the default user and password is set for the default connection from Caché Monitor to Caché at localhost.
if execution plan parsing fails, the html version is displayed -> see forum message for more details
for backward compatibility is this version compiled with Java 5
what that means? You can run Caché Monitor with Java 5 but also using Java 6
integrated JDBC Driver from Caché 2008.1 (jdk 5)
better support for big sql script files
changed separator from "GO" to ";"
new sql formatter and new sql parser
view editor is no longer editable
runtime/execution information is displayed in ms for each sql on message panel
support for Caché 2008.2
Version 0.40
Query Analyzer
Executing stored procedures with CALL no longe raise exception if the resultset is bigger than 99 rows and the option "block fetch" is used.
Better code complition in some situations Server Navigator / Table Browser
Max Rows and Max Chars can now be configured. Max Rows limit the rows fetched from server. Max Chars limit the size of charfields fetched from server
Version 0.39
This Version is a minor release for better support for Caché 2008.1
and his JDBC Driver. Use Java Runtime Environment 6!! AND Caché JDBC Driver for Java 6 !!
Version 0.38
Query Analyzer
The selected commit mode is now stored in query analyzer.
Version 0.37
Within the processlist terminate processes is now working with Cache 2007.1
Version 0.36
Query Analyzer
Work now with the current driver for Version 2007.1 AND with the Version for 2008.1
Version 0.35
Query Analyzer
Server Info box shows now the driver version and also the compile time of the driver
Maxresult and Autocomplete state is now saved, so this information is restored after restart
Work now with Caché Driver Version: 2008.1.0.171 Fri 06/01/2007 0:01:54.22
Version 0.34
0.34 is a minor release for better support for Caché 2007.1
The Processlist (In table browser) is now working with Cache 2007.1
Constraints Register can now be selected
Version 0.33
0.33 is a minor release for better support for Caché 2007.1
General
Query Analyzer
The Home Folder from Cache Monitor can be configured by passing the variable "homepath" for example homepath "c:\myfolder" In this folder Caché Monitor save the confguration- and sql history file
Native Windows Executeable is bundled with the latest 2007.1 JDBC Driver
Some enhancements for the detail Table Viewer.
The Cache Index Type is now listed at a new Page called ‘Caché Indexes'. Possibale values in column TYPE are: "" for normal, unique for ..., and BITMAP
More Caché specific keywords added
The SQL Source from cached queries can be loaded from a Cache 2007.1 server
If an error occur while parsing execution plan information, the xml source will be displayed as raw text
Version 0.32
General
Query Analyzer
Main Toolbar removed to get more space
Main Page context actions added eg: Connect\disconnect
Open Query Analyzer on last server\namespace show now last server\namespace
Query metadata can displayed by context menu on result table
Column width can by optimized by context menu
Column width is optimized for each query
Version 0.31
General
In table browsers context menu quick filter function added
Date/Time/Timestamp are now editable
Many many memory leaks removed (improve performance)
Sub nodes created at first expand (improve performance)
Version 0.30
General
Server Navigator
SQL Scanner
Query Analyzer
add/change table and column description
In Comboboxes with Namespaces the _default_ namespace from the current server is selected
Edit Server data refresh the node in tree
The datatable in table browser is now editable
Data from type LONGVARCHAR is visible over context menu "Show columns details"
Nodes in tree now repainted while scanning, so the nodetext is full visible
Update count is listed if result to grid is selected
Version 0.29
General
Query Analyzer
first version for "CREATE TRIGGER" function added
CachedQuery Details are now scrollable
Tip of the Day dialog
copy server now don't copy the cached namespaces
Query Analyzer request focus if tabbed register selection changed
Execute "next" SQL with F7
Version 0.28
more datatypes colored
change dialog now save file really if user select "SAVE"!
login timeout can set at server config
parsed query no longer uppercase formatted
if result is text: the message tabs no longer selected if an error occur
context menu works also on first data row in Tabledetails-Tab
Version 0.27
Server Navigator
Query Analyzer:
General
Since 0.26 you can view tabledata from selected table in Server Navigator. Now can you also filter the data by enter a WHERE clause or using the contextmenu to generate WHERE from selected cells.
Better Query-Canceling
The filename from saved or opened file is showing in titlebar
If an open file changed, Caché Monitor ask before closing
After sorting table the internal and visible selecion was not in sync, so it happend that you select one row but the program works internaly with another
Block fetching Tabledata don't block repaint
"DatabaseMetadata.getSuperTables(currentCatlog, schema, tableName)" blocks with 5.1, -> disabled
Frame and Splitter positions are now saved and restored
Version 0.26
Query Analyzer:
Sql history entrys always expanded
Keywords are sorted in autocomplete box
Result table can be sorted
Multi resultsets if more than one sql statement is executed
Sql history is now sorted descenting and expanded
Table details with tabledata in server navigator
CTRL-F working in table to search for data
server info shows more information about protcol version
server info now works with cache 5.1
Version 0.25
Query Analyzer:
Error: [SQLCODE: <0>:]
[Details: ]
[%msg: ]
Error: [SQLCODE: <-370>:]
[Cache Error: <errdone+1^%qaqqt>]
[Details: ]
Server Navigator
"SELECT * FROM" on table with many columns results in an error like: Error: Invalid Message Count (452); expected: 38 got: 942946098. Connection closed (Client Driver Version: 5.0.5504.0) Size: 679Kb Error: Communication link failure: Socket closed (Client Driver Version: 5.0.5902.0) Size: 977Kb Error: Communication link failure: Socket closed (Client Driver Version: 5.1.0.826) Size: 1,466Kb The exact message depends on the version of your jdbc driver!
CALL on Stored Procedures result in errors like (Client Driver Version: 5.1.0.826) Size: 1,466Kb [%msg: < SQL ERROR #370: SQL CALL Statement cannot be used for Query Procedure ‘SQLUSER.xxxx'>] (Client Driver Version: 5.0.5504.0) Size: 679Kb The exact message depends on the versiuon of your jdbc driver!
block fetching is always disabled if result is txt, and can be anabled/disabled if result is table
the selection in table is now free, so you can select cell,row and so on
with context menu on server node the refresh namespace/schema action can be triggerd
Version 0.24
Query Analyzer:
SQL Scanner
General
Foreign Key JOIN suggestions. After typing the keyword ON Caché Monitor it will display a JOIN suggestion
The keyword CALL shows Stored Procedures in an autocomplete box
More autocomplete for sql keywors, functions, etc.
Result to grid is now working 😉
Result to grid fetches blocks with blocksize of 100 only, after scrolling at the end the next block will be fetched -> FAST!
Selecting a piece of text in the Script Editor will execute that piece only
PK Columns are marked with red icon in autocomplete dialog
DROP INDEX can be executed on selected index from SQL Scanner(Redundant Index finder)
CREATE INDEX can be executed on selected index from SQL Scanner(Cached Queries Scanner)
SQL Scanner / Cached Queries Scanner is no more case sensitive
Login dialog box will popup if User or Password is missing in server configuration
Caché Monitor is running on Java 6.0
x button on the "select server/namespace" dialog has the same behavior like the cancel button
namespaces are now cached for each server, the connect to database with in the query analyzer is now faster
schemas are now cached for each server/namespace, the connect to database within the query analyzer is now faster
An Error dialog box displays the error message if something has happend
Version 0.23
Server Navigator
Query Analyzer:
Editing Find CTRL+F
MetaBrowser
SQL Scanner
Server Groups and Servers can now be rearrangde with drag and drop
more autocompletion (SQL-Schemas are now listed)
You can toggle with F8 between MetaBrowser and QueryWindow
current line with cursor position is highlighted
the autocomplete popup can be enabled/disabled with a double click on the statusbar
Some general infos about editor: You can also highlight a block of code and press TAB to indent it all. SHIFT-TAB will move it all back. Bookmarks Insert or remove a bookmark CTRL+F2 Bookmarks Move to next bookmark F2 Bookmarks Move to previous bookmark SHIFT+F2 Editing Go to a line number CTRL+G Editing Increase indent TAB
F8 will toggle between MetaBrowser and QueryWindow
SQL Scanner will check or redundant indexes now
Version 0.22
Query Analyzer:
MetaBrowser
General
much better autocomplete (again 🙂
autocomplete column list will mark the primary key column
better query execution performance
file save/open dialog uses last path
tooltip on query analyzer shows current namespace
the title format on each Query Analyzer tab is changed to: @
selected query analyzer shows information about selected namespace and pid in titlebar
cancel button now works
if autocommit is disabled, commit/rollback actions can be executed from toolbar
shows tables/views etc. in all schemas
tables are asc sorted
An message occured if the CacheDB.jar (the Cache JDBC Driver) can not be found
faster startup
Version 0.21
Query Analyzer:
SQL Scanner
General
Bug in sql history fixed: first sql execution will run very long
"Copy QueryAnalyzer with CTRL+N" copies now also the retrieved database metadata to boost 😉 performance
Some bugs fixed
Used Caché Client Driver Version is now listed in Server Info box
Version 0.20
Query Analyzer:
SQL Scanner (NEW)
ClassCastException on Linux in MetaDataBrowser fixed
AutoCommit can enabled/disabled from Toolbar
Show execution plan works now for selected SQL (it wille be enough to position the cursor in a row)
"Result in new tab" function added
The Transaction Isolation Level can be changed from Toolbar
SQL Scanner checks FK-Constraints for supporting index
SQL Scanner checks cached queries for supporting indexes on JOINs
Version 0.19
Server Navigator
Query Analyzer
SQL History
"Server info" is changed now only if another ServerNode (or sub node) is selected
Change of intelli-schema refresh metabrowser
More keywords are highlighted (ADD NEW and so on)
Find/Replace dialog fixed
Executed SQLs are now listed in treeview within the SQL in a table or a column, so it wille be easier to find the right SQL statement
The "Copy content" behavier can be configured: "Replace", "Copy at cursor pos" and "Copy at end" Please consider, in this version the Caché Driver is NOT included!
You have to put the driver (CacheDB.jar) next to the Caché Monitor -
programmfile (CacheMonitor.jar) -
That will be enough, you don't need to add the CacheDB.jar to the -
classpath -
start Caché Monitor by doubleclicking the jar file, -
or type this at your console window: "javaw -jar CacheMonitor.jar" -
Version 0.18
Server Navigator
Query Analyzer
New MetaBrowser:
Tablelist shows column selectivity
Server & Servergroups can be removed 😉 (thanks ian!)
better autocompletion 😉
last "max Result"-Value was saved
change isolation level from toolbar
with CTRL+I you can navigate to tablemetadata in the metabrowser for table(name) under cursor position
navigate with hyperlink (CTRL+LEFT_MOUSE) to tablemetadata in metabrowser
execute SQL _around_ cursor position
execute SQL with CTRL+ENTER
SHIFT+ENTER insert statement seperator (GO) New SQL History: (not compatible with older version sorry!)
SQL History now grouped by date
Statement was shown in Query Analyzer Editor with syntax highlighting
first version for metabrowser
Version 0.17
Query Analyzer:
better autocompletion
completion "auto popup" can be switched on/off
multi selection in tables activated to copy more than one row to clipboard (CTRL+C)
shows Cache Locktable
CMUtilities.xml is no longer needed! If Caché Monitor need special Serverside functions, it will be generated this on the fly.
Query Analyzer preselects the last used schema at startup
For "DROP INDEX" the Code Completion shows all existing indexes
Query Analyzer: SQL History
Query Analyzer: Current Namespace in Statusbar
PopUp-Menue in Server Navigator Tree works on Linux now
Format SQL in Query Analyzer
Look and Feel can be changed
Version 0.14
Better Code Completion
SQL abbreviation, Type: se for "SELECT * FROM "
Version 0.13
Show routine source fixed
some minor fixes
Version 0.12
Terminate Process
Show Processinfos
Show routine source fixed
Reload processlist
User can select Transaction-Isolationlevel
User can turn AutoCommit On/Off
Version 0.11
Connectionhandling fixed
Frequently asked questions
What was the last Caché Monitor version?
Caché Monitor 2.96, released on 7 April 2020. It added the InterSystems IRIS 2020.1 driver and IRIS support in Query Cloud.
Which version introduced InterSystems IRIS support?
Version 2.90 (December 2018) added the IRIS JDBC driver. Version 2.93 (August 2019) brought native IRIS support with Global Browser and the other Caché-specific features.
Where are the release notes for newer versions?
On the SQL DATA LENS what's new page.
Continue with SQL DATA LENS
SQL DATA LENS is the current release of this tool: native InterSystems IRIS and Caché support, SQL editor, Global Browser, database diagrams, Query Cloud and much more. Free Edition and a full 30-day Pro trial with every download, no registration.