Re: [Quickfixj-users] jdbc logging

[Toli K. <to...@ma...>]

Robert,

When i said that the JdbcLog was "fixed", I meant that it stopped
going into the recursive death spiral of printing stacktraces, so that
you get this instead:
> JdbcLog cannot log SQLException due to recursive log errors!

Truth be told, i'm at a loss what your problem may be. i'm not seeing
anything useful in the log. I saw that kind of exception when the QFJ
engine couldn't make the connection to the database: it was either not
running, the tables were not present, the user/password was incorrect,
it didn't have perms to write, etc. In that case, the underlying
proxool cashing code would go crazy, trying to keep creating
connections. But it doesn't look like that's the case with you.

I haven't tried QFJ with Oracle - we don't have it in-house, we use MySQL.
I can't remember if you said that it worked for you with 1.0.3, or if
it was the other problem (app exiting w/out an explicit wait() call).

There are 3 approaches i can suggest:
1. Try something other than Oracle - maybe MySQL. it's fairly easy to
setup, and you can see if it's an Oracle or a general Jdbc problem you
have.

2. The error comes from Proxool - which is a transparent JDBC pooling
framework. If you feel comfortable modifying QFJ, you can check out
the source and try to disable Proxool altogether, but changing the
quickfix.JdbcUtil.getDataSource() function not create a Proxool pool.
Perhaps that'll give you a better error that somehow gets masked by
Proxool.

3. Another thing i may suggest for debugging is for you to download
our Marketcetera OMS and configure it to point to your Oracle database
and see if you get the same problem.
If you don't, then you can perhaps isolate the problem to your app
setup. Otherwise, we are much more likely seeing a bug in QFJ itself,
and then I can work on getting an Oracle setup and trying to reproduce
your setup.
http://trac.marketcetera.org/trac.fcgi/wiki/Marketcetera/OMSInstallation
I'd be happy to walk you through the Marketcetera setup to save you
time if you want. Just let me know.

I realize that all of these suggestions are a lot of work and may be
asking too much. If you can isolate the error to QuickfixJ. then you
can post the SQL create scripts for Oracle database, and we'll try to
reproduce the problem locally.

-- 
Toli Kuznets
http://www.marketcetera.com: Open-Source Trading Platform
download.run.trade.