Softpedia >Windows >Internet >Servers >Database Utils >Caché Monitor Home Edition >  Changelog

Caché Monitor Home Edition Changelog

What's new in Caché Monitor Home Edition 2.96

Jul 8, 2020
  • ENH: Driver added for InterSystems IRIS 2020.1 (JDBC Version: 2020.1.0.215)
  • ENH: QueryCloud supports InterSystems IRIS
  • ENH: QueryCloud show source code of views
  • ENH: TableViewer : JDBC connections show source code of views (e.g. SQL Server)
  • ENH: Server Navigator: JDBC connections show source code of views (e.g. SQL Server)

New in Caché Monitor Home Edition 2.95 (Apr 12, 2020)

  • FIXED: cancel a query refresh the statusbar
  • ENH : code completion improvements
  • FIXED: corrected counted rows and time after canceling a query
  • FIXED: GlobalViewer: minor fixes and improved in displaying unicode and $lb (listblock) elements
  • FIXED: GlobalViewer: Refreshing globals view don’t duplicate values
  • ENH : Driver updated to CsvJdbc – CSV file JDBC driver (csvjdbc-1.0-36.jar) (http://csvjdbc.sourceforge.net/index.html)
  • 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)

New in Caché Monitor Home Edition 2.94 (Jan 5, 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

New in Caché Monitor Home Edition 2.93 (Aug 14, 2019)

  • ENH : Show Stored Procedures for JDBC Connecions
  • ENH : Some refactoring, like removing old startingstopping 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 ServerConnections
  • ENH : DateTime UI improvments, e.g. display format is configurable
  • FIXED: Refresh on Stored Procedure View

New in Caché Monitor Home Edition 2.91 (Jan 8, 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 CsvJdbc – CSV file JDBC driver (csvjdbc-1.0-34)
  • 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 : Positioning of dialog improved

New in Caché Monitor Home Edition 2.90 (Dec 10, 2018)

  • FIXED: MAX CHARS doesnt work in Query editor
  • FIXED: TableViewer : Source tab (DDL) Editor fixed
  • ENH : TableViewer : Source tab (DDL) performance improved
  • ENH : DB Driver : IRIS Intersystems JDBc Driver added

New in Caché Monitor Home Edition 2.85 (Aug 1, 2017)

  • ENH : Improved ServerConnection 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 catalogsschemas. 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

New in Caché Monitor Home Edition 2.83 (Apr 21, 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 ServerConnection dialog

New in Caché Monitor Home Edition 2.82 (Jan 18, 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.

New in Caché Monitor Home Edition 2.81 (Jan 10, 2017)

  • New Highlights from this and the last release:
  • Server Navigator: Selection concept has 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.
  • 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.
  • Calculate size for allselected tables

New in Caché Monitor Home Edition 2.80 (Jun 25, 2016)

  • 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.
  • Renamed and refactored context menu, some functions grouped within menu “Tasks”:
  • 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

New in Caché Monitor Home Edition 2.79 (Mar 31, 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

New in Caché Monitor Home Edition 2.78 (Mar 24, 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”

New in Caché Monitor Home Edition 2.77 (Mar 23, 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

New in Caché Monitor Home Edition 2.76 (Mar 20, 2016)

  • 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

New in Caché Monitor Home Edition 2.76 Beta (Jan 26, 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 : "Close" on a server node execute the same action like "Disconnect"
  • ENH : "Refresh" on a table node improved, local cached metadata will be deleted
  • ENH : H2 Database support included
  • FIXED: some minor fixes
  • ENH : New data node "Security" with User and Role detail lists
  • ENH : 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 : List of SQL Gateway connections

New in Caché Monitor Home Edition 2.75 (Dec 22, 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
  • FIXED: Reading Windows Registry values stabilzed (for Caché connection import, ODBC import)
  • 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
  • ENH : Caché 2016.1 driver added; Caché 2015.3 removed
  • 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.

New in Caché Monitor Home Edition 2.74 (Oct 21, 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: SQL Editor : Code completion performance improved
  • FIXED: TableViewer : Viewing MySQL Data is working
  • 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

New in Caché Monitor Home Edition 2.73 (Jun 22, 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

New in Caché Monitor Home Edition 2.72 (Jun 22, 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.

New in Caché Monitor Home Edition 2.71 (Mar 27, 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

New in Caché Monitor Home Edition 2.70 (Mar 6, 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

New in Caché Monitor Home Edition 2.69 (Feb 23, 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

New in Caché Monitor Home Edition 2.68 (Feb 10, 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

New in Caché Monitor Home Edition 2.62 (Sep 23, 2014)

  • FIXED: No function for Ok\Cancel Buttons on the edit server dialog

New in Caché Monitor Home Edition 2.60 (Aug 18, 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”

New in Caché Monitor Home Edition 2.59 (Jul 24, 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’

New in Caché Monitor Home Edition 2.58 (Jun 23, 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”

New in Caché Monitor Home Edition 2.57 (May 15, 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

New in Caché Monitor Home Edition 2.56 (Apr 16, 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).

New in Caché Monitor Home Edition 2.55 (Apr 7, 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

New in Caché Monitor Home Edition 2.54 (Apr 2, 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

New in Caché Monitor Home Edition 2.53 (Jan 23, 2014)

  • ENH: New Bulk Export Dialog allows to save current- and load previous 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

New in Caché Monitor Home Edition 2.51 (Jan 13, 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”

New in Caché Monitor Home Edition 2.50 (Jan 6, 2014)

  • 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 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.
  • For any database, you can create as many database diagrams as you like; each database table can appear on any number of diagrams.
  • 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?”.
  • 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.
  • 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.
  • 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

New in Caché Monitor Home Edition 2.09 (Nov 7, 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

New in Caché Monitor Home Edition 2.08 (Nov 6, 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

New in Caché Monitor Home Edition 2.07 (Oct 24, 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

New in Caché Monitor Home Edition 2.06 (Oct 9, 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

New in Caché Monitor Home Edition 2.05 (Sep 18, 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

New in Caché Monitor Home Edition 2.04 (Sep 3, 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

New in Caché Monitor Home Edition 2.03 (Aug 20, 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

New in Caché Monitor Home Edition 2.02 (Jul 24, 2013)

  • 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 more 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 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), right click on the selection and choose "Create mapped table". You get asked about the destination namespace, 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!
  • There are some restrictions in this version:
  • DefaultStorage is required for mapped tables
  • The table name has to be unique in the federated namespace
  • FIXED: RoutineList fixed
  • FIXED: Driver selection fixed

New in Caché Monitor Home Edition 2.01 (Jul 24, 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

New in Caché Monitor Home Edition 2.00 (Jul 8, 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.
  • ENH : Based on the decimal digits definition on each columns are the value now formatted

New in Caché Monitor Home Edition 1.67 Beta (Nov 20, 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

New in Caché Monitor Home Edition 1.66 Beta (Nov 20, 2012)

  • Caché Monitor is now running with Java 7

New in Caché Monitor Home Edition 1.64 Beta (Apr 6, 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)

New in Caché Monitor Home Edition 1.63 Beta (Apr 6, 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

New in Caché Monitor Home Edition 1.62 Beta (Apr 6, 2012)

  • 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

New in Caché Monitor Home Edition 1.61 Beta (Aug 17, 2011)

  • 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

New in Caché Monitor Home Edition 0.55 (Oct 6, 2009)

  • "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 Cache 2009.1
  • TableView: Read data is executed only the first time the panel is selected.

New in Caché Monitor Home Edition 0.29 (Oct 6, 2009)

  • General
  • 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
  • Query Analyzer request focus if tabbed register selection changed
  • Execute "next" SQL with F7