SymmetricDS Changelog

New in version 3.7.22

September 15th, 2015
  • 0002393: [Bug] NVARCHAR limit on SQL Server is a size of 4000 (chenson) - resolved.

New in version 3.7.21 (September 15th, 2015)

  • 0002388: [Bug] SQLServer 2008 does not correctly create remote tables with fields of type nvarchar(max) (chenson) - resolved.
  • 0002392: [Bug] SqlScriptReader has a bug where if multiline literals in a statement have a comment at the end of the line, the comment is lost (chenson) - closed.
  • 0001575: [New Feature] Offline data synchronization (elong) - closed.
  • 0002368: [Bug] Null key value causes additive transform not to work (chenson) - closed.
  • 0002374: [Bug] Memory being held up un-necessarily in StagingManager and StagedResource (chenson) - closed.
  • 0002376: [Improvement] Add MSSQL 2008 type for datetimeoffset (chenson) - closed.
  • 0002377: [Bug] SQLServer 2008 does not correctly create remote tables with fields of type varbinary(max) (chenson) - closed.
  • 0002378: [Improvement] Protect against duplicate sym_data_gap entries (chenson) - closed.
  • 0002379: [Improvement] Expose access to the SymmetricEngineHolder from the ServerSymmetricEngine (chenson) - closed.
  • 0002383: [Bug] Audit Table Router does not handle column name case sensitivity for SQL Server (josh-a-hicks) - closed.
  • 0002385: [Improvement] No need to create functions and enable and disable triggers on greenplum where triggers are not supported (chenson) - closed.
  • 0002386: [Improvement] Add logging of data rows that failed to load for the oracle bulk loader (chenson) - closed.
  • 0002387: [Improvement] Make oracle.bulk.load.max.rows.before.flush so that it does not require a restart (chenson) - closed.
  • 0002389: [Improvement] Make sym_node.external_id bigger. Support an of up to 255 characters. (chenson) - closed.
  • 0002390: [Bug] Prevent the extract in background job from going into an endless loop if request extracting takes more than 30 seconds (chenson) - closed.
  • 0002391: [Bug] File sync hangs forever when the tracker job breaks a hung shared lock (chenson) - closed.

New in version 3.7.20 (August 9th, 2015)

  • [Improvement] set as the default setting (chenson) - resolved.
  • [Improvement] Don't select row_data, old_data or pk_data when routing if only default routers are assigned (chenson) - resolved.
  • [Improvement] Upgrade Jetty to version 9.2.11.v20150529 (chenson) - resolved.
  • [Improvement] Bump up the default amount of memory from 256 to 1024 (chenson) - resolved.
  • [Improvement] There should be foreign keys from file_trigger to channel (chenson) - resolved.
  • [Improvement] Don't use 503 when SymmetricDS is unavailable as some proxies return that as well. (chenson) - resolved.
  • [Improvement] Return different error codes for when an engine is stopped or starting versus the server is too busy (chenson) - resolved.
  • [Improvement] Don't route sym_parameter changes if the parameter change is a local change (chenson) - resolved.

New in version 3.7.19 (May 31st, 2015)

  • 0002308: [Bug] Bsh variables were removed from bsh column transform accidentally. Readding support (chenson) - closed.
  • 0002306: [Improvement] Add a trim() column transform (chenson) - closed.
  • 0002307: [Bug] Outgoing batches are missing the sql message sometimes (chenson) - closed.

New in version 3.7.18 (May 28th, 2015)

  • 0002302: [Bug] AckUriHandler has an incorrect Comparator code (chenson) - closed.
  • 0002305: [New Feature] Add new extension point that allows batches to be filtered prior to sending them (chenson) - closed.

New in version 3.7.17 (May 18th, 2015)

  • 0002301: [Bug] If an incoming batch is marked as IG when it is loading and the batch fails, then the IG status is lost (chenson) - closed.
  • 0002299: [Bug] Deadlock for additive transform. It should use the same transaction that the default writer uses. (chenson) - closed.
  • 0002290: [Bug] Postgres bulk writer throws a null pointer error versus logging what is going on when the target table cannot be found (chenson) - closed.
  • 0002293: [Bug] sym_node_group_channel_wnd functionality is broken (chenson) - closed.
  • 0002294: [Improvement] Improve the bean shell database filter. pk data should be bound on deletes. (chenson) - closed.

New in version 3.7.16 (May 2nd, 2015)

  • 0002289: [Improvement] When a node is removed, clear out its sym_incoming_batch table (versus just setting batches to OK) (chenson) - resolved.
  • 0002288: [Bug] The file directory listing in the snapshot is inaccurate (chenson) - resolved.
  • 0002287: [Bug] Multiplier transform isn't working (chenson) - resolved.
  • 0002285: [Improvement] Slight performance improvement in reading table metadata on Firebird (chenson) - resolved.

New in version 3.7.15 (April 24th, 2015)

  • 0002282: [Improvement] Add create.table.without.foreign.keys setting that prevents foreign keys to be create on target databases (chenson) - closed.
  • 0002279: [Bug] Fix misleading warning. "None of the target nodes specified in the data.node_list field ({}) were qualified nodes" (chenson) - closed.
  • 0002273: [Bug] Auto calculate of number of required batches an extract in background extract should use the initial load select (chenson) - closed.
  • 0002277: [Improvement] Don't log a warning when there is a missing column data for a transform due to a delete when capture old data is turned off (chenson) - closed.

New in version 3.7.14 (April 17th, 2015)

  • 0002265: [Bug] Xml Publisher fails when delete comes through. Null Pointer Exception. (chenson) - closed.
  • 0002270: [Improvement] Log when an initial load or reverse initial load is queued up (chenson) - closed.
  • 0002274: [Bug] If a row is marked as IG and an ACK comes in with an ER status the IG status is overwritten (chenson) - closed.
  • 0002275: [Bug] Common batch mode not detected if trigger router is defined that does not use the default router and is on the same link (chenson) - closed.

New in version 3.7.13 (April 11th, 2015)

  • 0002263: [Bug] Trigger is not able to be created (chenson) - closed.

New in version 3.7.12 (April 6th, 2015)

  • 0002245: [Bug] Column match router should not do work during initial load if initial load select is used (chenson) - closed.
  • 0002249: [Bug] Alter script broken on Sybase ASE because SqlScript parser leaves ; in the script (chenson) - closed.
  • 0002251: [Improvement] If the ack response does not come back with a 200 error code, the throw an error. Before we looked for only 4 error codes. (chenson) - closed.
  • 0002252: [Improvement] Re-add a buffer flush at the end of a push and at the end of a file push. (chenson) - closed.

New in version 3.7.11 (March 30th, 2015)

  • 0002237: [Improvement] Add new auto.sync.triggers.after.config.loaded property that allows sync triggers to be turned on on client when config changes (chenson) - closed.
  • 0002238: [Bug] Router service fails due to Syntax error (chenson) - closed.
  • 0002239: [Bug] The xml publisher removes '-' from the key data so 'This is a test" and 'This-is-a-test' are equivalent. This is wrong. (chenson) - closed.
  • 0002241: [Bug] Routing fails with null pointer exception (NPE) (elong) - closed.
  • 0002242: [Bug] SQL Server fails to create triggers (chenson) - closed.

New in version 3.7.10 (March 18th, 2015)

  • 0002217: [Bug] Android zip contains superflous slf4j jars (chenson) - closed.
  • 0002231: [Bug] ; in sql scripts in sql content aren't properly parsed (chenson) - closed.
  • 0002232: [Bug] Insert fails due to error in Trigger (chenson) - closed.

