SymmetricDS - Change Log

SymmetricDS - 3.7.0 (Not Yet Released) View Issues ]
======================================
- 0002108: [Improvement] Add processinfo to track when symmetricds is "inserting load events" on the route job thread (chenson) - resolved.
- 0002102: [Improvement] Remove double logging of exception messages to improve log readability (chenson) - resolved.
- 0001621: [Improvement] Move SymmetricDS to Gradle (chenson) - resolved.
- 0002092: [Bug] Should be able to remove mongo and amazon jar files and the application should still work (chenson) - resolved.
- 0001828: [Improvement] Update jTDS driver from 1.2.4 to 1.2.8 (chenson) - resolved.
- 0001756: [Bug] dbimport doesn't handle relative pathnames (elong) - resolved.
- 0002047: [Improvement] Add extension service that can read extensions from database (elong) - resolved.
- 0002067: [Bug] Snapshot fails when run on nodes that are not registered (chenson) - resolved.
- 0002063: [Improvement] Remove the getName() method from the IColumnTransform interface (chenson) - resolved.
- 0002060: [Improvement] We currently log data sent and received from jobs at INFO level. Do the same from the server side. (chenson) - resolved.
- 0002057: [Improvement] The sync triggers cluster lock is being grabbed every ten seconds (so initial load events are not inserted during trigger sync) (chenson) - resolved.
- 0002050: [Bug] dropping a table before dropping trigger causes NPE (chenson) - resolved.
- 0002040: [Improvement] Can't set windows service dependencies in sym_service.conf (elong) - resolved.
- 0002048: [Improvement] Option for delayed start of Windows service (elong) - resolved.
- 0002020: [Bug] Log4j cannot be configured to send errors by email (chenson) - resolved.
- 0001970: [Improvement] Valuemap transform syntax for passing values through (elong) - resolved.
- 0001952: [Bug] NullPointerException when setting replication for an unsupported table in PostgreSQL (chenson) - resolved.

[17 issues]

SymmetricDS - 3.6.17 (Not Yet Released) View Issues ]
=======================================
- 0002107: [Bug] Initial load extract in background can fail when purge is set aggressively (chenson) - resolved.
- 0002104: [Improvement] Add feature to turn off the use of default values in the create schema first feature (chenson) - resolved.
- 0002078: [Bug] Service wrapper unsatisfied link error (elong) - resolved.
- 0002090: [Bug] Informix installations fail when existing SymmetricDS tables exist due to case sensitive comparisons (chenson) - resolved.
- 0002101: [Improvement] Add a property that instructs symmetricds to use PK from target tables when creating update and delete statements (chenson) - resolved.
- 0002094: [Bug] Row deletion is not synced if table has conflict resolution by timestamp (chenson) - resolved.
- 0002100: [Bug] getChannelStatus REST call is broken (chenson) - resolved.

[7 issues]

SymmetricDS - 3.6.16 (Released 2014-12-11) View Issues ]
==========================================
- 0002093: [Bug] Table structure changes, sym_trigger is updated and old table structure is used for new trigger (chenson) - closed.
- 0002097: [Bug] sync triggers gets called during and initial load (chenson) - closed.

[2 issues]

SymmetricDS - 3.6.15 (Released 2014-12-04) View Issues ]
==========================================
- 0002087: [Bug] Extract initial load in background doesn't work with wildcard catalogs and schemas (chenson) - closed.

[1 issue]

SymmetricDS - 3.6.14 (Released 2014-12-01) View Issues ]
==========================================
- 0001310: [Improvement] Support sql dialect 1 for firebird (elong) - closed.
- 0002062: [Bug] Slow SYM_DATA reads on Firebird (chenson) - closed.
- 0002064: [Bug] NVARCHAR field is not mapped in MySQL DDL Builder (josh-a-hicks) - closed.
- 0002065: [Bug] Newer wins conflict resolution does not work on Android (chenson) - closed.
- 0002068: [Bug] SymmetricLauncher references a MySQL string utils class. The MySQL jdbc jar file should not be required (chenson) - closed.
- 0002069: [Bug] MySQL DDL Builder for auto increment columns, decimal type is not valid must be bigint (josh-a-hicks) - closed.
- 0002076: [Bug] Synchronization is not performed if datetime column has changes in fractional seconds part (chenson) - closed.
- 0002077: [Bug] Sql Server and MySQL bulk database writer should use quoted identifiers around table names (chenson) - closed.
- 0002081: [Improvement] Disable SSLv3 (chenson) - closed.

[9 issues]

SymmetricDS - 3.6.13 (Released 2014-11-10) View Issues ]
==========================================
- 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.

[4 issues]

SymmetricDS - 3.6.12 (Released 2014-11-03) View Issues ]
==========================================
- 0002029: [Bug] When old data is off and a primary key is updated in the same batch where a primary key is not updated will result in a failure (chenson) - closed.
- 0002030: [Improvement] For initial load deletes, provide BOTH source and target node replacement variables (chenson) - closed.
- 0002032: [Improvement] Resolve table name in create trigger statement with default catalog and schema if source catalog and schema are not specified (chenson) - closed.
- 0002036: [Improvement] When a router fails to route a data row, no information is logged about the failed data row (chenson) - closed.
- 0002041: [Bug] Initial load failing on Interbase because of "Implementation limit exceeded. Block size exceeds implementation restricti (chenson) - closed.
- 0002042: [Bug] Create of data_id trigger on sym_data fails on firebird and interbase if db.delimited.identifier.mode=false (chenson) - closed.
- 0002043: [Bug] The "other" data type template for Postgres should escape string values just like the string template. (chenson) - closed.
- 0002046: [Improvement] Add left and bleft column transforms (chenson) - closed.

[8 issues]

SymmetricDS - 3.6.11 (Released 2014-10-27) View Issues ]
==========================================
- 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 redshift.append.to.copy.command 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.

[12 issues]

SymmetricDS - 3.6.10 (Released 2014-10-09) View Issues ]
==========================================
- 0001997: [Bug] Excessive logging from PropertiesFactoryBean (elong) - closed.
- 0001998: [Bug] Support ntext type on sql server with the JTDS driver (chenson) - closed.
- 0001999: [Bug] Server can hang when database is unavailable while attempting to handle connection attempt from client (chenson) - closed.
- 0002000: [Bug] SymmetricDS startup fails. Check for existence of sym tables isn't limited to the default catalog and schema at start up (chenson) - closed.
- 0002002: [Bug] delete and update transforms are broken when dealing with compound primary keys (chenson) - closed.
- 0002004: [Bug] Multiplier transforms don't use correct old data (chenson) - closed.
- 0002006: [Improvement] Add dataloader.apply.changes.only property that control whether update statements will update all columns or only changed column (chenson) - closed.

[7 issues]

SymmetricDS - 3.6.9 (Released 2014-09-30) View Issues ]
=========================================
- 0001942: [Bug] PostGIS initial load fails unless you set initial.load.concat.csv.in.sql.enabled=true (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.

[16 issues]

SymmetricDS - 3.6.8 (Released 2014-09-17) View Issues ]
=========================================
- 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.

[14 issues]

SymmetricDS - 3.6.7 (Released 2014-09-02) View Issues ]
=========================================
- 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.

[2 issues]

SymmetricDS - 3.6.6 (Released 2014-08-27) View Issues ]
=========================================
- 0001920: [New Feature] Redshift database dialect (elong) - closed.
- 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 dataloader.fit.to.column 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.

[13 issues]

SymmetricDS - 3.6.5 (Released 2014-08-11) View Issues ]
=========================================
- 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.

[17 issues]

SymmetricDS - 3.6.4 (Released 2014-08-02) View Issues ]
=========================================
- 0001867: [Bug] Windows service won't stop (elong) - closed.
- 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.

[7 issues]

SymmetricDS - 3.6.3 (Released 2014-07-29) View Issues ]
=========================================
- 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 initial.load.concat.csv.in.sql.enabled=false and db.treat.date.time.as.varchar.enabled=true (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.

[27 issues]

SymmetricDS - 3.6.2 (Released 2014-07-12) View Issues ]
=========================================
- 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] external.id.is.unique.enabled 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 stream.to.file.threshold.bytes 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.

[19 issues]

SymmetricDS - 3.6.1 (Released 2014-06-26) View Issues ]
=========================================
- 0001734: [Bug] Audit table created with wrong schema (chenson) - closed.
- 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.

[4 issues]

SymmetricDS - 3.6.0 (Released 2014-06-16) View Issues ]
=========================================
- 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.
- 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 http://postgis.refractions.net/ [^] (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] host.bind.name 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 db.spring.bean.name (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.
- 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.

[64 issues]

SymmetricDS - 3.5.22 (Released 2014-05-27) View Issues ]
==========================================
- 0001367: [New Feature] Create bulk loader for SQLServer (gwilmer) - resolved.
- 0001712: [Bug] null pointer at startup when sync.url is null in the database (chenson) - closed.
- 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) - closed.
- 0001722: [Bug] Trigger errors for large numerics on SQL Server: Arithmetic Overflow Error (josh-a-hicks) - closed.
- 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 trigger.update.capture.changed.data.only.enabled 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.

[11 issues]

SymmetricDS - 3.5.21 (Released 2014-04-28) View Issues ]
==========================================
- 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.

[8 issues]

SymmetricDS - 3.5.20 (Released 2014-04-14) View Issues ]
==========================================
- 0001667: [Improvement] Support capturing only changed data (trigger.update.capture.changed.data.only.enabled) 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.

[5 issues]

SymmetricDS - 3.5.19 (Released 2014-03-16) View Issues ]
==========================================
- 0001629: [Improvement] SQL Server bulk loader option to fire triggers (elong) - closed.
- 0001630: [Bug] SQL Server bulk loader extra spaces causes truncation error (elong) - closed.
- 0001631: [Bug] CSV is missing "columns" row when two different sets of columns are being used with three different inserts or updates (chenson) - closed.
- 0001632: [Bug] SQL Server bulk loader does not handle BLOB (elong) - closed.
- 0001633: [Bug] MySQL bulk loader error with Windows-based server (elong) - closed.
- 0001634: [Improvement] Snapshot utility properties show changes, remove passwords, and sort (elong) - closed.
- 0001636: [New Feature] Add capture changed data only to Postgres (elong) - closed.
- 0001638: [Improvement] REST call for client to know how many batches and rows are waiting (elong) - closed.
- 0001639: [Improvement] MySQL and SQL-Server bulk loaders loading rows multiple times (elong) - closed.
- 0001645: [Bug] MySQL bulk loader does not load NULL (elong) - closed.
- 0001646: [Bug] MySQL bulk loader columns out of order (elong) - closed.

[11 issues]

SymmetricDS - 3.5.18 (Released 2014-03-02) View Issues ]
==========================================
- 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.

[9 issues]

SymmetricDS - 3.5.17 (Released 2014-02-15) View Issues ]
==========================================
- 0001420: [Task] Generate parameter documentation automatically from symmetric-default.properties. (elong) - closed.
- 0001566: [Improvement] Column match router support for "contains" and "not contains" (elong) - closed.
- 0001578: [Bug] Jobs can lock up if jobs.synchronized.enable is on and routing.peek.ahead.window.after.max.size is smaller then data rows (chenson) - closed.
- 0000810: [Improvement] symadmin reload-table - pass multiple tables (elong) - closed.
- 0001568: [Bug] NullPointerException when initial.load.create.first is on using wildcard trigger definitions on postgres (chenson) - closed.
- 0001455: [Bug] Audit tables don't get created (chenson) - closed.
- 0001484: [Improvement] Firebird trigger should be created at a position other than 0 so that users can define triggers that fire before the sym trigger (chenson) - closed.
- 0001562: [Bug] Routing using TransactionId causes bad routing when H2 DB is restarted (chenson) - closed.
- 0001565: [Bug] Ambiguous reference to sysindexes (elong) - closed.
- 0001567: [Bug] Transforms that are symmetric aware can get the wrong symmetric engine when multi-homed (chenson) - closed.
- 0001569: [Bug] System clock goes too fast (elong) - closed.
- 0001572: [Bug] Windows Problem Calling sym.bat from Another Drive (chenson) - closed.
- 0001573: [Bug] Peek ahead window smaller than expected (chenson) - closed.
- 0001574: [Bug] Too many routers are run when file sync targets more than one node group (chenson) - closed.
- 0001576: [Improvement] File Sync's default batch algorithm should be nontransactional (chenson) - closed.
- 0001579: [Bug] target_base_dir can be null in file_trigger. causes null pointer in filesyncservice save of snapshot due to / replacement (mhanes) - closed.
- 0001580: [New Feature] Expose the relative target directory as a variable that can be scripted in order to flatten the directory structure in file sync (chenson) - closed.
- 0001583: [Improvement] Create new value map column transform (mhanes) - closed.

[18 issues]

SymmetricDS - 3.5.16 (Released 2014-02-05) View Issues ]
==========================================
- 0001559: [Improvement] If there are no primary keys defined when the database writer is processing an update or delete report an error. (chenson) - closed.
- 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.

[16 issues]

SymmetricDS - 3.5.15 (Released 2014-01-22) View Issues ]
==========================================
- 0001319: [Bug] Symmetric databases install fails on Postgres (elong) - closed.
- 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.

[4 issues]

SymmetricDS - 3.5.14 (Released 2014-01-17) View Issues ]
==========================================
- 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.
- 0001520: [Improvement] Add further details about Linux installation as a service options (mhanes) - 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.
- 0001534: [Bug] API - createTriggersOnChannelForTables() fails when it encounters a table name that is longer than 50 characters (chenson) - closed.

[11 issues]

SymmetricDS - 3.5.13 (Released 2014-01-06) View Issues ]
==========================================
- 0001497: [Bug] Missing primary key with Stream Lobs causes initial load to fail (mhanes) - 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.
- 0001496: [Bug] Triggers not created when "handle key updates" enabled (mhanes) - closed.
- 0001498: [Bug] Table reload broken on Sybase ASA 9 (elong) - closed.
- 0001502: [Improvement] Assign a load id to batches that contain reload events when the batch is created during routing (chenson) - closed.
- 0001504: [Improvement] Add variables to initial load delete SQL (elong) - 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.
- 0001469: [Bug] Time and Timestamp field issues on Firebird and Postgres databases (chenson) - closed.

[13 issues]

SymmetricDS - 3.5.12 (Released 2013-12-18) View Issues ]
==========================================
- 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.
- 0001466: [Bug] REST API - setting the target schema and/or catalog does not work when using the REST API (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.
- 0001486: [Bug] File Sync "sync_on_delete" not honored. (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.
- 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.
- 0001475: [Bug] Replication From Branch to Central Broken (Firebird at Both Ends) (chenson) - closed.

[17 issues]

SymmetricDS - 3.5.11 (Released 2013-11-15) View Issues ]
==========================================
- 0000575: [Bug] Triggers are created without transaction_id function when auto.config.database=false (chenson) - closed.
- 0001269: [New Feature] Update ddl utils xml to support specific database types so create schema commands replicate the same schema on same databases (chenson) - closed.
- 0001448: [Improvement] Provide global parameter to specify that BSH database writer filters will handle missing tables (mhanes) - closed.
- 0001449: [Improvement] Add support for allowing a database writer filter to change the target tables catalog, schema and table name (chenson) - closed.
- 0001450: [Bug] ignore case parameter should apply to only the table (not schema and catalog) for now in the load filter (chenson) - closed.
- 0001451: [Improvement] Expose apis to prefix a Database and read a list of Table from the physical database (chenson) - closed.
- 0001457: [Bug] PostgreSQL timestamp with timezone columns won't sync for very old, European dates. (mhanes) - closed.
- 0001460: [Bug] On postgres, when sync triggers is run from symadmin tool the generated triggers put null into the transaction id field (chenson) - closed.
- 0001462: [Bug] Stored procedure with NOCOUNT is rolled back (elong) - closed.
- 0001458: [Improvement] Add support for Oracle's TIMESTAMP WITH LOCAL TIME ZONE data type (chenson) - closed.

[10 issues]

SymmetricDS - 3.5.10 (Released 2013-10-20) View Issues ]
==========================================
- 0001429: [Bug] sym_pkg is hard coded in the oracle dialect so the prefix parameter doesn't work on Oracle (chenson) - closed.
- 0001438: [Improvement] Improve memory footprint usage when big lobs are in flight (chenson) - closed.
- 0001440: [Improvement] Implement simple conflict resolution for file sync (chenson) - closed.
- 0001442: [Bug] Statements are being prepared too often. Results in poor data loading performance on Firebird (and possibly other platforms) (chenson) - closed.
- 0001447: [Improvement] Change error message if a batch fails to transport because of an EOF error to be more intuitive. (chenson) - closed.

