|
 Changelog and Release notes for Caché Monitor
- 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
- 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
- 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
- "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
- 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
- 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
- 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
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
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.
- 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
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
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 !!
Query Analyzer
- The selected commit mode is now stored in query analyzer.
V 0.37:
- Within the processlist terminate processes is now working with Cache 2007.1
Query Analyzer
- Work now with the current driver for Version 2007.1 AND with the Version for 2008.1
- 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
Query Analyzer
- Work now with Caché Driver Version: 2008.1.0.171 Fri 06/01/2007 0:01:54.22
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
0.33 is a minor release for better support for Caché 2007.1
General
- 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
Query Analyzer
- 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
General
- 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 Analyzer
- 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
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)
General
- add/change table and column description
- In Comboboxes with Namespaces the _default_ namespace from the current server is selected
Server Navigator
- 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"
SQL Scanner
- Nodes in tree now repainted while scanning, so the nodetext is full visible
Query Analyzer
- Update count is listed if result to grid is selected
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
- 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
Server Navigator
- 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.
Query Analyzer:
- Better Query-Canceling
- The filename from saved or opened file is showing in titlebar
- If an open file changed, Caché Monitor ask before closing
General
- 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
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
Query Analyzer:
- "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
Error: [SQLCODE: <0>:]
[Details: ]
[%msg: ]
(Client Driver Version: 5.1.0.826) Size: 1,466Kb
Error: [SQLCODE: <-370>:]
[Cache Error: <errdone+1^%qaqqt>]
[Details: ]
[%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
Server Navigator
- with context menu on server node the refresh namespace/schema action can be triggerd
Query Analyzer:
- 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
SQL Scanner
- 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
General
- 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
Server Navigator
- Server Groups and Servers can now be rearrangde with drag and drop
Query Analyzer:
- 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 Find CTRL+F
Editing Go to a line number CTRL+G
Editing Increase indent TAB
MetaBrowser
- F8 will toggle between MetaBrowser and QueryWindow
SQL Scanner
- SQL Scanner will check or redundant indexes now
Query Analyzer:
- 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
MetaBrowser
- shows tables/views etc. in all schemas
- tables are asc sorted
General
- An message occured if the CacheDB.jar (the Cache JDBC Driver) can not be found
- faster startup
Query Analyzer:
- 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
SQL Scanner
- Some bugs fixed
General
- Used Caché Client Driver Version is now listed in Server Info box
Query Analyzer:
- 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 (NEW)
- SQL Scanner checks FK-Constraints for supporting index
- SQL Scanner checks cached queries for supporting indexes on JOINs
Server Navigator
- "Server info" is changed now only if another ServerNode (or sub node) is selected
Query Analyzer
- Change of intelli-schema refresh metabrowser
- More keywords are highlighted (ADD NEW and so on)
- Find/Replace dialog fixed
SQL History
- 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" -
-----------------------------------------------------------------------
Server Navigator
- Tablelist shows column selectivity
- Server & Servergroups can be removed ;-) (thanks ian!)
Query Analyzer
- 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
New MetaBrowser:
- first version for metabrowser
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.
- SQL History: Bug concering file separator fixed (thanks ralph)
- SQL History: Bug concerning sqlhistory.dat file fixed
(Each SQL execute multiply entrys)
- Better Code Completion
- Open Query Analyzer on last used Namespace/Server
- 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
- Better Code Completion
- SQL abbreviation, Type: se for "SELECT * FROM "
- Show routine source fixed
- some minor fixes
- Terminate Process
- Show Processinfos
- Show routine source fixed
- Reload processlist
- User can select Transaction-Isolationlevel
- User can turn AutoCommit On/Off
- Connectionhandling fixed
|
