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

[Christoph J. <chr...@ma...>]

Hi Colin,

thanks for sharing this, it was interesting to see how you implemented the store.

Cheers,
Chris.

On 22.02.21 17:24, Colin DuPlantis wrote:
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
>
>
> 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.
>>

-- 
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