Softpedia >Mac >Developer Tools >Jailer >  Changelog

Jailer Changelog

What's new in Jailer 10.5.7

Aug 16, 2021
  • An error in the validation of database connections that have not been used for a long time has been corrected.

New in Jailer 10.5.6 (Jul 30, 2021)

  • The user interface of the data browser and SQL console has been made a bit more appealing.

New in Jailer 10.5.5 (Jul 22, 2021)

  • Performance issues with autocomplete have been fixed.

New in Jailer 10.5.4 (Jul 22, 2021)

  • Fixed an error when rearranging table windows.
  • Added a "welcome" dialog for new users.

New in Jailer 10.5.3 (Jul 22, 2021)

  • Improved automatic arrangement of table windows in the data browser.
  • Minor fixes and improved error reporting mechanism.

New in Jailer 10.5.1 (Jul 22, 2021)

  • The new "Where Condition" Editor allows quick and easy narrowing of table contents to the relevant data.
  • Code completion feature has been significantly improved.

New in Jailer 10.4.9 (Jul 22, 2021)

  • Fix for bug "Exported enum names are truncated in lookup table definitions". https://sourceforge.net/p/jailer/discussion/700499/thread/69ccdee460

New in Jailer 10.4.8 (Jul 22, 2021)

  • An error in the autocompletion of "*" in "Insert into... Select..." statements has been corrected.
  • Working with multiple browser windows has been made clearer.

New in Jailer 10.4.7 (Jul 22, 2021)

  • Inplace editors for PostgreSQL data types "hstore", "ghstore", "json", "jsonb" and "boolean".
  • Prevention of the "Streaming result set is still active." error with mysql.

New in Jailer 10.4.5 (Jul 22, 2021)

  • Sessions can be restored from the history of recent sessions.
  • The automatic initial naming of database connections has been greatly improved.

New in Jailer 10.4.4 (Jul 22, 2021)

  • The detail view dialog has been made non-modal, allowing a smoother workflow.
  • Rows can now also be edited via the detail view dialog.

New in Jailer 10.4.3 (Jul 22, 2021)

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

New in Jailer 10.4.2 (Jul 22, 2021)

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

New in Jailer 10.4.1 (Jul 22, 2021)

  • 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.
  • Fixed "(Minor) Dropdown menu disabling inconsistency #40" https://github.com/Wisser/Jailer/issues/40
  • Fixed "Parameters not working when using complex filters #41" https://github.com/Wisser/Jailer/issues/41
  • New logo.
  • Minor fixes and improvements.

New in Jailer 10.3.5 (Jul 22, 2021)

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

New in Jailer 10.3.4 (Jul 22, 2021)

  • Detection and renewal of invalid database connections.
  • With nullable (virtual) primary key columns, errors could occur in the generated SQL statements. This has been fixed.

New in Jailer 10.3.3 (Jul 22, 2021)

  • 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 bug was fixed.
  • 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/

New in Jailer 10.3.2 (Jul 22, 2021)

  • The SQL formatting algorithm has been improved.
  • Increased responsiveness of the SQL console.

New in Jailer 10.3.1 (Jul 22, 2021)

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

New in Jailer 10.2.7 (Jul 22, 2021)

  • Workaround for "Parser hangs in some queries #1013"
  • Internal refactoring measures

New in Jailer 10.2.6 (Jul 22, 2021)

  • 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

New in Jailer 10.2.4 (Jul 22, 2021)

  • When working with PostgreSQL, you can use the "ctid" pseudo columns instead of primary keys for row identification. See https://github.com/Wisser/Jailer/issues/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.

New in Jailer 10.2.2 (Jul 22, 2021)

  • Error "Streaming result set is still active" when a limit is defined on the subject was fixed (MySQL)

New in Jailer 10.2.1 (Oct 22, 2020)

  • The response time in case of errors has been improved by immediately terminating all running SQL statements.

New in Jailer 10.2 (Oct 14, 2020)

  • Support for the MS SQL data type "hierarchyid".
  • Severe error in log file creation was fixed.

New in Jailer 10.1 (Oct 9, 2020)

  • Automatic download of JDBC drivers.
  • Workaround for bug "JDK-8215200 : IllegalArgumentException in sun.lwawt.macosx.CPlatformWindow"

New in Jailer 10.0 (Sep 25, 2020)

  • Java 7 support was dropped in favor of reduced development overheads.
  • Third party libraries and JDBC drivers have been upgraded accordingly.