[5 issues]

SymmetricDS - 3.5.9 (Released 2013-10-10) View Issues ]
=========================================
- 0001430: [Bug] When a file is modified on Windows it is not unpacked at the target of a file sync (chenson) - closed.
- 0001431: [Bug] SQLite primary keys only recognized when they are in column position 1. (mhanes) - closed.
- 0001433: [Improvement] Expose api so a single sym table and single trigger can be installed without other SymmetricDS configuration (chenson) - closed.
- 0001436: [Improvement] Set table name on processinfo before attempting extract query for initial load (chenson) - closed.
- 0001437: [Bug] Multi-homed temp file system should be keyed by engine name to prevent collisions (mhanes) - closed.

[5 issues]

SymmetricDS - 3.5.8 (Released 2013-09-24) View Issues ]
=========================================
- 0001426: [Bug] Postgres datetime with timezone not formatted correctly when timezone_hour offset = 0 and timezone_minute offset < 0 (gwilmer) - closed.

[1 issue]

SymmetricDS - 3.5.7 (Released 2013-09-14) View Issues ]
=========================================
- 0001414: [Improvement] Add build information to Manifest and use it from AbstractVersion to get version information. Add build time to the version api (chenson) - closed.
- 0001412: [Bug] Numeric(15,5) type columns are truncated when written to Sybase dialects. (abrougher) - closed.
- 0001416: [Improvement] TriggerRouterService should cache a list of TriggerRouter's for each channel instead of querying db each time. (abrougher) - closed.
- 0001419: [Bug] USE_STREAM_LOBS=1 in Oracle does not replicate LOB data (chenson) - closed.
- 0001413: [Bug] SymmetricDS not returning the fully qualified hostname (abrougher) - closed.

[5 issues]

SymmetricDS - 3.5.6 (Released 2013-09-05) View Issues ]
=========================================
- 0001356: [Bug] money field type with PostgreSQL (chenson) - closed.
- 0001409: [Bug] The database uninstall feature does not remove the sym_ H2 trigger tables. (abrougher) - closed.
- 0001410: [Bug] When USE_CAPTURE_OLD_DATA is not set, the database writer will not update non null columns to null. (abrougher) - closed.

[3 issues]

SymmetricDS - 3.5.5 (Released 2013-08-27) View Issues ]
=========================================
- 0001381: [Bug] transform_table.target_table_name should be optional according the documentation. the transform code requires that is be set (chenson) - closed.
- 0001395: [Improvement] When data is transformed the old values are not retained. (abrougher) - closed.
- 0001397: [Improvement] Conflict detection mechanism USE_CHANGED_DATA should be able to specify columns to ignore. (abrougher) - closed.
- 0001399: [Bug] Config and heartbeat batches can be lost if initial load is scheduled (chenson) - closed.
- 0001400: [Bug] Implied transforms are not implying individual DML transforms. (abrougher) - closed.
- 0001404: [Improvement] Add db.read.strings.as.bytes to turn on functionality to better control character encoding on MySQL (chenson) - closed.
- 0001405: [Bug] If sym_trigger_router.initial_load_delete_stmt is not set, then the initial.load.delete.first.sql property should be used (chenson) - closed.
- 0001396: [Bug] Null pointer in log message when initial load extract job is turned on and a table takes longer than 60 seconds to extract (chenson) - closed.

[8 issues]

SymmetricDS - 3.5.4 (Released 2013-08-20) View Issues ]
=========================================
- 0001334: [Bug] The issue with jConnect JDBC, SQL Anywhere and decimal value (chenson) - closed.
- 0001335: [Bug] dbexport doesn't work with SQL Anywhere (abrougher) - closed.
- 0001382: [Bug] Bad external_data: The bean shell router should unbind external data if it is void because the interpreter is reused (chenson) - closed.
- 0001389: [Bug] Postgres alter to add a default varchar value to a column without a default value fails (chenson) - closed.
- 0001390: [Bug] Not routing configuration properly when a source node group has multiple target node groups (chenson) - closed.
- 0001392: [Bug] When initial.load.use.extract.job.enabled is set to true the byte count and data count aren't being captured (chenson) - closed.
- 0001393: [Bug] Setting a batch to status of IG causes exception when initial.load.use.extract.job.enabled is set to true (chenson) - closed.
- 0001388: [Bug] "The current version of 3.5.3 is newer than the last running version of 3.4.5" prints out many times in the log file at INFO (chenson) - closed.

[8 issues]

SymmetricDS - 3.5.3 (Released 2013-08-10) View Issues ]
=========================================
- 0001368: [Bug] On extraction retries the data_event_count is not reset (chenson) - closed.
- 0001369: [Bug] Alter generated by table upgrade that requires a rebuild of the table, and includes the addition or removal of columns, fails (chenson) - closed.
- 0001370: [Improvement] When initial loads are configured to extract in the background, multiple load requests can queue up on top of each other (chenson) - closed.
- 0001373: [Bug] dropping a column with a default value fails on sql server because of default constraint (chenson) - closed.
- 0001374: [Bug] The primary key constraint name needs to be quoted when dropping a PK on Postgres (chenson) - closed.
- 0001375: [Bug] DB2 dropping column that is part of a composite primary key on a table causes error (chenson) - closed.
- 0001376: [Bug] DB2 table needs reorg after dropping a column. (abrougher) - closed.
- 0001377: [Bug] RestService handleError method should be public. Exceptions are not being serialized to the client properly (chenson) - closed.
- 0001378: [Bug] alterTables(boolean continueOnError, Table... desiredTables) in platform should use isRequiresAutoCommitForDdl (chenson) - closed.
- 0001379: [Improvement] When SymmetricDS starts, schedule the first run of the periodic jobs the period amount away from the last run (chenson) - closed.

[10 issues]

SymmetricDS - 3.5.2 (Released 2013-08-04) View Issues ]
=========================================
- 0001346: [Bug] reloadTable JMX method and command should always route to the node_list (chenson) - closed.
- 0001347: [Bug] Initial load ignores subselect routers and routes to all nodes. (chenson) - closed.
- 0001348: [Bug] Table object passed to DatabaseWriterFilters do not have types on them any more (chenson) - closed.
- 0001350: [Bug] Push batch not getting acked when multiple batches exist and it passed the transport.max.bytes.to.sync threshold (chenson) - closed.
- 0001351: [Bug] PK transform columns transformations run twice (chenson) - closed.
- 0001360: [Bug] rest service should set the engine name for logging (chenson) - closed.
- 0001361: [Bug] StagedResource.setState should support setting the state to itself without failing (chenson) - closed.
- 0001362: [Bug] Background initial load extract was allowing the client to start pulling data for a table that was currently extracting (chenson) - closed.
- 0001363: [Bug] SQL Server DateTime2 type does not work with conflict resolution. (abrougher) - closed.
- 0001365: [Improvement] Print out statistics if data rows in associated with a table/batch take longer than 60 seconds to process (chenson) - closed.
- 0001366: [Bug] If a custom column transformation isn't found the engine silently ignores it. An error should be thrown. (chenson) - closed.
- 0001364: [Improvement] Speed up bsh column transform by evaluating a transform as a method once and then call that method for each data element (chenson) - closed.
- 0001353: [Bug] The batch URL feature is broken (chenson) - closed.

[13 issues]

SymmetricDS - 3.5.1 (Released 2013-07-24) View Issues ]
=========================================
- 0001342: [Bug] Upgrade to 3.5.0 causes sym_trigger_hist to be rebuilt (chenson) - closed.
- 0001343: [Bug] alter of default column value on postgres is not working (chenson) - closed.
- 0001344: [Bug] Sybase ASE can not return columns with the alias "count". (abrougher) - closed.
- 0001345: [Bug] The reload table JMX method and command isn't working (chenson) - closed.
- 0001339: [Bug] When using PayloadType.SQL Symmetric doesn't pay attention to target database catalog and schema rules (gwilmer) - closed.

[5 issues]

SymmetricDS - 3.5.0 (Released 2013-07-22) View Issues ]
=========================================
- 0000046: [New Feature] National Language Support (NLS) data types such as NTEXT and NVARCHAR2 (elong) - closed.
- 0000281: [Bug] MS SQL: Update on varbinary(max) gets not synchronized (elong) - closed.
- 0000398: [Task] Test with latest Oracle JDBC drivers (elong) - closed.
- 0000949: [Bug] reload table doesn't work with wildcard triggers (chenson) - closed.
- 0001143: [Improvement] (Firebird) 64-bit Sym_UDF.dll (chenson) - closed.
- 0001236: [Improvement] Hash trigger text in sym_trigger_hist so we know when triggers change to force a rebuild. (abrougher) - closed.
- 0001295: [Bug] Numeric type on postgres should be read in as a JDBC decimal type (chenson) - closed.
- 0001297: [Improvement] The load filter target table value should only be case sensitive on case sensitive databases. (abrougher) - closed.
- 0001301: [Bug] BSH Load filter will not execute unless table exists on the target database. (abrougher) - closed.
- 0001302: [Improvement] Speed up queries against sym_data, sym_data_gap and sym_outgoing_batch on postgres (chenson) - closed.
- 0001307: [Improvement] Allow users to insert custom trigger text in the Symmetric triggers. (abrougher) - closed.
- 0001317: [Improvement] Bind column names using original case versus requiring router expressions to reference them in UPPER case. (abrougher) - closed.
- 0001318: [Improvement] Bind column names using original case and UPPER case for load filters. (abrougher) - closed.
- 0001321: [Improvement] Attempt recovery from corrupt trigger_hist table by looking up trigger_hist rows by table name when the table name mismatches (chenson) - closed.
- 0001322: [Bug] node_communication locks don't time out (chenson) - closed.
- 0001325: [Improvement] Add sym_registration_request to the purge process (chenson) - closed.
- 0001329: [Bug] ArrayOutOfBoundsException - during removal of column (chenson) - closed.
- 0001330: [Bug] stream.to.file.threshold.bytes and stream.to.file.ttl.ms were documented as overridable in the database but weren't really (chenson) - closed.
- 0001332: [Bug] The /batch url always extracts from the database. It should extract the same way the pull does (use staging). (chenson) - closed.
- 0001333: [Bug] Transforms with a source column containing an empty string or white space fail. (abrougher) - closed.
- 0001336: [Bug] Restart of Android job manager fails when job parameters are changed in the database (chenson) - closed.
- 0001052: [Improvement] Install a default ssl cert if none exists when ssl is turned on so that ssl works by default (chenson) - closed.
- 0001203: [Bug] SymmetricDS cannot operate on Oracle tables with dollar sign in name (chenson) - closed.
- 0001222: [Bug] db. properties are not overridable as -D system properties (chenson) - closed.
- 0001247: [Task] Change license to GPL 3.0 (chenson) - closed.
- 0001249: [New Feature] Add REST API methods to allow a "Pull Only" client (gwilmer) - closed.
- 0001260: [Bug] A null pointer happens when trying to schedule load when sync triggers has never run (chenson) - closed.
- 0001262: [Bug] Locally suspended channels are ignored when a node is pushing during extraction. (abrougher) - closed.
- 0001271: [Bug] Table creation on reload creates columns with default of 'NULL' incorrectly. (chenson) - closed.
- 0001272: [Improvement] Add support for the MySQL POINT data type. (abrougher) - closed.
- 0001274: [Improvement] Do not query the RECYCLEBIN while reading table metadata to see if the table has been recycled. (chenson) - closed.
- 0001277: [Bug] NPE during conflict resolution (use_version -> newer_wins) (chenson) - closed.
- 0001278: [Bug] The IDatabaseWriterFilter should always be passed the source table, not the target table (chenson) - closed.
- 0001218: [Improvement] bind a logger as the "log" variable to the beanshell router, column transform and load filter to make debugging easier (chenson) - closed.
- 0001226: [Bug] Table sym_node_group_channel_window exceeds the max table name length for Sybase ASE 12. (chenson) - closed.
- 0001231: [Improvement] Bind initialLoad flag to the beanshell data router so it can making routing decisions on initial load (chenson) - closed.
- 0001237: [Improvement] JdbcSqlTransaction not logging sql and args for some methods (chenson) - closed.
- 0001245: [Bug] Mariab driver doesn't recognize tables in a different database (chenson) - closed.
- 0000032: [New Feature] Implement file synchronization (chenson) - closed.
- 0001064: [New Feature] Add interactive command line sql tool. dbsql (chenson) - closed.
- 0001188: [Improvement] Inserting leading or trailing spaces in column ROUTER_EXPRESSION on table ROUTER produce ER in outgoing batch (chenson) - closed.
- 0001192: [Bug] Unrouted batches can't be extracted http://localhost:31415/batch/-1-50 [^] gets a 404 (chenson) - closed.
- 0001193: [Improvement] rename snapshot files from yyyyMMddhhmmss.jar to {engine.name}-yyyyMMddhhmmss.zip (chenson) - closed.
- 0001194: [Improvement] Use a constant router_id for the virtual sym_ tables instead of an ever incrementing number (chenson) - closed.
- 0001199: [Improvement] EXCLUDED COLUMNS in triggers can't participate in lookuptable router expressions (chenson) - closed.
- 0001204: [Bug] Invalid target node on "lookup table data router", trouble cache key resolution (chenson) - closed.
- 0000370: [New Feature] SymmetricDS support for Sybase Database (abrougher) - closed.
- 0001182: [New Feature] Open source the android client implementation (chenson) - closed.
- 0001210: [Bug] Wildcards don't work on Derby, DB2, and HSQLDB (chenson) - closed.
- 0001270: [Improvement] Update sqlite jdbc driver to the latest version to fix result set metadata issue. Allows unit tests to pass. (chenson) - closed.
- 0001273: [Improvement] Add new parameter to dbexport to request that dates and time NOT be in JDBC format (chenson) - closed.
- 0001223: [Bug] the sendSql JMX method and command can end up with multiple batches due to timing issue (chenson) - closed.
- 0001296: [Bug] Prevent invalid size DDL of (0) or (0,0) to be written for data types that have size (chenson) - closed.
- 0001056: [Bug] Sync on incoming batch causes ping-back when in common batch mode (chenson) - closed.
- 0001303: [Bug] REST API doesn't return heartbeat interval properly when getting node status (gwilmer) - closed.
- 0001309: [Bug] Reload node events are not taking place in the correct order. (chenson) - closed.

