BroadSQL 4.3 - Release Notes

What's new with BroadSQL 4.3?

• 4.3 is a stabilization release. Many errors have been corrected. The code has also been extensively revised in order to be more coherent.

• INI file / Parameters
  • Decommissioned following INI parameters
    • ServersFileType => must be H2 in all cases, no other platform supported
    • prompt.text => default is always "BroadSQL>"
    • DefaultFolder vs TemporaryFolder => TemporaryFolder deleted
    • SqlLib: can be relative or absolute (default: relative, "sqllib")
  • Core
    • Linux/Windows
      • In code, replaced all occurences of \\ by SpringPropertiesConfig.getFileSep()
  • Commands
    • ADD CONNECTION: create new connections from command line (alternative to CONFIG;)
    • CNT: new command
    • CONFIG: error message if executed from Linux
    • DEL CONNECTION: delete existing connections from command line (alternative to CONFIG;)
    • DESCR: several corrections
    • EDIT CONNECTION: edit existing database connection from command line (alternative to CONFIG;)
    • HARDDEL (hidden): delete existing connections from command line (alternative to CONFIG;)
    • HELP:
      • If entered command is unknown, send the help request to the database (H2 only)
    • DIRECT LOAD/UPDATE: Are extended commands * Renamed LOAD and BATCHLOAD  (create/update) => LOAD <actionName> <tableName> <fileName>
    • EXPORT: * Corrected: for XLS and XLSX files truncation of records after 32767 caracters. error when size of field > 32767 characters. WARN c.p.c.BroadSQL:277 - The maximum length of cell contents (text) is 32,767 characters
    • PING/CHECK: minor corrections
    • SET LIST ON: Problem correction: was not working any more since 4.2
    • SET SCHEMA: (new) changes current schema
    • SHOW ALL CONNECTIONS
      • New synonymys: sh al co, shalco
      • Corrections: Synomym SH ALL CO does not work for example => sh all co PostgreSQL;
    • SHOW COLUMNS:
      • Correction: some problems existed with version 4.3
    • SHOW INSTANCES: New command: lists all instances of the current database connection (if no connection ID provided) or of the provided connection ID * Possibility to filter by instance ID
    • SHOW SCHEMAS: minor corrections
    • SHOW TABLES: minor corrections
    • SHOW VIEWS: minor corrections
      • Documented: * Problem corrected: at login, Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

Upgrading from previous releases

1. Replace BroadSQL.bat, connect.bat, connect.ps1, broadsqlux.ini, broadsql.sh with most recent versions

2. Replace BroadSQL.jar and all files in lib with most recent version

Known issues