BroadSQL 4.1 - Release Notes

What's new with BroadSQL 4.1?

Core

Oracle db drivers (jar files) are either longer part of the core package nor shipped in the /drivers folder. Oracle is now being considered as a regular JDBC database. Before 4.1, specific code was written.

Autocommit

Reviewed implementation of uncommitted detection : DDL queries are not eligible to rollback except for some databases (SQLite)

Check uncommitted for Oracle databases is based on "select dbms_transaction.step_id from dual;"

No more API for converting SQL rows to documents (NoSQL). Future API will be based on JSON instead.

Config (Swing)

Several bugs correction for the commands "Test connection", "Duplicate connection" and "Delete connection"

List of database connections refreshed after a change in the config screen. No need to restart BroadSQL.

Commands

New shortcuts for commands having long names. For example: SH CO is a shortcut for SHOW CONNECTION. See help for more details.

New commands:

RELOAD VAULT for reloading the CDF without restarting BroadSQL (this command is not visible in the HELP screen)

PING / TEST for testing a connection

HELP command revisited

SET PASSWORD: is now limited to the following types: Oracle, MySQL, H2, HSQLDB and PostgreSQL. This command changes the password in the CDF but also, and most notably, in the database referenced by the connection.

SET MASTER PASSWORD: several bugs corrected. This command is for changing the password of the BroadSQL client. It also changes the password of the AES encrypted H2 database.

EXPORT: correction of a bug when specifying a target directory different than the default. When you type EXPORT MYFILE; the command will create export results in the file MYFILE.XLXS of the default folder. You can specify a different folder by specifying its path: EXPORT /usr/myfile

Extended commands: several bugs correction. Extended commands are those additional commands that one can create and add to a BroadSQL instance. By default, BroadSQL ships with two extended command: edit file in notepad and edit file in notepad++