New in Jailer 9.5.6 (Sep 20, 2020)

  • New CLI tool for printing the closure of subject tables. https://github.com/Wisser/Jailer/issues/34
  • The command line interface has been cleaned up and simplified.
  • An error in the HTML rendering of a data model was corrected.

New in Jailer 9.5.5 (Sep 14, 2020)

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

New in Jailer 9.5.4 (Sep 9, 2020)

  • Deactivated dependencies had no effect on topological sorting. This was corrected. https://sourceforge.net/p/jailer/discussion/700499/thread/b3685a49
  • Fix for "NoClassDefFoundError was not logged, Jailer failed without showing reason #33" https://github.com/Wisser/Jailer/issues/33

New in Jailer 7.11 (Sep 1, 2018)

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

New in Jailer 7.10.2 (Jul 16, 2018)

  • Fix for "Can't connect to SOCKS proxy:http" https://github.com/Wisser/Jailer/issues/8
  • Added context menu to columns view of results table.

New in Jailer 7.6.5 (Mar 14, 2018)

  • Minor GUI Improvements and bug fixes.
  • Improved table meta data rendering.
  • Asynchronous meta data loading.
  • Added "Columns", "Text" and "Meta" views to SQLConsole.
  • Added "Functions", "Packages" and "Triggers" views to Data Browser.
  • Added "Copy toClipboard" context menu item.
  • New feature "Explain Plan" in SQLConsole.
  • JDBC driver updates.
  • Minor GUI Improvements and bug fixes.
  • Constraint checking tool.
  • Fix for "#23 Bugs when exporting timestamps and JSON ", https://sourceforge.net/p/jailer/bugs/23/
  • Minor GUI Improvements and bug fixes.

New in Jailer 7.5.10 (Dec 15, 2017)

  • SQLConsole: added outline-view for SQL statements.

New in Jailer 7.5.8 (Dec 15, 2017)

  • SQLConsole: added ability to execute SQL fragments.
  • DDL view for tables.

New in Jailer 7.5.7 (Nov 23, 2017)

  • Data browser improvements:
  • In-place editing of query results.
  • Column filtering in data browser.
  • Improved table search feature.

New in Jailer 7.5.2 (Oct 18, 2017)

  • https://github.com/Wisser/Jailer/pull/5 "Include the column names in the first statement to avoid ORA-00918: column ambiguously defined"
  • Table search feature.
  • Minor GUI improvements.

New in Jailer 7.5 (Oct 12, 2017)

  • Full featured SQL Console with code completion, syntax highlighting and database schema visualization.

New in Jailer 7.4.2 (Sep 28, 2017)

  • Improved data model merging.
  • Added ability to change the data model base folder.
  • Metadata views in data browser.

New in Jailer 6.1 (Oct 22, 2016)

  • The new feature "Filter Templates" allows you to define rules for assigning filters to columns. (Edit -> Filter editor... -> Templates)
  • Filters on primary key columns will automatically be applied to the corresponding foreign key columns.

New in Jailer 6.0.3 (Sep 21, 2016)

  • Fixed an error extracting from a postgresql table with a date primary key and a local database (thanks to olivier45).

New in Jailer 6.0.2 (Sep 18, 2016)

  • Fixed an incompatibility with Java 9.

New in Jailer 6.0.1 (Sep 15, 2016)

  • Bug fixes for "Error exporting from postgresql with global tables with a working table schema" and "Error exporting from postgresql with temporary tables".

New in Jailer 6.0 (Sep 9, 2016)

  • New "Export To" mode allows to export rows directly into a different schema in the same database.

New in Jailer 5.6.1 (Sep 8, 2016)

  • Minor bug fixes.

New in Jailer 5.6.0 (Aug 13, 2016)

  • Improved error handling.
  • Improved performance.

New in Jailer 5.5.7 (Aug 11, 2016)

  • Fixed an issue with exporting XML data from MySQL databases.

New in Jailer 5.5.6 (Aug 6, 2016)

  • Minor bug fixes.

New in Jailer 5.5.5 (Aug 3, 2016)

  • Minor bug fixes.

New in Jailer 5.5.2 (Jul 9, 2016)

  • Added ability to specify the schema for the working tables.

New in Jailer 5.5.1 (Jul 7, 2016)

  • Fixed NPE in data browser.

