change-log-3.0.txt

SymmetricDS - 3.4.2 (Released 2013-04-26) 
=========================================
- 0001190: [Improvement] Remove file sync tables. They should not have been released yet. (chenson) - closed.

SymmetricDS - 3.4.1 (Released 2013-04-24)
=========================================
- 0001053: [Improvement] Verify that NOCOUNT is off for SQL Server before starting SymmetricDS. When NOCOUNT is turned on SymmetricDS won't work. (chenson) - closed.
- 0001183: [Improvement] Add new property db.init.sql that allows sql to be run against a database connection right after it is created (chenson) - closed.
- 0001184: [Improvement] Record ProcessInfo for server side registration process so it can more easily be monitored for errors (chenson) - closed.

SymmetricDS - 3.4.0 (Released 2013-04-21)  
=========================================
- 0001117: [Bug] registration_enabled doesn't get set to 0 when node is really registered (chenson) - resolved.
- 0001116: [Bug] sym_data_gap referenced directly instead of using sync.table.prefix (chenson) - resolved.
- 0001115: [New Feature] Add option to dbexport to NOT use quoted identifiers when exporting data as SQL (chenson) - resolved.
- 0001111: [Bug] MySQL upgrade issue: Columns not modified when symmetricds table columns type or size change (chenson) - resolved.
- 0001110: [Bug] Triggers not removed when sym_trigger source_ catalog, schema or table name changed (chenson) - resolved.
- 0001109: [Bug] Registration can fail when multiple sym_node records exist with a null created_at_node_id value (chenson) - resolved.
- 0000580: [Improvement] MySQL trigger throwing error on special characters (chenson) - resolved.
- 0001107: [Improvement] Bind all of the symmetric properties to the spring context for use in extensions points (chenson) - resolved.
- 0001105: [Improvement] Add new web.xml setting that controls whether the symmetric engine(s) are started (chenson) - resolved.
- 0001046: [Bug] There are 2 log4j-1.2.16.jar files in the symmetricds deployment (chenson) - resolved.
- 0001104: [Improvement] Exclude sym_ tables from being effected by wildcard load filters (chenson) - resolved.
- 0001086: [Improvement] Make the 3.x use 1.x protocol for backwards compatibility (chenson) - resolved.
- 0000865: [Bug] Ignore batch is not working for an initial load batch that was failing to extract because of a bad initial_load_select (chenson) - closed.
- 0000958: [New Feature] JNDI DataSource Support (chenson) - closed.
- 0000989: [Improvement] Provide a way to blank out the target schema/catalogs in sym_router (chenson) - closed.
- 0001118: [Improvement] Allow the sync.url to be blank. Past versions of SymmetricDS allowed this and defaulted to using the registration.url (chenson) - closed.
- 0001119: [Bug] When dead triggers are disabled SymmetricDS attempts to delete triggers that don't exist. Causes warning in log file. (chenson) - closed.
- 0001121: [New Feature] Add a new "remove" column transform type that can be used with implied table transforms to remove a column completely. (chenson) - closed.
- 0001124: [Improvement] Add support to use the jboss.binding.address system property in JBoss 7 for the cluster.server.id (chenson) - closed.
- 0001128: [Improvement] Add new parameter to make heartbeat at server startup optional. Defaulting heartbeat at startup to off. (chenson) - closed.
- 0001129: [Bug] Null pointer happens if trigger router is removed for a reload event that has not been sent. Should just skip the reload event. (chenson) - closed.
- 0001139: [New Feature] Expose information about the processes that are currently running via an api to be used to inspect what is going on in an engine (chenson) - closed.
- 0001149: [Bug] Log error message when an invalid sync_key_name column is specified. If no columns match, then return the original keys. (chenson) - closed.
- 0001154: [Improvement] Make the max_batch_size for the config channel bigger (2000) than its current default of 100 (chenson) - closed.
- 0001160: [Bug] Marking of old incoming batches as OK during initial load should also include the setting of the error_flag to 0 (chenson) - closed.
- 0001161: [Improvement] Set the default fetch size to 100. 1000 is a little big for smaller installations or for database with very BIG rows. (chenson) - closed.
- 0001162: [Improvement] Reuse nodes when auto.registration is turned on so you don't end up with a bunch of stranded nodes (chenson) - closed.
- 0001163: [Bug] If a database error occurs while initializing SymmetricDS the error bubbles out of a startup thread and is logged to std err (chenson) - closed.
- 0001164: [Bug] If a protocol error happens during extract (corrupted staging file), then delete the staging file so it will be reextracted (chenson) - closed.
- 0001165: [Bug] For an initial load on push, exit out of load loop if one of the batches failed (chenson) - closed.
- 0001166: [Improvement] Add DbFill support for PostgreSQL 'text' and 'active_inactive' column types. (chenson) - closed.
- 0001168: [Bug] Audit router throws NPE on Oracle and PostgreSQL. (chenson) - closed.
- 0001169: [Bug] Selection of batches is short circuited when a channel is encountered that is missing or disabled (chenson) - closed.
- 0001171: [Bug] Don't refresh the ParameterService cache if the database is unavailable because you can end up misconfigured for a timeperiod (chenson) - closed.
- 0001175: [Improvement] Add reload_id and create_by to sym_outgoing_batch (chenson) - closed.
- 0001176: [Improvement] Add support for MariaDB's Jdbc Driver (chenson) - closed.
- 0001179: [Bug] Parameters are not refreshed right after registration (chenson) - closed.

