Development of Mediator version

Version 5.2.4.0 (February 20th, 2017)

The following features/bug fixes have been introduced:

• test support for MS SQL 2016
• minor enhacements and fixes

Version 5.2.3.0 (March 9th, 2015)

The following features/bug fixes have been introduced:

• new functions: MedTbUsers(), MedMrkSQL(), MedMrkOrd(), MedMrkActv()
• PostgreSQL Native - fix for reading binary memo fields
• Mediator for MS SQL Server - introducing the possibility to fill organisational table columns (RECNO, IE$x) with RDBMS triggers
• introducing the possibility to define the temporary table order with usage of mark tables (MedMrkActv() and related functions)
• test support for MS SQL 2014
• minor enhacements and fixes

Version 5.2.0.0 (March 14th, 2014)

The following features/bug fixes have been introduced:

• test support for Oracle 12c
• new functions: MedIdxOpt, MedC1AsLog
• support for Harbour 3.2.0 (ChangeLog 2014-01-03): Build 3201
• support for xHarbour 1.2.2 (ChangeLog 9719 2012-09-29) Build 1220
• libraries for Visual Studio 2010+ (Harbour 3.2.0, xHarbour 1.2.2)
• 64-bit libraries for Harbour 3.2.0
• minor enhacements and fixes

Version 5.1.1.2 (April 17th, 2013)

The following features/bug fixes have been introduced:

• new functions: MedSvMaint, MedExOpInf, MedDelMode, MedClTrace
• saving locks to a file through MMT
• possibility to trace Mediator server
• fixes for LOB support (MS SQL Server)
• minor enhacements and fixes

Version 5.0.4.0 (April 19th, 2012)

The following features/bug fixes have been introduced:

• new functions: MedKillSes, MedGetSLst, MedGetSNum, MedTabTemp, MedStTbsp, MedGetLAll, MedConNetA, MedConSock, MedConCS
• possiblity to implement columns for expression indexes as Oracle virtual columns (MedIdxSQL)
• test support for Harbour 3.0/MinGW
• test support for MS SQL 2012
• adapting some 32-bit client functions for using in multithreaded applications
• Mediator server - introducing the server processes monitoring for better diagnostics
• minor enhacements and fixes

Version 5.0.3.1 (August 29th, 2011)

The following features/bug fixes have been introduced:

• support for Harbour 3.0
• support for xHarbour 1.2.1 Rev. 9382 (SVN snapshot dated 18.07.2011)

Version 5.0.3.0 (March 23th, 2011)

The following features/bug fixes have been introduced:

• UNICODE databases support for xHarbour and Harbour applications
  - new MedLogin() function parameter specifies if the character data should travel from/to application as UNICODE
  - ability to work on UNICODE database from applications using different codepages - multilingual applications working on common database
  - automatic character data conversion from application codepage to database (UNICODE) codepage
  - MedSetDefColEnc() function defines the default database type (encoding format) for character values
  - extended MedColAdd() function allows definition of the encoding method to be used in added character columns
  - new or modified MedSqlParA(), MedSqlParEx(), MedSetSqlEnc() functions allow the precise control over the encoding method used for SQL queries and their parameters


• communication protocol has been rewritten to support messages longer than 64 KB which removes many limitations present in the previous versions:
  - communication buffer has been extended from 64 KB to 512 KB, which allows faster communication and sending to application more records in one message
  - maximum record size has been extended from 64 KB to 512 KB
  - maximum character column size has been extended to 64 KB (subject to database limitations)
  - maximum size of parameters defined with MedSqlPar/A/Ex functions has been extended from 32 KB to 256 KB
  - maximum SQL query text has been extended from 20 KB to 512 KB (including parameters)
  - new MedClpComp() function can be used to enforce the old limits in xHarbour/Harbour applications - usefull if CA-Clipper applications access the same database


• version of Mediator server for MySQL using the native client access library for Windows and Linux (free ODBC version is still available)


• version of Mediator server for PostgreSQL using the native client access library for Windows and Linux


