Jailer Changelog

New in version 4.0.18

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

New in version 4.0.16 (June 20th, 2013)

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

New in version 4.0.15 RC (May 20th, 2013)

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

New in version 4.0.12 (July 21st, 2012)

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

New in version 4.0.10 (June 25th, 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 version 4.0.7 (May 3rd, 2012)

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

New in version 4.0.4 (February 11th, 2012)

  • Minor bugfixes.

New in version 4.0.2 (December 19th, 2011)

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

New in version 3.6.10 (September 20th, 2011)

  • Improved key detection.

New in version 3.6.8 (September 13th, 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 version 3.6.3 (July 19th, 2011)

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

New in version 3.6.2 (June 22nd, 2011)

  • A data browser has been introduced.

New in version 3.5.6 (March 10th, 2011)

  • Data Browser GUI improvements.

New in version 3.5.3 (February 7th, 2011)

  • A data browser has been introduced.

New in version 3.5.1 (January 17th, 2011)

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

New in version 3.5 (January 10th, 2011)

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

New in version 3.4.6 (July 22nd, 2010)

  • Added an associations list view to the closure browser.

New in version 3.4.1 (March 24th, 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 version 3.3 (February 24th, 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 version 3.1.9 (October 12th, 2009)

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

New in version 3.1.8 (October 5th, 2009)

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

New in version 3.1.2 (July 13th, 2009)

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

New in version 3.1.1 (July 6th, 2009)

  • Support for multi-row inserts in oracle.

New in version 3.0 (June 24th, 2009)

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

New in version 2.9.10 (June 17th, 2009)

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

New in version 2.9.10 Beta 2 (June 13th, 2009)

  • fixed a bug concerning multi-line CLOB content.

New in version 2.9.10 Beta (June 9th, 2009)

  • Fixed a bug concerning multi-line CLOB content.

New in version 2.9.9 (June 3rd, 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 version 2.9.9 Beta 3 (June 1st, 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 version 2.9.9 Beta 2 (May 30th, 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 version 2.9.8 Beta 2 (May 13th, 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 version 2.9.8 Beta (May 8th, 2009)

  • Graph layout is persistent [2787683]

New in version 2.9.7 (May 4th, 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 version 2.9.6 (April 21st, 2009)

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

New in version 2.9.5 (April 14th, 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 version 2.9.4 (April 6th, 2009)

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

New in version 2.9.3 (April 1st, 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 version 2.9.3 Beta (March 16th, 2009)

  • Implemented column type replacement for DDL generation (beta)

New in version 2.9.2 (March 16th, 2009)

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

New in version 2.9.1 (March 12th, 2009)

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

New in version 2.9.0 (March 3rd, 2009)

  • added data filtering feature for data anonymization and test data aging [2530625]
  • added setting for Sybase jConnect 6.0

New in version 2.9.0 Beta (February 24th, 2009)

  • added data filtering feature for data anonymization and test data aging [2530625].

New in version 2.8.2 (February 17th, 2009)

  • Support for qualified tables in DbUnit datasets.

New in version 2.8.1 (January 29th, 2009)

  • Support for MySQL's SET and ENUM column type

New in version 2.8.0 (January 24th, 2009)

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

New in version 2.8.0 Beta (January 21st, 2009)

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

New in version 2.7.1 (January 10th, 2009)

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

New in version 2.7.1 Beta 3 (January 9th, 2009)

  • added type conversion for Sybase

New in version 2.7.1 Beta 2 (January 9th, 2009)

  • Support for MS SQL's uniqueidentifier type.

New in version 2.7.1 Beta (January 6th, 2009)

  • Sybase compatibility release (beta)

New in version 2.7.0 (December 15th, 2008)

  • support for DbUnit flat dataset format

New in version 2.6.1 (November 24th, 2008)

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

New in version 2.6.0 (November 20th, 2008)

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

New in version 2.5.10 Beta (November 19th, 2008)

  • support for oracle raw type (beta)

New in version 2.5.9 (November 18th, 2008)

  • workaround for Swing bug 4618607, see http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4618607
  • minor GUI improvements

New in version 2.5.8 (November 12th, 2008)

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

New in version 2.5.8 Beta (November 5th, 2008)

  • support for oracle DATE type which contains also time

New in version 2.5.7 Beta (October 22nd, 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 version 2.5.6 (October 20th, 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 version 2.5.5 (October 17th, 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 version 2.5.2 (September 23rd, 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 version 2.5.1 (September 18th, 2008)

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

New in version 2.5.0 (August 27th, 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