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

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

Hi Ajay,

thanks for this, I totally forgot that it is quite simple to override the built-in Jdbc stuff. Been 
using FileStore most of the time...

Cheers,
Chris.


On 22.02.21 17:05, Ajay Patwardhan wrote:
> Yes Chris
> we use c3p0. https://www.mchange.com/projects/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... <mailto:ap...@en...>
>
>
> On Mon, Feb 22, 2021 at 5:25 AM Christoph John via Quickfixj-users 
> <qui...@li... <mailto: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/ <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
>     <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... <mailto:chr...@ma...>
>
>     MACD GmbH
>     Oppenhoffallee 103
>     52066 Aachen, Germany
>     www.macd.com <http://www.macd.com>
>
>     Amtsgericht Aachen: HRB 8151
>     Ust.-Id: DE 813021663
>     Geschäftsführer: George Macdonald
>
>
>
>     _______________________________________________
>     Quickfixj-users mailing list
>     Qui...@li... <mailto:Qui...@li...>
>     https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>     <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. 

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