[56 issues]

SymmetricDS - 3.4.9 (Released 2013-07-16) View Issues ]
=========================================
- 0001323: [Bug] Missing columns at target table can cause columns after the missing columns to not be updated (chenson) - closed.

[1 issue]

SymmetricDS - 3.4.8 (Released 2013-07-03) View Issues ]
=========================================
- 0001291: [Bug] Transforms can cause an error when attempting to use the create tables feature of SymmetricDS (chenson) - closed.
- 0001305: [Bug] Possible lock up during extraction. If the max number of locks are reached on a batch the extract method can hang forever (chenson) - closed.
- 0001306: [Improvement] Add setting in web.xml to allow the engines to be stored statically so multiple wars in an ear can reference the same engine (chenson) - closed.

[3 issues]

SymmetricDS - 3.4.7 (Released 2013-06-18) View Issues ]
=========================================
- 0001285: [Bug] If an Error (versus an Exception) happens during the data load process, the database transaction can be left hanging (chenson) - closed.
- 0001284: [Bug] StackOverflowError can happen when a transform exists and the primary keys mismatch causing conflicts on both update and insert (chenson) - closed.
- 0001287: [Bug] EXTERNAL_DATA is not available for routing for event types other than I, U, or D (chenson) - closed.

[3 issues]

SymmetricDS - 3.4.6 (Released 2013-06-06) View Issues ]
=========================================
- 0001246: [Bug] Oracle NUMBER datatype is incorrectly mapped to an Integer data type. (abrougher) - closed.
- 0001253: [Bug] Node communication records can be stranded (chenson) - closed.
- 0001254: [Improvement] Allow additional paramters min idle and max idle on connection pool (gwilmer) - closed.
- 0001256: [Improvement] Add a parameter that turns off writing to sym_incoming_batch altogether unless there is an ER (chenson) - closed.
- 0001257: [Bug] common batches report data_event_count on outgoing_batch only on the first batch (chenson) - closed.
- 0001258: [Bug] When an incoming_batch is finished, it's status is updated twice. (chenson) - closed.
- 0001259: [Improvement] Add JMX method to extract batches to a file for a node and time and channel ranges (chenson) - closed.
- 0001244: [Bug] Mariadb driver is chosen even though the MySQL driver is specified (chenson) - closed.

[8 issues]

SymmetricDS - 3.4.5 (Released 2013-05-29) View Issues ]
=========================================
- 0001220: [Bug] Wrong number of sym_data_events being logged when routing common batch (chenson) - closed.
- 0001221: [Bug] lookup column transform throws null pointer when used during extract (chenson) - closed.
- 0001227: [Bug] Reading of MySQL tables can sometimes include the PRIMARY index if the primary key columns aren't at the start (chenson) - closed.
- 0001238: [Bug] Issue with detecting whether batch is common or not. (chenson) - closed.
- 0001239: [Improvement] Add the ability to NOT add triggers to a client database until initial load has finished (chenson) - closed.
- 0001242: [Bug] ping_back settings broken for conflict resolution. class cast exception. (chenson) - closed.
- 0001211: [Bug] Backwards compatibility change. Use the client's Charset-Accept http header to decide what encoding to use. (chenson) - closed.
- 0001214: [Bug] reloadTable race condition (chenson) - closed.
- 0001215: [Bug] The initial load sql is not overridden in the reloadTable method (chenson) - closed.
- 0001232: [Bug] NullPointerException in BshDataRouter for reload events (chenson) - closed.
- 0001233: [Bug] DataService.insertData(Data data) should populate external_data (chenson) - closed.
- 0001235: [Bug] https settings in symmetric-server.properties not working with sym_service (chenson) - closed.

[12 issues]

SymmetricDS - 3.4.4 (Released 2013-05-12) View Issues ]
=========================================
- 0001206: [Bug] dataloader.ignore.missing.tables not working for initial load when initial.load.delete.first=true (chenson) - closed.
- 0001207: [Bug] DB2 text column default value metadata values are quoted. Need to remove quotes when reading table metadata from database. (chenson) - closed.

[2 issues]

SymmetricDS - 3.4.3 (Released 2013-05-07) View Issues ]
=========================================
- 0001202: [Bug] Wild card expressions are currently broken (chenson) - closed.

[1 issue]

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

[1 issue]

SymmetricDS - 3.4.1 (Released 2013-04-24) View Issues ]
=========================================
- 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.
- 0001053: [Improvement] Verify that NOCOUNT is off for SQL Server before starting SymmetricDS. When NOCOUNT is turned on SymmetricDS won't work. (chenson) - closed.
- 0001184: [Improvement] Record ProcessInfo for server side registration process so it can more easily be monitored for errors (chenson) - closed.

[3 issues]

SymmetricDS - 3.4.0 (Released 2013-04-21) View Issues ]
=========================================
- 0000026: [New Feature] Provide an API to ignore or cancel a batch (elong) - closed.
- 0000142: [New Feature] Support SQL Server 2000 (elong) - closed.
- 0000246: [New Feature] Add script or JMX feature to capture system state to help debug issues (elong) - closed.
- 0000546: [Bug] Update of identical rows for a table not possible (no primary key and no uniqueness constraint) (elong) - closed.
- 0000553: [Bug] H2DbDialect Bad writeColumnAutoIncrementStmt definition (elong) - 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.
- 0001150: [Bug] Allow wild card load filters to work on tables sharing the same prefix as the symmetric tables. (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.
- 0000580: [Improvement] MySQL trigger throwing error on special characters (chenson) - closed.
- 0001117: [Bug] registration_enabled doesn't get set to 0 when node is really registered (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.
- 0001046: [Bug] There are 2 log4j-1.2.16.jar files in the symmetricds deployment (chenson) - closed.
- 0001086: [Improvement] Make the 3.x use 1.x protocol for backwards compatibility (chenson) - closed.
- 0001104: [Improvement] Exclude sym_ tables from being effected by wildcard load filters (chenson) - closed.
- 0001105: [Improvement] Add new web.xml setting that controls whether the symmetric engine(s) are started (chenson) - closed.
- 0001107: [Improvement] Bind all of the symmetric properties to the spring context for use in extensions points (chenson) - closed.
- 0001109: [Bug] Registration can fail when multiple sym_node records exist with a null created_at_node_id value (chenson) - closed.
- 0001110: [Bug] Triggers not removed when sym_trigger source_ catalog, schema or table name changed (chenson) - closed.
- 0001111: [Bug] MySQL upgrade issue: Columns not modified when symmetricds table columns type or size change (chenson) - closed.
- 0001115: [New Feature] Add option to dbexport to NOT use quoted identifiers when exporting data as SQL (chenson) - closed.
- 0001116: [Bug] sym_data_gap referenced directly instead of using sync.table.prefix (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.
- 0000939: [New Feature] Provide capability to specify initial load delete statement by trigger / router (gwilmer) - closed.
- 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.

[44 issues]

SymmetricDS - 3.3.7 (Released 2013-04-15) View Issues ]
=========================================
- 0001170: [Bug] postgres - Inserts fail on reverse reload events when a table contains duplicate rows. (chenson) - closed.
- 0001172: [Bug] postgres - Syncing slow for tables with bigint keys (chenson) - closed.
- 0001178: [Improvement] Performance Improvement: Many calls are being made to the file system to check if file exists while extracting big batches (chenson) - closed.

[3 issues]

SymmetricDS - 3.3.6 (Released 2013-04-03) View Issues ]
=========================================
- 0001133: [Bug] Multiple reverse reloads can be queued up because of timing issues (chenson) - closed.
- 0001137: [Improvement] Rest API Enhancements (gwilmer) - closed.
- 0001140: [Bug] SQL Server 2000 triggers are being created using the 'max' keyword, which 2000 does not support. (abrougher) - 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.
- 0001131: [Bug] NPE in conflict resolution when detecting a conflict using TIMESTAMP and existing row doesn't exist (gwilmer) - 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.

[12 issues]

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

[1 issue]

SymmetricDS - 3.3.4 (Released 2013-03-09) View Issues ]
=========================================
- 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.
- 0001101: [Bug] sqlite create tables doesn't work because a transaction is in process and the database is locked (chenson) - closed.
- 0001100: [Bug] sqlite create tables quotes create_timestamp default values (chenson) - closed.

[4 issues]

SymmetricDS - 3.3.3 (Released 2013-03-01) View Issues ]
=========================================
- 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] MySQL - error calling unknown function sym_transaction_idnull() (chenson) - closed.
- 0001083: [Bug] Registration slow on Oracle with lots of nodes (chenson) - closed.

[4 issues]

SymmetricDS - 3.3.2 (Released 2013-02-26) View Issues ]
=========================================
- 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.
- 0001048: [Bug] Timestamps are not exported correctly using dbexport. (abrougher) - closed.
- 0001049: [Bug] DbExport allows --sql option without a table name argument. (abrougher) - closed.
- 0001050: [Improvement] Introduce conf/symmetric-server.properties which contains http/https/jmx port/enabled settings and other server specific setting (chenson) - closed.
- 0001057: [Bug] Postgres datetime with timezone not formatted correctly when timezone offset < 0 and timezone offset has minutes (gwilmer) - closed.
- 0001058: [Improvement] Provide access to include-on and source dml type in bean shell transforms (mhanes) - closed.
- 0001061: [Improvement] Support synchronization of Oracle Synonyms (chenson) - closed.
- 0001066: [Bug] Reverse initial load may be computed and routed before triggers are done synchronizing when a client first registers (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.
- 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.
- 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.
- 0001051: [Bug] --jmx-port and --jmx-disabled command line help is not available (chenson) - closed.
- 0001068: [Improvement] Add new extension point ILoadSyncLifecycleListener which gets callbacks before and after a load sync (chenson) - closed.

[20 issues]

SymmetricDS - 3.3.1 (Released 2013-02-12) View Issues ]
=========================================
- 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.
- 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.

[4 issues]

SymmetricDS - 3.3.0 (Released 2013-02-08) View Issues ]
=========================================
- 0000274: [New Feature] Allow keywords in table names (enable identifier delimiters) (elong) - closed.
- 0000016: [Bug] GIve options on how to handle non-existant table at client node (elong) - closed.
- 0000967: [Bug] Unknown table "INFORMATION_SCHEMA.SESSION_STATUS" error for MySQL 5.0.XX (chenson) - closed.
- 0000987: [New Feature] Add the "current" (conflicting) data to a column in sym_incoming_error (chenson) - closed.
- 0000994: [Improvement] Update Users Guide to describe how to deploy to separate machines (tutorial is multi-homed) (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.
- 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.
- 0001033: [Improvement] Before allocating push/pull jobs check to see if thread count has changed and if so, restart thread pool (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.
- 0001028: [Bug] stream.to.file.enabled=false is broken (chenson) - closed.
- 0001030: [Bug] Exception in clustered firebird environment (chenson) - closed.
- 0001031: [Bug] Documentation for outgoing_batch is missing IG and has RE instead of RT and QE instead of QY (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.
- 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.
- 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.
- 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.
- 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.
- 0001034: [New Feature] Add last_update_by, last_update_time, create_time to transform_*, parameter, channel, node_group, and node_group_link (chenson) - closed.
- 0001024: [Improvement] Use the symmetric table name as the virtual trigger name instead of a hashcode of the table name (chenson) - closed.

[26 issues]

SymmetricDS - 3.2.3 (Released 2013-01-24) View Issues ]
=========================================
- 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.

[7 issues]

SymmetricDS - 3.2.2 (Released 2013-01-12) View Issues ]
=========================================
- 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.
- 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.
- 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.

[5 issues]

SymmetricDS - 3.2.1 (Released 2013-01-05) View Issues ]
=========================================
- 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.
- 0000971: [Bug] Push / Pull threads should run in Job's thread when jobs.synchronized.enable is true (mhanes) - 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.

[6 issues]

SymmetricDS - 3.2.0 (Released 2012-12-16) View Issues ]
=========================================
- 0000021: [New Feature] Add support for Sqlite over JDBC (mhanes) - 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.
- 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.
- 0000936: [Bug] Oracle integer datatype has a larger precision than the java Integer datatype. (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.
- 0000946: [Bug] Cannot delete triggers from tables if SymmetricDS user doesn't own those tables (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.
- 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.
- 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.
- 0000871: [New Feature] Implement a REST API for SymmetricDS (gwilmer) - 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.
- 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.
- 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.
- 0000935: [Bug] dbexport null timestamp values from Oracle result in empty string ("") in CSV. (chenson) - closed.
- 0000896: [Bug] RouterService.getUnroutedDataCount() is not accurate. Uses max(last_id) when it should use max(start_id) (chenson) - closed.
- 0000806: [Bug] DbFill --help argument captions are not displayed correctly. (abrougher) - closed.
- 0000880: [New Feature] Add support for cascading random data to DbFill. (abrougher) - closed.

[50 issues]

SymmetricDS - 3.1.11 (Released 2012-11-29) View Issues ]
==========================================
- 0000929: [Improvement] Add oracle hint to query to select data from sym_data to force it to use the obvious index (chenson) - 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 (chenson) - closed.
- 0000894: [New Feature] Add property to turn sync_on_incoming off for sym_ table triggers (chenson) - closed.

[3 issues]

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

[2 issues]

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

[2 issues]

SymmetricDS - 3.1.8 (Released 2012-10-29) View Issues ]
=========================================
- 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.
- 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.
- 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.

[9 issues]

SymmetricDS - 3.1.7 (Released 2012-10-22) View Issues ]
=========================================
- 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 or postgres (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.
- 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.

[10 issues]

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

[4 issues]

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

[14 issues]

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

[11 issues]

SymmetricDS - 3.1.3 (Released 2012-08-28) View Issues ]
=========================================
- 0000783: [Bug] Null date in the primary key causes parse exception on postgres (chenson) - closed.
- 0000784: [Improvement] Use the NetworkInterface Java class to get the current ipAddress of a node (chenson) - closed.
- 0000785: [Bug] syncTriggers(true) does not force trigger to be rebuilt (chenson) - closed.
- 0000788: [Bug] DbFill is populating columns with foreign values when a foreign key is not defined for the column. (abrougher) - 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.
- 0000787: [Bug] DbFill does not generate random values from BigInteger columns. (abrougher) - closed.

[7 issues]

SymmetricDS - 3.1.2 (Released 2012-08-22) View Issues ]
=========================================
- 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.
- 0000781: [Bug] Restart of jobs can cause embedded derby database connections to fail (chenson) - closed.
- 0000774: [Bug] DbFill does not respect a columns scale and precision. (abrougher) - closed.
- 0000776: [Improvement] Change SqlScriptReader to allow comments in places other than the beginning of a line in a sql script (chenson) - closed.
- 0000775: [Improvement] Change SqlScript to use SqlScriptReader so that statements are streamed (chenson) - closed.

[5 issues]

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

[1 issue]

