[Quickfixj-users] acceptor

[Robert B. <rbr...@me...>]

Hey guys,

When we fire up our acceptor (we're using JDBC logging), it logs an
entry in the sessions table and continues to log to the other 3 tables
throughout the day, but NEVER comes back to the session table to
increment the sequence numbers.  It's internally keeping tally of the
sequence numbers, which kind of sucks because if something happens and
our acceptor instance goes down, our vendor needs to resend the entire
days' worth of messages because even if we manually update the session
entry in the sessions table with the correct sequence numbers, it
refuses to read that entry, creates a new entry and starts from 1, 1.

I just figured out what the problem is but I don't know how to fix it
without modifying the source code and rebuilding the jar file, which I
was hoping to not have to do because then that becomes a maintenance
nightmare whenever a new release of the quickfix libraries is released
and we'd like to upgrade.

The issue is we're using an oracle database and with an acceptor you're
not allowed to use a session qualifier for whatever reason and I'm
guessing somehow the initial creation of the session entry works but any
subsequent update to the table fails because the session qualifier is
null.  I haven't looked into the code but I remember that JDBC logging
against an Oracle db is a problem if you don't provide a session
qualifier.  This is all working fine and good for our initiators, but
the acceptor doesn't not update the sessions table at all...all other
tables get inserted to just fine.  I guess I could modify the source
code in the interim but I was hoping we could put in for a fix in a
future release for this or get an explanation as to why session
qualifiers don't work for acceptors?

Thanks!

robert l. brueckmann
vice president
merlin securities
712 fifth avenue
new york, ny 10019
p: 212.822.4821
f: 212.822.4820

Merlin Securities - #1 Prime Broker North America and #1 Prime Broker Singl=
e Strategy Funds - Global Custodian 2007
#1 Prime Broker for Hedge Funds under $1 Billion - Alpha Survey 2007



=20

--------------------------------------------------------

This message contains information from Merlin Securities, LLC, or from one =
of its affiliates, that may be confidential and privileged. If you are not =
an intended recipient, please refrain from any disclosure, copying, distrib=
ution or use of this information and note that such actions are prohibited.=
 If you have received this transmission in error, please notify the sender =
immediately by telephone or by replying to this transmission.
=20
Merlin Securities, LLC is a registered broker-dealer. Services offered thro=
ugh Merlin Securities, LLC are not insured by the FDIC or any other Federal=
 Government Agency, are not deposits of or guaranteed by Merlin Securities,=
 LLC and may lose value. Nothing in this communication shall constitute a s=
olicitation or recommendation to buy or sell a particular security.