Jailer 8.8.4

Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

Tags front-end quality-assurance utilities java sql cross-plattform developers end-users
License Apache
State stable

Recent Releases

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.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.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.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.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.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.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.