New in version 3.7.9 (March 7th, 2015)

  • 0002230: [Bug] HSQLDB ddl builder doesn't creates a varbinary instead of a blob when the type in xml is blob (chenson) - closed.
  • 0002216: [Bug] Replication of rows with NULL in large object column on PostgreSQL throws exception (chenson) - closed.
  • 0002219: [Bug] When Primary key is binary; SymmetricDS fails capture changes. (chenson) - closed.
  • 0002222: [Bug] BSH transform context variables overwrite column variables (elong) - closed.
  • 0002223: [Bug] platform should pass in setting for whether to use autocommit for ddl in createDatabase and dropDatabase. (chenson) - closed.
  • 0002224: [Bug] When calling symadmin open-regsitration only works for the first two nodes with the same id (chenson) - closed.
  • 0002225: [Bug] JMX method openRegistration should behave like the command line openRegistration command (chenson) - closed.
  • 0002226: [Bug] Sql Server 2000's default schema is the user. We had hardcoded dbo as the schema which only worked for dbowner accounts (chenson) - closed.
  • 0002227: [Bug] Initial load create first does not support the creation of REAL columns for sqlite (chenson) - closed.

New in version 3.7.8 (February 25th, 2015)

  • 0002210: [Bug] You should be able to request an initial load from a server by setting the initial_load_enabled flag on the client node. (chenson) - closed.
  • 0002211: [Improvement] Don't insert file sync initial load batch if there are no file trigger routers configured (chenson) - closed.
  • 0002212: [Bug] getOutgoingBatchStatus only returns pending batches for one status. It should return multiple summaries. (chenson) - closed.
  • 0002213: [Bug] Missing space in ORDER BY CLAUSE (chenson) - closed.

New in version 3.7.7 (February 18th, 2015)

  • 0002205: [Bug] Subselect router arguments are encoded on reload (chenson) - closed.
  • 0002191: [Bug] Unrouted batches end up with a status of NE and never get purged (chenson) - closed.
  • 0002192: [Bug] Conflict resolution of FALLBACK transforms update to insert although row exists (chenson) - closed.
  • 0002193: [Improvement] Only run the check for abandoned batches check once after the server starts, not everytime we route (chenson) - closed.
  • 0002194: [Bug] postgres geometry types broken by issue 1996 (chenson) - closed.
  • 0002196: [Improvement] Bsh Data Router: Bind in nodeIds for nodes that would normally be routed to. Useful for implementing default behavior. (chenson) - closed.
  • 0002197: [Bug] Right before a node loads registration configuration, clear out sym_data on the config channel (chenson) - closed.
  • 0002200: [Bug] Microsoft JDBC maps nvarchar(max) and varchar(max) to a varchar with a size. Should be mapped to a longvarchar or longnvarchar. (chenson) - closed.

New in version 3.7.5 (February 6th, 2015)

  • 0002173: [Improvement] "arithmetic exception, numeric overflow, or string truncation" on firebird due to row_data being > 10k. Log a better error msg. (chenson) - closed.
  • 0002174: [Bug] Redshift Bulkloader - S3 regions that require v4 of the authentication protocol get an error (chenson) - closed.
  • 0002175: [Improvement] Package jt400 ibm as400/iSeries jar file with SymmetricDS (chenson) - closed.
  • 0002176: [Bug] iSeries - Any tools that insert into sym_data cause errors because of invalid query to lookup last identity record (chenson) - closed.
  • 0002177: [Bug] When a case sensitive collation is used on sql server alters to prevent page lock escalation fail with a warning (chenson) - closed.
  • 0002178: [Improvement] Allow the use of wildcards in catalog and schema for load filters (chenson) - closed.

New in version 3.7.4 (February 2nd, 2015)

  • 0002172: [Bug] Ignore case not working due to bug in ignore case feature for schema and catalog in table lookup (chenson) - closed.

New in version 3.7.3 (January 29th, 2015)

  • 0002152: [Bug] DDL errors on DB2 i5 AS/400 (elong) - closed.
  • 0002124: [Improvement] Support foreign keys in ddl builder for sqlite (chenson) - closed.
  • 0002148: [Bug] When checking for gap expiration compare data create times against the database time, not against the symmetric server time (chenson) - closed.
  • 0002155: [Improvement] Reduce updates to sym_node_communication (chenson) - closed.
  • 0002158: [Improvement] Snapshot util should just package up all files with the .log extension in the log directory (chenson) - closed.
  • 0002159: [Improvement] Add database time and server time to support snapshot (chenson) - closed.
  • 0002161: [Improvement] Interrupt working threads when a symmetric engine is stopped. Also check for interrupted threads when processing data. (chenson) - closed.
  • 0002163: [Bug] Configured extension with a node group id of ALL is not working (chenson) - closed.

New in version 3.7.2 (January 20th, 2015)

  • 0002135: [Bug] bsh column transform can pick up source columns from previous tables in the batch (chenson) - closed.
  • 0002136: [Bug] Changing a primary key with an implied transform does not work (chenson) - closed.
  • 0002139: [Improvement] Log original conflict error message if available. Makes it easier to identify root cause conflict issues. (chenson) - closed.
  • 0002144: [Improvement] When transformed data is retransformed it should only try to match the key values if more than one transformed data is returned (chenson) - closed.
  • 0002145: [Improvement] Do a better job of table lookup when case is suppose to be ignored. Lookup across catalogs and schemas is now case insensitive (chenson) - closed.
  • 0002147: [Improvement] Add validation and better error message if the parsed tokens doesn't match the column count of the last parsed table (chenson) - closed.

New in version 3.7.1 (January 14th, 2015)

  • 0002127: [Bug] Tinyint is 0 to 255 on Sql Server. JTDS treats it as -128 to 127. The driver throws an error for values > 127. (chenson) - closed.
  • 0002133: [Bug] SQL Anywhere capturing wrong date format (elong) - closed.

New in version 3.7.0 (January 7th, 2015)

  • 0001756: [Bug] dbimport doesn't handle relative pathnames (elong) closed.
  • 0001952: [Bug] NullPointerException when setting replication for an unsupported table in PostgreSQL (chenson) closed.
  • 0000043: [New Feature] Expressions for target_schema_name (elong) closed.
  • 0001621: [Improvement] Move SymmetricDS to Gradle (chenson) closed.
  • 0001650: [New Feature] Reverse initial load with symadmin (elong) closed.
  • 0001828: [Improvement] Update jTDS driver from 1.2.4 to 1.2.8 (chenson) closed.
  • 0001970: [Improvement] Valuemap transform syntax for passing values through (elong) closed.
  • 0002020: [Bug] Log4j cannot be configured to send errors by email (chenson) closed.
  • 0002040: [Improvement] Can't set windows service dependencies in sym_service.conf (elong) closed.
  • 0002047: [Improvement] Add extension service that can read extensions from database (elong) closed.
  • 0002048: [Improvement] Option for delayed start of Windows service (elong) closed.
  • 0002050: [Bug] dropping a table before dropping trigger causes NPE (chenson) closed.
  • 0002057: [Improvement] The sync triggers cluster lock is being grabbed every ten seconds (so initial load events are not inserted during trigger sync) (chenson) closed.
  • 0002060: [Improvement] We currently log data sent and received from jobs at INFO level. Do the same from the server side. (chenson) closed.
  • 0002063: [Improvement] Remove the getName() method from the IColumnTransform interface (chenson) closed.
  • 0002067: [Bug] Snapshot fails when run on nodes that are not registered (chenson) closed.
  • 0002092: [Bug] Should be able to remove mongo and amazon jar files and the application should still work (chenson) closed.
  • 0002102: [Improvement] Remove double logging of exception messages to improve log readability (chenson) closed.
  • 0002108: [Improvement] Add processinfo to track when symmetricds is "inserting load events" on the route job thread (chenson) closed.
  • 0002114: [Improvement] Upgrade sqlite jdbc library version to latest version (chenson) closed.
  • 0002115: [Bug] Stream lobs doesn't work with tables in a different schema when router.use_source_catalog_schema is set to 0 (chenson) closed.
  • 0002119: [Bug] common batch mode incorrectly detected if a table syncs bidirectionally on different channels (chenson) closed.
  • 0002122: [Improvement] Remove deprecated Data Gap Purge Job (chenson) closed.
  • 0002088: [Bug] The addition of a new symds configuration table makes registration incompatible with previous versions (chenson) closed.
  • 0002109: [Bug] Trigger creation fails on Sybase ASE database for CLOB,BLOB,BINARY,VARBINARY,LONGBINARY (chenson) closed.

