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

[Colin D. <co...@ma...>]

Not sure if this helps, exactly, but, we replaced the JDBC message store 
with a Hibernate-based one that's fronted by the in-memory message store.

It's fundamentally Spring-based, so allows you to swap in your own pool. 
We've used Hikari and C3P0 successfully.

Here are the pieces:

https://github.com/Marketcetera/marketcetera/blob/master/fix/fix-core/src/main/java/org/marketcetera/fix/store/


On 2/22/21 3:24 AM, Christoph John via Quickfixj-users wrote:
> QuickFIX/J Documentation: 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.
>
-- 
Colin DuPlantis
Chief Architect, Marketcetera
Download, Run, Trade
888.868.4884
https://www.marketcetera.com