SymmetricDS - 3.1.0 (Released 2012-08-13) View Issues ]
=========================================
- 0000375: [Improvement] Document example for bi-directional synchronization in the tutorial (elong) - closed.
- 0000430: [Improvement] Create a patches directory in the standalone distribution of SymmetricDS that can be used to drop jar or class file patches (elong) - closed.
- 0000766: [Bug] dbimport of timestamp column doesn't support 'default' for Oracle (maybe others) (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.
- 0000770: [New Feature] Improve DbImport so that it incorporates the SymmetricDS data loader (chenson) - closed.
- 0000725: [New Feature] Add a feature to allow dynamic load filters to be created and executed based configuration (gwilmer) - closed.
- 0000726: [New Feature] Add a new parameter that, when set, is evaluated to choose a node id (chenson) - closed.
- 0000727: [Improvement] Upgrade Derby to 10.9.1.0 (chenson) - closed.
- 0000728: [Improvement] Lookup table router should throw an exception when the router expression is invalid. (abrougher) - closed.
- 0000731: [Improvement] Redo the derby database triggers so they can handle tables with more columns (chenson) - closed.
- 0000733: [Improvement] dbexport should use the default schema and default catalog if they aren't specified (chenson) - closed.
- 0000735: [New Feature] dbimport and dbexport should support symmetric batch xml. (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.
- 0000738: [Bug] AbstractSymmetricEngine should call init() method of the SecurityService (chenson) - closed.
- 0000739: [Bug] Multiple wildcard expressions, only one used (chenson) - closed.
- 0000740: [Bug] Symadmin help subcommand missing (chenson) - closed.
- 0000742: [Bug] "ORA-01000: maximum open cursors exceeded" during initial load (RouterService.insertInitialLoadEvents) (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.
- 0000744: [Bug] Inefficient 'Sort by Foreign Keys' algorithm (chenson) - closed.
- 0000745: [Bug] Type of float(63) on oracle loses precision during data load. (chenson) - closed.
- 0000746: [Improvement] Improve documentation on how to handle Oracle error 'ORA-01489: result of string concatenation is too long' (chenson) - closed.
- 0000747: [Improvement] DbImport should have an empty constructor to make dependency injection easier. (abrougher) - closed.
- 0000748: [Bug] Data in a single transaction is split across batches and is out of order on Firebird (gwilmer) - closed.
- 0000751: [Improvement] Add new extension point called INodeIdCreator that replaces INodeIdGenerator and gets the remote address and host passed to it (chenson) - closed.
- 0000752: [Bug] Null pointer during trigger inactivation of deleted table can cause SymmetricDS engine not to start (chenson) - 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.
- 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.
- 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.
- 0000759: [New Feature] Create utility to fill a given database with random data. (abrougher) - closed.
- 0000762: [Improvement] Change command line options --noconsole to --no-log-console and --nologfile to --no-log-file (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.
- 0000767: [Bug] Latest oracle jdbc drivers for 11g return (0,-127) for types defined as integer resulting in bad mappings (chenson) - closed.
- 0000771: [Improvement] DbFill should have the ability to load all of the tables in a given schema with random data. (abrougher) - closed.
- 0000724: [Task] Include an example of filtering or data subsetting (route items to a store) in the User Guide Tutorial (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.
- 0000734: [Bug] H2 wasn't selecting the schema or catalog in the table lookup (chenson) - closed.
- 0000736: [Bug] deployment_type not being recorded properly in sym_node (chenson) - 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.
- 0000760: [Bug] Columns mismatched on updates when source table has more columns than the target table. (chenson) - closed.
- 0000768: [Bug] Don't hide startup errors if the spring context fails to start (chenson) - closed.
- 0000655: [Task] Update dbexport and dbimport to support the SymmetricDS XML format (abrougher) - closed.
- 0000730: [Bug] dbexport schema property ignored when data is exported. (abrougher) - closed.
- 0000769: [Bug] Tomcat Deployment Broken (chenson) - closed.

[44 issues]

SymmetricDS - 3.0.10 (Released 2012-07-23) View Issues ]
==========================================
- 0000700: [Bug] StackOverflowError when filtering data during initial load (chenson) - closed.
- 0000713: [Bug] Automate upgrade from 2.x to 3.x on most platforms (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.
- 0000723: [Bug] XML with DATE column type gets created as a DATETIME on SQL Server (chenson) - closed.
- 0000721: [Improvement] Explicitly set the key alias and the keystore type on the ssl connector (chenson) - closed.

[7 issues]

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

[4 issues]

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

[4 issues]

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

[2 issues]

SymmetricDS - 3.0.6 (Released 2012-06-29) View Issues ]
=========================================
- 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.

[9 issues]

SymmetricDS - 3.0.5 (Released 2012-06-26) View Issues ]
=========================================
- 0000665: [Bug] Don't commit a batch that doesn't have commit in the csv protocol (chenson) - closed.
- 0000668: [Bug] sym_trigger.use_stream_lobs had a bug where every column after a lob is not captured (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.

[4 issues]

SymmetricDS - 3.0.4 (Released 2012-06-22) View Issues ]
=========================================
- 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.
- 0000663: [Improvement] Add a variable transform that makes a column <null> (chenson) - closed.
- 0000664: [Improvement] Pass a reference to ISymmetricEngine to the Scripted Router so it has access to SymmetricDS services - closed.
- 0000658: [Bug] Fix null pointer exception that hides true exception during install of triggers (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.

[6 issues]

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

[2 issues]

SymmetricDS - 3.0.2 (Released 2012-06-18) View Issues ]
=========================================
- 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.

[4 issues]

SymmetricDS - 3.0.1 (Released 2012-06-06) View Issues ]
=========================================
- 0000646: [Bug] Command lines should fail if specified engines file doesn't exist (mhanes) - closed.
- 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.

[8 issues]

SymmetricDS - 3.0.0 (Released 2012-06-04) View Issues ]
=========================================

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

- 0000033: [New Feature] Rewrite csv loader/reader to make it a core SymmetricDS component (elong) - closed.
- 0000041: [New Feature] Addition of HTTPS Transport Type (elong) - closed.
- 0000054: [Bug] The initial.load.create.first feature should include foreign keys (elong) - closed.
- 0000057: [Improvement] Triggers should be created in same catalog and schema as source table (elong) - closed.
- 0000064: [New Feature] Support for HTTP Authentication Methods (elong) - closed.
- 0000143: [Bug] bin/sym root.properties --auto-create fails on some sym_* tables (elong) - closed.
- 0000160: [Bug] The where statement generated by the data loader needs to use 'is null' instead of '= null' when a primary key is null. (elong) - closed.
- 0000219: [New Feature] Synchronize tables to same schema/catalog in target if source_schema_name / source_catalog_name is defined for trigger (elong) - closed.
- 0000228: [Improvement] Store trigger creation errors in sym_trigger_hist (elong) - closed.
- 0000238: [New Feature] Optionally, send the source_node_id from sym_data in the protocol so the dataloader has access to it. (elong) - closed.
- 0000360: [Bug] Fallback for insert statements doesn't work (elong) - closed.
- 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.

[49 issues]

SymmetricDS - 2.5.13 (Released 2012-05-31) View Issues ]
==========================================
- 0000617: [Bug] Transforms run in separate connection from data loader - closed.
- 0000619: [Improvement] Add support for Postgres UUID and VARBIT types - closed.
- 0000620: [Improvement] Make sure sequences are ordered (on Oracle) when creating them for SymmetricDS - closed.
- 0000627: [Improvement] auto.reload.reverse feature does not support datareload.batch.insert.transactional - closed.
- 0000635: [Bug] Column of type money loses precision on MSSQL - closed.

[5 issues]

SymmetricDS - 2.5.12 (Released 2012-05-02) View Issues ]
==========================================
- 0000606: [Improvement] Add -D system property org.jumpmind.symmetric.ddl.use.table.seq that forces postgres to NOT use sequences for SymmetricDS tables - closed.
- 0000610: [Bug] A delete transform on the load side does not have access to columns if transform has occurred on the extract side because old da - closed.
- 0000611: [Bug] auto.reload.reverse causes other nodes to auto reload. - closed.
- 0000612: [Bug] Postgres DATE field leaves an extra '.' at the end of captured data in version 8.5 which causes a parse exception during the dat - closed.
- 0000615: [Bug] When a timestamp with time zone column is part of a primary key or part of a table w.out a primary key, then the trigger fails t (chenson) - closed.

[5 issues]

SymmetricDS - 2.5.11 (Released 2012-04-10) View Issues ]
==========================================
- 0000600: [Bug] Some versions of Postgres 8.3 (EnterpriseDB 8.3.x) don't support txid_current() function - closed.
- 0000603: [New Feature] Add setting to allow a client to push an initial load back to the server after registration. - closed.
- 0000602: [Bug] Export of configuration does not work because all data is filtered out. The config router thinks it doesn't need to route the ex (chenson) - closed.

[3 issues]

SymmetricDS - 2.5.10 (Released 2012-04-02) View Issues ]
==========================================
- 0000581: [Bug] Registration problems when you have a multi-tier system with many nodes at the same group level that allows registration of chil (chenson) - closed.

[1 issue]

SymmetricDS - 2.5.9 (Released 2012-03-27) View Issues ]
=========================================
- 0000589: [Improvement] Register JMX HTTP adapter with the host (network interface) that is specified on the command line - closed.
- 0000590: [Bug] "Time Zone is not captured correctly for columns that are of type ""Timestamp With Time Zone""" - closed.
- 0000591: [Bug] Oracle NUMBER(3) isn't java.sql.TINYINT - closed.

[3 issues]

SymmetricDS - 2.5.8 (Released 2012-03-05) View Issues ]
=========================================
- 0000541: [Improvement] Support GeoSpatial data type (SDO_GEOMETRY) in oracle spatial - closed.
- 0000585: [Bug] Schemas and catalogs should be quoted during trigger generation. - closed.
- 0000586: [Improvement] Provide the capability to start up SymmetricDS on different network interfaces - closed.
- 0000587: [Bug] Allows tables with FK to be used with initial.load.create.first=true - closed.
- 0000588: [Bug] Oracle model reader translates a number(1) to a bit type which breaks synchronization (only values of 1 or 0 are inserted) - closed.

[5 issues]

SymmetricDS - 2.5.7 (Released 2012-02-23) View Issues ]
=========================================
- 0000583: [Bug] Race condition can leave sym_node_security in an incorrect state at a client after reload (chenson) - closed.

[1 issue]

SymmetricDS - 2.5.6 (Released 2012-02-13) View Issues ]
=========================================
- 0000558: [Bug] Transaction boundaries can be broken when max_batch_size is set to a small number and batch algorithm is set to 'transactional' - closed.
- 0000577: [Bug] When more than one channel is in error, channels that are not in error have the possibility of being held up - closed.
- 0000578: [Improvement] The outgoing.batches.max.to.select property should not have to take into account that a channel might be disabled - closed.
- 0000579: [Bug] The feature to pass a properties file to the sym command when creating a war file does not work - closed.
- 0000582: [Bug] Identity column transform not working - closed.

[5 issues]

SymmetricDS - 2.5.5 (Released 2012-01-27) View Issues ]
=========================================
- 0000569: [Improvement] Allow StandaloneSymmetricEngine to be embedded with Symmetric-Core only (gwilmer) - closed.
- 0000570: [Bug] Make sure the insert of a GP record never fails. (chenson) - closed.
- 0000573: [Bug] ColumnMatchDataRouter incorrectly parses router expressions with column names that contain 'OR'. e.g. CONCENTRATOR_ID (chenson) - closed.
- 0000574: [Improvement] Remove the check to run purge only if an initial load has happened (chenson) - closed.
- 0000571: [Bug] "Time Zone is not captured/sent to the replicated node for columns that are of type ""Timestamp With Time Zone""" (chenson) - closed.
- 0000572: [Bug] Misleading error printed out during transformation where no columns were found to transform (chenson) - closed.

[6 issues]

SymmetricDS - 2.5.4 (Released 2011-12-23) View Issues ]
=========================================
- 0000561: [Bug] Issue deleting tuples from a table that has a column of type timestamp as part of the Primary Key (chenson) - closed.
- 0000563: [Bug] When a transformation happens on a primary key, it does not have access to new column values other than the keys of the original (chenson) - closed.
- 0000565: [Improvement] Add the ability to use the source node's external id as a column value in a variable transform (chenson) - closed.
- 0000567: [New Feature] Provide a load filter that will enable bulk load for Postgres and Greenplum dialects (gwilmer) - closed.
- 0000568: [Improvement] Increase the default idle time for the standalone instance's embedded jetty instance (chenson) - closed.

[5 issues]

SymmetricDS - 2.5.3 (Released 2011-11-30) View Issues ]
=========================================
- 0000555: [Bug] Connection pool can exhaust at high activity because of out of order interceptors in 2.5 (chenson) - closed.
- 0000557: [Bug] sym_data_gap can be left stranded without a required last gap entry record (chenson) - closed.
- 0000559: [New Feature] Add support for geometry types in postgres. The fix should work for other unknown types that can be cast and dealt with as varch (gwilmer) - closed.
- 0000556: [Bug] Slow extracts - During the extract process routers are being queried from the database for each data event read. (chenson) - closed.

[4 issues]

SymmetricDS - 2.5.1 (Released 2011-11-19) View Issues ]
=========================================
- 0000540: [Bug] Postgres insert of same row with no primary keys does not insert a row past the first insert. (chenson) - closed.
- 0000542: [Bug] two errors in JRE5.0 (chenson) - closed.
- 0000547: [Improvement] Limit the number of nodes that can register in parallel the same way nodes that can pull and push are limited. (chenson) - closed.

[3 issues]

SymmetricDS - 2.5.0 (Released 2011-11-06) View Issues ]
=========================================
- 0000518: [Bug] Fix NullPointerException in transform dataloader's fallback logging (chenson) - closed.
- 0000519: [Bug] When a transformed row is being loaded (from the dataloader) and it encounters a conflict it should re-transform the original da (chenson) - closed.
- 0000525: [Bug] Pass old data to transformations when a DELETE event comes through (chenson) - closed.
- 0000527: [Bug] Postgres doesn't accept null characters (0x00) in textfields while other databases do. Strip them out during synchronization. (chenson) - closed.
- 0000529: [Bug] Support reading in TIMESTAMP WITH TIME ZONE data types in Oracle (chenson) - closed.
- 0000524: [Bug] Client DataLoad nullpointers when registering if server fails to send down a values for sym_node (chenson) - closed.
- 0000539: [Improvement] Capture and route node and node_security changes out to all interested nodes. - closed.
- 0000517: [Improvement] Add support for hosting multiple engines in a single SymmetricDS server (chenson) - closed.
- 0000523: [Bug] Make postgres dataloader more efficient by removing the use of savepoints. (chenson) - closed.
- 0000526: [Improvement] When creating autoincrement columns in postgres don't specify that they have to be unique. The fact that a primary key is define (chenson) - closed.
- 0000528: [New Feature] Add support for Greenplum as a SymmetricDS client (chenson) - closed.
- 0000530: [Bug] sym_pkg is recreated each time the symmetricds server restarts (chenson) - closed.
- 0000532: [Improvement] Only attempt fallback to update when there is a true primary key collision. (chenson) - closed.
- 0000533: [Bug] "ORA-01489: result of string concatenation is too long: Because of large varchar fields that exceed the limit when , and "" are (chenson) - closed.
- 0000534: [Bug] Postgresql to mssql 2K8 (elong) - closed.
- 0000536: [Improvement] Consolidate code that reads tables in the ddlutils package. (chenson) - closed.
- 0000537: [Bug] Ping pongs happens when collation is set to Latin1_General_CI_AS on SQL Server because 0x0 aren't stripped from source_node_id w (chenson) - closed.
- 0000538: [Improvement] Don't read every table in the database at SymmetricDS startup. Only read in the relevant SymmetricDS tables to check for needed (chenson) - closed.
- 0000520: [Bug] PostgreSQL - Quotes around tables in trigger creation. (chenson) - closed.
- 0000522: [Bug] When multiple transformations with different columns sets and the same target table are defined the metadata that gets written o (chenson) - closed.

[20 issues]

