Jailer

• Implemented "#57 Analyze database convenience". UPK is formed exclusively for the tables related to the subjects.
• Implemented "#58 receipt += times"
• Fixed "#34 Possible Performance-Improvement in CellContentConverter.toSql"
• Fixed "#59 Retry Deadlock?"
• Automatic adjustment of the number of database connections.

• 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 bug fixes.

• Fixed "SQLite JDBC: inconsistent internal state" during database analysis.
• Fixed "#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.

• 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.
• Fix for bug 32 "SQL analyzer: duplicate associations"

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

• 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"
  https://sourceforge.net/p/jailer/feature-requests/50/
• Improved Cycle Finder component.

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

• The new "PathFinder" feature allows elaborate finding
  of association paths between tables in complex data models.

• Database analysis not only finds primary keys and foreign keys for tables,
  but also for views and synonyms by analyzing the underlying tables.
• Fixed a memory leak in data browser.

7.10.8

• 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.
• Feature Request "Improve the usability of the Data Model Editor" (partially). see https://sourceforge.net/p/jailer/feature-requests/43/

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

• 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

• Fix for "Can't connect to SOCKS proxy:http" https://github.com/Wisser/Jailer/issues/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.

• 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 closed if the item doesn't have the focus.

7.9.1

• Fixed statement leak.
• Minor GUI Improvements and bug fixes.

• Comprehensive usability improvements of the data browser.
• Fix for "#25 Invalid SQL when exporting for H2 dialect"
  https://sourceforge.net/p/jailer/bugs/25/?limit=25#49d4
• Minor bug fixes.

Jailer 7.8.2

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

• SQL-Console improvements:
  • new "Toggle Line Continuation" context menu item.
  • "Substitute Variables" context menu item.
  • Loading/Saving of SQL Script Files (with Drag & Drop support)

7.6.7

• SQL-Console: added support for substitution variables.
• Fixed a bug concerning SQL outline rendering.