Re: [Quickfixj-users] jdbc logging

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

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()
=3D false
2007-05-02 13:24:08,930 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value:
getHoldability() =3D 1
2007-05-02 13:24:08,930 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value:
getTransactionIsolation() =3D 2
2007-05-02 13:24:08,946 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value: getTypeMap()
=3D {SYS.XMLTYPE=3Dclass oracle.xdb.XMLTypeFactory}
2007-05-02 13:24:08,946 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value: getCatalog()
=3D null
2007-05-02 13:24:08,946 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-05-02 13:24:08,946 DEBUG [main] proxool.Prototyper
(Prototyper.java:204) - 000000 (01/01/00) - Connection #1 created on
demand =3D 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 =3D 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 S=
trategy 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
=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.