Re: [Quickfixj-users] jdbc logging

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

Hi Robert,

actually it would be helpful to have some more logging. Therefore, I suggest 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örg

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,
> 
> 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.
> 
> Any further insight?
> 
> Thanks!
> 
> 
> 
> Merlin Securities - #1 Prime Broker North America, #1 Prime Broker Single Strategy Funds, #1 Prime Broker Funds Under $100M - Global Custodian 2007
> 
> 
> 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
> 
> 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 
> related information in your session-specific log or does it not
> get that far? 
> 
>> -----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()
>> = false
>> 2007-04-27 13:38:26,871 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
>> getHoldability() = 1
>> 2007-04-27 13:38:26,871 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
>> getTransactionIsolation() = 2
>> 2007-04-27 13:38:26,886 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
> getTypeMap()
>> = {SYS.XMLTYPE=class oracle.xdb.XMLTypeFactory}
>> 2007-04-27 13:38:26,886 DEBUG [main] proxool.ConnectionResetter
>> (ConnectionResetter.java:168) - Remembering default value:
> getCatalog()
>> = null
>> 2007-04-27 13:38:26,886 INFO  [main] proxool.ConnectionPool
>> (ConnectionPool.java:623) - Proxool statistics legend: "s - r
> (a/t/o)"
>>> s=served, r=refused (only shown if non-zero), a=active, t=total,
>> o=offline (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 = 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 
>> Broker Single Strategy Funds, #1 Prime Broker Funds Under $100M - 
>> Global Custodian 2007
>>
>>
>>  
>>
>> --------------------------------------------------------
>>
>> 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, distribution 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.
>>  
>> Merlin Securities, LLC is a registered broker-dealer. Services 
>> offered through 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 solicitation 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
>>
> 
> ------------------------------------------------------------------------
> -
> 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
>  
> 
> --------------------------------------------------------
> 
> 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, distribution 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.
>  
> Merlin Securities, LLC is a registered broker-dealer. Services offered through 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 solicitation 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

-- 
Joerg Thoennes
http://www.macd.com                 Tel.: +49 (0)241 44597-24
Macdonald Associates GmbH           Geschäftsführer: Roger Macdonald
Lothringer Str. 52, D-52070 Aachen  Amtsgericht Aachen, HRB 8151, Ust.-Id DE813021663