SymmetricDS - 3.3.6 (Released 2013-04-03) 
=========================================
- 0001140: [Bug] SQL Server 2000 triggers are being created using the 'max' keyword, which 2000 does not support. (abrougher) - closed.
- 0001131: [Bug] NPE in conflict resolution when detecting a conflict using TIMESTAMP and existing row doesn't exist (gwilmer) - closed.
- 0001133: [Bug] Multiple reverse reloads can be queued up because of timing issues (chenson) - closed.
- 0001134: [Bug] An incoming batch can be left stranded in the ER state after an initial load sets the outgoing batch to OK (chenson) - closed.
- 0001135: [Bug] symmetric-server.properties enable flags for ssl are not working (chenson) - closed.
- 0001141: [Bug] Prevent invalid warning that expected ack was not received (chenson) - closed.
- 0001144: [Bug] When a reload is queued up the outgoing batches should be marked as OK in reverse order so as to not cause FK issues (chenson) - closed.
- 0001151: [Bug] NullPointerException can happen on reload events queued up by sym_table_reload_request during an upgrade (chenson) - closed.
- 0001155: [Bug] Audit router causes NPE on MySQL. (chenson) - closed.
- 0001156: [Bug] Fatal Error (like OOM) could possibly cause a reload event to be stranded in sym_data and routed to all child nodes (chenson) - closed.
- 0001157: [Bug] Don't allow api status methods if the engine isn't registered (gwilmer) - closed.

SymmetricDS - 3.3.5 (Released 2013-03-18) 
=========================================
- 0001122: [Improvement] Add support for Sql Server 2000 (abrougher) - closed.

SymmetricDS - 3.3.4 (Released 2013-03-09) 
=========================================
- 0001087: [Bug] If engine.name isn't used, then some services are not available. Should be available as long as there is only one node deployed (chenson) - closed.
- 0001094: [Bug] sync_keys isn't used to create triggers which causes a SQL Server table w/out primary keys and sync_keys to not capture updates (chenson) - closed.
- 0001100: [Bug] sqlite create tables quotes create_timestamp default values (chenson) - closed.
- 0001101: [Bug] sqlite create tables doesn't work because a transaction is in process and the database is locked (chenson) - closed.

SymmetricDS - 3.3.3 (Released 2013-03-01)
=========================================
- 0001079: [Improvement] Children node are selected from the database each heartbeat but not necessarily used, can be time consuming w. lots of children (chenson) - closed.
- 0001080: [Bug] Reload and config channel should never be "common" channels (chenson) - closed.
- 0001082: [Bug] error calling unknown function sym_transaction_idnull() (chenson) - closed.
- 0001083: [Bug] Registration slow on Oracle with lots of nodes (chenson) - closed.

SymmetricDS - 3.3.2 (Released 2013-02-26) 
=========================================
- 0001077: [Bug] SymmetricDS has to be restarted to recognize a change in the data load filter table. (chenson) - closed.
- 0001078: [Improvement] Allow sym_load_filter.target_table_name to be left blank so that filters are applied to all tables (chenson) - closed.
- 0000396: [Improvement] Updates of primary keys are not captured on SQL Server (gwilmer) - closed.
- 0001045: [Bug] Upgrade from 3.0.9 to 3.3.1 fails. Fix the oracle dialect so it can run alter statements to change column sizes (chenson) - closed.
- 0001047: [Improvement] Incoming Error's cur_data columns should reflect values at moment of conflict, not values prior to start of transaction (mhanes) - closed.
- 0001050: [Improvement] Introduce conf/symmetric-server.properties which contains http/https/jmx port/enabled settings and other server specific setting (chenson) - closed.
- 0001051: [Bug] --jmx-port and --jmx-disabled command line help is not available (chenson) - closed.
- 0001057: [Bug] Postgres datetime with timezone not formatted correctly when timezone offset < 0 and timezone offset has minutes (gwilmer) - closed.
- 0001061: [Improvement] Support synchronization of Oracle Synonyms (chenson) - closed.
- 0001067: [Bug] syncTriggers called multiple times when multiple batches have queued up for the client and at least one has config changes (chenson) - closed.
- 0001048: [Bug] Timestamps are not exported correctly using dbexport. (abrougher) - closed.
- 0001049: [Bug] DbExport allows --sql option without a table name argument. (abrougher) - closed.
- 0001058: [Improvement] Provide access to include-on and source dml type in bean shell transforms (mhanes) - closed.
- 0001066: [Bug] Reverse initial load may be computed and routed before triggers are done synchronizing when a client first registers (chenson) - closed.
- 0001068: [Improvement] Add new extension point ILoadSyncLifecycleListener which gets callbacks before and after a load sync (chenson) - closed.
- 0001070: [Bug] If trigger table name changes and the new trigger table name doesn't exist, the old triggers don't get remove from the old table (chenson) - closed.
- 0001071: [Improvement] Column transforms are being called even if the includeOn does not match. Only effects custom transforms that take some action. (chenson) - closed.
- 0001074: [Bug] sym_node_channel_ctl should not be included in the list of tables to load during registration (chenson) - closed.
- 0001075: [Improvement] Turn on sym_trigger.use_capture_lobs and sym_channel.contains_big_lobs by default for sym tables and the config channel (chenson) - closed.
- 0001076: [Bug] Update transform that falls back to insert does not retransform (chenson) - closed.

SymmetricDS - 3.3.1 (Released 2013-02-12) 
=========================================
- 0001041: [Improvement] If an outgoing_batches status is set back to NE, then always re-extract it versus using the already staged batch. (chenson) - closed.
- 0001042: [New Feature] MariaDB Dialect (gwilmer) - closed.
- 0001043: [Bug] dataloader.error.save.curval=true doesn't work (chenson) - closed.
- 0001044: [Bug] Map of semaphores used to prevent concurrent extraction of individual batches are not cleaned up (chenson) - closed.

