Changes Report

Release History

Version Date Description
1.3.3 2008-04-22 Patch release
1.3.2 2008-04-01 Patch release
1.3.1 2008-03-29 Patch release
1.3.0 2008-03-12 A brave new frontier
1.2.0 2008-01-23 New dialects and bug fix release


Release 1.3.3 - 2008-04-22

Type Changes By
fix Remove extra comma in mssql.xml trigger text. Fixes aid=1945207&atid=997724 . chenson42
fix Multi-row updates don't work for the Sql Server Dialect. Fixes aid=1948790&atid=997724 . chenson42
fix Time portion of DATE column not syncing. Fixes aid=1948109&atid=997724 . erilong

Release 1.3.2 - 2008-04-01

Type Changes By
fix Make buildOutgoingBatches use only one connection from the connection pool vs the previous two it used. Fixes aid=1930496&atid=997724 . chenson42
fix Don't put all ACKs in the same transaction. Fixes aid=1929400&atid=997724 . chenson42
fix Introduce a compression filter that does not read an entire stream into memory before compressing. Fixes aid= 1929395&atid=997724 . chenson42
fix Fixed the isInitialLoadComplete JMX method so it works with the new asynchronous reload. Fixes aid=1918310&atid=997724 . chenson42

Release 1.3.1 - 2008-03-29

Type Changes By
fix Queries need to alias columns on PostgreSQL in case reserved words like "limit" are used as a column name. Fixes synchronization for Adempiere. Fixes aid=1924351&atid=997724 . erilong
fix Fixed the PostgreSQL dialect to query for existence of triggers correctly, which was causing it to try creating them on every startup. Fixes aid=1922524&atid=997724 . erilong
fix Fixed the population of the failed_data_id on sym_outgoing_batch_hist, which was always zero. It should link to the sym_data. Fixes aid=1913260&atid=997724 . erilong
fix The oracle dialect should select from user_objects vs. all_objects to determine if the package variable has been installed. Fixes aid=1914242&atid=997724 . chenson42

Release 1.3.0 - 2008-03-12

Type Changes By
add Changed Version.java to reference the pom.properties version that is packaged in the jar during a Maven build. chenson42
add Only log node concurrency rejects every 10 minutes. chenson42
add Log fallback update/deletes at debug level instead of at the warn level. chenson42
add Don't log socket exceptions and HTTP 503 errors as stack traces, instead log as warnings. chenson42
add Make DataService.reloadNode(node_id) transactional. If it isn't we run the risk of inserting only half of an initial load. chenson42
add Added an additional optional properties file that can put in the classpath to override properties values called symmetric-override.properties. chenson42
add Moved channel_id and transaction_id from the data table to the data_event table. It makes it much more efficient to create batches when data is backed up because you don't need to join between data and data_event. chenson42
add Added the configurable number of times to attempt a 'resend' of the 'status' on a pull. chenson42
add Added the removal of all incoming batch rows when reloading a node. This is to prevent the loss of data should the symmetric.runtime.incoming.batches.skip.duplicates property be set to true. chenson42
add Made the purge of incoming and outgoing batches exclusive. Also made sure if one fails, the other will still be able to run. chenson42
add Make the AbstractJob configurable so that it can reschedule itself. If we do this, then we get natural randomness in the push, pull cycles. kbajaj01
fix Transaction ids can be interleaved by different processes. The batching algorithm needs to take this into account. Also, cap the max number of batches that can be sent per channel in one sweep. chenson42
fix We had a few places where we were not closing Statements and ResultSets. chenson42
fix Fixed integrity violation when updating a primary key with an empty value between database systems that handle char padding differently Fixes aid=1891508&atid=997724 . erilong
fix Fixed SafetySwitch error when parsing large columns Fixes aid=1903641&atid=997724 . erilong
fix Fixed cross schema trigger creation for PostgreSQL Fixes aid=1903635&atid=997724 . erilong
add reloadTable() JMX function to delete and reload a table for a node Fixes aid=1903649&atid=997727 . erilong
add Timings for network, filter, and database on incoming batches. Fixes aid=190874&atid=997727 . erilong
add Addition of optional compression on push. Fixes aid=1861766&atid=997727 . erilong
fix Case sensitive schema and table names on MySQL for Unix Fixes aid=1907627&atid=997724 . erilong
fix Extract can send batches out of order when channel is in error Fixes aid=1907658&atid=997724 . erilong

Release 1.2.0 - 2008-01-23

Type Changes By
add Add support to auto create the tables that are being synced Fixes atid=997727&aid=1825801 . erilong
add Implement the HSQLDB Dialect Fixes atid=997727&aid=1861088 . chenson42
add Implement the Apache Derby Dialect Fixes atid=997727&aid=1825799 . erilong
add Make the concurrent worker count by servlet instead of across all servlets Fixes atid=997727&aid=1877262 . chenson42
add Support the automatic detection of http compression Fixes atid=997727&aid=1861764 . chenson42
add Add support for automatically sending initial load Fixes atid=997727&aid=1852586 . erilong
add Add cluster support by providing a ClusterService Fixes atid=997727&aid=1851161 . chenson42
add Add promiscuous registration mode Fixes atid=997727&aid=1851159 . erilong
add Add curTriggerValue variable for use in sym_trigger definitions Fixes atid=997727&aid=1849379 . chenson42
fix To many data events can be purged in the same transaction Fixes atid=997724&aid=1861090 . chenson42
fix SQL Server Initial Load broke when 'text' fields are used Fixes atid=997724&aid=1858083 . chenson42
fix The JMX showBatch and writeBatchRangeToFile broken in 1.1 Fixes atid=997724&aid=1854418 . erilong
fix Trigger name is too long ... Fixes atid=997724&aid=1851065 . chenson42
fix To many data events can be purged in the same transaction Fixes atid=997724&aid=1861090 . chenson42
fix Don't output a WARN if the sync_url is null Fixes atid=997724&aid=1849767 . chenson42
fix Bug introduced in refactoring of SqlScript Fixes atid=997724&aid=1849763 . chenson42