Re: [Quickfixj-users] JDBC MessageStore with several number of sessions / connection pooling library

[Ajay P. <ap...@en...>]

Yes Chris
we use c3p0. https://www.mchange.com/projects/c3p0/
We configure it in our code and manually set it into the factories where we
need it
((JdbcStoreFactory)storeFactory).setDataSource(ourDatasource);
((JdbcLogFactory)jdbcLogFactory).setDataSource(ourDatasource);

We manually run over 500 sessions spread across about 10 processes in prod
between staging and dropcopy connections and have had no issues.


Ajay Patwardhan
Enfusion LLC
125 South Clark Street, Suite 750, Chicago, IL 60603
Main  : 312-253-9800
Direct: 312-253-7659
Fax   : 312-253-9888
email : ap...@en...


On Mon, Feb 22, 2021 at 5:25 AM Christoph John via Quickfixj-users <
qui...@li...> wrote:

> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support:
> http://www.quickfixj.org/support/
>
>
> Hi,
>
> does anyone have the JDBC MessageStore in use with a larger number of
> sessions? Let's say 50+ sessions?
> I currently struggle to use it because the connection pooling lib Proxool
> (which QFJ uses) is not
> maintained anymore and if I ran into issues then probably there would be
> no bug fixes.
>
> Probably it would be not such a big deal to replace it with something
> better, e.g. HikariCP...?
> Did someone already replace Proxool with something different?
>
> Feedback is highly appreciated.
>
> There also is https://github.com/quickfix-j/quickfixj/discussions/373 if
> you want to leave comments
> on Github.
>
> Thanks,
> Chris.
>
> --
> Christoph John
> Software Engineering
> T +49 241 557080-28
> chr...@ma...
>
> MACD GmbH
> Oppenhoffallee 103
> 52066 Aachen, Germany
> www.macd.com
>
> Amtsgericht Aachen: HRB 8151
> Ust.-Id: DE 813021663
> Geschäftsführer: George Macdonald
>
>
>
> _______________________________________________
> Quickfixj-users mailing list
> Qui...@li...
> https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>

-- 
 
<https://www.linkedin.com/uas/login?session_redirect=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fenfusion-systems-llc%2Fmycompany> 
 <https://twitter.com/enfusion>
Agility-on-demand. What is it as applied to 
middle and back office operations, when do you need it, and how can you get 
it? Read more here 
<https://www.enfusion.com/how-agile-is-your-asset-management-team/> and 
follow us for future insights.