YPP

thanks for your quick inputs. Files don't exist. Could there be issues with e.g. connection pools?

Just tested with 128000 that doesn't work either, the .script file still contains SET FILES CACHE SIZE 10000. Maybe that setting isn't supported in JDBC connections?

so that property will really only be considered only with certain values? couldn't a rounding be done in the code to consider all values?

No effect setting hsqldb.cache_size & hsqldb.cache_rows in JDBC connection