Some
documentation on the Dbj latest releases
Dbj was
initially developed around 2002/2003, for JDBC classes testing, without
release features tracking.
Release tracking started from 2004.
You should
try to keep up to date with the Dbj releases
and the Java JRE releases : "A download a day, keeps the bugs away"...
Release 2024.09.16
- Synthetic data manager provides new features for Integer generation :
beside traditional uniform distribution, you can now select a normal
distribution and a log-normal distribution. You can also generate only
unique values - in random order
- Synthetic data manager provides new features for Float generation :
beside traditional uniform distribution, you can now select a normal
distribution and a log-normal distribution.
- Synthetic data manager provides new sets of constants for text generation
: Animals names, Car brands, Countries and Countries iso-codes,
Industries, Materials. A new algorithm also allows to generate over
11'000 distinct random job titles
Release 2024.08.10
- Brand new component : "Synthetic Data Manager" !
- On the "Table tools", you get a new tab which allows to
generate synthetic data for tables, based on metadata, semantics
configuration, or through data profiling
- The new "Synthetic data manager" tool allows to handle similar
data generation, with referential integrity between the tables (still
early dev, work in progress...)
- Integration with CharSep ! Every grid results can be imported with one-click into CharSep for further processing
- Profile dialog on Grid results shows details on the results (distinct values, nb of nulls, format masks, etc..)
- Fixed issue with Transactions isolation setup when not supported by the JDBC driver
- Corrected a defect to access View details
Release 2024.03.02
- Table creation wizard enhancements : you can now create a table by leveraging a file :
- CSV file : table will be created with name of file as name of
table, headers of file as column names, and a profiling of the file
content to discover best fitting datatypes. Any unique, not null column
will be proposed to be included as part of primary key
- PowerBI
model file : full schema will be created based on PowerBI model. Save
your powerBi model as a "pbit" template. If JDBC driver metadata
provides SQL datatypes details, specific datatypes will be used to
define the model, else standard datatypes will be proposed. Primar keys and foreign
keys can be optionally defined, primary keys are assumed based on relationships
described.
- Table creation wizard : you can now directly save the generated SQL script.
- Under the new Tools - Connection information option, details on the driver, database, and connection can be obtained.
- In Schema browser tool and Table Info tool, include Remarks / Definition of tables
- Multi-columns sort on grid results
- New pluggable look and feel packages installed (for Flat dark and
light, Intellij style, darcula style)
- Size estimates for datatypes in Schema tool corrected
- In
grid contextual menu, new option to display a dialog on "Column
details" - showing min and max value, number of non-null values, number
of occurences for min and max values - and
allowing to select rows based on this column content, or to copy column
values in clipboard, or sort on this column
- Case-insensitive duplicates search is possible on all grids
- On grid contextual menu, "distinct values" dialog will show
the total of rows in % that are covered by these values
- On grids,
you can change sort order by clicking again on same header - Ctrl-click
still allows for descending order
- Corrected a defect on schemas comparison - tables and columns remarks/descriptions were systematically flagged as "different"
Release 2022.10.20
- Upgraded Apache commons text to v1.10.0 to remove "Text4Shell"
security vulnerability
- Option to compare differences in result selected rows (in
right-click menu on grid)
- Fuzzy match search support of commons text v1.10.0
Release 2020.02.02
- Loading of resource files (icons) was failing on newest JVMs due
to modularization. This is fixed.
- In any grid menu - the option displaying the number of rows
allows to display these selected rows in a separate dialog
- In any grid menu - user can navigate from selected row to next
selected row
- Cosmetic changes on Find & Search dialogs (better resizing,
additional help tips for Regex...)
- On
Grid "Find" function, new feature to search for duplicate rows based on
"fuzzy logic" / similarity algorithms (Jaro-Winkler, Levenshtein edit
distance, Soundex). Displays an outcome grid exposing all similar rows
- On Search-Replace : replace latine extended characters by
their equivalent in standard Ascii.
- Standard template to export JSON file fixed to match JSON
specifications
Release 2019.11.24
- Control-Wheelmouse on the results grid allows to change 'zoom
level' / font size
- Grid contextual pop-up menu now shows a count of distinct values
for a column (when less than 10'000 values).
- "Select rows" contextual dialog shows by default currently
selected row number
- When displaying distinct values of a column,
double-clicking one value will select related rows in the grid
- In Find in grid - option to select only first occurence of
duplicates, or select only unique values
- Search and Replace on grid allows to left-pad or
right-pad values with a character or set of characters
- Search and Replace on grid allows to copy values from another
column
- Sorting grid does not reset selection anymore
Release 2019.06.29
- Connections management dialog is now a bit more
friendly / robust
- In Grid results, many features on contextual / right-click menu :
- "Select Rows" dialog allows to select
per row number, from beginning to a row - or from a row to the end, or
to 'select evenly distributed nb of rows', or only even rows / odd
rows...
- "Search-replace"
dialog allows to 'obfuscate' data, to select only n left
chars or n right chars, to replace based on 'full cell'
search, to replace by sequence of numerics (1,2,3..), etc..
- Capability to export Grid :
- as an HTML file with export style for HTML and XLS formats
(matching odd and even rows
style). HTML default extension added when no extension is provided in
file name.
- to generate an XML or JSON structure.
Release 2014.04.07
- In Table tool, for data 'import' : allow to import
from clipboard using Alt-click on "import" button
- In Table tool, added a 'Force update statements' on
Table tool
- In Table tool, DBJ now always limit to max 100'000
rows fetched
- In Schema compare tool, comparison is now done on the
list of columns for each index
- In Schema compare tools, DBJ remembers of last opened
location directory
- In Schema compare tools, DBJ now provide option to
check "case-insensitive" objects names
- When executing 'commands' - when "value" token is
used, check on the result grid and cell content only if existing
- On 'Catalog/Schema' button tooltip, display the
current catalog/schema name when rolling-over with mouse
- Added jdbc:sqlite:C:/work/mydatabase.db as an
example for jdbc url definition
- Wording : changed 'indexes' not 'indices' in compare
tool
- Set statement delimiter as case-insensitive
Release
2013.05.26
- Add a new menu to include commands (with shortcuts alt-1 to
alt-9) to integrate at edit point
- Improved preference / storage of 'maximizing' windows
- Get the grid result set ‘editable’ by double-clicking the cells
(based on a choice in preferences)
- Set tooltip on execution time on 'file results' too
- Add custom isolation level - store with connection
- Schema compare - change 'schema 1/schema 2' into schema names
- In table data edition, have a check-box to include or not the
Primary key col in the 'INSERT' statements
- In quick search-replace, change the 'Replace' label by an option
to :
Change to UPPER-CASE, to lower-case, to Pretty-Case...
Remove all non alpha chars, all non alphanumeric chars, all non numeric
chars
Left Trim spaces, Right Trim spaces, Trim spaces
- In File comparison tool :
Last column of file was not checked.
Num of col in case of difference was indicated taking into account the
'index' col
'Position' type of message was reported even if rows were at same pos.
Release
2011.05.30
- In preferences, user can now configure the SQL
Separator (Loop on statements).
- A new dialog "Connections Manager" allow to manage
many connections
- Added a status change during execution, when the
'fetch' starts
- When closing a connection, tool does not attempt to
"rollback" if autocommit is true
- Disable 'Exec Repeat' button during processing of
queries
Release
2009.09.18
- Schema browser : The checkbox "Table size" is not selected by
default anymore.
- Schema
browser : added a new tab to view the tables, called "Table view" --
that lists 1 row per table (Table name, Record max size, Nb Records,
Nb Records * Record max size).
- Schema Tools : double-click a table now opens the Table detailed
view.
- Schema Tools : a new checkbox allow to include (optionnally) the
views in the schema browser.
- On
sql execution : in the status line, shows start/end time of execution
and miliseconds of execution (Splitted in Preparation and Fetch time,
in thetooltip on the status line).
- On the grid, results of
search options can behave differently : you can now choose between
'Select Results', 'Append results to selection', 'Unselect Results',
'Get results in newwindow'
Release
2009.05.21
- Connections management has been changed to support many
connections - still allowing to select the most important ones to be
directly accessible in menu
- The grids functionality has evolved
to include RegEx search and to search duplicates, display the number of
selected rows, etc...
- The status
line now displays the process time - a tooltip allows to display
separately process time and data fetch time.
Release
2006.01.12
- "Find" functionality on the edit zone
- Import of a CSV file in the 'Table Tools'
- Support of Chinese-Japanese-Korean characters in the grid
result
- Additional delimiters for CSV export or import : added
multiple tokens standard combo-box (Pipe, Semi-colon,etc...)
- Schema & Catalog management in the connection
definition
- "Find" in grids : added "Not equal", "Does not contain"
functionality
Release
2005.09.01
- 'Schema Tools' : export/import of one schema or some tables
: based on tables selected in the schema tree browser
- Connection definition : list of standard urls to provide
help for setting up a connection
- When searching on grids, does not take into account the
upper/lower case
- 'Find' on all grids : 'Select all rows', 'Show first
selected row', 'Find...'
- Codepage decoding results management...
- Unicode compliant Texte File management...
- Added 1 Edit zone (swapping between Edit 1 / Edit 2)
- Re-execute last command
- Secured version, requesting password for each connection
- CSV / TAB separated file formats for file results exports
- Execution on multiple connections
- More preferences (Show metadata, Trace on command-line...)
Release
2004.7.19
- Table creation wizard (that can easily create Table copy
statement)
- Look&Feel of Execution buttons improved
- Changed Look&Feel of buttons in the status bar
(Rollback,
Commit and AutoCommit) to make it clear that the 2 first ones are
"command buttons", the 3rd one (rollback) is a "State button"
- Default directory is "My Documents", but I now keep the
last directory used. If it does not exist, back to "My Documents"
- Preferences : Pluggable Look&Feel selection
- New combo-boxes to show the list of Views and list of
Procedures
- New function to 'Refresh metadata' to reload tables and
columns
- 'Find in tables' : tool to search a value -based on SQL
statements- in a subset of tables/columns
- CSV / TAB separated file formats for all grids exports
Releases 2002/2003
- Initial tool creation
- SQL command area, with "helpers" (list of tables and columns to insert)
- Results area : either in text log, direct to file, or in grid
- Configuration manager : connections configuration, jdbc drivers configuration