New in version 3.6.17 (December 26th, 2014)

  • 0002078: [Bug] Service wrapper unsatisfied link error (elong) - closed.
  • 0002090: [Bug] Informix installations fail when existing SymmetricDS tables exist due to case sensitive comparisons (chenson) - closed.
  • 0002094: [Bug] Row deletion is not synced if table has conflict resolution by timestamp (chenson) - closed.
  • 0002100: [Bug] getChannelStatus REST call is broken (chenson) - closed.
  • 0002101: [Improvement] Add a property that instructs symmetricds to use PK from target tables when creating update and delete statements (chenson) - closed.
  • 0002103: [Bug] Create table to check and allow for identity columns that are not part of PK. (josh-a-hicks) - closed.
  • 0002104: [Improvement] Add feature to turn off the use of default values in the create schema first feature (chenson) - closed.
  • 0002105: [Bug] Error code 2601 on Sql Server should be treated like other unique constraint errors (chenson) - closed.
  • 0002107: [Bug] Initial load extract in background can fail when purge is set aggressively (chenson) - closed.
  • 0002109: [Bug] Trigger creation fails on Sybase ASE database for CLOB,BLOB,BINARY,VARBINARY,LONGBINARY (chenson) - closed.
  • 0002110: [Bug] On firebird ddl fails if table column switches from NOT NULL to NULLABLE (chenson) - closed.
  • 0002111: [Improvement] When big transactions are interspersed routing requires a lot of memory which can result in OOM errors (chenson) - closed.
  • 0002112: [Bug] When lots of unrouted data exists with small transactions, the peek ahead queue can get big and cause out of memory errors (chenson) - closed.
  • 0002113: [Bug] sqlite trigger fails to capture data when a blank string is inserted into a datetime field (chenson) - closed.

New in version 3.6.15 (December 5th, 2014)

  • 0002087: [Bug] Extract initial load in background doesn't work with wildcard catalogs and schemas (chenson) - closed.

New in version 3.6.13 (November 10th, 2014)

  • 0002052: [Bug] Remove transform when used on a primary key without the pk column checked fails (chenson) - closed.
  • 0002053: [Bug] Fallback to insert fails when transform is configured as update first on the LOAD side. Data is retransformed as an update. (chenson) - closed.
  • 0002054: [Bug] NullPointerException happens during file sync pull (chenson) - closed.
  • 0002059: [Improvement] Do not blindly update outgoing batch where status = RT at start of routing. Select first to see if the update is needed. (chenson) - closed.

New in version 3.6.11 (October 27th, 2014)

  • 0002009: [Bug] Java column transform cannot compile inner classes (elong) - closed.
  • 0002027: [Bug] Firebird detection of auto increment columns should look for existence of trigger, not the generator itself (chenson) - closed.
  • 0001286: [Bug] Failed to create trigger when table contains timestamp with time zone column in Oracle (chenson) - closed.
  • 0002010: [Bug] Initial load failing on Firebird because of "Implementation limit exceeded. Block size exceeds implementation restriction" (chenson) - closed.
  • 0002011: [Improvement] Automatically handle conversion from Time to Timestamp during data load (chenson) - closed.
  • 0002014: [Bug] Stopping service from sym_service on Windows does not stop wrapper (elong) - closed.
  • 0002016: [Bug] On some platforms (sybase) sql fails when numeric column names are used in the where clause of initial load sql (chenson) - closed.
  • 0002017: [Improvement] Log the DDL that installs functions required for SymmetricDS as it is being installed (similar to the way we log table DDL) (chenson) - closed.
  • 0002018: [Improvement] Translate sql server's getdate() function to current_timestamp when used as a default value in building ddl for other platforms (chenson) - closed.
  • 0002022: [Improvement] Add which allows the options to be passed to the copy command for the red shift bulk loader (chenson) - closed.
  • 0002023: [Bug] bsh router is broken when capture old data is turned off (chenson) - closed.
  • 0002024: [Bug] Should not have to specify properties file for symadmin command if only one properties file exists (chenson) - closed.

New in version 3.6.9 (September 30th, 2014)

  • 0001942: [Bug] PostGIS initial load fails unless you set (chenson) - closed.
  • 0001969: [Bug] Integer conversion between Oracle and PostgreSQL maps to wrong type (chenson) - closed.
  • 0001977: [Bug] The bean shell router swallows errors and does not route the data (chenson) - closed.
  • 0001978: [Bug] NullPointerException in ColumnsToRowsValueColumnTransform (chenson) - closed.
  • - 0001979: [Bug] Broken replication on tables with uuid field (chenson) - closed.
  • 0001980: [Improvement] Report script line number for bsh transforms and bsh routers (chenson) - closed.
  • 0001983: [Improvement] Better document reverse initial load (chenson) - closed.
  • 0001984: [Bug] Wrong key values can be returned when load transforms don't put keys at beginning of transform list (chenson) - closed.
  • 0001986: [Improvement] REST call for reading parameters (elong) - closed.
  • 0001987: [Improvement] Add extension for filtering parameters as they are saved (elong) - closed.
  • 0001988: [Bug] Default values for ARRAY types on Postgres cause create tables to fail (chenson) - closed.
  • 0001989: [Bug] Switching cluster locks off causes initialization error (elong) - closed.
  • 0001993: [Improvement] Add support for composite data types in postgres (chenson) - closed.
  • 0001994: [Bug] Time columns in postgres should be captured as time only. Date is currently captured which breaks the postgres bulk loader (chenson) - closed.
  • 0001996: [Improvement] Support JSON data type. Map all Types.OTHER to LONGVARCHAR for Postgres. (chenson) - closed.
  • 0001991: [Improvement] Allow override of startup parameters (elong) - closed.

New in version 3.6.8 (September 18th, 2014)

  • 0001950: [Bug] Reinsert of sym_data_gap after it has been purged can fall outside of captured sym_data range (chenson) closed.
  • 0001953: [Bug] Transform column value to NULL removes column (chenson) closed.
  • 0001959: [Improvement] Add feature where character data can be modified by an property expression in order to support "weird" character issues (chenson) closed.
  • 0001961: [Bug] Routing does not stop when sym_channel.max_data_to_route is reached and batch_algorithm is set to nontransactional (chenson) closed.
  • 0001962: [Bug] Log the actual values that were passed to prepared statement in the default data loader (currently logs those passed in csv) (chenson) closed.
  • 0001963: [Bug] Memory issue on nontransactional channel during routing (chenson) closed.
  • 0001964: [Bug] Upgrade from 3.1.5 to 3.6 fails on MySQL (chenson) closed.
  • 0001965: [Bug] Initial load uses wrong case on Oracle to PostgreSQL table creation. (chenson) closed.
  • 0001966: [Improvement] Add better logging when a subselect router query fails. Log table and event for which the query failed. (chenson) closed.
  • 0001968: [Bug] Oracle LONG types don't work when stream_to_lob is turned on (chenson) closed.
  • 0001971: [Bug] Missing AWS java SDK needed for Redshift bulk load (elong) closed.
  • 0001973: [Bug] Use LSB-compliant dependency in init script (elong) closed.
  • 0001974: [Bug] fallback to update fails with implied load transform that adds to pk (chenson) closed.
  • 0001975: [Bug] Push service continues to quickly attempt to push data on failure to read ack condition during initial load (chenson) closed.

