Re: [Quickfixj-users] jdbc logging

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

To clarify, in my first paragraph I typed the wrong versions of the min and=
 slfj libraries...I'm definitely using the min and slfj libraries that come=
 with the 1.1.0 qfj download...and when I reverted to qfj-1.0.3, I reverted=
 the min and slfj libraries as well...I was very careful about this...

Thanks!
=20
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, #1 Prime Broker Single S=
trategy Funds, #1 Prime Broker Funds Under $100M - Global Custodian 2007

From: qui...@li... [mailto:quickfixj-users=
-bo...@li...] On Behalf Of Robert Brueckmann
Sent: Monday, April 30, 2007 11:26 AM
To: qui...@li...
Subject: Re: [Quickfixj-users] jdbc logging

QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/
J=F6rg,

Ok...oddest thing...when I switched to JdbcLogging, I also simultaneously u=
pgraded my QuickFix/j library from 1.0.3 to 1.1.0.  So with the 1.1.0 libra=
ries (including min-0.9.3 and slf4j-1.0.1), I am having the problems I illu=
strated in my previous emails...so I reverted my code to use:

MessageStoreFactory messageStoreFactory =3D new FileStoreFactory(settings);
LogFactory logFactory =3D new ScreenLogFactory(true, true, true, true);

Fired it up...same behavior...the runtime just exits.

So then I left my code in it's original state and reverted the libraries ba=
ck to quickfixj-1.0.3 (and reverted to min-0.9.3 and slf4j-1.0.1 as well), =
fired up my code...same code, came config file)...engine is up and running =
fine...heart beats every 30 seconds, not a problem.

So then I left the 1.0.3 libraries in place and used your suggestion of the=
 CompositeLogFactory:

MessageStoreFactory messageStoreFactory =3D new JdbcStoreFactory(settings);
LogFactory[] logFactories =3D {new JdbcLogFactory(settings),
            		new ScreenLogFactory(true, true, true, true)};
LogFactory logFactory =3D new CompositeLogFactory(logFactories);

Magically fires up without a hitch...logging to database and screen...no pr=
oblems.

Same code, same config files but the 1.1.0 libraries...engine just dies.  I=
 looked at the Banzai example that came with the 1.1.0 src download to see =
if my Initiator class is missing something that 1.1.0 needs that 1.0.3 wasn=
't doing...or that I personally was doing something crazy, likewise with my=
 custom Application class...both are plain vanilla...the only custom thing =
we're doing in the Application class is creating a connection to an Oracle =
queue in the init() method triggered in the main class of the Initiator and=
 then simply passing the xml-converted FIX messages to the Oracle queue...w=
orks with qfj-1.0.3...not so much with 1.1.0...I even tried 1.0.5 and those=
 don't work either.

Can you think of anything that I might be doing that could cause these libr=
aries to not be backwards compatible with my code?

Thanks for any help!

Rob

Merlin Securities - #1 Prime Broker North America, #1 Prime Broker Single S=
trategy Funds, #1 Prime Broker Funds Under $100M - Global Custodian 2007

From: qui...@li... [mailto:quickfixj-users=
-bo...@li...] On Behalf Of Joerg Thoennes
Sent: Monday, April 30, 2007 10:34 AM
To: qui...@li...
Subject: Re: [Quickfixj-users] jdbc logging

QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/
Hi Robert,

actually it would be helpful to have some more logging. Therefore, I sugges=
t to use the
CompositeLogFactory to log *both* to the file (which works as you say) and =
to the JDBC.

Would be good to see all the logging output in one file. Do you use log4j?
Then put the appropriate slf* jar in your CLASSPATH.

Cheers, J=F6rg

On 04/30/07 15:48, Robert Brueckmann wrote:
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
> Hi Steve,
>=20
> In the 'sessions' table a record is inserted with the seq numbers, begin
> string, comp and target ids, etc (session_qualifier is NULL)...then
> immediately afterwards, the 'event_log' table gets 3 messages inserted
> (session_qualifier is NULL here as well) and the 3 text messages of the
> 3 records indicate the session information with the start and end times,
> then a message claiming the session was created, then the final message
> explaining the valid order types.  Then the engine quietly shuts down as
> you see in the log I pasted below.  There are NO System.exit()s anywhere
> in my code...the only way this code can exit is by someone hitting
> ctrl+c on the command-line...there's no programmatic exiting in my
> code...and being the log below gives no explanation...and if I switch
> back to the standard file-based logging, this works fine and the engine
> starts processing incoming messages, I'm a little perplexed.
>=20
> Any further insight?
>=20
> Thanks!
>=20
>=20
>=20
> Merlin Securities - #1 Prime Broker North America, #1 Prime Broker Single=
 Strategy Funds, #1 Prime Broker Funds Under $100M - Global Custodian 2007
