assure product sql does not rise 'packet too large'

[daczo]

'INSERT INTO ... VALUES ...' is a good syntax, yet for large databases its possible that the generated statement will be even larger than 1Gb (mysql maximum possible length of query)

Safeguard is required, maybe by specifying another property
output.maxInsertSize = 16Mb

then inside the code the 'INSERT' statement has to be broken down into several smaller ones, each smaller than 16Mb.
(or throw exception if not possible, for example due to a large CLOB value)

[3awsomies]

We have divided the max insert rows at a time to be max cap as 100. Please check the latest code committed.

[ari]

Happy with that for now. If we need to, we can reduce this to a smaller numbers of rows easily.