New in version 3.6.7 (September 3rd, 2014)

  • 0001940: [Bug] On MySQL sym_transaction_id_post_5_1_23 function should not be checking the autocommit session variable (chenson) - closed.
  • 0001946: [Bug] ConcurrentModificationException due to timing issue in OutgoingBatchService (chenson) - closed.

New in version 3.6.6 (August 27th, 2014)

  • 0001920: [New Feature] Redshift database dialect (elong) resolved.
  • 0001869: [Bug] The symmetric wrapper kills the process when an OOM error occurs before the heap can be dumped (elong) closed.
  • 0001907: [Improvement] Add the ability to republish xml messages via jmx (chenson) closed.
  • 0001910: [Bug] Too many connections when network environment is bad. Bug in DBCP. (chenson) closed.
  • 0001917: [Improvement] SymmetricDS should find tables in schemas and catalogs other than the default schema/catalog when schema/catalog is left blank (chenson) closed.
  • 0001921: [Bug] While sending a batch, if a batch is set to IG and an error occurs, then the batch gets set to ER and the IG status is ignored (chenson) closed.
  • 0001922: [Bug] Incorrect conversion of values of type BIT in SQL Server 2005 to SQLite (chenson) closed.
  • 0001925: [Bug] Send Table Schema uses cached tables (chenson) closed.
  • 0001926: [Improvement] Add that when set will truncate data to fit in the target column (chenson) closed.
  • 0001929: [Bug] Routing reader can get stuck if an Error is thrown during the close of the read cursor (chenson) closed.
  • 0001930: [Bug] Upgrade from 3.5 to 3.6 of Sybase ASA fails (chenson) closed.
  • 0001935: [Improvement] Upgrade mongodb java client (chenson) closed.
  • 0001938: [Improvement] Add the ability to copy a node to a new node id (chenson) closed.

New in version 3.6.5 (August 12th, 2014)

  • 0001668: [Bug] PostGIS Spatial data replication fails with SRID problem (chenson) - closed.
  • 0001860: [Bug] symmetric-wrapper should not include the version number, otherwise the service needs to be reinstalled on each upgrade (elong) - closed.
  • 0001868: [Bug] Introduce a more accurate way to get a machine's hostname (chenson) - closed.
  • 0001870: [Improvement] Include directory listing of symmetricds installation in snapshot (chenson) - closed.
  • 0001873: [Bug] Control Center doesn't start on Windows if not Administrator (elong) - closed.
  • 0001875: [Improvement] Add extensions.xml property which can be used to configure symmetric extensions (like jms) via database configuration (chenson) - closed.
  • 0001877: [Bug] Process status can be stranded in non-ok or non-error status on pull if an io expection occurs in the uri handler (chenson) - closed.
  • 0001879: [Bug] Database upgrade fails on sql server because drop index doesn't allow database name in the ddl (chenson) - closed.
  • 0001881: [Bug] MS Azure does not support the sysconstraints view (chenson) - closed.
  • 0001886: [Bug] SymmetricDS upgrade on Azure fails. (chenson) - closed.
  • 0001887: [Bug] http.concurrent.workers.max doesn't prevent the same node from over pulling on itself (chenson) - closed.
  • 0001888: [Improvement] Improve stagedresource (chenson) - closed.
  • 0001889: [Improvement] Add reverse version of initial load before/after sql (elong) - closed.
  • 0001892: [Bug] New version of Postgis fails to replicate (chenson) - closed.
  • 0001893: [Improvement] Log information about failed column transform to make it easier to debug transforms (chenson) - closed.
  • 0001894: [Improvement] Make lookup transform column names case insensitive when used as named parameters in sql (chenson) - closed.
  • 0001895: [Improvement] Add support for token replacement for $(sourceCatalogName) and $(sourceSchemaName) in lookup table transform (chenson) - closed.

New in version 3.6.4 (August 4th, 2014)

  • 0001852: [Bug] When a table has multiple transforms, the order of execution should be reversed when a delete comes through the system (chenson) - closed.
  • 0001853: [Improvement] Clear staging if transformation changes come through the data loader or data router (chenson) - closed.
  • 0001856: [Bug] Bsh variables for transformedData and transformColumn not being updated (elong) - closed.
  • 0001857: [Bug] Initial load is broken for the master to master sync scenario (chenson) - closed.
  • 0001859: [Improvement] Document that a -1 node id in outgoing batch means that the batch was unrouted (chenson) - closed.
  • 0001863: [Bug] Triggers get blown away when saving a link for an individual table. broke with 0001827 fix (chenson) - closed.

New in version 3.6.3 (July 30th, 2014)

  • 0001845: [Bug] The transaction id for sybase ase isn't always unique (chenson) closed.
  • 0001846: [Improvement] Update router helper methods that get column values use a case insensitive map (chenson) closed.
  • 0001805: [Improvement] Add support for mysql enums in dbfill (chenson) closed.
  • 0001806: [Bug] dbfill only inserts 1 char for char fields. It should respect the size of the char field (chenson) closed.
  • 0001807: [Bug] dbfill mishandles clob fields (chenson) closed.
  • 0001808: [Bug] '0000-00-00 00:00:00' fails when and (chenson) closed.
  • 0001812: [Bug] bit type in should be mapped to a bit type in mysql. not a tinyint(1) (chenson) closed.
  • 0001814: [Bug] NullPointerException in AbstractTriggerTemplate.createInitalLoadSql (chenson) closed.
  • 0001818: [Bug] sym script error with Java 5 detection (elong) closed.
  • 0001820: [Improvement] Add property that instructs symmetric to keep the same node_password for a node on re-registration (chenson) closed.
  • 0001821: [Improvement] Add the ability, through configuration, to specify a system commands to dump and load a database's schema during initial load. (chenson) closed.
  • 0001829: [Bug] dbexport doesn't respect "use quoted identifiers" for schema exports (chenson) closed.
  • 0001830: [Bug] sql server needs to explicitly ALLOW_PAGE_LOCKS = OFF if mssql.allow.only.row.level.locks.on.runtime.tables is set (chenson) closed.
  • 0001831: [Improvement] Add new property that instructs the data loader to alter the case of db artifacts being created to the default case of the db. (chenson) closed.
  • 0001832: [Bug] Null values aren't being passed through transforms (chenson) closed.
  • 0001619: [Improvement] Stabilize the Sybase unit tests. (chenson) closed.
  • 0001811: [Improvement] Add new transform types that will put the source catalog, schema or table names into a column (chenson) closed.
  • 0001823: [Improvement] DB2 sync trigger variables should use prefix (elong) closed.
  • 0001827: [Bug] Long Oracle tables generate ORA-04095 on trigger creation (chenson) closed.
  • 0001833: [Bug] ASE 12.5 create triggers in a multi-statement fails (chenson) closed.
  • 0001836: [Bug] The removal of a node isn't synchronized to other nodes in a master to master scenario (chenson) closed.
  • 0001837: [Bug] If the engine isn't found, the logging context should be '?', not the previously handled symmetric engine name for that thread (chenson) closed.
  • 0001839: [Improvement] Global BSH script for transforms (elong) closed.
  • 0001841: [Bug] Update registration request doesn't work on sql server with the latest microsoft jdbc driver (chenson) closed.
  • 0001842: [Improvement] Additional transform variables for bsh (elong) closed.
  • 0001843: [Bug] Oracle dialect has static "sym" prefix on objects (elong) closed.
  • 0001844: [Improvement] Make picking conflict detection strategy case independent when matching tables (chenson) closed.