• additional session monitoring features in mmt.exe program:
  - monitoring of the command being executed
  - monitoring of the previously executed command
  - monitoring of the session memory usage


• option for Mediator for Oracle server which allows permanent table deletion

Version 4.3.3.1 (October 10th, 2010)

The following features/bug fixes have been introduced:

• New MedPrepStmt(), MedExecStmt(), MedFreeStmt() functions allow executing prepared SQL statements


• New MedNoGoTop() function allows optimization by eliminating the unnecessary GO TOP statements


• New MedLobNew(), MedLobClse(), MedLobDel(), MedLobOpen(), MedLobRead(), MedLobWrt(), MedLobNull(), MedLobErr() - experimental support for handling variable-length large fields (BLOB/CLOB) for Oracle and MS SQL


• MS SQL - new option that allows switching of filtering the DELETED records from database server to Mediator server. This can be used as a workaround in rare cases when MS SQL optimizer chooses incorrect execution plan for Mediator queries. This can happen on tables on which external SQL statements are executed. The statistics collected when executing external SQLs can direct optimizer to choose very inefficent plan, which results in a large slow-down of executed Mediator queries.


• MMT - added information about the last command executed within a session


• xbAPI/xhbcom.dll - the list of accepted method parameters extended to suport VARIANT containing VARIANT. Sample value passed in this way is a date value passed from PHP script


• xbAPI/Delphi - introduced UNICODE support on the Delphi application level, support for Delphi2009


• xbAPI - fixed small memory leak related to allocated table aliases


• PostgreSQL fix - creating tables and deleting indexes in non-default schemas


• recommended sample linking scripts changed to use multithreaded libraries for VC and Borland. Important, because of possible problems resulting from using non-serialized heap in multithreaded application: hang-ups, GPFs, etc. Application containing Mediator libraries is always multithreaded because of the automatically started auxiliary thread.


• other minor fixes

Version 4.3.2.0 (February 26th, 2010)

The following features/bug fixes have been introduced:

• Mediator client libraries for Harbour 2.0 for Windows and Linux


• Mediator client libraries for xHarbour 1.2.1.1 (xHarbour 1.2.1 Rev. 6686, CVS snapshot dated 15.02.2010)


• Fix which allows proper functioning of the TbrowseDB() object with the default skip block (skipblock)


• DbInfo(DBI_ISREADONLY) implementation


• DbRecordInfo(DBRI_DBASELOCK) implementation


• Fix of the handling of the error possibly reported by the database during record update


• DbRename() function implementation


• Fix of the DbExists() and DbDrop() functions related to the returned values

4.3.1.1 version (October 5th, 2009)

The following features/bug fixes have been introduced:

• Mediator client libraries for Harbour 1.0.1


• Fix in MedSetOFil() function eliminates the possible GPF when setting a long filter


• Extentions of the xbAPI interface (Delphi/COM/C++). Among others, include new HbConnection.SetValidWorkareas() and HbConnection.CloseAllWorkareas() methods


• Other minor bugfixes

4.3.0.0 version (April 21st, 2009)

The following features/bug fixes have been introduced:

• Mediator client libraries for xHarbour 1.2.1


• Mediator client libraries for Harbour 1.0


• 64-bit version of Mediator server for MS SQL


• MS SQL Server 2008 support


• Mediator client libraries for MSVC 2005 (MSC 8.0)


• Substantial performance enhancements of Mediator server for Oracle using OCI9 interface in statistics-based optimization environment (Oracle 9/10/11)


• Many new functions added for xbAPI interface (Delphi,COM,C++)


• medhbudf.dll xbAPI sample extended so that it can use Mediator client libraries


• New MedIdxLmt() function allows changing of the maximum allowed number of indexes active within the workarea


• Fix in Delphi TMedQuery object allows executing SQL queries with parameters on Oracle server


• New TrimStingFields property in TMedConnection Delphi object allows automatic trimming of the trailing spaces from values read from text fields


• Fix in Delphi components - now it is possible to assign Null value to table field. Also Null (zero) date is handled properly


• Fix in OrdKeyVal() function - selected codepage conversions are now properly applied to the returned value


