Re: [Quickfixj-users] jdbc logging

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

Robert,

The message about exceeding the connection "throttling" limit is
very strange. This is an internal Proxool message. The Proxool 
throttle limit default is 10, but the message indicates it is
0 for some reason. It's a configurable parameter, but I don't
modify it. I have no idea how it would be set to 0 and nobody
else has reported a similar problem. I also can't imagine how 
it would be related to Oracle specifically.

Steve

> -----Original Message-----
> From: qui...@li...
> [mailto:qui...@li...]On Behalf Of
> Robert Brueckmann
> Sent: Wednesday, May 02, 2007 1:35 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/
> Toli,
> 
> You said in your message below that the recursive error was repaired in
> 1.1.0 but I cannot for the life of me get the JDBC logging to work
> against an Oracle database.
> 
> Is anyone out there successfully running JDBC logging against an Oracle
> database?
> 
> I tried with the included proxool-0.9.0RC2.jar and I even got the latest
> version proxool-0.9.0RC3.jar and tried it with those as well. The engine
> fires up and this is what I see and then the engine just hangs:
> 
> running FIX engine...
> beginning initiator...
> 2007-05-02 13:24:08,821 DEBUG [main] proxool.ShutdownHook
> (ShutdownHook.java:73) - Registered shutdownHook
> 2007-05-02 13:24:08,836 DEBUG [main] proxool.HouseKeeperController
> (HouseKeeperController.java:84) - Registering 'quickfixj-1' house keeper
> 2007-05-02 13:24:08,836 DEBUG [main] proxool.HouseKeeperController
> (HouseKeeperController.java:92) - Starting a house keeper thread
> 2007-05-02 13:24:08,915 DEBUG [main] proxool.ConnectionResetter
> (ConnectionResetter.java:168) - Remembering default value: isReadOnly()
> = false
> 2007-05-02 13:24:08,930 DEBUG [main] proxool.ConnectionResetter
> (ConnectionResetter.java:168) - Remembering default value:
> getHoldability() = 1
> 2007-05-02 13:24:08,930 DEBUG [main] proxool.ConnectionResetter
> (ConnectionResetter.java:168) - Remembering default value:
> getTransactionIsolation() = 2
> 2007-05-02 13:24:08,946 DEBUG [main] proxool.ConnectionResetter
> (ConnectionResetter.java:168) - Remembering default value: getTypeMap()
> = {SYS.XMLTYPE=class oracle.xdb.XMLTypeFactory}
> 2007-05-02 13:24:08,946 DEBUG [main] proxool.ConnectionResetter
> (ConnectionResetter.java:168) - Remembering default value: getCatalog()
> = null
> 2007-05-02 13:24:08,946 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-05-02 13:24:08,946 DEBUG [main] proxool.Prototyper
> (Prototyper.java:204) - 000000 (01/01/00) - Connection #1 created on
> demand = ACTIVE
> 2007-05-02 13:24:09,086 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface java.sql.Connection
> 2007-05-02 13:24:09,102 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.jdbc.internal.OracleConnection
> 2007-05-02 13:24:09,102 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface oracle.sql.ClobDBAccess
> 2007-05-02 13:24:09,102 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.jdbc.OracleConnection
> 2007-05-02 13:24:09,102 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface oracle.sql.BlobDBAccess
> 2007-05-02 13:24:09,102 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.sql.BfileDBAccess
> 2007-05-02 13:24:09,102 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.jdbc.internal.ClientDataSupport
> 2007-05-02 13:24:09,680 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> java.sql.PreparedStatement
> 2007-05-02 13:24:09,680 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface java.sql.Statement
> 2007-05-02 13:24:09,696 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.jdbc.internal.OraclePreparedStatement
> 2007-05-02 13:24:09,696 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.jdbc.OraclePreparedStatement
> 2007-05-02 13:24:09,696 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.jdbc.internal.OracleStatement
> 2007-05-02 13:24:09,696 DEBUG [main] proxool.ProxyFactory
> (ProxyFactory.java:171) - Implementing interface
> oracle.jdbc.OracleStatement
> May 2, 2007 1:24:13 PM quickfix.mina.initiator.InitiatorIoHandler
> sessionCreated
> INFO: MINA session created: /10.68.5.33:4593
> JdbcLog cannot log SQLException due to recursive log errors!
> java.sql.SQLException: We are already in the process of making 1
> connections and the number of simultaneous builds has been throttled to
> 0
> 	at
> org.logicalcobwebs.proxool.Prototyper.checkSimultaneousBuildThrottle(Pro
> totyper.java:260)
> 	at
> org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.j
> ava:170)
> 	at
> org.logicalcobwebs.proxool.ProxoolDataSource.getConnection(ProxoolDataSo
> urce.java:97)
> 	at quickfix.JdbcLog.insert(JdbcLog.java:79)
> 	at quickfix.JdbcLog.onEvent(JdbcLog.java:51)
> 	at quickfix.Session.next(Session.java:1247)
> 	at
> quickfix.mina.SessionConnector$SessionTimerTask.run(SessionConnector.jav
> a:222)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter
> .call(Executors.java:431)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.runAndReset(Fu
> tureTask.java:198)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.ScheduledThreadPoolExecut
> or$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:189)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.ScheduledThreadPoolExecut
> or$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:213)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker
> .runTask(ThreadPoolExecutor.java:650)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker
> .run(ThreadPoolExecutor.java:675)
> 	at java.lang.Thread.run(Thread.java:534)
> 2007-05-02 13:24:15,008 DEBUG [SocketConnectorIoProcessor-0.0]
> proxool.Prototyper (Prototyper.java:204) - 000007 (01/02/00) -
> Connection #2 created on demand = ACTIVE
> 2007-05-02 13:24:15,118 DEBUG [QF/J Session dispatcher:
> FIX.4.2:MERL_DROP->NEOV] fix.Application (Application.java:198) -
> logging off...
> May 2, 2007 1:24:43 PM quickfix.mina.initiator.InitiatorIoHandler
> sessionCreated
> INFO: MINA session created: /10.68.5.33:4600
> 2007-05-02 13:24:45,024 DEBUG [QF/J Session dispatcher:
> FIX.4.2:MERL_DROP->NEOV] fix.Application (Application.java:198) -
> logging off...
> May 2, 2007 1:25:14 PM quickfix.mina.initiator.InitiatorIoHandler
> sessionCreated
> INFO: MINA session created: /10.68.5.33:4613
> 
> 
> 
> 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 Toli
> Kuznets
> Sent: Monday, April 30, 2007 11:58 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/
> Robert,
> 
> I believe i know what the problem may be. in QFJ 1.1.0 we fixed a bug
> where an error connecting to the Jdbc store caused teh JdbcLog to go
> into an infinite recursion and print out the log below:
> > java.sql.SQLException: We are already in the process of making 1
> connections and the number of simultaneous builds has been throttled to
> 0
> 
> essentially, it catch an exception making the first db entry, then
> would try to log the exception, and never stop. you get the idea.
> 
> > I'm still baffled though why my FileStoreFactory code (no JDBC
> logging) will not work with the 1.1.0 libraries though...
> 
> in that case, you are not dealing with JdbcLog so everything worked
> fine - your system worked correctly and the above situation didn't
> happen.
> 
> If you look at the output of QFJ 1.1, you should see somewhere a line
> saying something about encountering a "write to Jdbc" failure and
> quitting the JdbcLog.
> 
> Still not sure why your app will quit completely in case of a JdbcLog
> failure - it should just not log, but the app itself should keep
> working.
> 
> So see if your database is setup correctly, make sure you can log on
> to it with the credentials supplied in the SessionSettings, etc.
> 
> Also, if you can, try to run it in the debugger and trap all
> Errors/Exceptions, maybe for some reason JdbcLog throws some error
> that kills your entire app?
> 
> ------------------------------------------------------------------------
> -
> 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
> 