Austin Brougher

Hi Pavithra, The error is... org.jumpmind.symmetric.SymmetricException: The configured state does not match recorded database state. The recorded external id is '002' while the configured external id is '001'. The recorded node group id is 'hotel1' while the configured node group id is 'hotel' Klementina answered a similar issue here. https://sourceforge.net/p/symmetricds/discussion/739236/thread/2a54beac/#a6c1 Is it possible you overwrote your db from another node? Maybe this is how your db and...

Hi Francis, It sounds like your hold up is just getting SymmetricDS started? Have you worked through the quick start guide? This will guide you through configuring SymmetricDS the way you described wanting to use it. https://www.jumpmind.com/downloads/symmetricds/doc/3.9/html/tutorials.html If you are hitting specific errors starting up, please share those errors and we can take a look.

SymmetricDS uses log4j. Instructions for modifying these settings can be found here... https://www.symmetricds.org/doc/3.9/html/user-guide.html#_logging

SymmetricDS uses log4j. Instructions for modifying these settings can be found here... https://www.symmetricds.org/doc/2.1/html/administration.html#logging

Hi ikezheng, Can you explain when you get the above errors? You lay out what you are trying to do but it's not clear when you are seeing the errors you are seeing.

Hi ikezheng, See this response... https://sourceforge.net/p/symmetricds/discussion/739236/thread/77d05a505f/#70d5 afterWrite is executing before the commit at the end of the batch. Your java code is genererating a new transaction. If you use.... ISqlTransaction transaction = context.findTransaction(); You can query the row in the existing transaction before it's committed. Thanks

afterWrite is running after each row write but before the batch has been committed. (see batch commit script for a script that will run after the commit) When you use getSqlTemplate() it will create a new connection to the database. This query won't have access to the uncomitted row. If you use context.findTransaction() you can get the existing transaction and lookup the new PK this way. ISqlTransaction transaction = context.findTransaction(); transaction.queryFor....

afterWrite run is running after each row write but before the batch has been committed. (see batch commit script for a script that will run after the commit) When you use getSqlTemplate() it will create a new connection to the database. This query won't have access to the uncomitted row. If you use context.findTransaction() you can get the existing transaction and lookup the new PK this way. ISqlTransaction transaction = context.findTransaction(); transaction.queryFor....