• Fix in codepage conversions of the values read and written from/to MEMO fields. For Clipper 5.3, Harbour and xHarbour conversion was not done, so the improper characters where seen from external SQL tools when accesssing Mediator MEMO data. The fix leaves the tables created with previous Mediator versions without MEMO conversions, while on the tables created with version 4.3.0.0 and later codepage conversions work as expected


• New MedSqlPTrm() function allows turning on the automatic trimming of the trailing spaces from SQL query parameters


• Other small fixes

4.2.6.0 version (December 17th, 2007)

The following features/bug fixes have been introduced:

• Libraries for use with xHarbour 1.0.0 Beta


• Mediator server for Oracle 11


• Enhancements of Mediator server for Oracle 10 and 11 eliminating problem of possible Mediator slow-down after accessing of Mediator tables from other SQL tools. For this changes to work, the Mediator tables must be re-created or modified using appropriate SQL script.


• Client libraries for Harbour 0.991 (Beta1) and 0.992 (Beta2)


• Functions returning information about the reason of failed locks: MedFlckInf(), MedRlckInf()


• Functions for storing and accessing the custom session-related info: MedSetInfo(), MedGetInfo()


• Extentions of mmt.exe enabling access to the information stored using MedSetInfo() function


• Various information functions: MedMedVPth(), MedCltVPth(), MedSrv64(), MedSrvOCI8(), MedMedId(), MedDate(), MedTime()


• Function which allows setting the speed limit of the client operation (can be usefull during heavy-load operations such as generating reports): MedOpSpeed()


• Functions changing the application exit/cleanup mode: MedExitFun(), MedStop2()


• A lot of new functions in xbAPI (Delphi,COM,C++) interface


• Fix in MedSelVal() function (reading the SQL_VARIANT field)


• Fix in MedLobOpen() function


• Delphi: fix allowing the proper storage of integer values larger then 2^31 passed as Int64 and fix in memory management


• Fix of the datetime field handling on the servers accessed via ODBC

4.2.4.1 version (January 18th, 2007)

The following features/bug fixes have been introduced:

• Libraries for use with xHarbour 0.99.7 (Beta-1.7)


• 64-bit version of Mediator server for Oracle for Windows and Linux


• New MMT (Mediator Management Tool) features: enhanced user authentication, introducing roles for differentiating operator privileges, added 'kill session' functionality


• Removing configuration GUI interface from Mediator server - now all configuration is made via MMT


• Removing 64KB size limitation of medpwd40.cfg configuration file


• Installations using LockManager: fixed error which could lead to deadlock in case of simultaneous record inserts to the same 'perforated' table via different Mediator servers


• Fixed handling of empty date in some commands (for ex. SEEK)


• xbAPI interface (Delphi,COM,C++): added Bin2L, Bin2I, Bin2W, L2Bin, I2Bin methods


• Fixed error with inserting strings containing only spaces via MedSqlPar/MedSqlParA followed by MedExecSQL


• Fixes and extentions to server logs

4.2.3.3 version (March 10th, 2006)

The following features/bug fixes have been introduced:

• Libraries for use with xHarbour 0.99.6 (Beta-1.6)


• MS SQL 2005 support - including schemas and some SQL changes


• For Oracle and MS SQL - the possibility of storing MEMO fields in the base table in BLOB/CLOB columns (Oracle OCI9) or text/image columns (MS SQL Server)


• New classes for accessing Mediator server and DBF files from C++. The interface can be used from Windows and Linux applications


• Oracle OCI9: introduced support for stored procedures and functions returning cursors - USE AS FUN i USE AS PROC on xBase level, DbUseSqlProcAre() and DbUseSqlFunArea() on Delphi/COM/C++ interface level, property OpenMode in TMedQuery Delphi component


• possibility of diffrentiating objecs with usage of database identifier (Oracle) or different ODBC datasource names (for other servers) - option "Use database ID (CS)". Enables safe usage of the same-named objects stored in different database servers


• mmt - extending the roles and priviledges for remote Mediator configuration


• mmt - fixes related to displaying and sorting lists


