So here is my code:
final List<InsertQuery<ReportAggregatesRecord>> batchInsert =
Lists.newLinkedList();
while (...) {
final
InsertQuery<ReportAggregatesRecord> i =
create.insertQuery(Tables.REPORT_AGGREGATES);
i.addValue(..., ...);
i.addValue(..., ...);
...
i.onDuplicateKeyUpdate(true);
batchInsert.add(i);
}
create.batch(batchInsert).execute();
And here is my exception (thrown by the last line):
org.jooq.exception.DataAccessException: BatchMultiple.execute; SQL [null];
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '[ no fields are
updated ]' at line 1
at org.jooq.impl.Util.translate(Util.java:472) ~[jooq-2.2.2.jar:na]
at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:91)
~[jooq-2.2.2.jar:na]
at amplify.adnetworks.appnexus.ANStatsUpdater$AdvertiserStatsRetriever.run(
ANStatsUpdater.java:227) ~[classes/:na]
Any ideas what the issue could be here?
Ian.