New in Jailer 5.5 (Jul 7, 2016)

  • Support for ROWID pseudo-column in Oracle.

New in Jailer 5.4.2 (Jun 22, 2016)

  • bug fix for [ jailer-Bugs-3294893 ] Outer Join for selecting dependant entries and Oracle 10 mixing left joins and theta-style joins caused problems on oracle DBMS
  • new pseudo-column: "$IN_DELETE_MODE"

New in Jailer 5.4.1 (Jun 7, 2016)

  • add ability to just generate the delete script, skip export (thanks to Jason Pell)
  • improved responsiveness when SQL exception occurs.

New in Jailer 5.4 (May 24, 2016)

  • Fixed an issue with exporting dependencies of Initial Tables. (thanks to Teddy Widom, https://sourceforge.net/p/jailer/discussion/700499/thread/60e83aef/)
  • -scope "LOCAL_DATABASE" now supports the pseudo-columns $DISTANCE and $IS_SUBJECT.
  • Support for multiple subject-tables has been added.

New in Jailer 5.3.2 (May 7, 2016)

  • Files with ".sql.zip" suffix are no longer created GZIP files but ZIP files.

New in Jailer 5.3.1 (Apr 21, 2016)

  • "Data Export" dialog now have a "Cancel" button.
  • An NPE occurred if the data model is empty.
  • Statistics were collected for the remote database instead for the local when using "-scope LOCAL_DATABASE".

New in Jailer 5.3 (Mar 18, 2016)

  • The Data Browser now offers a "Data Export" feature.

New in Jailer 5.2.1 (Mar 7, 2016)

  • Minor improvements.

New in Jailer 5.2 (Feb 15, 2016)

  • Added "Closure View" and "Closure Border View" tools.

New in Jailer 5.2 RC 1 (Feb 12, 2016)

  • Added "Closure View" and "Closure Border View" tools.

New in Jailer 5.1 (Jan 15, 2016)

  • Better UI and Improved navigation.

New in Jailer 5.0.2 (Jan 15, 2016)

  • Viewing contents of CLOB and XML column types

New in Jailer 5.0.1 (Jan 15, 2016)

  • Unicode support.

New in Jailer 4.3.9 (Jan 15, 2016)

  • don't write empty lob files for liquibase export. (thanks to Jason Pell)

New in Jailer 4.4 (Jan 15, 2016)

  • internal refactorings.

New in Jailer 4.3.8 (Jan 15, 2016)

  • fix for for liquibase BLOB export. (thanks to Jason Pell)

New in Jailer 4.3.7 (Jan 15, 2016)

  • refinements to timestamp, date, time format mask config for liquibase export. (thanks to Jason Pell)

New in Jailer 4.3.6 (Jan 15, 2016)

  • fixed a bug concerning CLOB export in Liquibase format. (thanks to Jason Pell)

New in Jailer 4.3.5 (Mar 16, 2015)

  • added support for ARRAY type.

New in Jailer 4.3.4 (Mar 16, 2015)

  • Workaround for http://bugs.mysql.com/bug.php?id=47108

New in Jailer 4.3.3 (Jan 8, 2015)

  • Fix for http://sourceforge.net/p/dbeauty/tickets/4/

New in Jailer 4.3.2 (Dec 19, 2014)

  • Fix for http://sourceforge.net/p/dbeauty/tickets/3/

New in Jailer 4.3.1 (Oct 18, 2014)

  • Minor bug fixes.

New in Jailer 4.3 (Sep 8, 2014)

  • Data Browser has been improved.
  • Fixed a performance issue related to ResultSet#getMetaData and Postgresql 9.1 JDBC driver.

New in Jailer 4.2.4 (Jul 31, 2014)

  • Added support for postgresql UUID type.

New in Jailer 4.2.3 (Jun 17, 2014)

  • Fixed an incompatibility with Java 8.

New in Jailer 4.2.1 (May 12, 2014)

  • fixed a bug concerning the determination of the universal-primary-key.
  • fixed a bug in file chooser window (thanks to oliver45)

New in Jailer 4.2 (Mar 14, 2014)

  • Added support for Liquibase file format.

New in Jailer 4.1 (Dec 3, 2013)

  • added support for Postgres HStore data type.
  • internal refactorings.

New in Jailer 4.0.18 (Oct 7, 2013)

  • Changed order of which the prolog/epilog files are included into the export script

New in Jailer 4.0.17 (Sep 2, 2013)

  • Workaround for ORA-01424

New in Jailer 4.0.16 (Jun 20, 2013)

  • Added support for Informix's "datetime year to day/month/minute" column type

New in Jailer 4.0.15 (May 23, 2013)

  • Added support for high-resolution mouse-wheels.
  • Added support for Informix nonlogging raw tables

New in Jailer 4.0.14 (Sep 17, 2012)

  • Fixed a bug concerning BLOB/CLOB support for MS SQL

New in Jailer 4.0.13 (Aug 13, 2012)

  • Workaround for ORA-08176.

New in Jailer 4.0.12 (Jul 20, 2012)

  • Fixed a bug where FlatXMLTransformer would produce invalid XML when table names were quoted.

New in Jailer 4.0.11 (Jul 3, 2012)

  • Fix for bug 3536695: "Upserts don't work for certain postgres types (e.g time)"

New in Jailer 4.0.10 (Jun 21, 2012)

  • fixed a bug concerning pre-populated alias fields for tables with quoted names in the QueryBuilder-UI.
  • Minor GUI improvements

New in Jailer 4.0.9 (Jun 9, 2012)

  • improved display-name-concept. Quoted table names will now be displayed unquoted.

New in Jailer 4.0.6 (Mar 7, 2012)

  • Fixed a bug concerning multi-line VARCHARs in DB2.

New in Jailer 4.0.4 (Feb 10, 2012)

  • Support for DB2's FIELD PROCS
  • Fixed a bug concerning NPE on HTML-rendering without a database connection.

New in Jailer 4.0.3 (Dec 28, 2011)

  • Added missing ';' at end of lines in generated delete script on DB2 on Z/OS

New in Jailer 4.0.2 (Dec 16, 2011)

  • Fixed a bug concerning TIMESTAMP pattern in Oracle.

New in Jailer 4.0.1 (Dec 5, 2011)

  • Configurable VARCHAR-length limit. Workaround for Informix JDBC-driver bug.

New in Jailer 4.0 (Dec 2, 2011)

  • Multi data model support.
  • "Subset by Example" feature.
  • Added a second demo-model.
  • Bug fixes.

New in Jailer 3.7.10 (Nov 22, 2011)

  • Fixed a bug concerning appending of layouts in the data browser.
  • Better integration of the closure-border-browser.

New in Jailer 3.7.9 (Nov 18, 2011)

  • Added ability to hide table-browser windows from views.
  • Added ability to append a stored layout.
  • Added context menu for thumbnailed browser windows.
  • Added "Show in New Window" feature.
  • Filter-condition historization.

New in Jailer 3.7.8 (Nov 18, 2011)

  • Fixed a performance issue within the Data Browser.
  • Improved rendering of null values.

New in Jailer 3.7.7 (Nov 14, 2011)

  • Added desktop context menu.
  • Minor GUI improvements.

New in Jailer 3.7.6 (Nov 4, 2011)

  • Border-Browser Feature introduced in data browser.
  • Fixed a bug concerning multi-line VARCHAR content. (Jailer Bug ID: 3432301)

New in Jailer 3.7.5 (Oct 29, 2011)

  • Fixed a bug concerning DATE literals in Oracle, the data browser now uses the "TO_DATE" function to specify the date pattern.
  • Minor GUI improvements.

New in Jailer 3.7.4 (Oct 25, 2011)

  • moves new table browser to center of the desktop.
  • "Reconnect" and "New Window" menu items added.

New in Jailer 3.7.3 (Oct 22, 2011)

  • Java 7 compatibility fix.
  • Desktop dragging.

New in Jailer 3.7.2 (Oct 21, 2011)

  • Data Browser improvements:
  • Tree navigator.
  • Automatic Layouting.
  • Desktop scaling.

New in Jailer 3.7.1 (Oct 18, 2011)

  • Query Builder generated incorrect queries when applied on a restored session. This bug has been fixed.
  • Added Demo Database.

New in Jailer 3.7 (Oct 14, 2011)

  • Implemented the "Subset by Example" feature: Use the Data Browser to collect all the rows to be extracted and let Jailer create a model for that subset.
  • Store/Restore of browser sessions (Feature Request ID: 3176291)

New in Jailer 3.6.12 (Sep 26, 2011)

  • Extended row limits in Data Browser.
  • Reduced memory footprint.

New in Jailer 3.6.11 (Sep 23, 2011)

  • Fixed a bug concerning DATE literals in Oracle, Jailer now uses the "TO_DATE" function to specify the date pattern.
  • Improved Query Builder.

New in Jailer 3.6.10 (Sep 21, 2011)

  • If a table has no primary key, an unique index on non-nullable columns is used as a key instead.

New in Jailer 3.6.9 (Sep 14, 2011)

  • Minor GUI improvements.

New in Jailer 3.6.8 (Sep 12, 2011)

  • Added ability to edit and execute arbitrary SQL statements in Data Browser.

New in Jailer 3.6.7 (Sep 10, 2011)

  • Added ability to edit data by automatically creating SQL/DML statements based on rows (Feature Request [3176294])
  • Improved syntax highlighting.
  • Integrated Schema Mapping Dialog into Data Browser.

New in Jailer 3.6.6 (Aug 31, 2011)

  • Improved schema analyzer.
  • Improved progress view.
  • Added status bar to Data Browser.

New in Jailer 3.6.5 (Aug 23, 2011)

  • Fix for bug [ jailer-Bugs-3394456 ] "IOException: 36 char of CLOB data cannot be read"

New in Jailer 3.6.4 (Aug 5, 2011)

  • Added start scripts for the Data Browser.

New in Jailer 3.6.3 (Jul 18, 2011)

  • Fixed a bug concerning data model changes not affecting table browsers.

New in Jailer 3.6.2 (Jun 22, 2011)

  • Further Data Browser GUI improvements.
  • Minor bug fixes.

New in Jailer 3.6.1 (May 27, 2011)

  • Fix for bug [3308328] "Filter definition updates not correctly detected and saved"
  • Further Data Browser GUI improvements.

New in Jailer 3.6 (May 24, 2011)

  • Integrated Query Builder into Data Browser.
  • Avoid using "TODAY" alias in SQL queries as it is a reserved keyword in H2 DBMS.

New in Jailer 3.5.9 (May 18, 2011)

  • minor GUI improvements.

New in Jailer 3.5.8 (May 3, 2011)

  • bug fix for [ jailer-Bugs-3294893 ] Outer Join for selecting dependant entries and Oracle 10
  • mixing left joins and theta-style joins caused problems on oracle DBMS

New in Jailer 3.5.7 (Apr 27, 2011)

  • Further Data Browser GUI improvements.

New in Jailer 3.5.6 (Mar 10, 2011)

  • Data Browser GUI improvements.

New in Jailer 3.5.5 (Feb 16, 2011)

  • Minor bug fix.

New in Jailer 3.5.4 (Feb 15, 2011)

  • Minor bug fixes and improvements.

New in Jailer 3.5.3 (Feb 3, 2011)

  • Data Browser has been improved.

New in Jailer 3.5.2 (Jan 26, 2011)

  • A data browser has been introduced.

New in Jailer 3.5.1 (Jan 17, 2011)

  • Bug fix: changing the subject table was not possible in version 3.5.

New in Jailer 3.5 (Jan 4, 2011)

  • A Data Browser has been introduced.
  • GUI enhancements.

New in Jailer 3.4.9 (Dec 10, 2010)

  • SQL generator no longer uses the "from DUAL" idiom for single-row inserts on Oracle DBMS.

New in Jailer 3.4.8 (Oct 29, 2010)

  • Bugfix: connections were not always closed properly.

New in Jailer 3.4.7 (Jul 28, 2010)

  • Fixed a bug concerning import of LOB data [3033441]

New in Jailer 3.4.6 (Jul 22, 2010)

  • Added associations list view in closure-browser.

New in Jailer 3.4.5 (Jun 7, 2010)

  • Added dependency cycle analysis feature.
  • Added support for data type 'YEAR' on MySQL.
  • minor bug fixes.

New in Jailer 3.4.4 (May 28, 2010)

  • Added support for SQLite DBMS.

New in Jailer 3.4.3 (May 19, 2010)

  • Added support for SQLite DBMS.
  • Added support for user-defined distinct types.

New in Jailer 3.4.2 (May 4, 2010)

  • Fixed a bug concerning numeric columns with unlimited precision in postgreSQL.
  • Amended configuration for Firebird DBMS.

New in Jailer 3.4.2 Beta (Apr 29, 2010)

  • Fixed a bug concerning numeric columns with unlimited precision in postgreSQL.

New in Jailer 3.4.1 (Mar 24, 2010)

  • Improvements of graphical progress indicator.
  • Support for MySQL string literal escape sequences.
  • Fixed a bug concerning the command line option "working-folder".

New in Jailer 3.4.1 Beta 2 (Mar 19, 2010)

  • Fixed a bug concerning the command line option "working-folder".
  • Support for MySQL string literal escape sequences.
  • Improvements of graphical progress indicator.

New in Jailer 3.4.1 Beta (Mar 16, 2010)

  • Fixed a bug concerning the command line option "working-folder".

New in Jailer 3.4 (Mar 8, 2010)

  • Added graphical progress indicator.
  • Added command line option to set working folder.
  • Added reachability-analysis feature.
  • Internal refactorings.

New in Jailer 3.3 (Feb 23, 2010)

  • Added ability to change the export mode (Insert/Upsert) for each table (via table's context menu)
  • Added support for data type 'GRAPHIC' on DB2 for z/OS.
  • Added ability to define display names for tables. [2946481]
  • Fixed binary format error on MS Sql Server. [2946477]
  • Added support for data type 'TIMESTAMP' on MS Sql Server. [2946477]
  • Added ability to define a placeholder for NULL columns in a DBUnit data set. [2953453]

New in Jailer 3.3 Beta (Feb 9, 2010)

  • Added ability to change the export mode (Insert/Upsert) for each table (via table's context menu)
  • Added support for data type 'GRAPHIC' on DB2 for z/OS.
  • Added ability to define display names for tables. [2946481]
  • Fixed binary format error on MS Sql Server. [2946477]
  • Added support for data type 'TIMESTAMP' on MS Sql Server. [2946477]

New in Jailer 3.2.1 (Dec 10, 2009)

  • Added ability to change XML root tag name.

New in Jailer 3.2 (Nov 11, 2009)

  • Support for XML column type

New in Jailer 3.1.8 (Oct 6, 2009)

  • Fix for bug 2871798 concerning importation of multi line CLOBs.

New in Jailer 3.1.7 (Sep 15, 2009)

  • Fix for bug 2849047 concerning the recognition of identity columns in MS SQL-Server and Sybase.

New in Jailer 3.1.6 (Aug 10, 2009)

  • Prevention of deadlocks during cancellation.

New in Jailer 3.1.3 (Jul 23, 2009)

  • New context menu item "Show associated table".
  • Minor GUI improvements and bug fix

New in Jailer 3.1.2 (Jul 13, 2009)

  • Progress indicator for SQL import tool.
  • Minor GUI improvements.

New in Jailer 3.1.1 (Jul 6, 2009)

  • A new feature for parametrizing filters, XML-templates, restriction conditions and subject conditions has been introduced.
  • GUI support for multi-line conditions and filters.
  • The "Query Builder" allows the user to build SQL queries based on the data model.
  • A bug concerning XML export on windows platform has been fixed.
  • Minor bug fixes.

New in Jailer 3.0 (Jun 26, 2009)

  • extensive internal refactorings
  • GUI improvements
  • Fix: $IS_SUBJECT/$DISTANCE expressions were not always evaluated correctly
  • minor bug fixes

New in Jailer 2.9.10 Beta (Jun 9, 2009)

  • fixed a bug concerning multi-line CLOB content.

New in Jailer 2.9.9 (Jun 3, 2009)

  • added support for MSSQL's identity column type and BIT type.
  • limited the length of lines in SQL export files to 2400 bytes, so that oracle's utility SQLPLUS can be used to import the data.
  • minor bug fixes

New in Jailer 2.9.9 Beta 2 (May 30, 2009)

  • added support for MSSQL's identity column type and BIT type.
  • limited the length of lines in SQL export files to 2400 bytes,
  • so that oracle's utility SQLPLUS can be used to import the data.
  • minor bug fixes

New in Jailer 2.9.9 Beta (May 29, 2009)

  • limited the length of lines in SQL export files to 2400 bytes,
  • so that oracle's utility SQLPLUS can be used to import the data.

New in Jailer 2.9.8 (May 18, 2009)

  • Graph layout is persistent [2787683]
  • Introduced pseudo-columns for each table: $DISTANCE and $IS_SUBJECT (a synonym for $DISTANCE=0), which can be used in restriction conditions

New in Jailer 2.9.8 Beta (May 8, 2009)

  • Graph layout is persistent

New in Jailer 2.9.7 (May 4, 2009)

  • new source-schema-mapping allows the user to specify the schema
  • to export data from
  • added column replacements for PostgreSQL
  • internal refactorings

New in Jailer 2.9.6 (Apr 23, 2009)

  • preserve manually defined keys after re-introspection
  • improvements of data model editor
  • export of BLOB/CLOB data into XML files

New in Jailer 2.9.5 (Apr 15, 2009)

  • allows exportation of the graph as image (File->Export graph as image)
  • allows enlargement of extraction model pane [2738574]
  • added context menu for associations
  • new UI layout (vertical+horizontal)
  • tables without primary keys will no longer be rejected

New in Jailer 2.9.4 (Apr 6, 2009)

  • enhancement of the sorting algorithm, single-row cycles detection
  • fixed compatibility issue with DB2 for z/OS

New in Jailer 2.9.3 Beta (Mar 17, 2009)

  • Implemented column type replacement for DDL generation (beta).

New in Jailer 2.9.2 (Mar 17, 2009)

  • Fixed issue with loading config file on some Windows XP systems

New in Jailer 2.9.1 (Mar 13, 2009)

  • Fixed compatibility issue with Informix 10
  • Fixed issue with '#' character in driver's file name

New in Jailer 2.9.0 (Mar 5, 2009)

  • Added setting for Sybase jConnect 6.0

New in Jailer 2.9.0 Beta (Feb 24, 2009)

  • Added data filtering feature for data anonymization and test data aging.

New in Jailer 2.8.2 (Feb 17, 2009)

  • Support for qualified tables in DbUnit datasets.

New in Jailer 2.8.1 (Jan 30, 2009)

  • Support for MySQL's SET and ENUM column type.

New in Jailer 2.8.0 (Jan 24, 2009)

  • animation step time is configurable
  • support for temporary working tables
  • elimination of DDL statements during export
  • internal refactorings

New in Jailer 2.7.1 (Jan 12, 2009)

  • Sybase compatibility fixes
  • Support for MS SQL's uniqueidentifier type

New in Jailer 2.7.1 Beta 3 (Jan 9, 2009)

  • Added type conversion for Sybase.

New in Jailer 2.7.1 Beta (Jan 7, 2009)

  • Sybase compatibility release (beta)

New in Jailer 2.7.0 (Dec 17, 2008)

  • Support for DbUnit flat dataset format

New in Jailer 2.6.1 (Nov 25, 2008)

  • Support for PostgreSQL types BOOL, BIT, BIT(n), BIT VARYING and unbounded VARCHAR

New in Jailer 2.6.0 (Nov 21, 2008)

  • tables not associated with subject table are rendered italic
  • support for BINARY/RAW column type
  • internal refactorings

New in Jailer 2.5.9 (Nov 19, 2008)

  • workaround for Swing bug
  • minor GUI improvements

New in Jailer 2.5.8 (Nov 12, 2008)

  • rendering of associations' cardinality
  • support for oracle DATE type which contains also time

New in Jailer 2.5.7 (Oct 29, 2008)

  • the primary key of the table JAILER_ENTITY can be generated in a more compact way in order to reduce the risc to exceed the maximum number of parts per key allowed by the DBMS. To enable this feature, set the parameter 'minimize-UPK' to true in 'config/config.xml'

New in Jailer 2.5.6 (Oct 22, 2008)

  • additional type arguments will now be removed from the result of DatabaseMetaData#getColumns (for better compatibility with MS SQL Server)

New in Jailer 2.5.2 (Sep 24, 2008)

  • "show table details" is now initially switched off
  • the focused table is now initially collapsed if it is associated with more than 10 other tables

New in Jailer 2.5.1 (Sep 19, 2008)

  • fixed a bug concerning the introspection of tables which have columns of type NVARCHAR2 or NCHAR.

New in Jailer 2.5.0 (Aug 27, 2008)

  • new dialog "Closure Browser" added which allows the user to browse through the closure of a table
  • Visualization of reversal association's type in tree view
  • "Shortest path" analysis and rendering
  • the 'UPDATE' part of 'UPSERT'-statements in generated SQL-scripts no longer updates primary key columns
  • added context menu item for HTML rendering of tables

New in Jailer 2.4.4 (Aug 19, 2008)

  • improved interaction between the graphical and hierarchical view
  • added predefined setting for Microsoft SQL Server 2005
  • minor bug fixes