Re: [Quickfixj-users] QuickFix/J and oracle

[Alexandre G. <aga...@sa...>]

After some work (it was my first java compilation, after of course a
proudly printf('Hello World') ;-) ), I changed the class and call
JdbcStoreFactory. Now, Oracle and QFJ are working well together inside a
BANZAI-EXECUTOR dialog.

Thanks all for your help.
Alexandre


Le mar. 23 juin 2020 à 08:34, Alexandre GALMICHE <
aga...@sa...> a écrit :

> As I'm starting from the very beginning, I'm still using banzai (and
> executor) to fully understand the engine.
>
> The main class has :
>
>         OrderTableModel orderTableModel = new OrderTableModel();
>         ExecutionTableModel executionTableModel = new
> ExecutionTableModel();
>         BanzaiApplication application = new
> BanzaiApplication(orderTableModel, executionTableModel);
>        /* this one ??? ==> */  MessageStoreFactory messageStoreFactory =
> new FileStoreFactory(settings);
>         LogFactory logFactory = new ScreenLogFactory(true, true, true,
> logHeartbeats);
>         MessageFactory messageFactory = new DefaultMessageFactory();
>
>
> Le 20/06/2020 à 02:40, Christoph John a écrit :
>
> Good point. This made me think that Alexandre might have used a
> FileStoreFactory all along.
> Alexandre, could you double check that you are using a JdbcStoreFactory in
> your application code? The behaviour you are describing (no error messages,
> no data in tables) sure sound a little like you are actually using a
> FileStore or MemoryStore.
>
> Cheers,
> Chris.
>
> On 19.06.20 15:51, Grant Birchmeier wrote:
>
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
>
>
> What is the symptom of the failure?  You say it's not working -- did it
> throw an exception?  Did you see any messages received on the other side?
> What malfunction do you actually see?
>
> Got a message log?  Do you see any logon messages being sent out?
>
> And just for our sanity: Does it work when you use a FileStoreFactory?
> e.g. does it connect when you don't use the DB at all?
>
>
>
> On Fri, Jun 19, 2020 at 8:43 AM Alexandre Galmiche <
> aga...@sa...> wrote:
>
>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support:
>> http://www.quickfixj.org/support/
>>
>>
>> Here is my log file :
>> 19 juin 2020 13:10:08,342 INFO [main] quickfix.DefaultSessionSchedule -
>> [FIX.4.2:CLIENT1->EXECUTOR] daily, 00:00:00-UTC - 00:00:00-UTC
>> 19 juin 2020 13:10:08,377 INFO [main] quickfix.mina.NetworkingOptions -
>> Socket option: SocketTcpNoDelay=true
>> 19 juin 2020 13:10:08,377 INFO [main] quickfix.mina.NetworkingOptions -
>> Socket option: SocketSynchronousWrites=false
>> 19 juin 2020 13:10:08,378 INFO [main] quickfix.mina.NetworkingOptions -
>> Socket option: SocketSynchronousWriteTimeout=30000
>> 19 juin 2020 13:10:08,406 INFO [main] quickfix.SocketInitiator -
>> SessionTimer started
>> 19 juin 2020 13:10:08,409 INFO [QFJ Message Processor]
>> quickfix.SocketInitiator - Started QFJ Message Processor
>> 19 juin 2020 13:10:09,538 DEBUG [NioProcessor-2]
>> org.apache.mina.filter.codec.ProtocolCodecFilter - Processing a
>> MESSAGE_RECEIVED for session 1
>> 19 juin 2020 13:10:09,540 DEBUG [NioProcessor-2]
>> quickfix.mina.message.FIXMessageDecoder - detected header:
>> pos=0,lim=98,rem=98,offset=0,state=1
>> 19 juin 2020 13:10:09,540 DEBUG [NioProcessor-2]
>> quickfix.mina.message.FIXMessageDecoder - body length = 76:
>> pos=0,lim=98,rem=98,offset=15,state=3
>>
>>
>>
>> The full content of the cfg file :
>> [DEFAULT]
>> ConnectionType=initiator
>> FileStorePath=init/store
>> FileLogPath=init/log
>> StartTime=00:00:00
>> EndTime=00:00:00
>> ResetOnLogon=Y
>> HeartBtInt=30
>> ReconnectInterval=2
>> MaxReconnectAttempts=5
>> MaxWaitSeconds=300
>>
>> #Oracle Config
>> ## Oracle config
>> JdbcDriver=oracle.jdbc.driver.OracleDriver
>> JdbcURL=jdbc:oracle:thin:@xxxxxx:1521:XE
>> JdbcSessionIdDefaultPropertyValue=n
>> JdbcStoreSessionsTableName=sessions
>> JdbcStoreMessagesTableName=messages
>> JdbcUser=xxxxx
>> JdbcPassword=xxxxx
>> SLF4JLogEventCategory=${senderCompID}.${targetCompID}.events
>> SLF4JLogIncomingMessageCategory=${senderCompID}.${targetCompID}.incoming
>> SLF4JLogOutgoingMessageCategory=${senderCompID}.${targetCompID}.outgoing
>>
>>
>> [SESSION]
>> BeginString=FIX.4.2
>> SenderCompID=CLIENT1
>> TargetCompID=EXECUTOR
>> SocketConnectPort=5001
>> SocketConnectHost=localhost
>>
>>
>> I also removed the primary key from the tables and removed the NULL
>> clauses but no netter results
>>
>> Thanks !
>>
>>
>>
>>>
>>
> --
> Christoph John
> Software Engineering
> T +49 241 557...@ma...
>
> MACD GmbH
> Oppenhoffallee 103
> 52066 Aachen, Germanywww.macd.com
>
> Amtsgericht Aachen: HRB 8151
> Ust.-Id: DE 813021663
> Geschäftsführer: George Macdonald
>
>