• MedColDel() - function for deleting table columns


• MedDelNow() - function for immediate complete deletion of the table record


• MedSelVal() - fix - now text values are properly converted according to active code pages


• MedKeyNo(), MedKeyCnt(), MedKeyNoCa(), MedKeyCtCa() - new functions for work with logical record numbers


• xHarbour/Harbour - fix- VALTYPE function now properly works with MEMO fields


• Delphi/VCL components - fixes related to stability on objects and connection closing


• Delphi/VCL components - fix allowing for execution of non-scrollable queries in TMedQuery component


• Delphi/COM/C++ interfaces - fix allowing for opening tables from different databases (after calling MedDbIgn(false))

4.2.2.5a version (July 13th, 2005)

The following features/bug fixes have been introduced:

• Linux and Solaris servers only - fixed bug introduced in version 4.2.2.5. Mediator server process caused unusually high CPU load when idle

4.2.2.5 version (June 10th, 2005)

The following features/bug fixes have been introduced:

• New COM object interface for Mediator. Using this feature it is easy to access Mediator from any Windows COM-enabled environment. COM interface work with all standard xHarbour and Mediator RDD drivers. The same application can be used to run either on DBF files or on SQL database via Mediator server!


• version of Mediator client libraries for xHarbour 0.99.5


• implemented new xHarbour DBOI_SCOPESET and DBOI_SCOPECLEAR DbOrderInfo() functions


• corrected formatting of the table-based numeric values with fractional part in xHarbour/Harbour


• xHarbour 0.99.4 and later: fixed problem with integer values which does not fit in 32 bits


• new MedLgMsg() function for more flexible connection error handling


• MedGetLLst() and DbRlockList() enhanced to return table locks in chronological order. Now they are 100% Clipper compatible.


• enhanced performance of the Mediator server for MySQL


• lenght of MEMO fields is now reported as 10 for better Clipper/xHarbour compatibility


• fixed xHarbour/Harbour problem with "Symbol not found" error when indirectly commiting workarea changes via relational move


• enhanced reporting of the database connection errors


• fixed several bugs in Mediator remote management tool (mmt)


• several other minor bug fixes

4.2.2.0 version (April 5th, 2005)

The following features/bug fixes have been introduced:

• Delphi client now includes new VCL components for easy integration with Delphi data-aware controls. Components work with all standard xHarbour and Mediator RDD drivers. The same Delphi application can be used to run either on DBF files or on SQL database via Mediator server! There is no better way to migrate your Clipper/xHarbour or Delphi application from DBF to SQL


• introduced profiling support in Mediator server. Now it is possible to profile the operations sent by application to Mediator server. You can profile either global server operation using server-side controls or single session using new functions: MedStStart(), MedStReset() and MedStStop(). Basic command line utility mkstat.exe is available for profiling data analysis. Now you can analyze and optimize every business-level function of your application!


• OCI9 version of Mediator server for Oracle is now optimized for much better work with Oracle 10


• version of Mediator client libraries for xHarbour 0.99.4


• new MedIdxSQL() function allowing faster expression index creation by specifying SQL expression to be used for initial populating of index key values


• functions operating on logical record numbers enhanced for better compatibility with Clipper/xHarbour. See documentation of MedKeyGoTo() for details


• column names used in SQL queries are now internally truncated to 10 characters by xHarbour client for better Clipper compatibility

4.2.1.0 version (January 10th, 2005)

The following features/bug fixes have been introduced:

• new version of Mediator server for Oracle. Database access layer has been completely rewritten from OCI7 API to OCI8/9/10 API. This has signifficantly enchanced server stability, especially for larger number of connections (above 100)


• xHarbour 0.99.3 libraries


• new OraIdxDBMS() and OraRcnDBMS() functions (OCI8/9/10 only) facilitate integration of CA-Clipper/xHarbour applications with other Oracle SQL applications


• new MedChgPwd() function allows changing of Mediator user password from application level


• new MedSQLParA() function used to specify SQL statements parameters as array of values


• structure of Windows and SUN Mediator configuration files has been unified for easier interchange


