Hi,
we are evaluating DBReplicator with DB2 and Derby (all combinations of publisher and subscriber).
When we make the first snapshot we have a syntax error at line org.dbreplicator.replication.Publication.createSnapShot(Publication.java:734).
The java code is below:
// updating values for bookmark table
String selectMaxSyncID= " select " + RepConstants.shadow_sync_id1 + " from " +
RepConstants.shadow_Table(tableName) + " order by " +
RepConstants.shadow_sync_id1 + " desc limit 1";
We discover that the "LIMIT 1" sql syntax is NOT standard (works only in MySQL and PostgresSQL!!).
For DB2 (> v. 7) you can use "FETCH FIRST 1 ROWS ONLY".
For Derby (> v. 10.5) you can also use "FETCH FIRST 1 ROWS ONLY", that now is in the SLQ-2008 standard.

Thanks in advance.
Massimo