Recent Releases
15.720 Feb 2024 11:30
major feature:
The configuration file was changed from XML to Json in order to eliminate the dependency on JAXB due to compatibility problems with JDK 11 or higher.
15.1.608 Aug 2023 22:41
minor feature:
The desktop overview view has been improved.
15.1.404 Aug 2023 10:58
minor feature:
The desktop overview view has been improved.
15.1.303 Aug 2023 10:26
minor feature:
Selection of a single row in the data browser was made possible.
15.1.225 Jul 2023 06:35
minor feature:
The dynamic search of the data browser now supports columns of type "UUID".
15.1.121 Jul 2023 09:40
minor feature:
he dynamic search of the data browser now supports columns of type "UUID".
11.1.419 Oct 2021 03:16
minor feature:
NPE in data browser.
11.1.214 Oct 2021 07:25
minor feature:
Database-side filtering of ad hoc queries in SQL Console.
11.108 Oct 2021 03:16
minor feature:
Database-side filtering of ad hoc queries in SQL Console.
10.6.201 Oct 2021 06:05
minor feature:
Database-side filtering of ad hoc queries in SQL Console.
10.6.122 Sep 2021 06:45
minor feature:
The new "Go Back"/"Go Forward" feature allows to go back and forth
to any state ever reached while navigating through the database.
The layout auto-rearrangement can now be turned off.
See https://sourceforge.net/p/jailer/discussion/700499/thread/255ca45c7b.
An error in creating NVARCHAR literals for MS-SQL Server was corrected.
10.618 Sep 2021 11:05
minor feature:
The new "Go Back"/"Go Forward" feature allows to go back and forth
to any state ever reached while navigating through the database.
The layout auto-rearrangement can now be turned off.
See https://sourceforge.net/p/jailer/discussion/700499/thread/255ca45c7b.
10.5.1012 Sep 2021 19:45
minor feature:
The user interface of the data browser and SQL console has been made a bit more appealing.
10.5.908 Sep 2021 10:05
minor feature:
The user interface of the data browser and SQL console has been made a bit more appealing.
10.5.828 Aug 2021 03:16
minor feature:
The connection dialog has been improved.
Database-specific logos are now displayed in the connection dialog and in the status bar.
The condition editor now also displays the number of rows that are "null" or "not null".
10.5.716 Aug 2021 17:25
minor feature:
An error in the validation of database connections that have not been used for a long time has been corrected.
10.5.630 Jul 2021 06:25
minor feature:
The user interface of the data browser and SQL console has been made a bit more appealing.
10.5.525 Jul 2021 11:05
minor feature:
Performance with autocomplete have been.
an error when rearranging table windows.
Added a "welcome" dialog for new users.
10.5.421 Jul 2021 11:05
minor feature:
an error when rearranging table windows.
Added a "welcome" dialog for new users.
10.5.313 Jul 2021 09:05
minor feature:
Improved automatic arrangement of table windows in the data browser.
Minor and improved error reporting mechanism.
10.5.209 Jul 2021 10:45
minor feature:
Minor and improved error reporting mechanism.
10.5.103 Jul 2021 03:25
minor feature:
The new "Where Condition" Editor allows quick and easy narrowing of table contents to the relevant data.
Code completion feature has been significantly improved.
10.528 Jun 2021 03:16
minor feature:
New "Where Condition" Editor allows quick and easy narrowing of table contents to the relevant data.
10.4.930 May 2021 03:16
minor feature:
For "Exported enum names are truncated in lookup table definitions".https://sourceforge.net/p/jailer/discussion/700499/thread/69ccdee460.
10.4.822 May 2021 07:25
minor feature:
An error in the autocompletion of "*" in "Insert into... Select..." statements has been corrected.
Working with multiple browser windows has been made clearer.
10.4.714 May 2021 03:45
minor feature:
Inplace editors for PostgreSQL data types "hstore", "ghstore", "json", "jsonb" and "boolean".
Prevention of the "Streaming result set is still active." error with mysql.
10.4.506 May 2021 16:05
minor feature:
Sessions can be restored from the history of recent sessions.
The automatic initial naming of database connections has been greatly improved.
10.4.424 Apr 2021 07:45
minor feature:
The detail view dialog has been made non-modal, allowing a smoother workflow.
Rows can now also be edited via the detail view dialog.
10.4.312 Apr 2021 03:19
minor feature:
Improved rendering quality on HiDPI environments.
Many icons have been improved and increased in resolution.
Mac keyboard shortcuts are now also used with Nimbus-LAF.
The GUI has been simplified in some places and made clearer.
10.4.203 Apr 2021 07:25
minor feature:
Further desktop improvements
Single-row views are now directly editable. It is also possible to search for columns within them.
The metadata view has been simplified and made clearer.
rowid/tid pseudo columns are used to identify a row when the table has no primary key.
An error in the row count query has been corrected.
.
Single-row views are now directly editable. It is also possible to search for columns within them.
The metadata view has been simplified and made clearer.
rowid/tid pseudo columns are used to identify a row when the table has no primary key.
An error in the row count query has been corrected.
10.4.125 Mar 2021 03:16
minor feature:
SQL Console and desktop improvements
Queries are now subjected to intensive analysis,
which makes it possible to detect primary and foreign keys and display them accordingly,
as well as the origin table of each column.
Number data is now formatted and right-aligned.
Faster metadata acquisition with Oracle DBMS.
.
Queries are now subjected to intensive analysis,
which makes it possible to detect primary and foreign keys and display them accordingly,
as well as the origin table of each column.
Number data is now formatted and right-aligned.
Faster metadata acquisition with Oracle DBMS.
"(Minor) Dropdown menu disabling inconsistency" #40.
"Parameters not working when using complex filters" #41.
New logo.
Minor and improvements.
10.419 Mar 2021 07:05
minor feature:
SQL Console and desktop improvements
Queries are now subjected to intensive analysis,
which makes it possible to detect primary and foreign keys and display them accordingly,
as well as the origin table of each column.
Number data is now formatted and right-aligned.
Faster metadata acquisition with Oracle DBMS.
.
Queries are now subjected to intensive analysis,
which makes it possible to detect primary and foreign keys and display them accordingly,
as well as the origin table of each column.
Number data is now formatted and right-aligned.
Faster metadata acquisition with Oracle DBMS.
"(Minor) Dropdown menu disabling inconsistency" #40.
"Parameters not working when using complex filters" #41.
Minor and improvements.
10.3.504 Mar 2021 03:17
minor feature:
Detection and renewal of invalid database connections (further improvements).
The inplace editor in the data browser now also supports fields of the "boolean" data type.
10.3.412 Feb 2021 03:16
minor feature:
Detection and renewal of invalid database connections.
With nullable (virtual) primary key columns, errors could occur in the generated SQL statements. This has been.
10.3.305 Feb 2021 10:05
minor feature:
The wording of the dialog for analyzing a scheme has been made more understandable.
Sorting columns in the result of a query in SQL Console did not work
if a column did not have an explicit name. This was.
The error message of the primary key checker tool is now more readable.
Feature request 67 "Export as imagemap", https://sourceforge.net/p/jailer/feature-requests/67/.
10.3.227 Jan 2021 09:25
minor feature:
The SQL formatting algorithm has been improved.
Increased responsiveness of the SQL console.
10.3.119 Jan 2021 06:45
minor feature:
The data browser has been revised and improved.
In particular, an overview panel for the desktop was developed,
Which simplifies orientation in complex data views.
10.315 Jan 2021 06:45
minor feature:
The data browser has been revised and improved.
In particular, an overview panel for the desktop was developed,
Which simplifies orientation in complex data views.
10.2.810 Jan 2021 03:16
minor feature:
Improved animation performance.
Workaround for "Parser hangs in some queries #1013".
Internal refactoring measures.
10.2.706 Jan 2021 03:16
minor feature:
Workaround for "Parser hangs in some queries".
Internal refactoring measures.
10.2.606 Dec 2020 19:45
minor feature:
If a foreign key is nullable, rows can now be exported with no parents without violating the integrity
by setting the foreign key to null instead. In the same way parents can be deleted without their children.
Support of CLOB/BLOB in MS SQL.
10.2.502 Dec 2020 11:25
minor feature:
If a foreign key is nullable, rows can now be exported with no parents without violating the integrity
by setting the foreign key to null instead. In the same way parents can be deleted without their children.
Support of CLOB/BLOB in MS SQL.
10.2.415 Nov 2020 12:45
minor feature:
When working with PostgreSQL, you can use the "ctid" pseudo columns instead of primary keys
for row identification. See #36.
Under rare circumstances SQL statements were generated that could not be processed by Sybase database systems.
This has been corrected.
The performance of the working table scope "local database" was improved. Especially with embedded usage (API).
If the subsetter is used via API, access to the working tables is synchronized
so that different extraction models can be used concurrently.
10.2.310 Nov 2020 03:16
minor feature:
When working with PostgreSQL, you can use the "ctid" pseudo columns instead of primary keys
for row identification. See #36.
Under rare circumstances SQL statements were generated that could not be processed by older MS SQL database systems.
This has been corrected.
10.2.230 Oct 2020 06:05
minor feature:
Error "Streaming result set is still active" when a limit is defined on the subject was (MySQL).
10.2.123 Oct 2020 03:16
minor feature:
The response time in case of errors has been improved by immediately terminating all running SQL statements.
10.217 Oct 2020 07:05
minor feature:
Support for the MS SQL data type "hierarchyid".
Severe error in log file creation was.
10.1.113 Oct 2020 03:25
minor feature:
the dynamic search of the data browser now supports columns of type "UUID".
10.109 Oct 2020 16:25
minor feature:
Automatic download of JDBC drivers.
Workaround for "JDK-8215200 : IllegalArgumentException in sun.lwawt.macosx.CPlatformWindow"AdoptOpenJDK/openjdk-jdk11#10https://.java.com/database/view_.do?_id=8215200https://.openjdk.java.net/browse/JDK-8215200.
10.025 Sep 2020 08:25
minor feature:
Java 7 support was dropped in favor of reduced development overheads.
Third party libraries and JDBC drivers have been upgraded accordingly.
9.5.621 Sep 2020 09:25
minor feature:
New CLI tool for printing the closure of subject tables.#34.
The command line interface has been cleaned up and simplified.
An error in the HTML rendering of a data model was corrected.
9.5.914 Sep 2020 21:05
minor feature:
For "Need help understanding delete script"https://sourceforge.net/p/jailer/discussion/700499/thread/b3685a49/
(A further release was necessary, as this was not completely corrected at first).
Improved CSV-handling.
9.5.410 Sep 2020 11:45
minor feature:
Deactivated dependencies had no effect on topological sorting. This was corrected.https://sourceforge.net/p/jailer/discussion/700499/thread/b3685a49.
For "NoClassDefFoundError was not logged, Jailer failed without showing reason #33"#33.
9.5.304 Sep 2020 11:25
minor feature:
Improved Connection Settings Wizard.
Some diagnostic means have been added.
Minor.
9.5.211 Aug 2020 11:45
minor feature:
For " firebird database - No suitable Inline-View Style known #32"#32.
For "Delete Reduction is not deleting rows"https://sourceforge.net/p/jailer/discussion/700499/thread/3d16e17980/.
9.5.105 Aug 2020 06:45
minor feature:
For " jailer: #43 PostgreSQL: Export of inet and interval"https://sourceforge.net/p/jailer//43/.
For " jailer: #44 not a proxy instance if WorkingTableScope.LOCAL_DATABASEand Tomcat jdbc pool"https://sourceforge.net/p/jailer//44/.
9.503 Jul 2020 03:16
minor feature:
Increased initial responsiveness of the Data Browser.
Extensive internal redesigns since the last major release.
9.4.318 Jun 2020 03:16
minor feature:
"Error when running sql script" https://sourceforge.net/p/jailer/discussion/700499/thread/90600d12b6.
9.4.204 Jun 2020 09:45
minor feature:
Improved database metadata management.
Increased initial responsiveness of the Data Browser.
9.4.122 May 2020 07:25
minor feature:
Improved database metadata management.
Increased initial responsiveness of the Data Browser.
9.408 May 2020 06:05
minor feature:
The new "Degree view" allows quick and easy editing of the associations of tables with the highest connectivity.
9.3.630 Apr 2020 11:05
minor feature:
"#66 Avoid plain text passwords on the command line"https://sourceforge.net/p/jailer/feature-requests/66/.
Minor improvements to GUI of the data browser.
9.3.511 Apr 2020 10:45
minor feature:
Minor improvements to the GUI of the SQL console.
Increased responsiveness and performance of the SQL Console.
9.3.403 Apr 2020 03:15
minor feature:
Instant visualization of the contents of the row under the mouse pointer in the data browser.
9.3.321 Mar 2020 13:05
minor feature:
Characters in bookmark names that are not valid in file names caused errors when saving the bookmarks.
Minor improvements to the GUI of the data-browser.
9.3.203 Mar 2020 03:15
minor feature:
"Conditions with () have leading and trailing parans removed" #28.
Fetching results from MySQL/MariaDB is now based on a cursor. This prevents out-of-memory errors with large amounts of data.
9.3.120 Feb 2020 10:45
minor feature:
"Syntax error creating tables in PostgreSQL" #27.
Modifications to the connection properties in the "Connection" dialog were sometimes retained after a "cancel".
"About" dialog now also shows system properties.
9.3.002 Feb 2020 18:45
minor feature:
The number of rows of a subject table to be exported can now be limited
taking into account a possible column order.
Nullable primary key columns could lead to incorrect results under certain circumstances.
In the data browser, the user interface sometimes blocked when the acquisition of database metadata took a long time.
9.329 Jan 2020 07:05
minor feature:
The number of rows of a subject table to be exported can now be limited
taking into account a possible column order.
Nullable primary key columns could lead to incorrect results under certain circumstances.
In the data browser, the user interface sometimes blocked when the acquisition of database metadata took a long time.
9.2.202 Jan 2020 03:15
minor feature:
When deleting rows, an IllegalStateException sometimes occurred incorrectly.
Improved performance of deletion script generation.
Progress dialog for exporting is no longer modal.
9.2.119 Dec 2019 06:25
minor feature:
Support for nullable primary key columns.
This simplifies the definition of pseudo-primary keys for tables without keys.
"Limit" parameter as a safeguard for exports. #24.
9.216 Dec 2019 03:15
minor feature:
Support for nullable primary key columns.
This simplifies the definition of pseudo-primary keys for tables without keys.
"Limit" parameter as a safeguard for exports. #24.
9.1.828 Nov 2019 11:45
minor feature:
Updated the SQLite JDBC driver.
A new wizard for JDBC URL settings has been created.
9.1.714 Nov 2019 06:25
minor feature:
NullPointerException in Data Browser.
Support for data type datetime2 in MS SQL. #20.
The -schemamapping option was not used correctly for the statements of a delete script. #21.
Formatting of dates/timestamps during export no longer takes place synchronized.
This improves performance when multiple threads are used.
Minor improvements to the "Export Data" dialog.
9.1.611 Nov 2019 03:15
minor feature:
Support for data type datetime2 in MS SQL. #20.
The -schemamapping option was not used correctly for the statements of a delete script. #21.
Formatting of dates/timestamps during export no longer takes place synchronized.
This improves performance when multiple threads are used.
Minor improvements to the "Export Data" dialog.
9.1.507 Nov 2019 03:15
minor feature:
Support for data type datetime2 in MS SQL. #20.
The -schemamapping option was not used correctly for the statements of a delete script. #21.
Formatting of dates/timestamps during export no longer takes place synchronized.
This improves performance when multiple threads are used.
9.1.402 Nov 2019 07:25
minor feature:
Deadlock prevention in PostgreSQL.
Support for PostgreSQL type "bpchar".
Improved display of errors in the data browser.
More robustness if primary keys are not specified correctly.
9.1.329 Oct 2019 12:45
minor feature:
More robustness if primary keys are not specified correctly.
Improved display of errors in the data browser.
9.1.221 Oct 2019 06:45
minor feature:
Fetching results from PostgreSQL is now based on a cursor. This prevents out-of-memory errors with large amounts of data.
Performance improvements.
The animation of the data model view in the desktop did not work.
When the DDL is generated for a table, it is also generated for the indexes.
HiDPI display support.
9.1.116 Oct 2019 10:45
minor feature:
The animation of the data model view in the desktop did not work.
When the DDL is generated for a table, it is also generated for the indexes.
Performance improvements.
HiDPI display support.
9.112 Oct 2019 03:15
minor feature:
Hover See function in the data browser to easily see which row is related to which other rows.
Added configuration information for MariaDB.
for "Gui: NPE after renaming model file (*.jm)" #16.
The initial base folder of the data models was incorrect if the installer was used on Windows.
The minimum requirement for the number of available database connections has been reduced to a single one.
Extensive internal redesigns since the last major release.
9.0.008 Oct 2019 15:45
minor feature:
Hover See function in the data browser to easily see which row is related to which other rows.
Added configuration information for MariaDB.
for "Gui: NPE after renaming model file (*.jm)" #16.
Extensive internal redesigns since the last major release.
9.003 Oct 2019 03:15
minor feature:
Hover See function in the data browser to easily see which row is related to which other rows.
Added configuration information for MariaDB.
for "Gui: NPE after renaming model file (*.jm)". #16.
Extensive internal redesigns since the last major release.
8.8.8.428 Sep 2019 16:45
minor feature:
Hotrelease for "Gui: NPE after renaming model file (*.jm)", #16.
8.8.8.024 Sep 2019 09:25
minor feature:
Avoid NPE if there is no default scheme.
Import filters did not work correctly when a foreign key column with a filter was exported,
but not the corresponding primary key column.
In the condition editor, scalar subqueries for columns of adjacent tables can now be generated.
Minor.
8.8.820 Sep 2019 08:25
minor feature:
Avoid NPE if there is no default scheme.
Import filters did not work correctly when a foreign key column with a filter was exported,
but not the corresponding primary key column.
In the condition editor, scalar subqueries for columns of adjacent tables can now be generated.
Minor.
8.8.712 Sep 2019 12:45
minor feature:
Upsert statements in PostgreSQL format could fail due to missing explicit conversion of "bytea" literals.
The data model editor is now more robust against errors in the data model files.
Minor improvements to the GUI and.
8.8.607 Sep 2019 14:05
minor feature:
" new feature add command line options to bypass the data model selection dialog" #14.
"Multiple table selection" #13.
The model selection dialog has been improved. Recently used connections/sessions/bookmarks can be reopened with a single click.
The sorting settings of table browsers in bookmarks are recorded and restored.
New feature "Find Column..." of the data browser makes it easy to find a column in a wide table.
8.8.503 Sep 2019 06:45
minor feature:
" new feature add command line options to bypass the data model selection dialog" #14.
"Multiple table selection" #13.
The model selection dialog has been improved. Recently used connections/sessions/bookmarks can be reopened with a single click.
8.8.423 Aug 2019 08:25
minor feature:
a that caused a Liquibase export not to work for Postgres TEXT columns.
SQL Console didn't work with SQLite.
Improved validation of CLI arguments.
The "Upsert" statements are generated for more compact.
Feature Request 65. https://sourceforge.net/p/jailer/feature-requests/65/.
Importing C/BLOBs did not work without write permission on the working directory.
8.8.320 Aug 2019 03:15
minor feature:
a that caused a Liquibase export not to work for Postgres TEXT columns.
SQL Console didn't work with SQLite.
Improved validation of CLI arguments.
The "Upsert" statements are generated for more compact.
Feature Request 65. https://sourceforge.net/p/jailer/feature-requests/65/.
8.8.206 Aug 2019 11:45
minor feature:
The layout optimizer of the export progress dialog has been improved.
The tutorial has been improved.
Minor and improvements.
8.8.121 Jul 2019 08:05
minor feature:
New feature "Check Primary Keys" makes it possible to check the user-defined primary keys for uniqueness.
A warning message appears if the number of collected rows differs from the number of exported ones.
The performance of the preparation for the subsetting-process has been improved.
Extraction models can now be loaded from the "Data Model Manager" dialog.
It was not possible to pass user / password via cli when it starts with '-'.
Updated local database to H2 1.4.199.
The fonts selection in the GUI has been standardized.
Improved error handling in the data browser.
If the same error occurs multiple times because it affects multiple table browsers,
it will be displayed only once.
8.817 Jul 2019 06:25
minor feature:
New feature "Check Primary Keys" makes it possible to check the user-defined primary keys for uniqueness.
A warning message appears if the number of collected rows differs from the number of exported ones.
The performance of the preparation for the subsetting-process has been improved.
Extraction models can now be loaded from the "Data Model Manager" dialog.
It was not possible to pass user / password via cli when it starts with '-'.
Updated local database to H2 1.4.199.
The fonts selection in the GUI has been standardized.
Improved error handling in the data browser.
If the same error occurs multiple times because it affects multiple table browsers,
it will be displayed only once.
8.7.805 Jul 2019 07:05
minor feature:
a that caused the creation of a delete script to generate syntactically incorrect SQL statements when a table without a primary key exists.
8.7.729 Jun 2019 03:15
minor feature:
Release notes update
.
Added TODO.
.
Don't check PKs if script format is XML.
.
Release notes update.
.
Added TODO.
.
8.7.7.
8.7.522 Jun 2019 08:45
minor feature:
For "Oracle queries are going failed". https://sourceforge.net/p/jailer//39/.
8.7.418 Jun 2019 03:15
minor feature:
For "Oracle queries are going failed". https://sourceforge.net/p/jailer//39/.
8.7.314 Jun 2019 03:15
minor feature:
the working table scope "local" did not work correctly with PostgreSQL.
Cursor-based result sets have been activated under PostgreSQL.
Retrieving the entire ResultSet at once led to out-of-memory errors.
8.7.209 Jun 2019 03:15
minor feature:
Selected tables are automatically scrolled into the visible area of the display.
SQL Console is now robust against outdated metadata.
Associations between visible tables were not always visible.
Modal dialogues were replaced by non-modal ones.
Creation of the data model files has been revised.
Execution plans for DB2 LUW.
"ERROR: failed to find conversion function from unknown to text".
that could occur with PostgreSQL in connection with the "local database" scope.
8.7.105 Jun 2019 07:45
minor feature:
Modal dialogues were replaced by non-modal ones.
Creation of the data model files has been revised.
Execution plans for DB2 LUW.
"ERROR: failed to find conversion function from unknown to text".
that could occur with PostgreSQL in connection with the "local database" scope.
SQL Console is now robust against outdated metadata.
Associations between visible tables were not always visible.
8.722 May 2019 22:45
minor feature:
Modal dialogues were replaced by non-modal ones.
Creation of the data model files has been revised.
Execution plans for DB2 LUW.
"ERROR: failed to find conversion function from unknown to text" that could occur with PostgreSQL in connection with the "local database" scope.
8.6.310 May 2019 13:45
minor feature:
View execution plans for DB2 LUW.
"ERROR: failed to find conversion function from unknown to text".
That could occur with PostgreSQL in connection with the "local database" scope.
8.6.205 May 2019 22:05
minor feature:
View execution plans for DB2 LUW.
"ERROR: failed to find conversion function from unknown to text".
That could occur with PostgreSQL in connection with the "local database" scope.
8.6.101 May 2019 03:25
minor feature:
View execution plans for DB2 LUW.
"ERROR: failed to find conversion function from unknown to text".
That could occur with PostgreSQL in connection with the "local database" scope.
8.617 Apr 2019 06:05
minor feature:
The data browser automatically reconnects when the connection is lost.
Minor.
8.5.506 Apr 2019 03:16
minor feature:
Increased version
.
QA 331.
.
Release notes update.
8.5.430 Mar 2019 03:16
minor feature:
The table from which the navigation starts can now be changed at any time in the data browser.
Improved data browser performance.
8.5.315 Mar 2019 03:16
minor feature:
Column order in the display can be defined not only globally but also for each table.
8.5.207 Mar 2019 06:05
minor feature:
Minor.
8.5.128 Feb 2019 07:25
minor feature:
Undo/Redo functionality.
Improved HiDPI Support.
8.524 Feb 2019 03:45
minor feature:
Undo/Redo functionality.
Improved HiDPI Support.
8.4.220 Feb 2019 03:15
minor feature:
Transactional import did not roll back the transaction in case of an error.
improved HiDPI Support.
Minor.
8.4.116 Feb 2019 03:15
minor feature:
Undo/Redo functionality.
an error in the analysis of views.
8.412 Feb 2019 03:15
minor feature:
Undo/Redo functionality.
an error in the analysis of views.
8.3.106 Feb 2019 03:17
minor feature:
New "Model Migration Tool" allows you to easily find and edit the newly added associations if the data model has been extended after the last change to this extraction model.
8.302 Feb 2019 03:15
minor feature:
New "Model Migration Tool" allows you to easily find and edit the newly added associations if the data model has been extended after the last change to this extraction model.
8.2.624 Jan 2019 03:18
minor feature:
"#37 PostreSQL: transactional execution".
"#36 Data Export Dialog: Some settings are 'lost' between Exports".
FR "#62 subsequent Analyze database, new links fate", only the new "parent- detail" relationships will be disabled.
FR "#61 Information about exported rows".
"Export to SQLite - Boolean values", #10.
8.2.511 Jan 2019 06:25
minor feature:
Improved livelock prevention.
feature-requests:#61 "Information about exported rows".
"Data Export Dialog: Some settings are 'lost' between Exports".
NPE in "explain" feature.
Minor.
8.2.401 Jan 2019 14:05
minor feature:
Implemented "#57 Analyze database convenience". UPK is formed exclusively for the tables related to the subjects.
Implemented "#58 receipt += times".
"#34 Possible Performance-Improvement in CellContentConverter.toSql".
"#59 Retry Deadlock?".
Automatic adjustment of the number of database connections.
8.2.329 Dec 2018 03:18
minor feature:
Implemented "#57 Analyze database convenience". UPK is formed exclusively for the tables related to the subjects.
Implemented "#58 receipt += times".
"#34 Possible Performance-Improvement in CellContentConverter.toSql".
"#59 Retry Deadlock?".
Automatic adjustment of the number of database connections.
8.2.107 Dec 2018 04:05
minor feature:
Intra-database export: automatic fallback to MERGE on tables without PK has been removed.
Increased SQL import performance + progress bar also for compressed files.
Logging did not work if the working directory is read-only.
Improved error handling.
Minor.
8.227 Nov 2018 07:05
minor feature:
"SQLite JDBC: inconsistent internal state" during database analysis.
"#32 SQL analyzer: duplicate associations".
Implemented "#51 Reduce transaction sizes".
Implemented "#54 Number thousand separators".
New option to set the isolation level.
Bookmark feature in data browser.
8.1.517 Nov 2018 07:05
minor feature:
New export option "check primary keys" allows checking the validity of manually defined primary keys.
New export option "limit transaction sizes" reduces transaction sizes. (Feature request 51).
Improved indexing of working tables.
JSQLParser has been updated to version 1.3.
for "SQL analyzer: duplicate associations".
8.1.313 Nov 2018 06:05
minor feature:
New export option "check primary keys" allows checking the validity of manually defined primary keys.
New export option "limit transaction sizes" reduces transaction sizes. (Feature request 51).
Improved indexing of working tables.
JSQLParser has been updated to version 1.3.
8.1.131 Oct 2018 06:45
minor feature:
SQL-Console: all requests are now executed in the same connection.
Feature Request "#47 Add additional tables adds too much".
Feature Request "#44 MSSQL export to another DB in same instance".
Feature Request "#49 Mac shortcuts".
Feature Request "#50 Option to not to delete too much from entities".
Improved Cycle Finder component.
Increased responsiveness and performance of the SQL Console.
8.0.213 Oct 2018 07:25
minor feature:
Foreign key columns can be set to null if parent row is not exported.
Increased responsiveness and performance of the data browser GUI.
The new "PathFinder" feature allows elaborate finding
of association paths between tables in complex data models.
8.0.106 Oct 2018 03:16
minor feature:
Foreign key columns can be set to null if parent row is not exported.
Increased responsiveness and performance of the data browser GUI.
The new "PathFinder" feature allows elaborate finding
of association paths between tables in complex data models.
8.021 Sep 2018 08:25
minor feature:
The new "PathFinder" feature allows elaborate finding
of association paths between tables in complex data models.
7.11.106 Sep 2018 21:45
minor feature:
Database analysis not only finds primary keys and foreign keys for tables,
But also for views and synonyms by analyzing the underlying tables.
a memory leak in data browser.
7.1101 Sep 2018 12:05
minor feature:
Database analysis not only finds primary keys and foreign keys for tables,
But also for views and synonyms by analyzing the underlying tables.
a memory leak in data browser.
7.10.824 Aug 2018 11:05
minor feature:
Data browser improvements
New layout feature: "align table horizontally with predecessor"
Improved layout strategy in the data browser.
Improved row-to-row-link rendering performance.
.
New layout feature: "align table horizontally with predecessor".
Improved layout strategy in the data browser.
Improved row-to-row-link rendering performance.
Feature Request "Improve the usability of the Data Model Editor" (partially). see https://sourceforge.net/p/jailer/feature-requests/43/.
7.10.717 Aug 2018 06:25
minor feature:
Animated desktop layout in the data browser.
Improved row-link rendering quality and performance.
Zoom in / out using the mouse wheel in the data browser.
7.10.613 Aug 2018 06:25
minor feature:
Animated desktop layout in the data browser.
Improved row-link rendering quality and performance.
7.10.509 Aug 2018 03:45
minor feature:
Animated desktop layout in the data browser.
Improved row-link rendering quality and performance.
7.10.428 Jul 2018 03:25
minor feature:
The estimated number of rows of the tables is displayed.
Limited fetch size of statements to prevent an OOM exception when the default fetch size is too large (MySQL).
Updated H2 DBMS from version 1.3.160 to 1.3.175.
7.10.321 Jul 2018 06:25
minor feature:
for "Can't connect to SOCKS proxy:http" #8.
Comprehensive usability improvements of the data browser.
Animated row-to-row links.
Increased rendering quality of row-to-row link.
Automatic layouting of data browser desktop.
Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks.
Update of SQL keyword catalog to SQL 2003 standard.
Added context menu to columns view of results table.
7.10.210 Jul 2018 19:25
minor feature:
for "Can't connect to SOCKS proxy:http" #8.
Comprehensive usability improvements of the data browser.
Animated row-to-row links.
Increased rendering quality of row-to-row link.
Automatic layouting of data browser desktop.
Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks.
Update of SQL keyword catalog to SQL 2003 standard.
Added context menu to columns view of results table.
7.10.106 Jul 2018 06:45
minor feature:
Comprehensive usability improvements of the data browser.
Animated row-to-row links.
Increased rendering quality of row-to-row link.
Automatic layouting of data browser desktop.
Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks.
Update of SQL keyword catalog to SQL 2003 standard.
Added context menu to columns view of results table.
7.1021 Jun 2018 07:05
minor feature:
Comprehensive usability improvements of the data browser.
Animated row-to-row links.
Increased rendering quality of row-to-row link.
Automatic layouting of data browser desktop.
Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks.
Update of SQL keyword catalog to SQL 2003 standard.
7.9.409 Jun 2018 07:05
minor feature:
Comprehensive usability improvements of the data browser.
Animated row-to-row links.
Increased rendering quality of row-to-row link.
.
Animated row-to-row links.
Increased rendering quality of row-to-row link.
7.9.304 Jun 2018 06:25
minor feature:
Feature to define the rendering position of a column.
Rendering of row-to-row links as bezier curves.
Data browser: prevented that context menu automatically gets if the item doesn't have the focus.
7.9.231 May 2018 09:25
minor feature:
Feature to define the rendering position of a column.
Rendering of row-to-row links as bezier curves.
7.9.123 May 2018 16:05
minor feature:
Statement leak.
Minor GUI Improvements and.
7.915 May 2018 06:25
minor feature:
Comprehensive usability improvements of the data browser.
for "#25 Invalid SQL when exporting for H2 dialect"https://sourceforge.net/p/jailer//25/?limit=25#49d4.
Minor.
7.8.201 May 2018 03:15
minor feature:
The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions.
This allows to reverse-engineer the data model based on existing SQL queries.
Improved render quality on high resolution screens.
7.827 Apr 2018 06:57
major feature:
The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions. This allows to reverse-engineer the data model based on existing SQL queries.