SymmetricDS - 2.4.0 (Released 2011-08-31) View Issues ]
=========================================
- 0000004: [New Feature] Stream LOB (large object), BLOB, and CLOB columns - closed.
- 0000387: [Task] Discuss sym_channel settings and how they effect synchronization in the users guide - closed.
- 0000372: [Improvement] Don't allow synchronization and log message in the push and pull servlets if the node is sync_enabled=0 - closed.
- 0000428: [Bug] Update trigger getting ORA-01489 error - closed.
- 0000433: [Improvement] Document the external_select feature better - closed.

[5 issues]

SymmetricDS - 2.3.0 (Released 2011-05-31) View Issues ]
=========================================
- 0000434: [Improvement] Put tables in quotes in triggers for the SQL Server dialect (chenson) - closed.

[1 issue]

SymmetricDS - 2.2.5 (Released 2011-05-17) View Issues ]
=========================================
- 0000436: [Improvement] Allow SQL Server collation to be set via a property for use in triggers (chenson) - closed.

[1 issue]

SymmetricDS - 2.2.4 (Released 2011-05-10) View Issues ]
=========================================
- 0000427: [Bug] SymmetricDS has problems when using a case sensitive Collation with SqlServer such as SQL_Latin1_General_CP437_BIN (gwilmer) - closed.
- 0000431: [Improvement] Fix the reloadTable() JMX method to insert all reload events for a single table (instead of only the first reload it comes acros - closed.
- 0000429: [Improvement] Allow NHibernate to work with SymmetricDS (chenson) - closed.

[3 issues]

SymmetricDS - 2.2.3 (Released 2011-05-03) View Issues ]
=========================================
- 0000417: [Improvement] Allow for token substitution in target table names, schema names and catalog names (chenson) - closed.
- 0000419: [Bug] Sql Server blob sync across catalogs does not work because the base 64 encoding function is not fully qualified. (chenson) - closed.
- 0000420: [Bug] Sql Server sync of tables with identity columns doesn't work when syncing across catalogs. Table name isn't fully qualified. (chenson) - closed.
- 0000422: [Bug] Line feed characters ( and ) can get corrupted during transfer depending on the character and the os (chenson) - closed.
- 0000424: [Improvement] Keep http connection alive during long file extracts (chenson) - closed.
- 0000425: [Improvement] default the java.io.tmpdir to ../tmp for the standalone install (chenson) - closed.
- 0000418: [Task] Document trigger.update.capture.changed.data.only.enabled (mhanes) - closed.
- 0000385: [Task] Better document SYM_OUTGOING_BATCH and error recovery in Users Guide (mhanes) - closed.

[8 issues]

SymmetricDS - 1.7.16 (Released 2011-05-02) View Issues ]
==========================================
- 0000421: [Bug] The logic for determining support for Postgres transaction identifiers is flawed (chenson) - closed.

[1 issue]

SymmetricDS - 2.2.2 (Released 2011-04-15) View Issues ]
=========================================
- 0000413: [Bug] Ddlutils blows up on table in DB2 - closed.
- 0000414: [Improvement] Change the mis-named property: routing.max.data.to.process.per.channel to routing.largest.gap.size - closed.
- 0000415: [Bug] Wrong version of the ddlutils platform is being returned for a specific DB2 version - closed.
- 0000416: [Bug] DB2 dialect is resetting auto-increments on sym_trigger_hist, _outgoing_batch, and _data every startup - closed.
- 0000392: [Task] Document the initialization procedure if an initial load is not needed (mhanes) - closed.
- 0000391: [Task] Explain gap detection in the users guide (mhanes) - closed.
- 0000217: [Task] Add build date/time to the User Guide. (mhanes) - closed.
- 0000381: [Task] Create better documentation for initial_load_select (mhanes) - closed.
- 0000390: [Task] Document the new PING_BACK_ENABLED flag on SYM_TRIGGER_ROUTER (mhanes) - closed.

[9 issues]

SymmetricDS - 2.2.1 (Released 2011-04-01) View Issues ]
=========================================
- 0000409: [Bug] ojdbc6.jar doesn't work with SymmetricDS - closed.
- 0000410: [Bug] The service wrapper didn't get updated for 2.2 - closed.
- 0000411: [Bug] Allow ddlutils to handle functional indexes by removing the logic to verify that a column exists - closed.
- 0000412: [Bug] Standalone startup issue with 2.2.0 - closed.

[4 issues]

SymmetricDS - 2.1.3 (Released 2011-03-29) View Issues ]
=========================================
- 0000364: [Bug] Failing to read database tables when SQL Server 2005 is being used (chenson) - closed.

[1 issue]

SymmetricDS - 2.2.0 (Released 2011-03-29) View Issues ]
=========================================
- 0000212: [Improvement] Add option on sym_trigger to not record data in sym_data if none of the columns have changed (chenson) - closed.
- 0000268: [New Feature] Support array data types on Postgres (chenson) - closed.
- 0000342: [New Feature] Add statistics at node level and at the job level. This is follow up to the new statistics in 2.1 (chenson) - closed.
- 0000346: [Improvement] Build a stripped down client only distribution of SymmetricDS (chenson) - closed.
- 0000352: [Bug] Trigger Hist row is inserted, even if the trigger generation failed. (chenson) - closed.
- 0000365: [Improvement] Refactor JobManager so that a list of jobs can be retrieved and reported on (chenson) - closed.
- 0000366: [New Feature] Add a sym_registration_request table that captures when a node both attempts and successfully registers (chenson) - closed.
- 0000367: [Bug] Nodes actually pull their configuration data 2 times during registration. It should only happen once. (chenson) - closed.
- 0000368: [Bug] Possible to extract the wrong target schema when two tables of the same name are syncing (chenson) - closed.
- 0000369: [Bug] SymmetricDS doesn't start up because of xml column in postgres (elong) - closed.
- 0000373: [Improvement] XmlPublisherDataRouter should only publish one message, not a message per node. (chenson) - closed.
- 0000374: [Improvement] Only use 1 database connection while loading data. (chenson) - closed.
- 0000378: [Bug] Segmentation fault in sym_hex UDF for Firebird (chenson) - closed.
- 0000380: [New Feature] Add batchid element to XML published by the XML data loader and the XML data router. (chenson) - closed.
- 0000382: [Bug] Oracle timestamp columns should synchronize milliseconds (chenson) - closed.
- 0000383: [Task] Turn on routing.data.reader.type=gap (chenson) - closed.
- 0000384: [Bug] Authentification failed when using custom INodePasswordFilter (chenson) - closed.
- 0000388: [Improvement] Improve the push and pull api to return a status code instead of a boolean. (chenson) - closed.
- 0000389: [Bug] Fix IOfflineClientListener. Add a few more possible exceptions that might cause offline. (chenson) - closed.
- 0000394: [Bug] During the extract process, if there is an error, then the extract file does not get deleted. (chenson) - closed.
- 0000395: [New Feature] Use dbms_lob.substr during an initial load on oracle if contains_big_lob column of sym_channel is set to false (chenson) - closed.
- 0000397: [Bug] When initial.load.delete.first is set to true and a table that is being synchronized is missing, the initial load fails (chenson) - closed.
- 0000399: [Bug] 22 million row initial load blew up at the very end because the stats in sym_incoming_batch became too big for the column (chenson) - closed.
- 0000400: [Improvement] Log the fact that a table is not found by the data loader. (chenson) - closed.
- 0000402: [Bug] If there is an ER on the reload channel, then other channels have to be sent to correct the error (chenson) - closed.
- 0000403: [Bug] symmetric-ddl conflicts with apache ddlutils (chenson) - closed.
- 0000404: [Bug] Should always check for duplicate trigger names, not just when the trigger name is > max length (chenson) - closed.
- 0000405: [Improvement] Break the purge job out into 3 different jobs to match how the job is locked. (chenson) - closed.

[28 issues]

SymmetricDS - 2.1.2 (Released 2010-11-10) View Issues ]
=========================================
- 0000361: [Bug] Race condition - Client can pull a batch before data_events are committed during routing (chenson) - closed.

[1 issue]

SymmetricDS - 2.1.1 (Released 2010-10-25) View Issues ]
=========================================
- 0000344: [Improvement] Improve performance of sym_data select on oracle by adding option to use dbms_lob.substr( sqltext, 4000, 1 ) at the channel leve (chenson) - closed.
- 0000349: [Improvement] Introduce changes to make it easier to massage SQL from the getSQL method (chenson) - closed.
- 0000353: [Bug] "Support PostgreSQL 8.0 - fix type ""e"" does not exist error" (elong) - closed.
- 0000357: [Bug] When db.metadata.ignore.case is set to true, SymmetricDS should still attempt to use the recorded table name first while looking (chenson) - closed.
- 0000359: [Bug] Fix the service wrapper configuration file to reference the new jar locations. (chenson) - closed.
- 0000347: [Improvement] In order to support bigger ACK payloads, Jetty needs to have a default setting ( -Dorg.mortbay.jetty.Request.maxFormContentSize) (chenson) - closed.
- 0000348: [Improvement] Better support DB2 by inserting into SYM_OUTGOING_BATCH outside the transaction that inserts SYM_DATA_EVENT (chenson) - closed.
- 0000351: [Bug] H2 trigger only captures TIMESTAMP columns to a resolution of seconds. (chenson) - closed.
- 0000355: [Improvement] Use JDBC batch APIs for insert of sym_data_event during routing. In some database environments this should boost performance. (chenson) - closed.

[9 issues]

SymmetricDS - 2.1.0 (Released 2010-09-29) View Issues ]
=========================================
- 0000240: [Bug] Null lookup of node channels possible (chenson) - closed.
- 0000242: [Bug] The query timeout was not being set for several database queries (chenson) - closed.
- 0000023: [New Feature] Create an Informix Dialect (elong) - closed.
- 0000345: [Bug] source_catalog_name in sym_trigger is not prepended in db dialect templates - closed.
- 0000208: [Improvement] Get rid of 'reload' channel and put all initial load events on the channels that tables are assigned to. (chenson) - closed.
- 0000231: [Improvement] Improve generated trigger for MySQL: filter unmodified rows in trigger before inserting to sym_data (chenson) - closed.
- 0000232: [Bug] Tables with similar names in different catalogs/schemas get mixed up. (chenson) - closed.
- 0000236: [Bug] MySQL InnoDB generates batches with same id if rows are cleaned from the sym_outgoing_batch and Mysql is restarted after that (chenson) - closed.
- 0000237: [Improvement] Name the JMX name after the engine.name symmetirc property so multiple engines can coexist (chenson) - closed.
- 0000239: [Improvement] Search Router By Router Id (chenson) - closed.
- 0000243: [Improvement] Add logging around the failure of a translation from CSV string to Java Object during data loading (chenson) - closed.
- 0000244: [Bug] Oracle dialect should be using ALL_TRIGGERS instead of USER_TRIGGERS (chenson) - closed.
- 0000252: [Improvement] Don't set batch to ER in acknowledgement service if it is already OK (chenson) - closed.
- 0000235: [Bug] sym.sync.table.prefix is missing from updateStrandedBatches in purge-service-sql.xml (chenson) - closed.
- 0000250: [Bug] A disabled channel should not route data (chenson) - closed.
- 0000207: [New Feature] Add a --create-war option to the sym command (chenson) - closed.
- 0000241: [Improvement] Add cleaner statistic implementation that can be trickled back to the parent node(s). (chenson) - closed.
- 0000269: [Bug] Before inserting more heartbeat events, make sure that the previous ones have been sent. (chenson) - closed.
- 0000271: [New Feature] Test HSQLDB 2.0 (chenson) - closed.
- 0000279: [Improvement] Log the failed table and column in ColumnDataFilters to make debugging easier. (chenson) - closed.
- 0000280: [Bug] Some operations that are suppose to be transactional are not due to the extension post bean processor. (chenson) - closed.
- 0000338: [Improvement] Don't write out properties to a temp file if the StandaloneSymmetricEngine(Properties) API is used (chenson) - closed.
- 0000339: [Improvement] Print out a warning if a trigger router exists for a table that can't be found during initial load vs.failing with an ugly excep (chenson) - closed.
- 0000343: [Improvement] Add a new column to sym_channel to enable/disable the selecting of primary key data from sym_data during routing (chenson) - closed.
- 0000340: [Bug] Postgres JDBC driver packaged with SymmetricDS has concurrency issues with PreparedStatements (chenson) - closed.
- 0000248: [Improvement] Provide a means to allow the purge job to be schedule (chenson) - closed.
- 0000260: [Improvement] Use a thread pool for symmetricds jobs. Add support for cron expressions. (chenson) - closed.
- 0000262: [Bug] Blob/Clob not updating for MySQL and Derby (chenson) - closed.
- 0000264: [Bug] If auto config is turned off and there are no upgrade tasks to run, then the upgrade service should not report that an upgrade n (chenson) - closed.
- 0000270: [Improvement] Register Router, Push, Pull and Purge Jobs as JMX beans (chenson) - closed.
- 0000255: [Improvement] Add an environment variable that allows the log4j file to live elsewhere on a system (chenson) - closed.

[31 issues]

SymmetricDS - 1.7.10 (Released 2010-05-25) View Issues ]
==========================================
- 0000251: [Improvement] Add Instructions for Clustering/Load Balancing for 1.7.x (elong) - closed.

[1 issue]

SymmetricDS - 2.0.5 (Released 2010-05-06) View Issues ]
=========================================
- 0000256: [Bug] Possible lock up of the router (chenson) - closed.
- 0000257: [Bug] When deploying to an app server extensions are not being properly registered (chenson) - closed.
- 0000258: [Bug] data_event_count in sym_outgoing_batch is being cleared out during the SE in latest 2.x release (chenson) - closed.
- 0000259: [Bug] boolean parameters/properties in symmetric.properties should be trimmed before being evaluated. (chenson) - closed.

[4 issues]

SymmetricDS - 2.0.4 (Released 2010-04-19) View Issues ]
=========================================
- 0000253: [Bug] Fix nullpointerexception in the configuration service (chenson) - closed.
- 0000254: [Bug] Fix sync issue when there is more columns at the source than at the target and the column that doesn't exist at target changes (chenson) - closed.

[2 issues]

SymmetricDS - 2.0.3 (Released 2010-04-05) View Issues ]
=========================================
- 0000247: [Bug] Upgrade from 2.0.1 to 2.0.2 failed. (chenson) - closed.
- 0000249: [Bug] Routing locks up (chenson) - closed.

[2 issues]

SymmetricDS - 2.0.1 (Released 2010-03-19) View Issues ]
=========================================
- 0000227: [Bug] sym.bat has a bad reference to log4j.xml (chenson) - closed.
- 0000229: [Improvement] Add support for NCHAR columns on Oracle (chenson) - closed.
- 0000230: [Improvement] Default oracle.use.transaction.view to false (chenson) - closed.

[3 issues]

SymmetricDS - 2.0.0 (Released 2010-03-17) View Issues ]
=========================================
- 0000211: [Improvement] Java service wrapper isn't configured properly to work on Suse Linux per User Guide (chenson) - closed.
- 0000214: [Improvement] Add property to turn on remote access to JMX console. (chenson) - closed.
- 0000215: [Bug] TARGET_CATALOG_NAME has no effect for ROUTER (chenson) - closed.
- 0000216: [Improvement] For initial loads, don't call the router if the initial_load_select is set (chenson) - closed.
- 0000220: [Bug] Default data routers should only route to target node groups (chenson) - closed.
- 0000221: [Improvement] Add property to turn off usage of transaction view on oracle (chenson) - closed.
- 0000223: [Bug] Similiar table definitions in different catalogs/schemas can cause errors during the data load. (chenson) - closed.
- 0000224: [Improvement] Add support for YEAR sql datatype (chenson) - closed.
- 0000225: [Improvement] Log an error when an ack is received that is in ER. (chenson) - closed.
- 0000222: [New Feature] Build upon the IDataLoaderFilter to create a wireable column level filter. (chenson) - closed.

