Jailer Changelog

What's new in Jailer 4.0.18

Oct 8, 2013
  • The order in which the prolog/epilog files are included into the export script has been changed.

New in Jailer 4.0.16 (Jun 20, 2013)

  • This version adds support for Informix's "datetime year to day/month/minute" column type.

New in Jailer 4.0.15 RC (May 20, 2013)

  • This version adds support for high-resolution mouse wheels and for Informix nonlogging raw tables.

New in Jailer 4.0.12 (Jul 21, 2012)

  • This version fixes a bug which made FlatXMLTransformer produce invalid XML when table names were quoted.

New in Jailer 4.0.10 (Jun 25, 2012)

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

New in Jailer 4.0.7 (May 3, 2012)

  • This version fixes a bug concerning multi-line VARCHARs in Oracle.

New in Jailer 4.0.4 (Feb 11, 2012)

  • Minor bugfixes.

New in Jailer 4.0.2 (Dec 19, 2011)

  • This version fixes a bug concerning a TIMESTAMP pattern in Oracle.

New in Jailer 3.6.10 (Sep 20, 2011)

  • Improved key detection.

New in Jailer 3.6.8 (Sep 13, 2011)

  • This version adds the ability to edit and execute arbitrary SQL statements in the Data Browser, adds the ability to edit data by automatically creating SQL/DML statements based on rows (Feature Request [3176294]), improves syntax highlighting, and integrates the Schema Mapping Dialog into the Data Browser.

New in Jailer 3.6.3 (Jul 19, 2011)

  • A bug concerning data model changes not affecting table browsers was fixed.

New in Jailer 3.6.2 (Jun 22, 2011)

  • A data browser has been introduced.

New in Jailer 3.5.6 (Mar 10, 2011)

  • Data Browser GUI improvements.

New in Jailer 3.5.3 (Feb 7, 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 10, 2011)

  • A data browser has been introduced.
  • Several GUI enhancements were made.

New in Jailer 3.4.6 (Jul 22, 2010)

  • Added an associations list view to the closure browser.

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.3 (Feb 24, 2010)

  • Jailer now supports the DbUnit flat XML dataset file format, thus allowing the users of the famous JUnit extension DbUnit to use the extracted data for unit testing.

New in Jailer 3.1.9 (Oct 12, 2009)

  • The maximum table name length is set to 120 characters.

New in Jailer 3.1.8 (Oct 5, 2009)

  • A bug concerning importation of multi line CLOBs has been fixed.

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)

  • Support for multi-row inserts in oracle.

New in Jailer 3.0 (Jun 24, 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 (Jun 17, 2009)

  • Redesigning of the "connection" dialog [2806688]
  • Fixed a bug concerning multi-line CLOB content.

New in Jailer 2.9.10 Beta 2 (Jun 13, 2009)

  • fixed a bug concerning multi-line CLOB content.

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 3 (Jun 1, 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.8 Beta 2 (May 13, 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 [2787683]

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 21, 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 14, 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 (Apr 1, 2009)

  • implemented column type replacement for DDL generation
  • ordering of rows in DbUnit datasets by primary keys
  • Test Suite added
  • new CLI option '-datamodel' allows to work with multiple data models
  • minor bug fixes

New in Jailer 2.9.3 Beta (Mar 16, 2009)

  • Implemented column type replacement for DDL generation (beta)

New in Jailer 2.9.2 (Mar 16, 2009)

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

New in Jailer 2.9.1 (Mar 12, 2009)

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

New in Jailer 2.9.0 (Mar 3, 2009)

  • added data filtering feature for data anonymization and test data aging [2530625]
  • 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 [2530625].

New in Jailer 2.8.2 (Feb 17, 2009)

  • Support for qualified tables in DbUnit datasets.

New in Jailer 2.8.1 (Jan 29, 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.8.0 Beta (Jan 21, 2009)

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

New in Jailer 2.7.1 (Jan 10, 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 2 (Jan 9, 2009)

  • Support for MS SQL's uniqueidentifier type.

New in Jailer 2.7.1 Beta (Jan 6, 2009)

  • Sybase compatibility release (beta)

New in Jailer 2.7.0 (Dec 15, 2008)

  • support for DbUnit flat dataset format

New in Jailer 2.6.1 (Nov 24, 2008)

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

New in Jailer 2.6.0 (Nov 20, 2008)

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

New in Jailer 2.5.10 Beta (Nov 19, 2008)

  • support for oracle raw type (beta)

New in Jailer 2.5.9 (Nov 18, 2008)

  • workaround for Swing bug 4618607, see http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4618607
  • 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.8 Beta (Nov 5, 2008)

  • support for oracle DATE type which contains also time

New in Jailer 2.5.7 Beta (Oct 22, 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' Currently in beta, needs more test.

New in Jailer 2.5.6 (Oct 20, 2008)

  • Additional type arguments will now be removed from the result of DatabaseMetaData#getColumns (for better compatibility with MS SQL Server).
  • The table name in insert statements for BLOB/CLOBs in generated SQL scripts is now qualified with target schema name.
  • A bug concering the importation of BLOB/CLOBs into non-nullable columns was fixed.
  • The pattern for timestamp values in generated SQL scripts for oracle DBMS is now fixed (using the to_timestamp function).

New in Jailer 2.5.5 (Oct 17, 2008)

  • the table name in insert statements for BLOB/CLOBs in generated SQL scripts is now qualified with target schema name
  • fixed a bug concering the importation of BLOB/CLOBs into non-nullable columns

New in Jailer 2.5.2 (Sep 23, 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 18, 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