• Lock Manager module version working with Mediator for SUN


• enchanced user interface in remote administration module (mmt.exe) - column sorts are now available for administration views


• fixed OrdSetFocus() for xHarbour - now returns the name of the previous order


• Mediator 16-bit client libraries fix - eliminated the possibility of random connection lost when transmitting very large packets over network


• fix for omvsx.vxd driver - eliminated possible disconnections

4.1.1.1 version (July 5th, 2004)

The following features/bug fixes have been introduced:

• new xbAPI interface allowing access to Mediator and DBF files from Borland Delphi applications


• DBORDERINFO() implementation extended to support DBOI_KEYNORAW and DBOI_KEYCOUNTRAW functions


• new MedKeyGoto() function for positioning in logical order (usefull for browsers using scrollbars)


• DGROUP usage reduced from 3.5 KB to 1.5 KB in Clipper client libraries


• additionally, in xHarbour/Harbour client:


• client library version for xHarbour 0.99


• relations support


• support for scopes. Now scopes can be set using either Mediator MedSetScpe() function or standard OrdScope() function.


• DBORDERINFO() extended to support DBOI_SCOPETOP, DBOI_SCOPETOPCLEAR, DBOI_SCOPEBOTTOM and DBOI_SCOPEBOTTOMCLEAR functions


• client filters support


• implementation of DBRLOCKLIST() function


• implementation of ORDKEYGOTO() function


• fix of VALTYPE() function to properly recognize values of MEMO type

4.1.0.2 version (March 16th, 2004)

The following features/bug fixes have been introduced:

• fixed bug introduced in client version 4.0.4.2 for Clipper 5.3b. Relations used in Clipper 5.3b programs might have behave incorrectly

4.1.0.1 version (March 12th, 2004)

The following features/bug fixes have been introduced:

• new version of Mediator xHarbour/Harbour libraries compatible with official xHarbour/Harbour distributions available from www.xharbour.org and www.harbour-project.org. No more need for proprietary compiler versions compiled with /MT (-tWM) switch


• new version of Mediator xHarbour libraries compatible with xHarbour distribution available from xHarbour.com Inc. (www.xharbour.com). Libraries are located in ...\XCC subdirectory

4.1.0.0 version (March 5th, 2004)

The following features/bug fixes have been introduced:

• Linux version of Mediator client libraries - now your xHarbour/Harbour Mediator application can run under Linux!


• a version of Mediator server for MySQL 4.0+ database - both Linux and Windows version of Mediator is available


• enchanced xBase-level SQL interface - introduced parameter passing method for SQL queries send by MedExecSQL(), MedSelVal() and USE q AS SELECT. See MedSQLPar() for details


• enchanced connection parameters identification - new configuration file where you can define one or many connections to be used by application when connecting to Mediator server. See MedPdbxxx() functions


• introduced schema support for PostgreSQL database


• implemented DBORDERINFO(DBOI_KEYVAL)


• several minor enchancements and bug fixes

4.0.2.0 version

The following features/bug fixes have been introduced:

• automatic quoting ("") of keywords of SQL server which appear as the names of columns in DBF tables. While working with Oracle, MS SQL, SyBase and PostgreSQL, the names of columns being in a conflict with the reserved database words (e.g. select) are automatically taken in apostrophes (e.g. "select"), which helps to avoid errors occurring during a migration of tables containing such columns. Now the migration to SQL is even easier!

4.0.1.0 version

The following features/bug fixes have been introduced:

• a version of Mediator server for PostgreSQL for Linux


• 32-bit client for Harbour and xHarbour for Windows


• a dedicated ADO/OLEDB driver for Mediator


• a tool enabling a full remote configuration and monitoring of Mediator servers (mmt.exe)


• Lock Manager - software, which enables a synchronized work of many Mediators, giving practically unlimited scalability of installations


• Windows based authorization of Mediator users


• an ability to encrypt network transmission between an application and Mediator server


• encryption of Mediator configuration file


• a global application password - a password configured in Mediator server which enables limiting the access to the server only for the authorized applications