Re: [Quickfix-developers] Using ODBC with SQLServer

[Bill R. <rob...@ra...>]

Messages_Log is maintained by the Log class.

To achieve what you want, you need to adapt the Log class and rewrite
the three methods mentioned below. 

QF itself fills the database fields according to the session, which
simplifies searches.

Regards, 
Rob

> -----Original Message-----
> From: Nil...@co... 
> [mailto:Nil...@co...] 
> Sent: Monday, March 10, 2008 10:29 AM
> To: Bill Robert
> Cc: qui...@li...
> Subject: RE: [Quickfix-developers] Using ODBC with SQLServer
> 
> 
> Thanks Bill
> 
> I agree and understand that 'message' table only logs the 
> outgoing messages and not incoming. However, my concerns is 
> about message_log'
> table and not 'message'. The 'message_log' table logs all 
> messages getting in and out from QF. The concern is the data 
> in 'sendercompid'
> and 'targetcompid', doesn't match with the FIX message stored 
> in text column.
> 
> 
> id	time	beginstring	sendercompid	targetcompid
> session_qualifier text
> 					
> 
> 764	03/10/ 2008 8:58:12 AM	FIX.4.2	WACH	Regression_QA	NULL
> 8=FIX.4.2
9=123
35=j
34=10
49=Regression_QA
52=20080310-08:58:
> 12.204
56=
> WACH
45=7
58=Conditionally Required Field Missing 
> (11)
372=8
380=5
10=207

> 
> Please see the tag value of 49 and 56, it is reverse of what 
> is displayed under sendcompid and targetcompid.
> 
> 
> Thanks
> -Nilesh
> 
> >-----Original Message-----
> >From: Bill Robert [mailto:rob...@ra...]
> >Sent: Monday, March 10, 2008 1:45 PM
> >To: Gajjar, Nilesh (Cognizant)
> >Subject: RE: [Quickfix-developers] Using ODBC with SQLServer
> >
> >In the Log class are these three functions:
> >
> >  void onIncoming( const std::string& value )  void 
> onOutgoing( const 
> > std::string& value )  void onEvent( const std::string& value )
> >
> >Pls refer to Log.h (ScreenLog) for an example.
> >
> >The message table contains only outgoing messages. Inbound messages
> need
> >to be stored by your application.
> >
> >Regards,
> >Rob
> >
> >
> >> -----Original Message-----
> >> From: qui...@li...
> >> [mailto:qui...@li...] 
> On Behalf 
> >> Of Nil...@co...
> >> Sent: Monday, March 10, 2008 8:52 AM
> >> To: or...@qu...
> >> Cc: qui...@li...
> >> Subject: Re: [Quickfix-developers] Using ODBC with SQLServer
> >>
> >> QuickFIX Documentation:
> >> http://www.quickfixengine.org/quickfix/doc/html/index.html
> >> QuickFIX Support: http://www.quickfixengine.org/services.html
> >>
> >>
> >>
> >> Thanks Oren for the reply.
> >>
> >> I don't understand what do you mean by the direction 
> field, I don't 
> >> see such fields in message_log or message table.
> >>
> >> I see that the sender-compid and target-compid mentioned in the 
> >> message (logged in text coloumn), doesn't match with the 
> id stored in 
> >> 'sendcompid' and 'targetcompid' column. Isn't this strange?
> >>
> >> Thanks
> >> -Nilesh
> >>
> >>
> >> The sender and target comp ids are merely identifiers for 
> the session 
> >> they do not belong to.  The direction field is what is used to 
> >> indicate direction.  They only time you will see different 
> values is 
> >> if there are messages on multiple sessions.
> >>
> >>
> >> --oren
> >>
> >>
> >> On Mar 6, 2008, at 2:41 AM, <Nil...@co...> wrote:
> >>
> >>
> >> QuickFIX Documentation:
> >> http://www.quickfixengine.org/quickfix/doc/html/index.html
> >> QuickFIX Support: http://www.quickfixengine.org/services.html
> >>
> >>
> >> Hi
> >>
> >> I am using ODBC with SQL Server for logging purpose. I 
> have observed 
> >> some strange behavior, not sure if this is bug in QF. I am 
> using QF 
> >> 1.12.4.
> >>
> >> I assume that "message_log" table stores all incoming and outgoing 
> >> messages. In my case it doing this job perfectly fine, no issues 
> >> there.
> >>
> >> Assume that the server comp-id is "SERVER" and client comp-id is 
> >> "CLIENT".
> >>
> >> What I see in "message_log" table is the sendercompid and 
> >> targetcompid is always "SERVER" and "CLIENT" respectively.
> >> Irrespective of the incoming or outgoing message.
> >>
> >> Any idea what is going on here...
> >>
> >> Thanks & Regards
> >> -Nilesh
> >>
> >>
> >> >-----Original Message-----
> >> >From: qui...@li...
> >> [mailto:quickfix-
> >> >dev...@li...] On Behalf Of Oren Miller
> >> >Sent: Saturday, March 08, 2008 2:05 AM
> >> >To: Gajjar, Nilesh (Cognizant)
> >> >Cc: qui...@li...
> >> >Subject: Re: [Quickfix-developers] Using ODBC with SQLServer
> >> >
> >> >QuickFIX Documentation:
> >> >http://www.quickfixengine.org/quickfix/doc/html/index.html
> >> >QuickFIX Support: http://www.quickfixengine.org/services.html
> >>
> >>
> >> This e-mail and any files transmitted with it are for the 
> sole use of 
> >> the intended recipient(s) and may contain confidential and 
> privileged 
> >> information.
> >> If you are not the intended recipient, please contact the 
> sender by 
> >> reply e-mail and destroy all copies of the original
> message.
> >> Any unauthorised review, use, disclosure, dissemination, 
> forwarding, 
> >> printing or copying of this email or any action taken in 
> reliance on 
> >> this e-mail is strictly prohibited and may be unlawful.
> >>
> >> --------------------------------------------------------------
> >> -----------
> >> This SF.net email is sponsored by: Microsoft Defy all challenges. 
> >> Microsoft(R) Visual Studio 2008.
> >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >> _______________________________________________
> >> Quickfix-developers mailing list
> >> Qui...@li...
> >> https://lists.sourceforge.net/lists/listinfo/quickfix-developers
> >>
> 
> This e-mail and any files transmitted with it are for the 
> sole use of the intended recipient(s) and may contain 
> confidential and privileged information.
> If you are not the intended recipient, please contact the 
> sender by reply e-mail and destroy all copies of the original message.
> 
> Any unauthorised review, use, disclosure, dissemination, 
> forwarding, printing or copying of this email or any action 
> taken in reliance on this e-mail is strictly
> 
> prohibited and may be unlawful.
>