New in version 3.6.2 (July 14th, 2014)

  • 0001755: [Bug] XML Data (schema and data) is not properly escaped. (chenson) closed.
  • 0001758: [Bug] PostgreSQL default value for 'uuid' field type (chenson) closed.
  • 0001781: [Bug] Uninstall fails if file sync is configured (chenson) closed.
  • 0001782: [Bug] initial.load.create.first fails for tables with a unique index on the primary key (chenson) closed.
  • 0001783: [Bug] A default value of (sysdate) should not translate to '(sysdate)' in the create statement when initial.load.create.first is on (chenson) closed.
  • 0001785: [Bug] Hard coded EXECUTE AS OWNER in Sql Server triggers causes issues if the tables are created under another account (chenson) closed.
  • 0001787: [Bug] Reverse initial load is broken in 3.6 (chenson) closed.
  • 0001789: [Bug] property is defined backwards. It is being used opposite of the definition. (chenson) closed.
  • 0001790: [Improvement] Add REST service to send schema changes (chenson) closed.
  • 0001793: [Bug] When the is reached and the staging manager writes the buffer to a file the buffer is not removed (chenson) closed.
  • 0001794: [Bug] Fix null pointer on busy system during staging area clean (chenson) closed.
  • 0001795: [Bug] DDL modification in schema different than symetricds one (chenson) closed.
  • 0001796: [Bug] Unable to parse ISO-8601 datetime on sqlite (chenson) closed.
  • 0001797: [Bug] sym_table_reload_request should be cleaned up when a node is deleted (chenson) closed.
  • 0001798: [Improvement] Add support for wildcarded catalogs and schemas (chenson) closed.
  • 0001801: [Bug] DbExport does not handle timestamp(9) on Oracle (elong) closed.
  • 0001802: [Bug] DbExport does not handle BLOB on DB2 (elong) closed.
  • 0001803: [Bug] Removing a node using engine.removeAndCleanupNode method on a master to master cluster does not send the remove to other nodes (chenson) closed.
  • 0001804: [Bug] sym_node_host on the heartbeat channel can cause FK errors when a node is removed (chenson) closed.

New in version 3.6.1 (June 26th, 2014)

  • 0001771: [Bug] Add support for ansi literal default date values. Also support well known sql 92 function types for the default values (chenson) - closed.
  • 0001772: [Bug] Custom IColumnTransform weren't being marked as installed. (chenson) - closed.
  • 0001776: [Bug] Postgres should auto commit ddl changes. Otherwise, if a ddl fails to run it cannot continue to move forward. (chenson) - closed.

New in version 3.6.0 (June 17th, 2014)

  • 0001441: [New Feature] Add ability to sync on control file (chenson) closed.
  • 0001485: [New Feature] Create a delete_after_sync function for file sync (chenson) closed.
  • 0000166: [New Feature] Integrate changes to support spatial data replication using [^] (elong) closed.
  • 0001581: [New Feature] Add support for multiple channels for file sync (chenson) closed.
  • 0001609: [Improvement] File sync mutex limits scaling multiple clients (elong) closed.
  • 0001637: [Improvement] Refactor databasewriter into abstractdatabasewriter and defaultdatabasewriter so we can subclass off of abstract databasewriter (chenson) closed.
  • 0001642: [Bug] Triggers referencing tables with case sensitive schemas fail to create on H2 (chenson) closed.
  • 0001643: [Improvement] Support multiple reload channels (chenson) closed.
  • 0001647: [New Feature] Create a Java router, transform, and load filter that uses compiled Java code (elong) closed.
  • 0001648: [New Feature] Add support for choosing the channel a trigger/table will use dynamically (chenson) closed.
  • 0001653: [Improvement] Allow downgrades within same minor version (elong) closed.
  • 0001654: [Bug] Restarting server crashes due to primary key violation (elong) closed.
  • 0001655: [Bug] has no effect when running stand-alone (elong) closed.
  • 0001656: [Improvement] PostgreSQL server side prepared statements causing slow query processing (elong) closed.
  • 0001658: [Improvement] Add sync triggers by table to REST API (elong) closed.
  • 0001371: [Improvement] Add a drop triggers feature (elong) closed.
  • 0001467: [Bug] trigger creation failed with MSSQL database column of nvarchar and ntext data type using the microsoft jdbc driver (chenson) closed.
  • 0001592: [New Feature] Create bulk loader for MySQL (elong) closed.
  • 0001652: [Improvement] Add BLOB support to PostgreSQL bulk loader (elong) closed.
  • 0000952: [Bug] Data can be skipped due to aggressive purge on some platforms (chenson) closed.
  • 0001240: [Bug] No way to send schema changes in schema other, than public (elong) closed.
  • 0001606: [New Feature] Create dialect for DB2 z/OS (elong) closed.
  • 0001624: [Improvement] Add setting to sym_node_group_link to prevent clients from updating configuration (chenson) closed.
  • 0001626: [Improvement] Create event should not store XML is row data (elong) closed.
  • 0001644: [Improvement] SQL Optimizations (chenson) closed.
  • 0001660: [Bug] Table creation generates wrong syntax when source is SQLServer (josh-a-hicks) closed.
  • 0001661: [Improvement] Parameter to collect router statistics (elong) closed.
  • 0001665: [Improvement] Upgrade JDBC drivers (elong) closed.
  • 0001678: [Improvement] Make trigger id column size larger (chenson) closed.
  • 0001689: [Improvement] While routing config changes sync triggers by id that haven't already been sync'd versus calling syncTriggers() (chenson) closed.
  • 0001691: [Improvement] Additional Logging for compliance (chenson) closed.
  • 0001699: [Bug] Changing Trigger results in Error om Tables with an uppercase letter (chenson) closed.
  • 0001700: [Improvement] Parameterized the node Id assignment directly from external Id (josh-a-hicks) closed.
  • 0001701: [Improvement] Re-add support for (chenson) closed.
  • 0001705: [Improvement] Improve initial load query performance (chenson) closed.
  • 0001707: [Bug] Trigger for all tables * is not creating triggers for some of the tables (chenson) closed.
  • 0001717: [Improvement] IReloadListener should be passed the current loadId for use (chenson) closed.
  • 0001718: [Bug] If a node is deregistered by deleting it's sym_node* records and it is registered it will route and sync the deletes (chenson) closed.
  • 0001721: [Improvement] Heartbeat immediately after registration so node information doesn't have to wait for next heartbeat to show up at reg server (chenson) closed.
  • 0001727: [Bug] 100% CPU when expiring SYM_DATA_GAP with missing SYM_DATA (chenson) closed.
  • 0001224: [Task] Remove dependency on java service wrapper (elong) closed.
  • 0001615: [Improvement] Figure out a way to make the usage of source schema and catalog more user friendly (elong) closed.
  • 0001618: [New Feature] Create a MongoDB data loader for SymmetricDS (chenson) closed.
  • 0001723: [Improvement] Unique constraint violation is not logged for tables declared for conflict detection (chenson) closed.
  • 0001729: [Bug] create of table with a varchar/char column with a default values of: ('N') fails to create table on client side (chenson) closed.
  • 0001735: [Improvement] Transforms write out the start of a table before every row which is inefficient and causes bulk loaders to become unusable (chenson) closed.
  • 0001737: [Improvement] Trim numeric values before parsing into primitive to handle situations where the source db might have whitespace prepended (chenson) closed.
  • 0001738: [Improvement] Introduce a new columntransform type that returns both new and old data. use it for the copy transform (chenson) closed.
  • 0001742: [Bug] Fix SQLServer 2005 issue where defaults for BIGINT's are being read with an extra "." at the end. (gwilmer) closed.
  • 0001743: [Improvement] package android dependency jars in zip under the libs directory. not lib. it is misleading because eclipse adk requires libs (chenson) closed.
  • 0001744: [Improvement] NodeService.deleteNode should remove delete from all ancillary tables (in addition to node, node_security and node_host) (chenson) closed.
  • 0001746: [Improvement] Add jdbc driver version to sym_node_host (chenson) closed.
  • 0001748: [Task] Remove auto increment from sym_trigger_hist and sym_extract_request. Use sym_sequence to get the pks. (chenson) closed.
  • 0001749: [Bug] Incoming ProcessInfo is not marked as ERROR when a batch ERROR occurs. It is marked as OK. (chenson) closed.
  • 0001750: [Task] Upgrade the spring framework to the latest released version (chenson) closed.
  • 0001752: [Improvement] Date format setting in triggers (chenson) closed.
  • 0001757: [Bug] java.lang.NumberFormatException w/ MSSQL and BIT column (chenson) closed.
  • 0001759: [Bug] PostgreSqlTriggerTemplate not handling timezone fractional minutes properly when timezone minute < 10 (gwilmer) closed.
  • 0001760: [Improvement] increase channel_id size (chenson) closed.
  • 0001762: [Bug] old data showing up as an array of nulls versus an array that is null causes a code path to be missed that strips out pks (chenson) closed.
  • 0001764: [Improvement] Add parameter to disable sync triggers at server startup (chenson) closed.
  • 0001765: [Bug] Uninstalling symmetric from the database staging area doesn't get wiped out (chenson) closed.
  • 0001766: [Bug] nvarchar data can be corrupted when the default database collation is set to a value that does not support double byte character (chenson) closed.
  • 0001767: [Improvement] On sql server build triggers with "execute as owner" so less grants are need for application users (chenson) closed.

