|
From: Jeff S. <jsc...@cq...> - 2007-08-15 20:03:19
|
I did not have those config settings in use, and the defaul is N, so I don't think that is it. I have added them with a value of N. I am currently using mysql-connector-java-3.1.10-bin.jar. I see that they are up to 3.1.14 and 5.0.7 in a separate path. Which would you recommend I use? Thanks, Jeff Toli Kuznets wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > Jeff, > > Looks like you DB connection maybe is getting closed when you get a > disconnect/logout message? > > Do you have ResetOnLogout/ResetOnDisconnect set to Y? maybe you can > try setting them to N if they are to see what happens, perhaps it'll > prevent the Jdbc connection from being closed. > > I found this link on the MySQL forum, it may be helpful (but it's hard > to say w/out knowing exactly which version of MySQL db/driver you are > using): > http://forums.mysql.com/read.php?39,44706,44751#msg-44751 > > > > On 8/15/07, Jeff Schwartz <jsc...@cq...> wrote: > >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J Support: http://www.quickfixj.org/support/ >> here is my config file: >> [default] >> BeginString=FIX.4.2 >> ConnectionType=initiator >> JdbcDriver=com.mysql.jdbc.Driver >> JdbcURL=jdbc:mysql://db/quickfixdev >> JdbcUser=root >> JdbcPassword=password >> JdbcLogHeartBeats=N >> >> [session] >> SenderCompID=sim.cqig.com >> TargetCompID=sim.calyonfinancial.com >> SocketConnectHost=128.128.128.128 >> SocketConnectPort=9999 >> StartTime=06:00:00 >> EndTime=21:30:00 >> HeartBtInt=30 >> ReconnectInterval=5 >> >> [VALIDATION] >> CheckLatency=N >> >> yes, I am using the JdbcLog and it is working fine. >> I am using JdbcStore and JdbcLog. >> The database seems to be working fine. I get logging before and after >> this NPE occurs. >> Around this error, I had a forced logout and subsequent logon and lost >> processing of some of the messages received. >> >> Jeff Schwartz wrote: >> >>> Can someone tell me what this means? >>> Is there some configuration I can do to make this clearer? >>> At first I thought it was unimportant, but I have had forced logouts >>> and socket exceptions occur at the same time as well. >>> >>> Thanks, >>> Jeff >>> >>> Aug 15, 2007 1:56:23 PM org.apache.commons.logging.impl.SLF4JLog warn >>> WARNING: #0001 was active for 5641 milliseconds and has been removed >>> automaticaly. The Thread responsible was named 'QFJ Message >>> Processor', but the last SQL it performed is unknown because the trace >>> property is not enabled. >>> Aug 15, 2007 1:56:23 PM org.apache.commons.logging.impl.SLF4JLog warn >>> WARNING: #0002 was active for 8485 milliseconds and has been removed >>> automaticaly. The Thread responsible was named 'QFJ Timer', but the >>> last SQL it performed is unknown because the trace property is not >>> enabled. >>> Aug 15, 2007 1:56:23 PM >>> quickfix.mina.SessionConnector$SessionTimerTask run >>> SEVERE: Error during timer processing >>> java.lang.NullPointerException >>> at >>> com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:733) >>> >>> at >>> com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:1738) >>> >>> at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >>> at java.lang.reflect.Method.invoke(Unknown Source) >>> at >>> org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) >>> at >>> org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) >>> >>> at $java.sql.Wrapper$$EnhancerByCGLIB$$ddcd5788.setString(<generated>) >>> at quickfix.JdbcStore.set(JdbcStore.java:233) >>> at quickfix.SessionState.set(SessionState.java:290) >>> at quickfix.Session.sendRaw(Session.java:1637) >>> at quickfix.Session.generateHeartbeat(Session.java:1328) >>> at quickfix.Session.next(Session.java:1320) >>> at >>> quickfix.mina.SessionConnector$SessionTimerTask.run(SessionConnector.java: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(FutureTask.java:198) >>> >>> at >>> edu.emory.mathcs.backport.java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:189) >>> >>> at >>> edu.emory.mathcs.backport.java.util.concurrent.ScheduledThreadPoolExecutor$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(Unknown Source) >>> >>> >> -- >> Jeff Schwartz >> Senior Programmer >> Cornerstone Quantitative Investment Group >> 203-327-0888 >> >> >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. >> Still grepping through log files to find problems? Stop. >> Now Search log events and configuration files using AJAX and a browser. >> Download your FREE copy of Splunk now >> http://get.splunk.com/ >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >> >> > > > -- Jeff Schwartz Senior Programmer Cornerstone Quantitative Investment Group 203-327-0888 |