SymmetricDS - 3.3.0 (Released 2013-02-08) 
=========================================
- 0001040: [Bug] When use_stream_lobs is on use_changed_data conflict resolution doesn't work because the lobs old data is always null (chenson) - closed.
- 0000994: [Improvement] Update Users Guide to describe how to deploy to separate machines (tutorial is multi-homed) (chenson) - closed.
- 0001036: [Bug] Error is not getting recorded in outgoing batch if there isn't a line number (chenson) - closed.
- 0001037: [Improvement] Default dataloader.ignore.missing.tables to false instead of true (chenson) - closed.
- 0001039: [Bug] syncTriggers should not abort when metadata cannot be read due to db permissions for just one trigger (chenson) - closed.
- 0000986: [New Feature] Include conflict_id reference in sym_incoming_error table to crossreference the type of conflict that occurred (chenson) - closed.
- 0001028: [Bug] stream.to.file.enabled=false is broken (chenson) - closed.
- 0001031: [Bug] Documentation for outgoing_batch is missing IG and has RE instead of RT and QE instead of QY (chenson) - closed.
- 0000987: [New Feature] Add the "current" (conflicting) data to a column in sym_incoming_error (chenson) - closed.
- 0001033: [Improvement] Before allocating push/pull jobs check to see if thread count has changed and if so, restart thread pool (chenson) - closed.
- 0001030: [Bug] Exception in clustered firebird environment (chenson) - closed.
- 0001034: [New Feature] Add last_update_by, last_update_time, create_time to transform_*, parameter, channel, node_group, and node_group_link (chenson) - closed.
- 0001035: [New Feature] Add new refresh cache job that can be turned on in a clustered environment to check for configuration changes (chenson) - closed.
- 0000967: [Bug] Unknown table "INFORMATION_SCHEMA.SESSION_STATUS" error for MySQL 5.0.XX (chenson) - closed.
- 0001010: [Improvement] Log better messages when server node is unavailable giving users a clue as to what action needs to be taken (admin) - closed.
- 0001013: [Improvement] BshDatabaseWriterFilter should bind the error to use in a HANDLE_ERROR script (chenson) - closed.
- 0001014: [Improvement] Don't write STOPPED for the last server id in sym_lock when releasing an infinite lock (chenson) - closed.
- 0001015: [Bug] Data event count and insert event count get lost for big reload batches because status is requeried and overwrites the values (chenson) - closed.
- 0001018: [New Feature] Add a mechanism for a remote node to request a table reload. This is helpful while rolling out new tables. (chenson) - closed.
- 0001019: [New Feature] Grouplets - Add a feature to specify a subset of nodes for which a router is enabled to allow piloting of configuration. (chenson) - closed.
- 0001024: [Improvement] Use the symmetric table name as the virtual trigger name instead of a hashcode of the table name (chenson) - closed.
- 0001025: [Improvement] Don't log staging area cleanup at the info level. Change logging to debug level (chenson) - closed.
- 0001026: [New Feature] If the minor version is upgraded, then (if you aren't the reg server) request a reload of key symmetric tables (chenson) - closed.
- 0001027: [New Feature] Add the ability to enable or disable trigger routers with an enabled column (chenson) - closed.

SymmetricDS - 3.2.3 (Released 2013-01-24) 
=========================================
- 0000983: [Bug] Table wasn't being quoted while selected lob data when stream_lobs is turned on and db.delimited.identifier.mode=true (chenson) - closed.
- 0000988: [Bug] use_stream_lobs uses routers target schema and catalog instead of the triggers source schema and catalog (chenson) - closed.
- 0000995: [Improvement] Upgrade to the latest postgres jdbc driver to get bug fix for retrieval of result set metadata (chenson) - closed.
- 0000997: [Improvement] dbimport and symmetricds dataloader throttle (abrougher) - closed.
- 0000998: [Improvement] Add parameters that allow the routing query to be optimized for large numbers of gaps with a large set of unrouted sym_data rows (chenson) - closed.
- 0001000: [Bug] Prevent null pointer if node channel control exists and channel does not. (chenson) - closed.
- 0001003: [Improvement] Don't allow a node to register if there are not links defined that will allow it to be part of the network (chenson) - closed.

SymmetricDS - 3.2.2 (Released 2013-01-12)  
=========================================
- 0000976: [Bug] Using wildcards in the source_table_name in databases that have foreign keys across schemas can cause triggers to not be built (chenson) - closed.
- 0000973: [Bug] batch_to_send_count not getting set properly unless you have batches in error (gwilmer) - closed.
- 0000974: [Bug] Informix - Function created with the schema name as part of the function name (chenson) - closed.
- 0000978: [Bug] int8 datatype doesn't work as a primary key for an update on postgresql (chenson) - closed.
- 0000982: [Bug] A conflict is not recorded in sym_incoming_error for sqlite because the database is locked and we use a different connection (chenson) - closed.

SymmetricDS - 3.2.1 (Released 2012-12-18) 
=========================================
- 0000961: [Bug] Uninstall feature needs to delete conflicts and transforms before trying to delete group links (chenson) - closed.
- 0000964: [Bug] Unchecked substring() while retrieving database name in firebird (chenson) - closed.
- 0000965: [Bug] Firebird and Interbase report unique constraint error code of 335544349 (chenson) - closed.
- 0000968: [Bug] Staging area clean up job can corrupt data extractions in progress (chenson) - closed.
- 0000969: [Bug] Trying to open registration on a node that has not been configured/registered itself causes null pointer (chenson) - closed.
- 0000971: [Bug] Push / Pull threads should run in Job's thread when jobs.synchronized.enable is true (mhanes) - closed.

SymmetricDS - 3.2.0 (Released 2012-12-16) 
=========================================
- 0000880: [New Feature] Add support for cascading random data to DbFill. (abrougher) - closed.
- 0000896: [Bug] RouterService.getUnroutedDataCount() is not accurate. Uses max(last_id) when it should use max(start_id) (chenson) - closed.
- 0000900: [Improvement] Add grant information to User's Guide for PostreSQL when a different schema is involved. (chenson) - closed.
- 0000902: [Bug] Don't allow an engine to service a request if that engine is not "started" (chenson) - closed.
- 0000831: [Bug] Timeout is not set on a re-directed registration request (chenson) - closed.
- 0000855: [Improvement] Create a new heartbeat channel for sym_node_host. Deprecate heartbeat_time on sym_node (chenson) - closed.
- 0000872: [New Feature] Add an uninstall feature to SymmetricDS (chenson) - closed.
- 0000890: [Improvement] The symmetricds client should always request UTF-8 character encoding. Also set -Dfile.encoding=utf-8 (chenson) - closed.
- 0000893: [Bug] Hidden feature to override the sym_ tables virtual triggers shouldn't look at router id to see if needs to replace the trigger (chenson) - closed.
- 0000899: [Bug] Prevent nodes from syncing with themselves (chenson) - closed.
- 0000904: [Bug] DbExport does not respect the compatible setting for data (chenson) - closed.
- 0000903: [Bug] dbexport not replacing ? in cases (chenson) - closed.
- 0000906: [Bug] Altering a default value for a varchar column on oracle fails. Default value not quoted. (chenson) - closed.
- 0000908: [Bug] Table that has a sequence for increment column fails to migrate data (chenson) - closed.
- 0000909: [New Feature] Support GEOMETRY type on MySQL (chenson) - closed.
- 0000911: [New Feature] Support GEOMETRY type on SQL Server (chenson) - closed.
- 0000912: [Bug] Missing primary key columns from source at target can cause data corruption or errors. Columns misaligned. (chenson) - closed.
- 0000914: [Improvement] Update startup scripts to explicitly use the -server option, output out of memory errors, and restart on memory errors (chenson) - closed.
- 0000915: [Bug] backslash (\) is exported as doubule backslash (\\) in CSV format (chenson) - closed.
- 0000916: [Bug] After registration sym_node_security does not get updated with update enabled flag and times (chenson) - closed.
- 0000918: [Bug] Add startup parameters to support basic authentication (chenson) - closed.
- 0000920: [Improvement] Support timestamp with time zone in dbfill (chenson) - closed.
- 0000921: [Improvement] postgres trigger template for timestamp with time zone did not zero pad negative time zone hours (chenson) - closed.
- 0000924: [Bug] dbexport's xml format does not export null data values correctly (chenson) - closed.
- 0000925: [Improvement] DbFill should ignore the symmetric tables by default. (abrougher) - closed.
- 0000936: [Bug] Oracle integer datatype has a larger precision than the java Integer datatype. (chenson) - closed.
- 0000708: [New Feature] Add ability to exclude BFILE columns from triggers for Oracle (chenson) - closed.
- 0000779: [New Feature] Add a symmetric parameter that tells the data loader that it is NOT ok to ignore a table if it is missing in the database (chenson) - closed.
- 0000806: [Bug] DbFill --help argument captions are not displayed correctly. (abrougher) - closed.
- 0000809: [Improvement] Firebird trigger template improvement for generators. (chenson) - closed.
- 0000848: [Bug] Tutorial doesn't work for MySQL (chenson) - closed.
- 0000852: [Improvement] Add the ability to define the "sync key" of a table versus using the actual primary key (chenson) - closed.
- 0000892: [Bug] Common batch mode should not be detected if a channel is bidirectional with separate trigger definitions for the same table. (chenson) - closed.
- 0000907: [Improvement] Document conflict resolution's ping-back settings, and resolve booleans (row only, changes only) (chenson) - closed.
- 0000937: [New Feature] Provide capability to specify initial load / reverse initial load ordering (chenson) - closed.
- 0000940: [Bug] Conflict resolution uses the target table to lookup data for timestamp and version checks. Should be using source. (chenson) - closed.
- 0000941: [Bug] Triggers should exclude excluded columns even if column is part of primary key (mhanes) - closed.
- 0000942: [New Feature] Add a router type of 'audit' that captures changes in an dynamically created audit table. (chenson) - closed.
- 0000943: [Improvement] Do simple column validation of extracted initial load row during the extraction process. Log better message. (chenson) - closed.
- 0000944: [Bug] Recursive call while processing data for routing when there are a lot of gaps can cause stack over flow error (chenson) - closed.
- 0000945: [Bug] batchCommit was being called for earlyCommit and for normal commit. The api is suppose to only be call for a normal commit (chenson) - closed.
- 0000947: [Bug] Bad alter statement generated on oracle upgrade: ALTER TABLE "SYM_DATA_EVENT" MODIFY ("BATCH_ID" DEFAULT ) (chenson) - closed.
- 0000948: [Bug] Fix upgrade to sym_trigger_hist to not blow away sequences (chenson) - closed.
- 0000021: [New Feature] Add support for Sqlite over JDBC (mhanes) - closed.
- 0000871: [New Feature] Implement a REST API for SymmetricDS (gwilmer) - closed.
- 0000946: [Bug] Cannot delete triggers from tables if SymmetricDS user doesn't own those tables (chenson) - closed.
- 0000951: [Bug] use_timestamp conflict resolution with transform can get into endless loop (chenson) - closed.
- 0000954: [Improvement] Change default file permissions for executables to 755 (vs 774) (chenson) - closed.
- 0000955: [Improvement] Add parameter to allow SymmetricDS jobs to be synchronized (mhanes) - closed.
- 0000935: [Bug] dbexport null timestamp values from Oracle result in empty string ("") in CSV. (chenson) - closed.

SymmetricDS - 3.1.11 (Released 2012-11-29) 
=======================================
- 0000894: [New Feature] Add property to turn sync_on_incoming off for sym_ table triggers (chenson) - closed.
- 0000929: [Improvement] Add oracle hint to query to select data from sym_data to force it to use the obvious index - closed.
- 0000931: [New Feature] Add property that specifies minimum time between pushes and pulls. Default to 0 so pull and push periods have same behavior - closed.

SymmetricDS - 3.1.10 (Released 2012-11-27) 
==========================================
- 0000926: [Bug] Staging area is not being cleaned up. Can cause out of memory or file system issues. (chenson) - closed.
- 0000913: [Bug] Verify that a staged resource reference exists before returning the reference. Symmetricds wasn't allowing me to remove failed (chenson) - closed.

SymmetricDS - 3.1.9 (Released 2012-10-30) 
=========================================
- 0000889: [Bug] dbimport of xml format fails with mark/reset error (chenson) - closed.
- 0000886: [Improvement] Routing of configuration data (especially the node tables) is very slow when there are lots of nodes (chenson) - closed.

SymmetricDS - 3.1.8 (Released 2012-10-29) 
=========================================
- 0000860: [Bug] Timestamp with timezone doesn't work with timestamp new wins conflict resolution (chenson) - closed.
- 0000868: [Task] dbimport needs to support imports from xml format (chenson) - closed.
- 0000870: [Improvement] Do not attempt to route data if a node does not have an identity (chenson) - closed.
- 0000875: [Bug] Node attempts to re-register when it attempts to pull from a non-registration server node that does yet have its security record (chenson) - closed.
- 0000876: [Improvement] During schema upgrade log the old version before attempting upgrade (chenson) - closed.
- 0000877: [Improvement] Downgrade not supported. Don't allow a older version of symmetricds start up against an newer schema (chenson) - closed.
- 0000882: [Bug] Stats Purge Job needs to be clustered. Running on multiple nodes can cause deadlocks (chenson) - closed.
- 0000883: [Bug] Non-authenticated pull wasn't being recorded as a failed pull attempt in sym_node_communication (chenson) - closed.
- 0000884: [Bug] Documented cluster.server.id property is not supported. Add support. (chenson) - closed.
- 0000886: [Improvement] Routing of configuration data (especially the node tables) is very slow when there are lots of nodes (chenson) - closed.

SymmetricDS - 3.1.7 (Released 2012-10-22) 
=========================================
- 0000825: [Improvement] Improve error handling around SymmetricEngineHolder if the engines dir isn't writeable or isn't a directory (chenson) - closed.
- 0000834: [Improvement] Add clarity to mention of CRON to differentiate Springs version vs the typical Unix one. (mhanes) - closed.
- 0000846: [Bug] SymmetricDS won't work with database names with a '-' in them on MySQL (chenson) - closed.
- 0000847: [Bug] dbexport does not extract timestamp columns correctly on oracle (chenson) - closed.
- 0000851: [Bug] Add primary key to SYM_REGISTRATION_REQUEST to make Azure happy (chenson) - closed.
- 0000856: [Bug] DbExport to XML and SYM_XML does not escape data (chenson) - closed.
- 0000859: [Bug] Changing external_select on sym_trigger does not cause syncTriggers to regenerate a trigger (chenson) - closed.
- 0000860: [Bug] Timestamp with timezone doesn't work with timestamp new wins conflict resolution (chenson) - closed.
- 0000862: [Bug] Wildcard matches in sym_trigger match more than they should (chenson) - closed.
- 0000863: [Bug] When testing to see if a symmetric trigger exists on postgres, also check for the existence of the function (chenson) - closed.
- 0000864: [Bug] LoadFilterService insert method fails. Effects the pro gui. (chenson) - closed.

SymmetricDS - 3.1.6 (Released 2012-10-02) 
=========================================
- 0000843: [Improvement] Add ability wire in database writer filters to dbimport (chenson) - closed.
- 0000845: [Bug] The STAGE_MANGEMENT and WATCHDOG jobs are not initialized (they won't work in a clustered environment) (chenson) - closed.
- 0000841: [Bug] 2 triggers for the same table that sync different subsets can end up causing errors (chenson) - closed.
- 0000844: [Bug] Windows Azure does not allow the use of context_info which SymmetricDS uses (chenson) - closed.

SymmetricDS - 3.1.5 (Released 2012-09-12) 
=========================================
- 0000822: [Improvement] Add new constructor to ClientSymmetricEngine so SymmetricDS can share an embedding application's Datasource and Spring Context (chenson) - closed.
- 0000820: [Bug] Inactivate database trigger when trigger_router is removed. (chenson) - closed.
- 0000811: [Bug] H2 trigger template doesn't resolve schema (chenson) - closed.
- 0000821: [Bug] Mark data row as unrouted if no trigger_router can be found for it (chenson) - closed.
- 0000815: [Bug] decode() function needs qualified in most recent version of Greenplum (mhanes) - closed.
- 0000819: [Bug] Support alter table alter column on H2 when column size changes (chenson) - closed.
- 0000816: [Bug] Log messages in AbstractJob are reversed (chenson) - closed.
- 0000813: [Bug] Trigger and Router Cache should be refreshed prior to syncTriggers (chenson) - closed.
- 0000808: [Improvement] Document installing as a service for Ubuntu (chenson) - closed.
- 0000817: [Improvement] Take only the first 50 characters of an ipaddress in order to make sure database save to tables doesn't fail (chenson) - closed.
- 0000814: [Bug] SqlScript autocommit=false with unique key error doesn't rollback or report exception in listener (chenson) - closed.
- 0000818: [Bug] Support alters tables statements for column size changes in postgres (chenson) - closed.
- 0000812: [Improvement] Better document various options related to inital loads in the User's Guide (chenson) - closed.
- 0000807: [Improvement] Allow the symmetric-core parameter parser to work with other parameter files. (abrougher) - closed.

SymmetricDS - 3.1.4 (Release 2012-09-08) 
======================================
- 0000796: [Improvement] AbstractSqlTemplate should report an error if a named parameter map is passed in that does not contain a required parameter (chenson) - closed.
- 0000793: [Bug] Columns of type OID and LO in Postgres do not work with sym_trigger.use_stream_lobs set to 1 (chenson) - closed.
- 0000800: [Bug] DbFill is incorrectly generating new random values for columns containing a FK reference. (abrougher) - closed.
- 0000797: [Bug] table structure sync with wildcards (chenson) - closed.
- 0000794: [Improvement] Support the lo datatype in postgres (chenson) - closed.
- 0000803: [Improvement] Check that column names match column values in the abstract router. If not log details. (chenson) - closed.
- 0000798: [Improvement] Refactor and improved Subselect Router, External Select, and Column Match Router documentation (chenson) - closed.
- 0000795: [Bug] ip_address field is not long enough to contain ipv6 addresses (chenson) - closed.
- 0000792: [Improvement] Support tables with names greater than 50 chars (chenson) - closed.
- 0000804: [Bug] Derby update trigger doubles up the row data (capture columns twice) (chenson) - closed.
- 0000799: [Bug] Tutorial initial load select needs single quotes around external id variable (chenson) - closed.

SymmetricDS - 3.1.3 (Released 2012-08-28) 
=========================================
- 0000787: [Bug] DbFill does not generate random values from BigInteger columns. (abrougher) - closed.
- 0000784: [Improvement] Use the NetworkInterface Java class to get the current ipAddress of a node (chenson) - closed.
- 0000788: [Bug] DbFill is populating columns with foreign values when a foreign key is not defined for the column. (abrougher) - closed.
- 0000785: [Bug] syncTriggers(true) does not force trigger to be rebuilt (chenson) - closed.
- 0000790: [Bug] stream.to.file.enabled=false opens outgoing transport multiple times which causes ack to be lost sometimes (chenson) - closed.
- 0000786: [Improvement] Create a unit test for DbFill. (abrougher) - closed.
- 0000783: [Bug] Null date in the primary key causes parse exception on postgres (chenson) - closed.

SymmetricDS - 3.1.2 (Released 2012-08-22)
=========================================
- 0000776: [Improvement] Change SqlScriptReader to allow comments in places other than the beginning of a line in a sql script (chenson) - closed.
- 0000778: [Bug] If database user doesn't have permission to drop trigger, extra trigger_hist rows get created and the old are not deactivated (chenson) - closed.
- 0000774: [Bug] DbFill does not respect a columns scale and precision. (abrougher) - closed.
- 0000781: [Bug] Restart of jobs can cause embedded derby database connections to fail (chenson) - closed.
- 0000775: [Improvement] Change SqlScript to use SqlScriptReader so that statements are streamed (chenson) - closed.

SymmetricDS - 3.1.1 (Released 2012-08-14) 
=========================================
- 0000773: [Bug] SqlScriptReader doesn't handle // comments correctly (chenson) - closed.

SymmetricDS - 3.1.0 (Released 2012-08-13)  
=========================================
- 0000655: [Task] Update dbexport and dbimport to support the SymmetricDS XML format (abrougher) - closed.
- 0000771: [Improvement] DbFill should have the ability to load all of the tables in a given schema with random data. (abrougher) - closed.
- 0000770: [New Feature] Improve DbImport so that it incorporates the SymmetricDS data loader (chenson) - closed.
- 0000757: [Improvement] All tables are synchronized during a CREATE batch when initial.load.create.first is true resulting in a lot of table missing (chenson) - closed.
- 0000769: [Bug] Tomcat Deployment Broken (chenson) - closed.
- 0000669: [Improvement] Add schema and catalog to the SymmetricDS Batch XML and change the publisher to fill in the schema and catalog (chenson) - closed.
- 0000725: [New Feature] Add a feature to allow dynamic load filters to be created and executed based configuration (gwilmer) - closed.
- 0000728: [Improvement] Lookup table router should throw an exception when the router expression is invalid. (abrougher) - closed.
- 0000747: [Improvement] DbImport should have an empty constructor to make dependency injection easier. (abrougher) - closed.
- 0000730: [Bug] dbexport schema property ignored when data is exported. (abrougher) - closed.
- 0000748: [Bug] Data in a single transaction is split across batches and is out of order on Firebird (gwilmer) - closed.
- 0000753: [Bug] The url for extracting a batch http://server:31415/sync/batch/nodeid-batchid [^] does not work if the nodeid has a '-' in it (chenson) - closed.
- 0000759: [New Feature] Create utility to fill a given database with random data. (abrougher) - closed.
- 0000716: [Improvement] dbimport should have an option that allows tables to be altered to match the import versus always trying to create them. (chenson) - closed.
- 0000768: [Bug] Don't hide startup errors if the spring context fails to start (chenson) - closed.
- 0000767: [Bug] Latest oracle jdbc drivers for 11g return (0,-127) for types defined as integer resulting in bad mappings (chenson) - closed.
- 0000763: [Improvement] When logging to the console, log to system.err so that command line utilities can redirect system.out to files (chenson) - closed.
- 0000762: [Improvement] Change command line options --noconsole to --no-log-console and --nologfile to --no-log-file (chenson) - closed.
- 0000760: [Bug] Columns mismatched on updates when source table has more columns than the target table. (chenson) - closed.
- 0000756: [Bug] If an initial load is aborted by marking batches as OK, the client might remain in initial load mode and end up in a loop. (chenson) - closed.
- 0000752: [Bug] Null pointer during trigger inactivation of deleted table can cause SymmetricDS engine not to start (chenson) - closed.
- 0000751: [Improvement] Add new extension point called INodeIdCreator that replaces INodeIdGenerator and gets the remote address and host passed to it (chenson) - closed.
- 0000746: [Improvement] Improve documentation on how to handle Oracle error 'ORA-01489: result of string concatenation is too long' (chenson) - closed.
- 0000745: [Bug] Type of float(63) on oracle loses precision during data load. (chenson) - closed.
- 0000740: [Bug] Symadmin help subcommand missing (chenson) - closed.
- 0000724: [Task] Include an example of filtering or data subsetting (route items to a store) in the User Guide Tutorial (chenson) - closed.
- 0000738: [Bug] AbstractSymmetricEngine should call init() method of the SecurityService (chenson) - closed.
- 0000744: [Bug] Inefficient 'Sort by Foreign Keys' algorithm (chenson) - closed.
- 0000726: [New Feature] Add a new parameter that, when set, is evaluated to choose a node id (chenson) - closed.
- 0000743: [Bug] Load fails when a null lob column is updated in same batch where the lob column is not null (chenson) - closed.
- 0000742: [Bug] "ORA-01000: maximum open cursors exceeded" during initial load (RouterService.insertInitialLoadEvents) (chenson) - closed.
- 0000739: [Bug] Multiple wildcard expressions, only one used (chenson) - closed.
- 0000737: [Bug] The symmetric engine won't startup in single server mode as a war unless a property file has been specified in the web.xml (chenson) - closed.
- 0000736: [Bug] deployment_type not being recorded properly in sym_node (chenson) - closed.
- 0000735: [New Feature] dbimport and dbexport should support symmetric batch xml. (chenson) - closed.
- 0000733: [Improvement] dbexport should use the default schema and default catalog if they aren't specified (chenson) - closed.
- 0000734: [Bug] H2 wasn't selecting the schema or catalog in the table lookup (chenson) - closed.
- 0000729: [Bug] oracle.template.precision should be supported in 3.0 (chenson) - closed.
- 0000732: [Bug] Support varying Locales for the "REAL" data type (e.g., Oracle's Float(63)) (chenson) - closed.
- 0000731: [Improvement] Redo the derby database triggers so they can handle tables with more columns (chenson) - closed.
- 0000727: [Improvement] Upgrade Derby to 10.9.1.0 (chenson) - closed.

SymmetricDS - 3.0.10 (Released 2012-07-23) 
==========================================
- 0000713: [Bug] Automate upgrade from 2.x to 3.x on most platforms (chenson) - closed.
- 0000700: [Bug] StackOverflowError when filtering data during initial load (chenson) - closed.
- 0000722: [Bug] Sync of a date field on the source to a datetime field on a target fails (chenson) - closed.
- 0000715: [Bug] Default values with underscores end up escaped (unecessarily) with a '\' or '%' character on MySQL (chenson) - closed.
- 0000720: [Bug] Variable Transform source-node-id incorrect on Extract type transforms (chenson) - closed.
- 0000721: [Improvement] Explicitly set the key alias and the keystore type on the ssl connector (chenson) - closed.
- 0000723: [Bug] XML with DATE column type gets created as a DATETIME on SQL Server (chenson) - closed.

SymmetricDS - 3.0.9 (Released 2012-07-14) 
======================================
- 0000707: [Bug] Fix JarBuilder for Windows (gwilmer) - closed.
- 0000709: [Bug] Wildcard table lookup should respect the db.metadata.ignore.case property (chenson) - closed.
- 0000711: [Bug] Table inactivation doesn't work properly when using the wildcard feature of sym_trigger (chenson) - closed.
- 0000712: [Bug] drop trigger doesn't work on Oracle if the trigger is in a different schema (chenson) - closed.

SymmetricDS - 3.0.8 (Released 2012-07-11) 
======================================
- 0000696: [Bug] Data is being pinged back during a re-registration (chenson) - closed.
- 0000694: [Bug] JdbcSqlTemplate allows null SqlTemplateSettings and then uses it without null check later on (gwilmer) - closed.
- 0000705: [Bug] When using the wildcard feature of SymmetricDS, the reload events aren't being generated properly (chenson) - closed.
- 0000695: [Bug] UseVariableDates option for DbImport and DbExport do not work properly (gwilmer) - closed.

SymmetricDS - 3.0.7 (Released 2012-07-04)
=========================================
- 0000690: [Bug] symmetric-util test code is being packaged with runtime application (chenson) - closed.
- 0000692: [Bug] Escaped varchar data can get corrupted (chenson) - closed.

SymmetricDS - 3.0.6 (Released 2012-06-29) 
=========================================
- 0000670: [Improvement] Better document how nodes are deployed in the engines directory. (chenson) - closed.
- 0000671: [Bug] When the router type is null the batch type is always common. (chenson) - closed.
- 0000672: [Improvement] Support a --engine option for the syadmin create-war command (chenson) - closed.
- 0000673: [Improvement] Start symmetricds engine instance in background (chenson) - closed.
- 0000676: [Bug] dbimport fails to create unique indexes (chenson) - closed.
- 0000678: [Bug] auto.reload is broke in 3.0 (chenson) - closed.
- 0000679: [Bug] DbImport help screen does not display description for --use-variable-dates. (abrougher) - closed.
- 0000680: [Improvement] Don't run the sync triggers process at all if in a SymmetricDS instance and auto.sync.triggers is false (chenson) - closed.
- 0000683: [Bug] Error synchronyzing triggers (NPE) (chenson) - closed.

SymmetricDS - 3.0.5 (Released 2012-06-26) 
=========================================
- 0000665: [Bug] Don't commit a batch that doesn't have commit in the csv protocol (chenson) - closed.
- 0000666: [Improvement] Don't capture the raw record in the csv parser. It allocates more memory than need be. (chenson) - closed.
- 0000667: [Improvement] Improve debug logging when the payload is VERY big. truncate data in the log. (chenson) - closed.
- 0000668: [Bug] sym_trigger.use_stream_lobs had a bug where every column after a lob is not captured (chenson) - closed.

SymmetricDS - 3.0.4 (Released 2012-06-22) 
=========================================
- 0000664: [Improvement] Pass a reference to ISymmetricEngine to the Scripted Router so it has access to SymmetricDS services - closed.
- 0000663: [Improvement] Add a variable transform that makes a column <null> (chenson) - closed.
- 0000659: [Improvement] Instead of failing to load a failed file, log warnings and delete staged resource if it was abandoned during xfer (chenson) - closed.
- 0000656: [Bug] Change the default secret key algorithm used for encrypting/decrypting password from PBEWithMD5AndTripleDES to PBEWithMD5AndDES (chenson) - closed.
- 0000657: [Improvement] SymmetricEngineHolder.install should encrypt database password by default (chenson) - closed.
- 0000658: [Bug] Fix null pointer exception that hides true exception during install of triggers (chenson) - closed.

SymmetricDS - 3.0.3 (Released 2012-06-18) 
=========================================
- 0000652: [Bug] Update documentation about how to configure purge (chenson) - closed.
- 0000647: [Bug] Fallback from insert to update causes an array index out of bounds exception (admin) - closed.

SymmetricDS - 3.0.2 (Released 2012-06-18)  
======================================
- 0000648: [Bug] Nested database transactions prevents H2 installation from deleting transforms sometimes. (chenson) - closed.
- 0000649: [Bug] Column matching routers can't match values with spaces. (abrougher) - closed.
- 0000651: [Bug] Initial Load Order not being honored. (chenson) - closed.
- 0000645: [Bug] Empty staged resource can be left around during the extract if there is an error during data extraction which causes SymmetricDS (chenson) - closed.

SymmetricDS - 3.0.1 (Released 2012-06-06)  
=========================================
- 0000638: [Improvement] Support Microsoft's JDBC 4 Driver for SQL Server - closed.
- 0000639: [Improvement] Support Windows Azure - closed.
- 0000640: [Improvement] For fallback, if update fails and then the insert fails (pk changed and row already exists), then attempt to update using the ne - closed.
- 0000641: [Improvement] Don't initial load a table if the initial load order is < 0 - closed.
- 0000642: [Bug] transforms with a transform_policy of implied don't copy primary keys to transform on insert - closed.
- 0000643: [Bug] Firebird requires commits after each ddl statement during upgrades - closed.
- 0000644: [Bug] Carriage return and line feeds are not being handled properly in the creation and parsing of CSV for 3.0.0 - closed.

SymmetricDS - 3.0.0 (Released 2012-06-04)  
=========================================

This major release restructures the code for performance improvements and adds conflict management.

- 0000629: [Bug] We don't quote the catalog and schema when allowing sql server identity inserts - closed.
- 0000630: [Bug] Make sure cached table definitions are cleared out before running sync triggers. - closed.
- 0000560: [Improvement] Support of AES Encryption Is Needed (elong) - closed.
- 0000628: [Bug] Duplicate columns in table. Fix jdbc ddl reader so that reading table columns is qualified by schema and catalog - closed.
- 0000608: [Improvement] Optimization - Only capture one row in sym_data_event per sym_data when all the routers on a channel always send to all nodes in - closed.
- 0000618: [New Feature] Add setting on trigger that indicates whether old data should be captured by the triggers - closed.
- 0000621: [Improvement] Reload parameters from sym_parameter when they come through the data loader or data router (so you don't have to wait for the ca - closed.
- 0000622: [Improvement] Restart jobs if job parameters come through the data loader or data router - closed.
- 0000623: [New Feature] Add the ability to set a status of IG (ignore) on either an incoming or outgoing batch so that the status will be transmitted re - closed.
- 0000624: [Bug] The subselect router should not kick in during an initial load if the initial_load_select is used - closed.
- 0000625: [Improvement] Upgrade Jetty from 7.1 to 7.6 (latest stable 7.x version) to fix sporadic EOF exceptions - closed.
- 0000626: [Improvement] Use prepared args for the OK status in the purge service. Not sure if it makes a difference, but the wrong query plans are somet - closed.
- 0000006: [New Feature] Add more robust conflict resolution strategies - closed.
- 0000423: [Improvement] Add configurable file cache folder - closed.
- 0000543: [Bug] Column's JdbcTypeName is Null - closed.
- 0000548: [Bug] Remove invalid documentation for embedded.webserver.basic.auth.username and embedded.webserver.basic.auth.password - closed.
- 0000549: [Bug] Section 4.8.2 Transformation Types fails to mention pre-defined Lookup Transform type - closed.
- 0000562: [Bug] Fix DataService bug. Max data id that is currently handled in 2.x is Integer.MAX_VALUE. It should go all the way up to Long.MAX_ - closed.
- 0000564: [Improvement] Add external_data to subselect router - closed.
- 0000566: [Improvement] Add documentation re purge requirements and sym_node_security - closed.
- 0000592: [New Feature] Make the data loader pluggable so that bulk loaders can be configured at the channel level. - closed.
- 0000593: [Improvement] Re-factor the data loader and data extractor so the components can be re-used outside of the core symmetricds engine - closed.
- 0000594: [Improvement] Remove dependency on commons-logging in favor of using slf4j everywhere for logging - closed.
- 0000595: [Improvement] Turn on multiServerMode as the default. Update tutorial and documentation - closed.
- 0000601: [Bug] Data type for data_id and batch_id should be a type that scales bigger than an integer - closed.
- 0000605: [New Feature] Support wildcards for the source_table_name in sym_trigger so you only have to configure one trigger entry to sync and entire da - closed.
- 0000607: [New Feature] Order triggers by FK constraints for initial load when initial_load_order is the same. - closed.
- 0000609: [New Feature] Add dbexport and dbimport features to SymmetricDS - closed.
- 0000613: [New Feature] Add a column_policy column to sym_transform_table that indicates whether undefined columns are specified or implied - closed.
- 0000616: [Improvement] Refresh parameter cache whenever new parameters come through the data loader or data router. - closed.
- 0000597: [Improvement] Consolidate database platform (former ddlutils) code and symmetricdialect code that contains information that should be in the p (chenson) - closed.
- 0000596: [Improvement] Load each batch as it arrives at the target (instead of transporting all batches for 1 sync and then loading them all) (chenson) - closed.
- 0000631: [Improvement] Add FKs to the SymmetricDS configuration tables - closed.
- 0000632: [New Feature] Create new feature to allow concurrent pulling and pushing of nodes - closed.
- 0000633: [Bug] Don't route inserts of sym_node or sym_node_security to the associated node_id - closed.
- 0000634: [Improvement] Speed up node reloads on push. Continuously push to a node if the previous push contained a reload event. - closed.
- 0000636: [Improvement] Support bigger than 32k clobs and varchar columns by swapping out sym_escape for REPLACE in the Firebird dialect - closed.
- 0000637: [Improvement] By default delete sym_data_gap rows instead of marking them as OK or SK - closed.