metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Henry Saputra <henry.sapu...@gmail.com>
Subject Re: Pooling of connections in JdbcCompiledQuery
Date Tue, 18 Feb 2014 19:03:39 GMT
+1 this is definitely useful and necessary for JDBC based stores.

- Henry

On Tue, Feb 18, 2014 at 6:07 AM, Kasper Sørensen
<i.am.kasper.sorensen@gmail.com> 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

Mime
View raw message