[10 issues]

SymmetricDS - 1.7.9 (Released 2010-02-10) View Issues ]
=========================================
- 0000183: [Improvement] Upgrade Derby to 10.5 (chenson) - closed.

[1 issue]

SymmetricDS - 1.7.8 (Released 2010-01-29) View Issues ]
=========================================
- 0000167: [New Feature] Support OID-based BLOB on PostgreSQL (elong) - closed.
- 0000172: [Bug] Statement too complex error with large number of columns on a table (elong) - closed.
- 0000175: [Bug] Derby varbinary not working (elong) - closed.
- 0000176: [Bug] Empty LOB syncs as null (elong) - closed.
- 0000171: [Bug] Reopening registration fails (elong) - closed.

[5 issues]

SymmetricDS - 1.7.7 (Released 2010-01-07) View Issues ]
=========================================
- 0000070: [Bug] Failing to create insert trigger on sym_trigger using the microsoft jdbc driver (chenson) - closed.
- 0000163: [Bug] Derby 10.5.3.0 not working (elong) - closed.

[2 issues]

SymmetricDS - 1.7.6 (Released 2009-09-19) View Issues ]
=========================================
- 0000151: [Bug] UTF-8 support (chenson) - closed.

[1 issue]

SymmetricDS - 1.7.5 (Released 2009-09-16) View Issues ]
=========================================
- 0000149: [Bug] transport file encoding should be UTF-8 (chenson) - closed.
- 0000150: [Bug] disconnect() from httpurlconnection if request for push is denied (chenson) - closed.

[2 issues]

SymmetricDS - 1.7.4 (Released 2009-09-04) View Issues ]
=========================================
- 0000144: [Bug] Initial load failing when replication is done across schemas (non-public) in PostgreSQL. Data changes however are replicated suc (chenson) - closed.

[1 issue]

SymmetricDS - 1.7.2 (Released 2009-07-22) View Issues ]
=========================================
- 0000047: [New Feature] Use CLOB on SYM_TRIGGER for expression fields (chenson) - closed.
- 0000062: [Improvement] Big tables can cause issues during an initial load because a load is in a single transaction. (chenson) - closed.

[2 issues]

SymmetricDS - 1.7.0 (Released 2009-06-27) View Issues ]
=========================================
- 0000018: [New Feature] Synchronize channel ids all the way to incoming batch (elong) - closed.

[1 issue]

SymmetricDS - 1.6.1 (Released 2009-05-11) View Issues ]
=========================================
- 0000069: [Bug] Catalog and Schema Names Need Quotes on SQL Server (chenson) - closed.

[1 issue]

SymmetricDS - 1.6.0 (Released 2009-04-28) View Issues ]
=========================================
- 0000066: [Bug] Allow the sym_* table virtual triggers to be 'overridden' (chenson) - closed.
- 0000065: [Improvement] Support clustering of push, pull and heartbeat jobs (chenson) - closed.
- 0000052: [Bug] Old and new values in node_select (chenson) - closed.
- 0000008: [Bug] Heartbeat messages accumulate if offline (chenson) - closed.
- 0000009: [Bug] Outer tier nodes should trickle heartbeat messages back to the root server (chenson) - closed.
- 0000011: [Bug] Registration is closed before the client acknowledges 'OK' (chenson) - closed.
- 0000015: [New Feature] Create an H2 embedded database Dialect - closed.
- 0000020: [New Feature] Create a Firebird Dialect (elong) - closed.
- 0000034: [Task] Add 3 tiered integration test (chenson) - closed.
- 0000037: [Bug] Triggers get overwritten with two synchronizations on the same table (chenson) - closed.
- 0000038: [Improvement] Change the default settings for the default PropertyPlaceholderConfigurer used by SymmetricDS (chenson) - closed.
- 0000040: [Bug] Fails to start up with Derby network client (elong) - closed.
- 0000048: [New Feature] Allow outer nodes in a multi-tier system to be able to connect to the central-most node for registration (chenson) - closed.
- 0000049: [Improvement] Change the statistics API so that statistic names are not Java enumerations (makes it more reusable). (chenson) - closed.
- 0000050: [Improvement] Support Oracle's BINARY_FLOAT and BINARY_DOUBLE column types (chenson) - closed.
- 0000051: [Bug] Multi-tier issue - Initial load enabled flag and initial load time are not properly set after an initial load on the client in 1 (chenson) - closed.
- 0000053: [Bug] Explicitly define the size of the statistic_total column on sym_statistic. DDLUTILS defaults the size to 5 on Apache Derby for d (chenson) - closed.
- 0000055: [New Feature] Add an extension point to allow users to customize how node ids are selected. (chenson) - closed.
- 0000056: [New Feature] Schedule the pull job to happen immediately if an initial load is in progress. No sense in waiting around when there is work to (chenson) - closed.
- 0000058: [Bug] NSFormatException on mysql bit column type (chenson) - closed.
- 0000059: [New Feature] Add a property that allows the syncTriggers process to not auto create the triggers. Also add a utility to print out the trigger (chenson) - closed.

[21 issues]

SymmetricDS Pro - Change Log

SymmetricDS Pro - 3.7.0 (Not Yet Released) View Issues ]
==========================================
- 0002072: [Bug] Auto install file is truncated when generated from console (elong) - resolved.
- 0002091: [Bug] When a parameter is set in engines file it shows up as current value on edit screen but edit popup has wrong value (chenson) - resolved.
- 0002085: [Improvement] Support queries that return multiple result sets (like running sp_configure on sybase) in the sql explorer (chenson) - resolved.
- 0002080: [Improvement] Add field level help text to edit forms (elong) - resolved.
- 0001741: [Improvement] Improve Firebird SYM_UDF installation (elong) - resolved.
- 0001931: [Bug] Unattended install spits out warnings (elong) - resolved.
- 0001982: [Improvement] Upgrade Vaadin (chenson) - resolved.
- 0001981: [New Feature] Rework sql explorer layout. Remove Symmetric Pro dependencies (chenson) - resolved.
- 0002049: [Bug] Sql Editor doesn't pull in correct formatting files when SymmetricDS is deployed as a war file (chenson) - resolved.
- 0002026: [Improvement] Relaunch control center as privileged process on Windows (elong) - resolved.
- 0002025: [Bug] Windows non-admin user cannot query service status (elong) - resolved.

[11 issues]

SymmetricDS Pro - 3.6.17 (Not Yet Released) View Issues ]
===========================================
- 0002106: [Bug] The configured state does not match recorded database state. The record... (chenson) - resolved.

[1 issue]

SymmetricDS Pro - 3.6.16 (Released 2014-12-11) View Issues ]
==============================================
- 0002098: [Bug] The dashboard is refreshed several times when it is navigated to which can cause ui lock on slower systems (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.6.14 (Released 2014-12-01) View Issues ]
==============================================
- 0002066: [Bug] Graph fails to render if > 22 channels are represented (chenson) - closed.
- 0002070: [Bug] NullPointerException can happen during uninstall (chenson) - closed.
- 0002074: [Improvement] When setting up connection for sybase ase always set nocount off as the db.init.sql (chenson) - closed.

[3 issues]

SymmetricDS Pro - 3.6.13 (Released 2014-11-10) View Issues ]
==============================================
- 0002051: [Bug] Outgoing batch browse dialog limit at 100 rows (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.6.12 (Released 2014-11-03) View Issues ]
==============================================
- 0002031: [Bug] Sorting is in the opposite direction of the arrow on the batch table (chenson) - closed.
- 0002033: [Bug] Column edit of multiple transforms is currently broken (chenson) - closed.
- 0002034: [Bug] Validate button for bsh transform column scripts is not reliable. It also doesn't show the error. (chenson) - closed.
- 0002035: [Bug] Cancel load is broken (chenson) - closed.
- 0002038: [Bug] Ordering transforms on the edit transform columns screen has issues (chenson) - closed.
- 0002039: [Bug] Commandline utils enabled for HTTPS with transport manager (elong) - closed.
- 0002045: [Bug] Fix uninstall null pointer when uninstalling from the node panel (chenson) - closed.

[7 issues]

SymmetricDS Pro - 3.6.11 (Released 2014-10-27) View Issues ]
==============================================
- 0002019: [Improvement] Edit transform columns should use a split pane and make the right pane bigger by default. Get rid of compile warnings for bsh (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.6.10 (Released 2014-10-09) View Issues ]
==============================================
- 0002007: [Improvement] Add refresh button that re-extracts batch data on the view batch screen (chenson) - resolved.
- 0001954: [Bug] Extracted batch viewer missing data and showing data in wrong columns (chenson) - resolved.
- 0002005: [Bug] Transform Edit Columns screen. Fix up and down arrows to be more predictable. (chenson) - resolved.
- 0002001: [Bug] Should not prompt for the console password on a client install (chenson) - resolved.

[4 issues]

SymmetricDS Pro - 3.6.9 (Released 2014-09-30) View Issues ]
=============================================
- 0001951: [Bug] Warnings are not cleared from notification area after timeout period, only errors are (chenson) - closed.
- 0001976: [Bug] Parameter edit text area in window doesn't expand on maximize (chenson) - closed.
- 0001990: [Bug] Error when transform row is selected on a client node that is not suppose to be editable (chenson) - closed.

[3 issues]

SymmetricDS Pro - 3.6.8 (Released 2014-09-17) View Issues ]
=============================================
- 0001958: [Improvement] Improve the layout of parameter edit dialog (chenson) - closed.
- 0001972: [Bug] Issue with upgrade of sym_console_user (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.6.7 (Released 2014-09-02) View Issues ]
=============================================
- 0001941: [Bug] An error occurs while saving a new transform if no rows have been selected in the transform list (chenson) - closed.
- 0001943: [Improvement] Change the default MySQL db.url to include &zeroDateTimeBehavior=convertToNull (chenson) - closed.
- 0001944: [Bug] Error occurs while searching for table in export dialog on sql explorer screen (chenson) - closed.
- 0001945: [Bug] Parameter edit panel doesn't display the correct parameter value for group if the node specific parameter has been set (chenson) - closed.
- 0001947: [Bug] db export to file from sql explorer does not work (chenson) - closed.
- 0001948: [Improvement] When using the parameter restore button, prompt to make sure the user really wants to restore the parameter (chenson) - closed.
- 0001949: [Improvement] Use sql editor for lookup transform editor. Update description to include information about tokens. (chenson) - closed.

[7 issues]

SymmetricDS Pro - 3.6.6 (Released 2014-08-27) View Issues ]
=============================================
- 0001903: [Improvement] Clean up console installer (elong) - closed.
- 0001847: [Improvement] Outgoing Batch Improvements (abailey) - closed.
- 0001898: [Bug] When canceling a failed load, set the batch error_flag=0 (abailey) - closed.
- 0001899: [Bug] If a form doesn't save, keep advanced options shown if they were at point of save (abailey) - closed.
- 0001900: [New Feature] Read batch data from the staging manager in Incoming and Outgoing Batches on Batch Id click (abailey) - closed.
- 0001901: [Bug] Execute as script and Execute sql under cursor buttons should be disabled unless the sql area contains text (abailey) - closed.
- 0001902: [Improvement] Tables in ChooseTablesToReloadWindow should be sorted alphabetically (abailey) - closed.
- 0001904: [Improvement] Table sorting should be case-insensitive (abailey) - closed.
- 0001905: [Improvement] Collapse the "Enabled" column when linking triggers (abailey) - closed.
- 0001906: [Bug] parameter edit screen doesn't show configured parameters when using views other than ALL (chenson) - closed.
- 0001908: [Improvement] Transform Auto Create should only populate tables with a trigger router (abailey) - closed.
- 0001909: [Improvement] When creating a new Transform, the trigger router should be found using the catalog and schema based on trigger/router options (abailey) - closed.
- 0001911: [Improvement] Router Type and Router Expression should always be displayed together (chenson) - closed.
- 0001912: [Bug] formatting of the sql explorer settings dialog is off. (abailey) - closed.
- 0001913: [New Feature] DbFill now has the capability to print the sql to the command line and to the Sql Editor. (abailey) - closed.
- 0001914: [New Feature] Ability to restore a parameter's value back to the default value (abailey) - closed.
- 0001915: [Improvement] Refactor the TabularResultLayout code from SqlRunner to its' own class (abailey) - closed.
- 0001916: [Improvement] Add the CTRL+M window maximizer to the ReadOnlyTextAreaDialog (abailey) - closed.
- 0001918: [Improvement] Make the Edit Scripts dialog for Load Filters resizable and maximizable (abailey) - closed.
- 0001919: [Bug] Fix Sql Explorer issues for Oracle (abailey) - closed.
- 0001924: [Bug] Bad parsing for dashboard link to batches screen (chenson) - closed.
- 0001927: [Bug] row number resets after 100 on outgoing and incoming batch panels' show batch data screen (chenson) - closed.
- 0001928: [Bug] The outgoing batch show shortcut doesn't explictly set the channels when selected "Show All Batches" (chenson) - closed.
- 0001934: [Improvement] Minor improvements to the Manage Outgoing and Incoming Batch Screens (abailey) - closed.
- 0001690: [Improvement] License key storage and updates (chenson) - closed.
- 0001932: [Improvement] Add more information to the About Panel (abailey) - closed.
- 0001933: [Improvement] Add the transform id to the edit columns window. Disable edit columns button if item selection in table isn't 1 (abailey) - closed.

[27 issues]

SymmetricDS Pro - 3.6.5 (Released 2014-08-11) View Issues ]
=============================================
- 0001864: [Bug] Test SymmetricDS install on Java 8 and Windows 7. I don't think the service will stop properly. (elong) - closed.
- 0001865: [Bug] SymmetricDS upgrade on Windows 7 defaults to C:\Program Files versus C:\SymmetricDS-Pro (elong) - closed.
- 0001616: [Improvement] Configuration of transforms has been said to "Give me more headaches than a rap concert." Simplify configuration. (abailey) - closed.
- 0001871: [Improvement] Improve performance of transform edit column screen by using cached metadata (chenson) - closed.
- 0001872: [Improvement] Installer should check if service name already in use (elong) - closed.
- 0001874: [Bug] sync on update is missing on the edit trigger form (chenson) - closed.
- 0001878: [Improvement] Installer should prompt for service name only when installing service (elong) - closed.

[7 issues]

SymmetricDS Pro - 3.6.4 (Released 2014-08-02) View Issues ]
=============================================
- 0001848: [Bug] sql explorer query results has two scrollbars due to fixed size (chenson) - closed.
- 0001849: [Bug] Foreign key metadata should not exclude table and schema columns (chenson) - closed.
- 0001850: [Bug] Errors that occur during the import of a new profile in the config wizard are ugly. The error needs to be handled better. (chenson) - closed.
- 0001851: [Bug] If you edit a property in a form and cancel it is still set on the underlying object and is reflect in the edit panel table (chenson) - closed.
- 0001854: [Bug] Error happens when sql history window is opened (chenson) - closed.
- 0001855: [Improvement] Make parameter edit dialog resizeable. Show description on the editor. (chenson) - closed.
- 0001858: [Improvement] Remove tooltips from the edit buttons on the parameters screen. (chenson) - closed.
- 0001861: [Improvement] Row # Column in Sql Explorer now has a header of "#" instead of "" (abailey) - closed.
- 0001862: [Bug] Fix bugs in outgoing batch panel. Duplicate batches. Not all batches shown. (chenson) - closed.