>=20
>=20
> From: qui...@li...
> [mailto:qui...@li...] On Behalf Of
> Steve Bate
> Sent: Friday, April 27, 2007 4:43 PM
> To: qui...@li...
> Subject: Re: [Quickfixj-users] jdbc logging
>=20
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
> This looks like something is either calling System.exit() or
> the main function is exiting. I'd look there first. Is there any=20
> related information in your session-specific log or does it not
> get that far?=20
>=20
>> -----Original Message-----
>> From: qui...@li...
>> [mailto:qui...@li...]On Behalf Of
>> Robert Brueckmann
>> Sent: Friday, April 27, 2007 1:45 PM
>> To: qui...@li...
>> Subject: Re: [Quickfixj-users] jdbc logging
>>
>>
>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
>> QuickFIX/J Support: http://www.quickfixj.org/support/
>> We've removed the NOT NULL constraint (kind of weird since this olumn
> is
>> part of the primary key and by oracle standards a column in the
> primary
>> key can't be not null so we had to remove that constraint as well...so
>> we removed these constraints and fired it up...no exceptions now but
> now
>> the engine starts up...logs a few messages to the screen which I'll
>> paste below and then immediately shuts down with no exception or
> message
>> of why it's immediately shutting down.
>>
>> Any thoughts?!?
>>
>> Here's the console output:
>>
>> 2007-04-27 13:38:24,215 DEBUG [main] proxool.ShutdownHook
>> (ShutdownHook.java:73) - Registered shutdownHook
>> 2007-04-27 13:38:24,230 DEBUG [main] proxool.HouseKeeperController
>> (HouseKeeperController.java:84) - Registering 'quickfixj-1' house
> keeper
>> 2007-04-27 13:38:24,230 DEBUG [main] proxool.HouseKeeperController
>> (HouseKeeperController.java:92) - Starting a house keeper thread
>> 2007-04-27 13:38:26,855 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
> isReadOnly()
>> =3D false
>> 2007-04-27 13:38:26,871 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
>> getHoldability() =3D 1
>> 2007-04-27 13:38:26,871 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
>> getTransactionIsolation() =3D 2
>> 2007-04-27 13:38:26,886 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
> getTypeMap()
>> =3D {SYS.XMLTYPE=3Dclass oracle.xdb.XMLTypeFactory}
>> 2007-04-27 13:38:26,886 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
> getCatalog()
>> =3D null
>> 2007-04-27 13:38:26,886 INFO  [main] proxool.ConnectionPool
>> (ConnectionPool.java:623) - Proxool statistics legend: "s - r
> (a/t/o)"
>>> s=3Dserved, r=3Drefused (only shown if non-zero), a=3Dactive, t=3Dtotal,
>> o=3Doffline (being tested)
>> 2007-04-27 13:38:26,886 DEBUG [main] proxool.Prototyper
>> (Prototyper.java:204) - 000000 (01/01/00) - Connection #1 created on
>> demand =3D ACTIVE
>> 2007-04-27 13:38:27,074 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.jdbc.internal.ClientDataSupport
>> 2007-04-27 13:38:27,089 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.jdbc.OracleConnection
>> 2007-04-27 13:38:27,089 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.jdbc.internal.OracleConnection
>> 2007-04-27 13:38:27,089 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface java.sql.Connection
>> 2007-04-27 13:38:27,089 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
> oracle.sql.ClobDBAccess
>> 2007-04-27 13:38:27,089 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
> oracle.sql.BlobDBAccess
>> 2007-04-27 13:38:27,089 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.sql.BfileDBAccess
>> 2007-04-27 13:38:27,855 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface java.sql.Statement
>> 2007-04-27 13:38:27,855 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.jdbc.OracleStatement
>> 2007-04-27 13:38:27,855 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.jdbc.OraclePreparedStatement
>> 2007-04-27 13:38:27,855 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> java.sql.PreparedStatement
>> 2007-04-27 13:38:27,855 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.jdbc.internal.OraclePreparedStatement
>> 2007-04-27 13:38:27,855 DEBUG [main] proxool.ProxyFactory
>> (ProxyFactory.java:209) - Implementing interface
>> oracle.jdbc.internal.OracleStatement
>> 2007-04-27 13:38:28,574 DEBUG [ShutdownHook] proxool.ShutdownHook
>> (ShutdownHook.java:93) - Running ShutdownHook
>> 2007-04-27 13:38:28,574 INFO  [Shutdown Hook] proxool.ConnectionPool
>> (ConnectionPool.java:490) - Shutting down 'quickfixj-1' pool
> immediately
>> [Shutdown Hook]
>> 2007-04-27 13:38:28,589 DEBUG [Shutdown Hook] proxool.ConnectionPool
>> (ConnectionPool.java:447) - 000004 (00/00/00) - #0001 removed because
> of
>> shutdown.
>> 2007-04-27 13:38:28,589 DEBUG [Shutdown Hook] proxool.ConnectionPool
>> (ConnectionPool.java:553) - Connection #1 closed
>> 2007-04-27 13:38:28,589 INFO  [Shutdown Hook] proxool.ConnectionPool
>> (ConnectionPool.java:570) - 'quickfixj-1' pool has been closed down by
>> Shutdown Hook in 15 milliseconds.
>> 2007-04-27 13:38:28,589 INFO  [Shutdown Hook]
>> proxool.PrototyperController (PrototyperController.java:100) -
> Stopping
>> Prototyper thread
>> 2007-04-27 13:38:28,589 INFO  [Shutdown Hook]
>> proxool.HouseKeeperController (HouseKeeperController.java:107) -
>> Stopping HouseKeeper thread
>>
>> Merlin Securities - #1 Prime Broker North America, #1 Prime=20
>> Broker Single Strategy Funds, #1 Prime Broker Funds Under $100M -=20
>> Global Custodian 2007
>>
>>
>>=20=20
>>
>> --------------------------------------------------------
>>
>> This message contains information from Merlin Securities, LLC, or=20
>> from one of its affiliates, that may be confidential and=20
>> privileged. If you are not an intended recipient, please refrain=20
>> from any disclosure, copying, distribution or use of this=20
>> information and note that such actions are prohibited. If you=20
>> have received this transmission in error, please notify the=20
>> sender immediately by telephone or by replying to this transmission.
>>=20=20
>> Merlin Securities, LLC is a registered broker-dealer. Services=20
>> offered through Merlin Securities, LLC are not insured by the=20
>> FDIC or any other Federal Government Agency, are not deposits of=20
>> or guaranteed by Merlin Securities, LLC and may lose value.=20
>> Nothing in this communication shall constitute a solicitation or=20
>> recommendation to buy or sell a particular security.
>>
>>
>>
>>
> ------------------------------------------------------------------------
> -
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> Quickfixj-users mailing list
>> Qui...@li...
>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>>
>=20
> ------------------------------------------------------------------------
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Quickfixj-users mailing list
> Qui...@li...
> https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>=20=20
>=20
> --------------------------------------------------------
>=20
> This message contains information from Merlin Securities, LLC, or from on=
e of its affiliates, that may be confidential and privileged. If you are no=
t an intended recipient, please refrain from any disclosure, copying, distr=
ibution or use of this information and note that such actions are prohibite=
d. If you have received this transmission in error, please notify the sende=
r immediately by telephone or by replying to this transmission.
>=20=20
> Merlin Securities, LLC is a registered broker-dealer. Services offered th=
rough Merlin Securities, LLC are not insured by the FDIC or any other Feder=
al Government Agency, are not deposits of or guaranteed by Merlin Securitie=
s, LLC and may lose value. Nothing in this communication shall constitute a=
 solicitation or recommendation to buy or sell a particular security.
>=20
>=20
>=20
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Quickfixj-users mailing list
> Qui...@li...
> https://lists.sourceforge.net/lists/listinfo/quickfixj-users

--=20
Joerg Thoennes
http://www.macd.com                 Tel.: +49 (0)241 44597-24
Macdonald Associates GmbH           Gesch=E4ftsf=FChrer: Roger Macdonald
Lothringer Str. 52, D-52070 Aachen  Amtsgericht Aachen, HRB 8151, Ust.-Id D=
E813021663

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Quickfixj-users mailing list
Qui...@li...
https://lists.sourceforge.net/lists/listinfo/quickfixj-users
=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.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Quickfixj-users mailing list
Qui...@li...
https://lists.sourceforge.net/lists/listinfo/quickfixj-users
=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.