I know this topic was asked before and after 10 Years there still just seem to be a workaround. But i still want to bring this widely wished feature up againg.
Could you possibly make HSQL export gz files directly? Exporting to zip is'nt really that what most people are looking for :) And I am sure MANY people would love to see this feature. And since 7zip supports commandline, this may should be no big deal to implement (if 7zip installation is installed [required]).
I'm not sure, just a guess :) May this also would solve the 4gb and above problem with the zip compression.
Best Regards Dwza