Hi all, At Human Inference we've been using a lot of MetaModel compiled queries from the JDBC module (created PreparedStatement underneath). We did run into a trouble that each compiled query reserves a connection, and thus we can run out of connections.
Our solution was to fix MetaModel up by adding a pool of Connection+PreparedStatement objects. The pool keeps those objects alive for a few seconds, but if they're idle they will be collected back until the next time the CompiledQuery is fired. This is implemented using commons-pool. I would like to contribute the fix also to Apache MetaModel. Would anyone object? Best regards, Kasper
