When running a lot of queries on a KB (defined in
Oryx), with SQLFunctions, I get an OutOfMemoryError
(after about 2000 queries). When setting
cacheStatements to false in
org.mandarax.sql.SQLFunction, the problem is solved
(but then, of course, there is no caching). See
attached file for all code. The gensql.py script
generates the (postgres) tables and fills them with
data. The runsql.sh script runs the test.
Test program to recreate the error.