<div dir="ltr"><div class="gmail_default" style="font-size:small;color:#000000">The MessageStore and the FileStore are two completely different components. It should be no problem for you to use one medium for the store and another for the log.</div><div class="gmail_default" style="font-size:small;color:#000000"><br></div><div class="gmail_default" style="font-size:small;color:#000000">However, I'm concerned that you are confusing the message log with the message store.</div><div class="gmail_default" style="font-size:small;color:#000000"><br></div><div class="gmail_default" style="font-size:small;color:#000000">The LogFactory creates two sets of files: the <b>message log</b> and the <b>event log</b>. The <b>message log</b> contains every message sent and received; it is very useful to humans. The <b>event log</b> contains status messages; it is kind of useful to humans sometimes. The engine doesn't care about either log file.</div><div class="gmail_default" style="font-size:small;color:#000000"><br></div><div class="gmail_default" style="font-size:small;color:#000000"><b>The store is something else.</b> It is used internally by the engine to store session state in case of resend requests and such. <b>Humans should ignore it. All other applications should ignore it too. It is only for QF.</b> If you want to use a DB for the store, great, but that is not an invitation for other apps to start messing with it.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 21, 2014 at 3:13 PM, Alberto Honorato <span dir="ltr"><<a href="mailto:honorabetto@gmail.com" target="_blank">honorabetto@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Thanks Olamide and Ruaan, I will try your suggestions, just to clarify, I want to store the messages using the IMessageStoreFactory. I am going to use a log in a file and the messages in a database. Have you seen something similar in your projects?<br><br></div>Thank you. <br></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 21, 2014 at 3:08 PM, Ruaan Viljoen <span dir="ltr"><<a href="mailto:ruaanv@gmail.com" target="_blank">ruaanv@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Alberto,<div><br></div><div>I have a branch on my github that I just pushed some local code I had been testing recently. It's rudimentary and incomplete, but hacked it together along with some PostgreSQL derived classes in a testing environment for some performance tests. Also, it uses SqlConnection instead of OledbConnection, but you should get the gist and strip out and swap the sections you need or extend and override where appropriate.</div><div><br></div><div>I'll be finishing it off in the holiday and adding some unit tests. I'm not sure this fits with the current direction of QuickFix/n master branch currently, especially with the Logging interface discussions going on at the moment, but feel free to use it if it may help.</div><div><br></div><div>Regards,</div><div>Ruaan</div></div><div class="gmail_extra"><span><font color="#888888"><br clear="all"><div><font face="arial, helvetica, sans-serif">Ruaan Viljoen</font><div><br></div></div></font></span><div><div>
<br><div class="gmail_quote">On 18 October 2014 15:59, olamide olatunji <span dir="ltr"><<a href="mailto:krazibit312@gmail.com" target="_blank">krazibit312@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Alberto,<div>Not sure the DB Logging is implemented in QuickFixN yet, but you can by implementing the ILogFactory</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Sat, Oct 18, 2014 at 4:50 PM, Alberto Honorato <span dir="ltr"><<a href="mailto:honorabetto@gmail.com" target="_blank">honorabetto@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><p dir="ltr">Hello,</p>
<p dir="ltr">I am implementing a quickfix connection with .NET. Right now the messages are being saved in a text file, however for my project I need to store them into an sql server database thru ODBC. </p>
<p dir="ltr">I have been searching the web to achieve this, but I wasn't able to find any example. </p>
<p dir="ltr">Could you help me with an example, similar to the code below, that stores the FIX messages into MS SQL Server?</p>
<p dir="ltr">Thanking in advance</p>
<p dir="ltr">Alberto Honorato</p>
<p dir="ltr"><i><b>main</b></i><i><b>method</b></i></p>
<p dir="ltr"><i>QuickFix.SessionSettings</i><i>settings</i><i>= new</i><i>QuickFix.SessionSettings</i><i>(file);</i><br>
<i>TradeClientApp</i><i>application</i><i>= new</i><i>TradeClientApp</i><i>();</i><br>
<i>QuickFix.IMessageStoreFactory</i><i>storeFactory</i><i>= new</i><i>QuickFix.FileStoreFactory</i><i>(</i><i>settings</i><i>);</i><br>
<i>QuickFix.ILogFactory</i><i>logFactory</i><i>= new</i><i>QuickFix.FileLogFactory</i><i>(</i><i>settings</i><i>);</i><br>
<i>QuickFix.Transport.SocketInitiator</i><i>initiator</i><i>= new</i><i>QuickFix.Transport.SocketInitiator</i><i>(</i><i>application</i><i>,</i><i>storeFactory</i><i>,</i><i>settings</i><i>,</i><i>logFactory</i><i>);</i></p>
<p dir="ltr"><i><b>Configuration</b></i><i><b>file</b></i></p>
<p dir="ltr"><i>#</i><i>default</i><i>settings</i><i>for</i><i>sessions</i><br>
<i>[</i><i>DEFAULT</i><i>]</i><br>
<i>FileStorePath</i><i>=</i><i>store</i><br>
<i>FileLogPath</i><i>=</i><i>log</i><br>
<i>ConnectionType</i><i>=</i><i>initiator</i><br>
<i>ReconnectInterval</i><i>=60</i><br>
<i>SenderCompID</i><i>=*****</i></p>
<p dir="ltr"><i>#</i><i>session</i><i>definition</i><br>
<i>[</i><i>SESSION</i><i>]</i><br>
<i>#</i><i>inherit</i><i>FileStorePath</i><i>,</i><i>FileLogPath</i><i>,</i><i>ConnectionType</i><i>,</i><i>ReconnectInterval</i><i>and</i><i>SenderCompID</i><i>from</i><i>default</i><br>
<i>BeginString</i><i>=</i><i>FIX</i><i>.4.4</i><br>
<i>TargetCompID</i><i>=****</i><br>
<i>SenderCompID</i><i>=*****</i><br>
<i>StartTime</i><i>=01:00:00</i><br>
<i>EndTime</i><i>=23:30:00</i><br>
<i>HeartBtInt</i><i>=60</i><br>
<i>SocketConnectPort</i><i>=*******</i><br>
<i>SocketConnectHost</i><i>=********</i><br>
<i>DataDictionary</i><i>=../../</i><i>dictionary</i><i>/FIX44.</i><i>xml</i><br>
<i>FileLogPath</i><i>=../../</i><i>Log</i><i>/</i><i>LogFix.txt</i><br>
<i>FileStorePath</i><i>=../../</i><i>store</i><br></p>
<p dir="ltr">================================================================================================</p>
<blockquote><p dir="ltr"><br>
<b>main</b><b>method</b></p>
<p dir="ltr">QuickFix.SessionSettings settings = new QuickFix.SessionSettings(file);<br>
TradeClientApp application = new TradeClientApp();<br>
QuickFix.IMessageStoreFactory storeFactory = new QuickFix.FileStoreFactory(settings);<br>
QuickFix.ILogFactory logFactory = new QuickFix.FileLogFactory(settings);<br>
QuickFix.Transport.SocketInitiator initiator = new QuickFix.Transport.SocketInitiator(application, storeFactory, settings, logFactory);</p>
<p dir="ltr"><b>Configuration</b><b>file</b></p>
<p dir="ltr"># default settings for sessions<br>
[DEFAULT]<br>
FileStorePath=store<br>
FileLogPath=log<br>
ConnectionType=initiator<br>
ReconnectInterval=60<br>
SenderCompID=*****</p>
<p dir="ltr"># session definition<br>
[SESSION]<br>
# inherit FileStorePath, FileLogPath, ConnectionType, ReconnectInterval and SenderCompID from default<br>
BeginString=FIX.4.4<br>
TargetCompID=****<br>
SenderCompID=*****<br>
StartTime=01:00:00<br>
EndTime=23:30:00<br>
HeartBtInt=60<br>
SocketConnectPort=*******<br>
SocketConnectHost=********<br>
DataDictionary=../../dictionary/FIX44.xml<br>
FileLogPath=../../Log/LogFix.txt<br>
FileStorePath=../../store<br>
</p>
</blockquote>
<br></div></div>_______________________________________________<br>
Quickfixn mailing list<br>
<a href="mailto:Quickfixn@lists.quickfixn.com" target="_blank">Quickfixn@lists.quickfixn.com</a><br>
<a href="http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com" target="_blank">http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>
Quickfixn mailing list<br>
<a href="mailto:Quickfixn@lists.quickfixn.com" target="_blank">Quickfixn@lists.quickfixn.com</a><br>
<a href="http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com" target="_blank">http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com</a><br>
<br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
Quickfixn mailing list<br>
<a href="mailto:Quickfixn@lists.quickfixn.com" target="_blank">Quickfixn@lists.quickfixn.com</a><br>
<a href="http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com" target="_blank">http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Quickfixn mailing list<br>
<a href="mailto:Quickfixn@lists.quickfixn.com">Quickfixn@lists.quickfixn.com</a><br>
<a href="http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com" target="_blank">http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div><font><span style="background-color:#000000"><span style="background-color:#ffffff">Grant Birchmeier</span></span></font><font><font color="#3333ff"><br></font></font></div><div><font><b><font color="#3333ff"><span style="background-color:#ffcc33"><span style="background-color:#ffcc66"><span style="background-color:#ffcc99"><span style="background-color:#ffffff"><span style="background-color:#ffcc00">Connamara Systems, LLC</span></span></span></span></span></font></b></font><br></div><div><font><b>Made-To-Measure Trading Solutions.</b></font></div><div><font>Exactly what you need. No more. No less.</font><font><b><font color="#3333ff"><br></font></b></font></div><div><font><a href="http://connamara.com" target="_blank">http://connamara.com</a><br></font></div>
</div>