[9 issues]

SymmetricDS Pro - 3.6.3 (Released 2014-07-29) View Issues ]
=============================================
- 0001809: [Improvement] Make minor UI improvements to Configure and Manage Tabs (abailey) - closed.
- 0001815: [Bug] Allow rest api test page to be used in a war deployment with a different context path than standalone (chenson) - closed.
- 0001817: [Improvement] Add a "Show configured parameters only" check box on the Config/Parameters screen (chenson) - closed.
- 0001822: [Bug] Format lost for transform expressions when column transforms are saved (chenson) - closed.
- 0001824: [Bug] Better support numeric database types in the sql explorer (chenson) - closed.
- 0001825: [Bug] After upgrade, windows service won't start (elong) - closed.
- 0001826: [Improvement] Add "runas" support to Wrapper service (elong) - closed.
- 0001834: [Improvement] Show stack traces on the Manage / Logging screen when they occur in the log file (chenson) - closed.
- 0001835: [Improvement] Only show the log output from the engine that is currently being viewed (chenson) - closed.
- 0001838: [Improvement] Add profile for master to master configuration to the setup wizard (chenson) - closed.
- 0001840: [Improvement] Add support for code and sql as parameter types in the parameter edit screen (chenson) - closed.

[11 issues]

SymmetricDS Pro - 3.6.2 (Released 2014-07-12) View Issues ]
=============================================
- 0001780: [Bug] Outgoing batch summary query doesn't work on interbase (chenson) - closed.
- 0001786: [Bug] Max Results in SQL Explorer isn't being respected when results are put into table (chenson) - closed.
- 0001791: [Improvement] Outgoing load screen can be slow when there is lots of data in sym_data because of join to get current table (chenson) - closed.
- 0001792: [New Feature] Add new features and make minor improvements to the SQL Explorer (abailey) - closed.
- 0001799: [Bug] Multiselect of outgoing batches with same batch id does not work. The item key needs to be nodeBatchId not batchId (chenson) - closed.

[5 issues]

SymmetricDS Pro - 3.6.1 (Released 2014-06-26) View Issues ]
=============================================
- 0001775: [Bug] Export configuration is empty (chenson) - closed.
- 0001777: [Bug] Fix reference to prettify js and css so it is properly referenced when deployed as war (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.6.0 (Released 2014-06-16) View Issues ]
=============================================
- 0000839: [Improvement] Introduce a global error icon or an error notification tray icon that is visible across all pages (chenson) - closed.
- 0001739: [Improvement] Make transform edit screen table sortable by group link (chenson) - closed.
- 0001761: [Improvement] Update console new/edit screens with appropriate titles. (josh-a-hicks) - closed.
- 0001763: [Improvement] Display only engine name if only a single engine is present in console. (josh-a-hicks) - closed.
- 0001768: [Improvement] Set width on all config forms to same size. (josh-a-hicks) - closed.
- 0001769: [Improvement] Transform type drop down changes sizes (josh-a-hicks) - closed.
- 0001770: [Improvement] Uninstall panel now allows uninstall of all multi-homed nodes (chenson) - closed.
- 0001594: [Improvement] Default Target Node should probably be "All" on Parameters screen. Most of the time parameters are changed for "All" (chenson) - closed.
- 0001599: [Bug] IZPack automated installer error (elong) - closed.
- 0001612: [New Feature] Add the ability to right click and remove triggers from the installed triggers screen (elong) - closed.
- 0001622: [Bug] Wrong batch number can sometimes be printed out when an error occurs (chenson) - closed.
- 0001628: [Bug] Installer should escalate privilege on Windows 8 (elong) - closed.
- 0001478: [Bug] Removing a node should remove incoming batches (elong) - closed.
- 0001595: [Bug] Ok and Cancel buttons are in the wrong order on some screens. Make them consistent. (chenson) - closed.
- 0001596: [Improvement] Upgrade to the newest version of Vaadin to get support for the newest version of IE (chenson) - closed.
- 0001598: [Improvement] If there are custom parameters in sym_parameter, allow them to be edited in the parameter screen (chenson) - closed.
- 0001607: [Bug] Saving trigger link on GUI causes race with sync triggers (chenson) - closed.
- 0001625: [Improvement] Load filters summary screen should indicate configured scripts (josh-a-hicks) - closed.
- 0001627: [Task] Add a cancel load feature to the load screen (chenson) - closed.
- 0001641: [Improvement] Parameters screen doesn't allow you to see a good view of the current node's parameters. (chenson) - closed.
- 0001659: [Bug] Manage->Nodes screen shows offline (elong) - closed.
- 0001683: [Improvement] Move the delete button from the form popup window to the main edit screen (chenson) - closed.
- 0001687: [Bug] On the outgoing loads panel, only show queued loads that would be handled by the current node (chenson) - closed.
- 0001694: [Bug] Channel chart on dashboard does not refresh channel list in a multi server mode (josh-a-hicks) - closed.
- 0001702: [Improvement] Add dashboard screen that shows errors and warning that have occurred via logging (chenson) - closed.
- 0001709: [Improvement] Allow filter by channel on trigger screen. Show the number of triggers selected when filtered. (chenson) - closed.
- 0001732: [New Feature] Double click to get node host information on node screen (chenson) - closed.
- 0001733: [Improvement] Add text field on batch screens to search by batch id. Link batch errors to go to outgoing batch screen with text field filled (chenson) - closed.
- 0001736: [Bug] The web console should allow table reloads, sql and schema updates to be sent on any group link (chenson) - closed.
- 0001740: [Improvement] Support hitting the ESC key to cancel popup windows and dialogs across the board (chenson) - closed.
- 0001747: [Improvement] Show database, registration time, load time, and reverse load time on node panel. Collapse all but database by default. (chenson) - closed.
- 0000975: [Improvement] Upload new profile from the current profile select screen at configuration time. (josh-a-hicks) - closed.
- 0001680: [Installation] Improve SymmetricDS Installation Process (elong) - closed.
- 0001704: [Improvement] Replace Pro Quick Start with shorter new version of Quick Start (josh-a-hicks) - closed.
- 0001719: [New Feature] Disable web console with a parameter (josh-a-hicks) - closed.

[35 issues]

SymmetricDS Pro - 3.5.22 (Released 2014-05-27) View Issues ]
==============================================
- 0001695: [Improvement] Allow sorting of tables on the reload and sync schema screens (chenson) - closed.
- 0001720: [Bug] The login screen is skipped if the first engine returned doesn't have an console user even if other engines have a user (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.5.21 (Released 2014-04-28) View Issues ]
==============================================
- 0001696: [Bug] Can't override config channel triggers for tables added by Pro in sym_trigger (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.5.19 (Released 2014-03-16) View Issues ]
==============================================
- 0001640: [Improvement] Empty license screen for first time users (elong) - closed.

[1 issue]

SymmetricDS Pro - 3.5.18 (Released 2014-03-02) View Issues ]
==============================================
- 0001605: [Improvement] Sort the transform types alphabetically in the Transform Column dropdown. (mhanes) - closed.

[1 issue]

SymmetricDS Pro - 3.5.17 (Released 2014-02-15) View Issues ]
==============================================
- 0001582: [Improvement] Add transform column order to transform column edit screen. (chenson) - closed.
- 0001482: [Bug] The wrong version of the Microsoft JDBC driver is being packaged with SymmetricDS (chenson) - closed.
- 0001563: [Bug] View Staging Area Screen doesn't work on Windows (chenson) - closed.
- 0001577: [Improvement] Installer prompt for service name (elong) - closed.
- 0001584: [Improvement] Change the name of the sql server dropdown options to "Sql Server" and "Sql Server Azure" to encourage users to pick JTDS (chenson) - closed.

[5 issues]

SymmetricDS Pro - 3.5.16 (Released 2014-02-05) View Issues ]
==============================================
- 0001547: [New Feature] Add Send Schema Feature to NodePanel. Right click on list of nodes to synchronize table schema. (chenson) - closed.
- 0001551: [Improvement] Log the actual exception as a warning if the pro database wizard fails to connect to the database (chenson) - closed.
- 0001552: [Bug] Wrong error message is reported when testing a connection from the pro install wizard (chenson) - closed.
- 0001554: [Bug] When NOT in multiservermode and the default engine fails to start, do NOT fallback to the config node wizard (chenson) - closed.
- 0001557: [Bug] Table names not showing up for wildcard tables in Reload Table and Send Schema Dialogs on the Node Panel (chenson) - closed.
- 0001560: [Bug] Transform Edit screen throws null pointer if you select a transform row on a client (mhanes) - closed.

[6 issues]

SymmetricDS Pro - 3.5.15 (Released 2014-01-22) View Issues ]
==============================================
- 0001535: [Bug] Contacting Server registration URL during client config wizard in pro results in error when server and client are SSL. (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.5.14 (Released 2014-01-17) View Issues ]
==============================================
- 0001517: [Bug] Uninstall leaves triggers and functions (chenson) - closed.
- 0001519: [Bug] upgrade of console_user.user_role from a version that has the column named role fails on firebird due to triggers (chenson) - closed.
- 0001522: [Bug] Leave a configure screen with search criteria and reenter the screen. Search text remains, but is not applied to the table. (chenson) - closed.
- 0001523: [Improvement] Add a hidden "Reload Table" column to the outgoing batch screen that shows the table being reloaded (chenson) - closed.
- 0001525: [Improvement] Confirm before sending a reverse initial load from the node panel in the user interface (chenson) - closed.
- 0001526: [New Feature] Add a feature to allow a user to enter SQL that will be sent to remove nodes and executed (chenson) - closed.

[6 issues]

SymmetricDS Pro - 3.5.13 (Released 2014-01-06) View Issues ]
==============================================
- 0001516: [Improvement] Add a "Manage - Stage Area" screen that allows the staging area to be browsed. Move the "Clear Staging" button to this screen. (chenson) - closed.
- 0001499: [Improvement] Show a warning on the trigger screen if a table is configured without a primary key and 'sync key names' has not been set (chenson) - closed.
- 0001500: [Bug] Catch and ignore vaadin CacheRefreshException on the process panel screen. It doesn't seem to cause issues so ignore the error (chenson) - closed.
- 0001501: [Improvement] Add data/sec column to the process info panel (chenson) - closed.
- 0001503: [New Feature] Add a feature to allow the user to specify tables to reload from the web user interface (chenson) - closed.
- 0001515: [Improvement] In REST API documentation UI allow the response type to be switched to application/xml (chenson) - closed.

[6 issues]

SymmetricDS Pro - 3.5.12 (Released 2013-12-18) View Issues ]
==============================================
- 0001476: [New Feature] Add browser panel for REST API in SymmetricDS Pro using swagger (chenson) - closed.
- 0001487: [Bug] Right click on unselected item on node or batch panels results in popup, but no action is executed when selected (chenson) - closed.
- 0001493: [Improvement] Support showing tables in sql explorer for databases that do not have catalogs and schemas (chenson) - closed.
- 0001494: [Improvement] Don't cache tables in sql explorer panel so they can be refreshed (chenson) - closed.
- 0001495: [Bug] Refresh from progress bar at startup leaves only a portion of the components on the dashboard screen. Requires manual refresh. (chenson) - closed.

[5 issues]

SymmetricDS Pro - 3.5.11 (Released 2013-11-15) View Issues ]
==============================================
- 0001464: [Bug] Configuration export in SQL format is broken (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.5.10 (Released 2013-10-20) View Issues ]
==============================================
- 0001443: [Improvement] Add file sync conflict detection setting to the Pro user interface (mhanes) - closed.
- 0001446: [Improvement] Left arrow button key binding to the back button in configuration wizard is annoying. Removing the binding. (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.5.9 (Released 2013-10-10) View Issues ]
=============================================
- 0001428: [Bug] Insert of initial load fails due to bug in Oracle jdbc driver. Update packaged driver. (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.5.8 (Released 2013-09-24) View Issues ]
=============================================
- 0001424: [Bug] Can't update "Contains Big Lobs" on the channel form (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.5.7 (Released 2013-09-14) View Issues ]
=============================================
- 0001415: [Improvement] Remove node status 'Online'. (abrougher) - closed.

[1 issue]

SymmetricDS Pro - 3.5.6 (Released 2013-09-05) View Issues ]
=============================================
- 0001198: [New Feature] Add feature to prevent write access on all nodes but the registration server. (abrougher) - closed.
- 0001411: [Improvement] Add clear staging button for outgoing batches (abrougher) - closed.
- 0001102: [Improvement] When removing a node in a multi-homed situation, remove .properties file from engines directory (abrougher) - closed.
- 0001407: [Improvement] When performing a new installation and a previous installation is detected, allow the user to first uninstall. (abrougher) - closed.
- 0001408: [Improvement] When removing a node from the Manage -> Nodes panel, allow users to optionally uninstall the node. (abrougher) - closed.
- 0001085: [Bug] Select two tables with the same name in different schemas from the auto create screen and only one gets generated. (abrougher) - closed.

[6 issues]

SymmetricDS Pro - 3.5.5 (Released 2013-08-27) View Issues ]
=============================================
- 0001357: [Improvement] The Pro wrapper.log should be included in the support snapshot. (abrougher) - closed.
- 0001398: [Improvement] Improvements to the node setup wizard to minimize the need for a mouse (chenson) - closed.
- 0001403: [Bug] Support multi node delete and allow registration (chenson) - closed.
- 0001324: [Bug] Configure column transform screen does not check for null target column name. (abrougher) - closed.
- 0001406: [Improvement] Support bulk updating Transform Columns. (abrougher) - closed.
- 0001401: [Improvement] When auto creating a transform, allow the user to choose between an implied or specified transform. (abrougher) - closed.
- 0001402: [Improvement] Support bulk inserting new column transforms for multiple table transforms. (abrougher) - closed.

[7 issues]

SymmetricDS Pro - 3.5.4 (Released 2013-08-20) View Issues ]
=============================================
- 0001394: [Bug] Setting a batch to IG via the ui should also reset the error_flag (chenson) - closed.
- 0001383: [Bug] Updating SymmetricDS Pro from the terminal does not remove old jar files in web\WEB-INF\lib. (abrougher) - closed.
- 0001384: [Installation] Prevent users from installing Pro on top of an existing SymmetricDS installation. (abrougher) - closed.

[3 issues]

