+1 this is definitely useful and necessary for JDBC based stores. - Henry
On Tue, Feb 18, 2014 at 6:07 AM, Kasper Sørensen <[email protected]> wrote: > 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