New in version 3.5.22 (May 27th, 2014)

  • 0001712: [Bug] null pointer at startup when sync.url is null in the database (chenson) - resolved.
  • 0001722: [Bug] Trigger errors for large numerics on SQL Server: Arithmetic Overflow Error (josh-a-hicks) - resolved.
  • 0001713: [Improvement] Add initial.load.before.sql and initial.load.after.sql which can contain sql that runs on the client before and after a load (chenson) - resolved.
  • 0001671: [Improvement] Cache node group links (chenson) - closed.
  • 0001708: [Improvement] Disable page level locking and enable row level locking on sym_data and sym_data_event (chenson) - closed.
  • 0001714: [Bug] The keystore type should be settable via a system property. It is currently hardcoded. (chenson) - closed.
  • 0001715: [Improvement] Add a new column transform that can be used to set a column to the value from a SymmetricDS parameter (chenson) - closed.
  • 0001725: [Improvement] MSSQL Bulk Loader support for UNC paths (elong) - closed.
  • 0001726: [Bug] When is enabled on SQL Server and old data capture is off, updates don't work (chenson) - closed.
  • 0001728: [Improvement] MSSQL Bulk Loader support for columns in different order (elong) - closed.

New in version 3.5.21 (April 29th, 2014)

  • 0001697: [Bug] Extract millis aren't captured on outgoing batch when initial.load.use.extract.job.enabled is true (chenson) - closed.
  • 0001299: [Improvement] Transforms should be case insensitive when matching catalog, schema, tablename and columns to make configuration much easier (chenson) - closed.
  • 0001649: [Improvement] Default auto.reload.sym.tables.on.upgrade to false (chenson) - closed.
  • 0001672: [Bug] network_millis on outgoing batch is incorrect (chenson) - closed.
  • 0001673: [Bug] snapshot functionality null pointers in open source (chenson) - closed.
  • 0001684: [Improvement] Passing the correct data type to select data statement improves performance on Postgres (chenson) - closed.
  • 0001685: [Bug] early commit doesn't work when data rows are in conflict. the uncommitted count doesn't increment (chenson) - closed.
  • 0001698: [Improvement] Provide the ability to pass the load time and network time to be populated in outgoing batch via the rest service (chenson) - closed.