SymmetricDS Pro - 3.5.3 (Released 2013-08-10) View Issues ]
=============================================
- 0001380: [Bug] After adding a group link sync triggers if there are not active triggers. This will cause symmetric triggers to be created. (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.5.2 (Released 2013-08-04) View Issues ]
=============================================
- 0001352: [Bug] The batch link on the outgoing batch screen is broken (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.5.0 (Released 2013-07-22) View Issues ]
=============================================
- 0001288: [Bug] Investigate where node heartbeat information should be displayed in Pro (abrougher) - closed.
- 0001294: [Improvement] Need to further clarify what "type" of push or pull on the Manage screens (abrougher) - closed.
- 0001328: [Bug] When there are lots of tables to synchronize it can slow down the save of a trigger or router link (chenson) - closed.
- 0001191: [Improvement] Add heartbeat.update.node.with.batch.status property to control if batch stats are updated in sym_node. Default: false (chenson) - closed.
- 0001264: [Task] Move quick start guide to docbooks, incorporate into build and update for 3.5 (abrougher) - closed.
- 0001225: [Bug] Table sym_node_group_channel_window exceeds the max table name length for Sybase ASE 12. (chenson) - closed.
- 0000836: [Improvement] The push/pull concurrency screens should have a search field similar to the nodes screen (abrougher) - closed.
- 0000849: [New Feature] Add an option for using the Microsoft JDBC driver in the configuration wizard (chenson) - closed.
- 0001219: [Improvement] Make the beanshell editor window stretch when the window is resized. Also, make the default size a bit bigger (abrougher) - closed.
- 0001230: [Improvement] Disabled delete buttons should indicate why they are disabled. (chenson) - closed.
- 0001243: [Improvement] SymmetricDS needs to be able to upgrade to 3.5.0 where the column sym_console_user.role was renamed "user_role". (chenson) - closed.
- 0001265: [Improvement] Set jobs.synchronized.enable=true when SQLLite is selected as the database (chenson) - closed.
- 0001266: [New Feature] Click through SSL setup in the wizard (chenson) - closed.
- 0001267: [Improvement] Allow multiple batches to be select so they can be marked for ignore or deleted at the same time (chenson) - closed.
- 0001275: [New Feature] Update UI to support File Sync (abrougher) - closed.
- 0001280: [Improvement] Don't allow a load to be scheduled if a node group link doesn't exist that would allow a load to be processed (chenson) - closed.
- 0001281: [Improvement] Log when loads and registration are requested from the UI (chenson) - closed.
- 0001300: [Bug] Configure/Conflicts columns mixed up (abrougher) - closed.
- 0001311: [Improvement] SQL Explorer should auto commit by default with the option to turn auto commit off. (abrougher) - closed.
- 0001313: [Improvement] SQL Explorer red un-committed background appears to be the result of an error. (abrougher) - closed.
- 0001173: [Improvement] Allow multiple nodes to be deleted from the node panel at once (abrougher) - closed.
- 0001308: [Bug] Wizard finish button is disabled even if the finish is rejected due to connection issue. (abrougher) - closed.
- 0001312: [Improvement] SQL Explorer multi-homed client tabs are confusing. (abrougher) - closed.
- 0001314: [Bug] The SQL Explorer window remains in an un-committed state until the user selects commit. They should be able to type commit. (abrougher) - closed.
- 0001315: [Improvement] Configure screen forms should have scroll bars so the buttons are always visible and the form is scrollable. (abrougher) - closed.
- 0001326: [Bug] Edit screens can become very unresponsive with lots of rows (this has been reported on the trigger screen) (chenson) - closed.
- 0001331: [Bug] Deletion of registration requests from the node panel does not work (chenson) - closed.

[27 issues]

SymmetricDS Pro - 3.4.8 (Released 2013-07-03) View Issues ]
=============================================
- 0001290: [Bug] Mariab db is chosen when going through MySQL database setup until SymmetricDS is restarted after setup (chenson) - closed.
- 0001293: [Bug] Sql Explorer's Run As Script is broken (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.4.5 (Released 2013-05-29) View Issues ]
=============================================
- 0001217: [Improvement] Don't allow node group link delete until transforms using that link are also removed. (abrougher) - closed.
- 0001200: [Bug] Manage/Nodes header in console grammar and number wrong (chenson) - closed.
- 0001201: [Improvement] Show offline nodes in red on the nodes panel (chenson) - closed.
- 0001212: [Bug] Editting of transform columns is broken in 3.4 (chenson) - closed.

[4 issues]

SymmetricDS Pro - 3.4.4 (Released 2013-05-12) View Issues ]
=============================================
- 0001208: [Bug] Sql Explorer doesn't work with sql.explorer.auto.commit=true (chenson) - closed.
- 0001209: [Bug] Configuration export broken in 3.4.3 (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.4.3 (Released 2013-05-07) View Issues ]
=============================================
- 0001195: [Bug] Pro version of sym_service.conf should NOT specify the http or jmx http ports (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.4.2 (Released 2013-04-24) View Issues ]
=============================================
- 0001189: [Improvement] Show registration error conditions as tooltip (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.4.1 (Released 2013-04-24) View Issues ]
=============================================
- 0001185: [Bug] Edit Group Link screen doesn't show more than one source node group. The refactored screen is using the wrong key. (chenson) - closed.
- 0001186: [Improvement] Automatically fill in db.init.sql for sql server to: SET NOCOUNT FALSE in setup wizard (chenson) - closed.
- 0001187: [Improvement] Show sql history in pop window and add max results field to sql explorer screen (chenson) - closed.

[3 issues]

SymmetricDS Pro - 3.4.0 (Released 2013-04-21) View Issues ]
=============================================
- 0001159: [Bug] PostgresBulkDatabaseWriter using the wrong escape character for bulk CSV (chenson) - closed.
- 0001181: [New Feature] Add Outgoing Loads screen for monitoring initial load status (chenson) - closed.
- 0001148: [Bug] Trigger Auto Create skips database tables starting with sym instead of sym_. (chenson) - closed.
- 0000950: [Improvement] Consider restricting the export URL (and other critical application functions) to authenticated sessions only. (abrougher) - closed.
- 0001092: [Improvement] Trigger Edit Form should allow you to edit sync_on_condition fields (chenson) - closed.
- 0001091: [Improvement] Should be able to filter trigger edit screen by channel (chenson) - closed.
- 0001123: [Installation] change logs and license attribution files don't get installed as part of symmetric-pro (chenson) - closed.
- 0000838: [Improvement] When triggers are synchronized, feedback should be given as to whether it did any work and if it was successful (chenson) - closed.
- 0000991: [Improvement] Auto delete the trigger_router rows when deleting a trigger (or a router for that matter) (chenson) - closed.
- 0000992: [Improvement] Add bulk update capabilities to the configuration screens. (chenson) - closed.
- 0001054: [Improvement] Trigger edit panel table rows scroll around after a user cancels an edit. (chenson) - closed.
- 0001089: [Improvement] Search field on configure screens should update the table as the user types. (chenson) - closed.
- 0001096: [Improvement] Give the option to export profile as sql script (chenson) - closed.
- 0001112: [Bug] Client install fails in setup wizard when "I'll configure things myself" is chosen (chenson) - closed.
- 0001113: [Improvement] Make next button enabled and the finish button disabled when the client install is checked at the end of the server install (chenson) - closed.
- 0001114: [Bug] trigger_router last_update_by column is not getting populated. (chenson) - closed.
- 0001120: [Bug] Error is not handled gracefully when a transform column is saved without a target column (chenson) - closed.
- 0001125: [Improvement] Target catalog, schema and table names aren't displayable in the router edit table (chenson) - closed.
- 0001126: [Improvement] Show instance id on the dashboard panel (chenson) - closed.
- 0001127: [Improvement] Show all of the incoming batch statistics in the filtered table on the manage incoming batch screen (chenson) - closed.
- 0001136: [Improvement] set the connectTimeout and the socketTimeout parameter in the mysql jdbc url by default during installation (chenson) - closed.
- 0001158: [Improvement] Change "Registering" status on Node panel to "Open" to make it more clear that registration is just "Open" and not "In progress" (chenson) - closed.
- 0001177: [New Feature] Add table browser and commit and rollback functionality to the sql explorer (chenson) - closed.
- 0001145: [Improvement] Add support to auto log in as administrator if no users exist in sym_console_user. (chenson) - closed.
- 0001146: [Bug] When a user tries to log in with a good username but a bad password, there is no error. (chenson) - closed.

[25 issues]

SymmetricDS Pro - 3.3.4 (Released 2013-03-09) View Issues ]
=============================================
- 0001093: [Bug] Postgres jdbc url parameter is not correct. (chenson) - closed.
- 0001095: [Bug] Export should not include sym_table_reload_request (chenson) - closed.
- 0001098: [Bug] Previous button on wizard install results in null pointer exception after choosing existing installation. (chenson) - closed.

[3 issues]

SymmetricDS Pro - 3.3.3 (Released 2013-03-01) View Issues ]
=============================================
- 0001084: [Bug] Node Panel is slow to load when there are 30,000+ nodes (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.3.2 (Released 2013-02-26) View Issues ]
=============================================
- 0001065: [Bug] When saving a trigger router, run syncTriggers for just that trigger to prevent error icon from showing up on ui (chenson) - closed.
- 0001055: [Improvement] Change the default jdbc url for JTDS to have a socketTimeout set (chenson) - closed.
- 0001059: [Improvement] Instead of showing "Unregistered" on the node panel, show "Registering" which is more accurate and informative (chenson) - closed.
- 0001060: [Improvement] Automatically fill in db.connection.properties when setting up an Oracle node (chenson) - closed.
- 0001069: [Bug] Icon in last row for router table doesn't show up first time it is displayed (chenson) - closed.
- 0001072: [Bug] Sql Explorer doesn't show results if more than one column with the same name is returned (chenson) - closed.
- 0001073: [Improvement] Package the mail api with pro so it can be used from filters. (chenson) - closed.

[7 issues]

SymmetricDS Pro - 3.3.0 (Released 2013-02-08) View Issues ]
=============================================
- 0001029: [New Feature] Allow a list of external ids to be pasted into a text box to configure grouplet links (chenson) - closed.
- 0001038: [Bug] Database name and version don't update on dashboard for a multihomed install (chenson) - closed.
- 0001009: [Improvement] Just disable buttons. Don't hide them. (chenson) - closed.
- 0001012: [Bug] The indicator that a trigger was not created should only show up on nodes that are linked where the source group is local group (chenson) - closed.
- 0001016: [Improvement] Add arrow indicator to the configure trigger panel to indicate the direction the data is moving relative to the current node (chenson) - closed.
- 0001017: [Improvement] Add icon to the configure router page to show the number of tables/triggers linked to the router (chenson) - closed.
- 0001020: [Improvement] For auto configuration of triggers, if the default catalog and schema are being used make sure they are blank in the trigger def (chenson) - closed.
- 0001021: [Bug] Console User Edit Panel data does not match column headers. (abrougher) - closed.
- 0001022: [Bug] Node panel doesn't display nodes in a predictable order. (chenson) - closed.
- 0001023: [Bug] Broken link icon displayed for triggers that are not "broken". (chenson) - closed.

[10 issues]

SymmetricDS Pro - 3.2.3.1 (Released 2013-01-25) View Issues ]
===============================================
- 0001008: [Improvement] Make the default installation path on unix /opt/symmetric-ds (chenson) - closed.
- 0001007: [Bug] Put the chosen install path into the sym_service.initd file (chenson) - closed.
- 0001006: [Improvement] Don't prompt for port numbers during upgrade. (chenson) - closed.
- 0001005: [Bug] Upgrade from 3.1 to 3.2 can't find log class or security class (chenson) - closed.
- 0001004: [Bug] Ports are not getting replaced during install on Ubuntu in sym_service.conf (chenson) - closed.

[5 issues]

SymmetricDS Pro - 3.2.3 (Released 2013-01-24) View Issues ]
=============================================
- 0001002: [Improvement] Add indicator to the configure trigger screen that shows when a trigger is not linked and shows when a trigger cannot be applied (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.2.2 (Released 2013-01-12) View Issues ]
=============================================
- 0000801: [Improvement] Installer to prompt port numbers (abrougher) - closed.
- 0000960: [Bug] Installation Wizard prompts for port numbers but they are not written as expected (chenson) - closed.
- 0000979: [Bug] Some popup editors are not working (router_type, transforms) (chenson) - closed.
- 0000980: [Improvement] Don't include ignore batches in the default list of batches to show on the outgoing batch panel (chenson) - closed.
- 0000981: [Bug] target_table_name should be required in the load filter configuration screen (chenson) - closed.
- 0000977: [Bug] Installed Triggers table doesn't scroll (chenson) - closed.

[6 issues]

SymmetricDS Pro - 3.2.1 (Released 2012-12-18) View Issues ]
=============================================
- 0000972: [New Feature] Add uninstall button to the pro user interface (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.2.0 (Released 2012-12-16) View Issues ]
=============================================
- 0000957: [Improvement] Add more description text for SymmetricDS concepts (gwilmer) - closed.
- 0000956: [Improvement] Improve the edit screen layout (chenson) - closed.
- 0000772: [New Feature] Provide LDAP support. (chenson) - closed.
- 0000840: [New Feature] Add a support snapshot tool that captures the state of the system for support purposes (chenson) - closed.
- 0000901: [New Feature] Add an new FTP dataloader extension that can write CSV files to an FTP or SFTP server (instead of the database) (chenson) - closed.
- 0000905: [New Feature] Distribute oracle, db2 and ms sql server jdbc jar files with pro (chenson) - closed.
- 0000932: [New Feature] Support multiple user roles (abrougher) - closed.

[7 issues]

SymmetricDS Pro - 3.1.9.1 (Released 2012-11-02) View Issues ]
===============================================
- 0000897: [Bug] The nodes panel sometimes doesn't order the node properly. Switch to use NetworkedNode for ordering. (chenson) - closed.
- 0000895: [Bug] Automatic upgrade doesn't work after an installation has been upgraded once already. Corrupt uninstaller.jar (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.1.9 (Released 2012-10-30) View Issues ]
=============================================
- 0000891: [Bug] Outgoing batch panel can cause an array out of bound exception because of common batch ids (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.1.8 (Released 2012-10-29) View Issues ]
=============================================
- 0000885: [Bug] Outgoing and Incoming Batch Panels cause errors when there are more than 1000 nodes on Oracle (chenson) - closed.
- 0000888: [Improvement] Add filter and buffer size options to logging ui (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.1.7 (Released 2012-10-22) View Issues ]
=============================================
- 0000850: [Improvement] Add SymmetricDS Version to the Nodes screen (chenson) - closed.
- 0000857: [Bug] Outgoing batch update events show two lines labeled old and new but both lines display new data. (abrougher) - closed.
- 0000867: [Improvement] Improve logging screen to include filter and buffer size (chenson) - closed.

[3 issues]

SymmetricDS Pro - 3.1.6 (Released 2012-10-03) View Issues ]
=============================================
- 0000837: [Improvement] The nodes screen should show the total count of the number of nodes. (chenson) - closed.
- 0000842: [Improvement] Node screen does not perform well with 1000s of nodes (chenson) - closed.
- 0000835: [Improvement] Concurrent pull and push screen show all the nodes in a table which take a long time to render (chenson) - closed.

[3 issues]

SymmetricDS Pro - 3.1.2 (Released 2012-08-20) View Issues ]
=============================================
- 0000782: [Bug] If import fails the error is not reported. It looks like the import succeeded. (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.1.0 (Released 2012-08-01) View Issues ]
=============================================
- 0000761: [Bug] Oracle timestamps not displayed correctly in SQL Explorer results (mhanes) - closed.
- 0000699: [Improvement] Provide a way to clear out the staging directory for a batch. (chenson) - closed.

[2 issues]

SymmetricDS Pro - 3.0.7 (Released 2012-07-04) View Issues ]
=============================================
- 0000687: [Bug] Installation Fail: NPE with client install (chenson) - closed.

[1 issue]

SymmetricDS Pro - 3.0.6 (Released 2012-06-29) View Issues ]
=============================================
- 0000681: [Installation] When installed in the Program Files directory on Windows 7 SymmetricDS fails to start because it can't write to the log file (chenson) - closed.

[1 issue]

Copyright © 2014 JumpMind, Inc. All rights reserved. Privacy Policy / Terms of Service