Markus Selbach

Ok Thanks. Hint for others: you should restart MirrorSync Server after installing driver mentioned above.

I'm trying to connect to a PostgreSQL database. What is the correct JDBC Driver Class Name to be entered in the configuration dialog? I tried org.postgresql.Driver , but that fails with the error "JDBC driver not loaded: org. postgresql.Driver". Thanks in advance, Markus

As our MySQL database doesn't support record-level-security I can't tell if this approach would work in general 😕. I tried adding a before delete trigger BEGIN IF OLD.Locked= 1 THEN SIGNAL SQLSTATE '02234' SET MESSAGE_TEXT = 'not found'; END IF; END which works. But as an error is thrown MirrorSync will retry to delete on every sync, which might drop performance when databases become big. Therefore I'm giving up on this.

Thanks Nick for your ideas. Unfortunatly disabling deletion completly is not an option because only the historical data should be frozen. Currently I'm investigating if our spoke SQL DB supports record-level-security, so that we can make delete requests from mirrorSync user fail (silently?) if fieldvalue locked=1. I will post results here if this works.

We want to use MirrorSync to synchronise a very large FileMaker database to a SQL Database. The Hub (FileMaker) Database controlls our production and should contain only data from the last 2 years. The Spoke (SQL) Database is used by BI-Department to analyse actual and historical data and must contain alltime data The direction of the sync is one-way from hub to spoke. On a certain date all data older than 2 years is deleted (really deleted - not just marked as deleted!!!) from the hub. I'm wondering how can I prevent MirrorSync from syncing these deletetions to the spoke? One solution would be to clear or extend the primary keys in the spoke. This would work, because the primarykeys were created only for MirrorSync. But it's not a nice solution. I would prefer a seperate field "locked" in all tables that marks these records as locked. Is there any customization option that let me exclude records where locked=1 from being deleted by MirrorSync? Thanks in advance for any ideas on this topic. Best, Markus

Any news on that one? He are having the exact same problem with our list of 360Works plugins: * Email 3.1 * FTPeek 2.1 * Scribe 3.09 * Scriptmaster 5.1 (But we had the same problem with lower version numbers). We had this issue on with FileMaker 13 on various Win 7 and Win 10 installations. Now we updated to FileMaker 17 on the same workstations and the problem is the same. Any help is hightly appreciated. Thanks in advance ;)