New in version 3.5.20 (April 15th, 2014)

  • 0001667: [Improvement] Support capturing only changed data ( on SQL Server (chenson) - closed.
  • 0001651: [Bug] MySQL and SQL-Server bulk loaders handle BLOBs between different platforms (elong) - closed.
  • 0001662: [Bug] SqlUtils is not thread safe. Can result in OOM errors. (chenson) - closed.
  • 0001664: [Bug] NullPointer with MSSQL Bulk Loader (elong) - closed.
  • 0001666: [Bug] SQL Server bulk loader does not handle comma (elong) - closed.

New in version 3.5.19 (March 17th, 2014)

  • [Improvement] SQL Server bulk loader option to fire triggers (elong) - closed.
  • [Bug] SQL Server bulk loader extra spaces causes truncation error (elong) - closed.
  • [Bug] CSV is missing "columns" row when two different sets of columns are being used with three different inserts or updates (chenson) - closed.
  • [Bug] SQL Server bulk loader does not handle BLOB (elong) - closed.
  • [Bug] MySQL bulk loader error with Windows-based server (elong) - closed.
  • [Improvement] Snapshot utility properties show changes, remove passwords, and sort (elong) - closed.
  • [New Feature] Add capture changed data only to Postgres (elong) - closed.
  • [Improvement] REST call for client to know how many batches and rows are waiting (elong) - closed.
  • [Improvement] MySQL and SQL-Server bulk loaders loading rows multiple times (elong) - closed.
  • [Bug] MySQL bulk loader does not load NULL (elong) - closed.
  • [Bug] MySQL bulk loader columns out of order (elong) - closed.

New in version 3.5.18 (March 3rd, 2014)

  • 0001586: [Bug] Stage manager doesn't check to see if a file is actually deleted when it qualifies for cleaning. (chenson) - closed.
  • 0001593: [Bug] Background initial load extract can get stuck. (chenson) - closed.
  • 0001597: [Bug] Overlapping database pull processes after connection outage - Default pull.thread.per.server.count=1 (chenson) - closed.
  • 0001601: [Improvement] Add Map-based methods to TransformData so one can more easily lookup target transform data (mhanes) - closed.
  • 0001602: [Improvement] Allow old source values to be accessible to other column transforms than just copy column (mhanes) - closed.
  • 0001603: [Improvement] Create new 'copy if the value has changed' column transform (mhanes) - closed.
  • 0001604: [Improvement] Create a set of two transforms that can map a series of columns to a series of rows based on a Map (mhanes) - closed.
  • 0001608: [Improvement] Reduce default purge retention period (elong) - closed.
  • 0001610: [Bug] CopyIfChangedTransform should only evaluate on non-delete DML (mhanes) - closed.

New in version 3.5.16 (February 6th, 2014)

  • 0000677: [Improvement] Allow the sym commands to be added to PATH and be called from any location (elong) closed.
  • 0001542: [Improvement] Need a math transform for transforming columns. (abrougher) closed.
  • 0001543: [Bug] Upgrade of schema from 3.3 to 3.5 on H2 fails (chenson) closed.
  • 0001544: [Bug] API transactions aren't being committed in the sequence service api for applications (outside of symmetricds) that use the api (chenson) closed.
  • 0001545: [Improvement] Unlock should use symmetricds server time, not database time, for consistency. (chenson) closed.
  • 0001546: [Bug] Table definition does not update correctly (postgresql) (chenson) closed.
  • 0001548: [Bug] Subdirectories with file sync from Windows to Linux has backslashes (elong) closed.
  • 0001549: [Bug] Delete of file is not synced (chenson) closed.
  • 0001550: [Bug] Sybase ASE : Lost precision from Datetime fields (elong) closed.
  • 0001553: [Bug] REST API HEARTBEAT returning NotAllowException (chenson) closed.
  • 0001555: [Bug] API ddl of type CLOB for sql server tries to change the column type on restarts (chenson) closed.
  • 0001556: [Bug] Wildcard triggers for tables with same name in different catalog/schema (elong) closed.
  • 0001529: [Bug] Columns in old data are not transformed causing conflict detection (chenson) closed.
  • 0001558: [Improvement] Add the ability to use the old column value to the list of variable column transform options (mhanes) closed.
  • 0001561: [Task] Example of configuring log4j to send errors over email (elong) closed.

New in version 3.5.15 (January 22nd, 2014)

  • 0001536: [Improvement] Change to sync.url not picked up (elong) - closed.
  • 0001538: [Bug] Target schema and catalog are not picked up on second router to the same node if different from the first router (chenson) - closed.
  • 0001539: [Bug] Fix *nix sym and setenv shell scripts after bug introduced in 3.5.14 (elong) - closed.

New in version 3.5.14 (January 17th, 2014)

  • 0001534: [Bug] API createTriggersOnChannelForTables() fails when it encounters a table name that is longer than 50 characters (chenson) closed.
  • 0001434: [Improvement] Build up classpath differently so path too long error isn't encountered in windows (elong) closed.
  • 0001518: [Bug] rebuild of trigger hist fails on some platforms (postgres, firebird, oracle) when upgrading from 3.1 to 3.5 (chenson) closed.
  • 0001521: [Improvement] For system snapshot capture not only outbound table definitions, but also incoming table definitions (chenson) closed.
  • 0001524: [Improvement] When applying a SQL event, support multiple SQL statements. Support additional replacement tokens. (chenson) closed.
  • 0001527: [Improvement] Add information about data gaps to the snapshot (chenson) closed.
  • 0001528: [Bug] Routing can get stuck if there are lots of gaps that range across a large amount of data that has already been routed (chenson) closed.
  • 0001531: [Bug] isDataGapExpired() in DataGapDectector can leave old gaps if the next data id is not present (chenson) closed.
  • 0001532: [Bug] integer value logged correctly at server, but inserted as different value at client (chenson) closed.
  • 0001533: [Bug] Unable to create trigger if primary key column excluded (chenson) closed.
  • 0001520: [Improvement] Add further details about Linux installation as a service options (mhanes) closed.

New in version 3.5.13 (January 8th, 2014)

  • 0001496: [Bug] Triggers not created when "handle key updates" enabled (mhanes) closed.
  • 0001502: [Improvement] Assign a load id to batches that contain reload events when the batch is created during routing (chenson) closed.
  • 0001505: [Task] Add blurb about the resolve_row_only column's functionality in the NEWER_WINS resolve type documentation. (chenson) closed.
  • 0001506: [Bug] NullPointerException on Android when INTENTKEY_PROPERTIES is not provided in the Intent when starting service (chenson) closed.
  • 0001507: [Improvement] API Improvement Added getTableTypes() to IDdlReader (chenson) closed.
  • 0001511: [Bug] Firebird TIME fields don't synchronize properly because of the fractional seconds component (chenson) closed.
  • 0001512: [Bug] sqlscriptreader has bug where tokens aren't replaced if the script has a single sql statement with no end of statement token (chenson) closed.
  • 0001513: [Improvement] Add API Operation description to the REST API (mhanes) closed.
  • 0001514: [Bug] Stream Lobs for SQL Server fails with bad trigger syntax (mhanes) closed.
  • 0001469: [Bug] Time and Timestamp field issues on Firebird and Postgres databases (chenson) closed.
  • 0001498: [Bug] Table reload broken on Sybase ASA 9 (elong) closed.
  • 0001504: [Improvement] Add variables to initial load delete SQL (elong) closed.

New in version 3.5.12 (December 20th, 2013)

  • 0001465: [Bug] REST API default schema and/or catalog are filled in for generated sql statement even if they are blank in sym_trigger (chenson) closed.
  • 0001466: [Bug] REST API setting the target schema and/or catalog does not work when using the REST API (chenson) closed.
  • 0001467: [Bug] trigger creation failed with MSSQL database column of nvarchar and ntext data type using the microsoft jdbc driver (chenson) closed.
  • 0001468: [Bug] Sync triggers on Oracle: Maximum open cursors exceeded (elong) closed.
  • 0001471: [Bug] Reload from TABLE_RELOAD_REQUEST does not support deletes (elong) closed.
  • 0001472: [Bug] Node Ids don't work in URLs if they have spaces in them. Need to urlencode the node id. (chenson) closed.
  • 0001473: [Bug] Oracle DDL Util issue isn't correctly recognizing varchar2() columns (chenson) closed.
  • 0001474: [Bug] sync blocks with java error when a field with affinity 'INTEGER' contains a (empty) string (chenson) closed.
  • 0001479: [Improvement] When using DmlStatement if columns are not provided then generate a select * for the SELECT_ALL type (chenson) closed.
  • 0001480: [Bug] SymmetricEngineHolder doesn't update engine count when installing a new engine (mhanes) closed.
  • 0001481: [Bug] Updates and Deletes can fail when a transform exists that have PKs where the source and target column names are different (chenson) closed.
  • 0001475: [Bug] Replication From Branch to Central Broken (Firebird at Both Ends) (chenson) closed.
  • 0001488: [Bug] If a create event and update event for a file happen in the same batch the building of the zip file fails (chenson) closed.
  • 0001489: [Improvement] Don't log stack trace on a file sync conflict. Just log the message. (chenson) closed.
  • 0001486: [Bug] File Sync "sync_on_delete" not honored. (chenson) closed.
  • 0001490: [Improvement] Background extract process currently just handles one request at a time. Change to handle multiple requests. (chenson) closed.
  • 0001491: [Bug] Mark outgoing batches as OK during the start of an initial load can hang until the config channel has been pulled (chenson) closed.
  • 0001492: [Bug] Staging manager bases purging of staging files based on create time of the resource, not the last modified time of the file. (chenson) closed.

New in version 3.5.11 (November 16th, 2013)

  • [New Feature] Update ddl utils xml to support specific database types so create schema commands replicate the same schema on same databases (chenson) - closed.
  • [Improvement] Provide global parameter to specify that BSH database writer filters will handle missing tables (mhanes) - closed.
  • [Improvement] Add support for allowing a database writer filter to change the target tables catalog, schema and table name (chenson) - closed.
  • [Bug] ignore case parameter should apply to only the table (not schema and catalog) for now in the load filter (chenson) - closed.
  • [Improvement] Expose apis to prefix a Database and read a list of Table from the physical database (chenson) - closed.
  • [Bug] PostgreSQL timestamp with timezone columns won't sync for very old, European dates. (mhanes) - closed.
  • [Improvement] Add support for Oracle's TIMESTAMP WITH LOCAL TIME ZONE data type (chenson) - closed.
  • [Bug] On postgres, when sync triggers is run from symadmin tool the generated triggers put null into the transaction id field (chenson) - closed.
  • [Bug] Stored procedure with NOCOUNT is rolled back (elong) - closed.

New in version 3.5.10 (October 21st, 2013)

  • This version fixes 2 bugs and makes 3 improvements.
  • Fixes include the package location on Oracle and statement performance on Firebird.
  • Conflict resolution for files sync was added.
  • Large BLOB handling was optimized for better memory usage.

New in version 3.5.7 (September 16th, 2013)

  • 0001413: [Bug] SymmetricDS not returning the fully qualified hostname (abrougher) - closed.
  • 0001419: [Bug] USE_STREAM_LOBS=1 in Oracle does not replicate LOB data (chenson) - closed.
  • 0001416: [Improvement] TriggerRouterService should cache a list of TriggerRouter's for each channel instead of querying db each time. (abrougher) - closed.
  • 0001412: [Bug] Numeric(15,5) type columns are truncated when written to Sybase dialects. (abrougher) - closed.

New in version 3.5.6 (September 6th, 2013)

  • This version fixes three bugs, including fixes for money type on PostgreSQL, old data capture, and the uninstall feature on H2.

New in version 3.5.5 (August 29th, 2013)

  • This version fixes five bugs and includes three improvements.
  • Fixes were made to transforms and initial load.
  • Transforms were improved to add access to old data.
  • Conflicts were improved with an option to ignore columns.
  • Encoding support was improved with a property to force character encoding.

New in version 3.5.4 (August 22nd, 2013)

  • This version fixes 8 bugs, including fixes for the SQL Anywhere dialect, beanshell routing, dbexport, and multi-batch initial loads.

New in version 3.5.3 (August 15th, 2013)

  • This version fixes 8 bugs and makes 2 improvements, including fixes for the upgrade process, REST service, and extraction.
  • Improvements were made to the background initial loads and job scheduler.

New in version 3.5.2 (August 6th, 2013)

  • This version has 11 bugfixes and 2 improvements, including fixes for the background initial load, JMX methods, transforms, and SQL-Server.
  • The speed of BSH transforms was improved.

New in version 3.5.1 (July 27th, 2013)

  • This version includes six bugfixes, including fixes to the upgrade process and dialect-specific fixes for Sybase ASE, SQL Anywhere, and PostgreSQL.

New in version 3.4.7 (June 25th, 2013)

  • This version includes three bugfixes, including a fix for a stack overflow caused by the combination of conflict management with a transformation.

New in version 3.4.6 (June 8th, 2013)

  • This version includes 5 bugfixes and 3 improvements, including fixes for MySQL dialect, Oracle dialect, and node communication.
  • Performance improvements to batch status and connection pooling were made.

New in version 3.4.5 (June 3rd, 2013)

  • This version includes 11 bugfixes and an improvement to allow the initial load to occur before creating triggers.

New in version 3.4.4 (May 13th, 2013)

  • This version includes bugfixes for ignoring missing tables from synchronization and reading metadata on DB2.

New in version 3.4.3 (May 9th, 2013)

  • This version includes a fix for using wildcards to match tables to be synced.

New in version 3.4.0 (April 23rd, 2013)

  • This version includes 4 new features, 18 bugfixes, and 15 improvements.
  • New features include an API to read the process synchronization status, support for both MariaDB server and driver, and a new "remove" column transform type.

New in version 3.3.5 (March 20th, 2013)

  • This version adds support for SQL-Server 2000.

New in version 3.3.4 (March 12th, 2013)

  • This version includes 4 bugfixes, including a fix for sync keys on SQL-Server and table creation on SQLite.

New in version 3.3.2 (March 1st, 2013)

  • This version includes 11 bugfixes and 8 improvements.
  • Fixes are included for node registration, dbexport, data capture, and upgrading from 3.0.
  • Improvements are included for filters, conflict detection, and transforms.

New in version 3.3.0 (February 9th, 2013)

  • This version includes eight new features, eight improvements, and eight bugfixes.
  • New features include piloting configuration changes to a subset of nodes, easy reloading of tables, and improved recording of conflicts.
  • Improvements include better logging to aid debugging, defaulting to an error for missing tables, and more documentation.
  • Bugs include fixing the disabling of stream to file and recording a batch error message even if it occurs before or after batch processing.

New in version 3.2.3 (January 26th, 2013)

  • This version fixes handling of large objects when tables need to be quoted and when targeting different catalogs.
  • Improvements include upgrading the PostgreSQL driver, options for tuning the routing query, and an option for throttling the dbimport.

New in version 3.2.2 (January 14th, 2013)

  • This version includes fixes for PostgreSQL, SQLite, and Informix dialects, and fixes wildcards for tables with multiple schemas.

New in version 3.2.1 (January 7th, 2013)

  • This version includes fixes for Firebird/Interbase, a registration null pointer, synchronizing jobs for SQLite, and a staging area fix.

New in version 3.2.0 (December 17th, 2012)

  • This version includes synchronization of SQLite databases, sending change data over S/FTP, synthetic keys, better geometric data type support, and audit tables.
  • There are 8 new features, 13 improvements, and 27 bugfixes in total.

New in version 3.1.11 (December 3rd, 2012)

  • This version includes some performance tweaks for Oracle, the push/pull interval, and heartbeats on large multi-node systems.

New in version 3.1.10 (November 29th, 2012)

  • This version fixes a staging issue that could cause out of memory errors and disk space issues.

New in version 3.1.9 (November 1st, 2012)

  • This version fixes six bugs and adds four improvements.
  • Clustering of the purge job was fixed, and performance improvements were made for data routing for a large number of nodes.

New in version 3.1.7 (October 24th, 2012)

  • This version fixes 9 bugs and adds 2 improvements.
  • Fixes include escaping data in dbexport, timestamp with timezone in conflict management, and working with database names containing a dash.
  • Improvements include error handling and documentation around the scheduler.

New in version 2.5.10 (April 3rd, 2012)

  • This version fixes a node registration problem for multi-tier systems which was preventing setup.

New in version 2.5.9 (March 30th, 2012)

  • This version fixes capture of timestamp with time zone and tinyint columns on Oracle, and fixes JMX console on multi-homed servers.

New in version 2.5.8 (March 21st, 2012)

  • This version fixes initial loading with foreign keys and data type issues on Oracle with boolean and geo spatial types.

New in version 2.5.0 (November 7th, 2011)

  • This version adds a multi-server option and support for the Greenplum database.
  • Multiple engines with different configurations can now run within the same server, conserving memory and consolidating management.
  • The Greenplum database, popular for its data warehousing and analytics, is now supported as a target for replication.

New in version 2.4.0 (September 2nd, 2011)

  • This version adds powerful new transformation features for mapping between different tables, combining data from multiple tables, and changing data through both configuration and scripts.
  • The large object support was improved with an option to stream the LOB from the database instead of using trigger data capture.

New in version 2.3.0 (June 1st, 2011)

  • Bug:
  • [SYMMETRICDS-442] - ColumnDefaultValueChange incorrectly detected for Postgres table
  • [SYMMETRICDS-443] - Postgres required functions not being detected as already installed.
  • Improvement:
  • [SYMMETRICDS-434] - Put tables in quotes in triggers for the SQL Server dialect
  • New Feature:
  • [SYMMETRICDS-449] - Support Interbase database

New in version 2.2.0 (March 30th, 2011)

  • This minor release brings 15 bugfixes, 8 improvements, and 5 new features.
  • It includes a new project organization and reduced library dependencies in preparation for mobile clients.

New in version 2.1.0 (September 30th, 2010)

  • Support for Informix 11 and HSQLDB 2 databases was added.
  • Improvements were made to job scheduling, initial data load, the purge process, batch statuses, and data routing performance.
  • An upgrade was made to Jetty 7 (for standalone mode) and Spring 3.0.4.
  • There were also many other improvements, new features, and bugfixes.

New in version 1.6.2 (May 20th, 2009)

  • Bug
  • [SYMMETRICDS-84] - Support for ABSTIME data type on PostgreSQL
  • [SYMMETRICDS-89] - DB2 Mainframe Dialect for String Trigger Creation needs to handle empty string
  • Improvement
  • [SYMMETRICDS-87] - Add an extension point to allow users to customize how a sync_url is selected
  • [SYMMETRICDS-88] - If enabled, write sync data to a file first during extract and before data load in order to decrease time db and network resources are in use