Menu
▾
▴
quickfixj-users — General mailing list for QuickFIX/J topics.
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(13) |
Jun
(21) |
Jul
(14) |
Aug
(29) |
Sep
(39) |
Oct
(47) |
Nov
(70) |
Dec
(27) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007 |
Jan
(43) |
Feb
(50) |
Mar
(90) |
Apr
(96) |
May
(84) |
Jun
(40) |
Jul
(58) |
Aug
(55) |
Sep
(55) |
Oct
(52) |
Nov
(38) |
Dec
(75) |
| 2008 |
Jan
(49) |
Feb
(72) |
Mar
(49) |
Apr
(55) |
May
(21) |
Jun
(31) |
Jul
(47) |
Aug
(59) |
Sep
(59) |
Oct
(77) |
Nov
(51) |
Dec
(54) |
| 2009 |
Jan
(52) |
Feb
(57) |
Mar
(17) |
Apr
(27) |
May
(44) |
Jun
(46) |
Jul
(69) |
Aug
(38) |
Sep
(39) |
Oct
(45) |
Nov
(38) |
Dec
(37) |
| 2010 |
Jan
(49) |
Feb
(35) |
Mar
(21) |
Apr
(33) |
May
(52) |
Jun
(28) |
Jul
(39) |
Aug
(34) |
Sep
(21) |
Oct
(82) |
Nov
(36) |
Dec
(20) |
| 2011 |
Jan
(28) |
Feb
(64) |
Mar
(93) |
Apr
(75) |
May
(151) |
Jun
(77) |
Jul
(35) |
Aug
(53) |
Sep
(56) |
Oct
(36) |
Nov
(94) |
Dec
(59) |
| 2012 |
Jan
(105) |
Feb
(43) |
Mar
(68) |
Apr
(91) |
May
(45) |
Jun
(18) |
Jul
(103) |
Aug
(77) |
Sep
(45) |
Oct
(59) |
Nov
(58) |
Dec
(43) |
| 2013 |
Jan
(48) |
Feb
(65) |
Mar
(63) |
Apr
(22) |
May
(41) |
Jun
(60) |
Jul
(43) |
Aug
(17) |
Sep
(20) |
Oct
(20) |
Nov
(42) |
Dec
(43) |
| 2014 |
Jan
(54) |
Feb
(34) |
Mar
(34) |
Apr
(20) |
May
(31) |
Jun
(39) |
Jul
(66) |
Aug
(22) |
Sep
(52) |
Oct
(22) |
Nov
(67) |
Dec
(70) |
| 2015 |
Jan
(18) |
Feb
(5) |
Mar
(40) |
Apr
(32) |
May
(62) |
Jun
(28) |
Jul
(86) |
Aug
(44) |
Sep
(61) |
Oct
(65) |
Nov
(8) |
Dec
(19) |
| 2016 |
Jan
(50) |
Feb
(22) |
Mar
(38) |
Apr
(55) |
May
(30) |
Jun
(42) |
Jul
(11) |
Aug
(9) |
Sep
(4) |
Oct
(51) |
Nov
(38) |
Dec
(31) |
| 2017 |
Jan
(40) |
Feb
(40) |
Mar
(23) |
Apr
(35) |
May
(121) |
Jun
(55) |
Jul
(37) |
Aug
(16) |
Sep
(27) |
Oct
(109) |
Nov
(67) |
Dec
(23) |
| 2018 |
Jan
(52) |
Feb
(6) |
Mar
(23) |
Apr
(28) |
May
(32) |
Jun
(20) |
Jul
(20) |
Aug
(22) |
Sep
(8) |
Oct
(33) |
Nov
(32) |
Dec
(13) |
| 2019 |
Jan
(16) |
Feb
(29) |
Mar
(17) |
Apr
(16) |
May
(1) |
Jun
(2) |
Jul
(25) |
Aug
(50) |
Sep
(17) |
Oct
(29) |
Nov
(16) |
Dec
(7) |
| 2020 |
Jan
|
Feb
|
Mar
(29) |
Apr
(64) |
May
(25) |
Jun
(49) |
Jul
(15) |
Aug
(10) |
Sep
(37) |
Oct
(20) |
Nov
(19) |
Dec
(9) |
| 2021 |
Jan
(33) |
Feb
(10) |
Mar
(67) |
Apr
(40) |
May
(70) |
Jun
(33) |
Jul
(14) |
Aug
(10) |
Sep
|
Oct
(7) |
Nov
(6) |
Dec
(16) |
| 2022 |
Jan
(27) |
Feb
(2) |
Mar
(5) |
Apr
(3) |
May
|
Jun
(2) |
Jul
|
Aug
(1) |
Sep
(6) |
Oct
(2) |
Nov
|
Dec
(10) |
| 2023 |
Jan
(1) |
Feb
(2) |
Mar
(21) |
Apr
(3) |
May
(15) |
Jun
(3) |
Jul
(4) |
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
(1) |
| 2024 |
Jan
(7) |
Feb
(2) |
Mar
(8) |
Apr
(11) |
May
(6) |
Jun
(5) |
Jul
|
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
|
| 2025 |
Jan
(10) |
Feb
(4) |
Mar
(9) |
Apr
|
May
(3) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Nenge M. <geo...@gm...> - 2020-06-20 02:24:15
|
On Sat, 20 Jun 2020, 02:01 Christoph John, <chr...@ma...> wrote: > Looking at the stack trace, I think your problem is that you are trying to > crack admin messages (at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin( > ClientApplicationAdapter.java:68)). This is not required. > You only need to do this for application messages, i.e. in your fromApp() > callback. > > Cheers, > Chris. > > On 18.06.20 15:36, Nenge Masoya wrote: > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > Hello Devs, > > I am still facing the issues in reading messages returned from other party > (server) which is using FIX.5.0SP2.... this is my errors message from > events logs > > 20200617-14:19:45: Session FIXT.1.1:CLIENT->SERVER schedule is daily, > 00:00:00-UTC - 22:50:00-UTC > 20200617-14:19:45: Created session: FIXT.1.1:CLIENT->SERVER > 20200617-14:19:45: Configured socket addresses for session: > [/"server-address here"] > 20200617-14:19:45: MINA session created: local=/192.168.91.98:39322, > class org.apache.mina.transport.socket.nio.NioSocketSession, > remote=/"server-address here" > 20200617-14:19:46: Initiated logon request > 20200617-14:19:46: Invalid message: Can't determine ApplVerID from message > 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 > 16=0 10=149 > 20200617-14:19:46: Setting DefaultApplVerID (1137=8) from Logon > 20200617-14:19:46: Error during message processing > quickfix.RuntimeError: java.lang.ClassCastException: quickfix.fixt11.Logon > cannot be cast to quickfix.fix50sp2.Message > at quickfix.Session.next(Session.java:1157) > at quickfix.Session.next(Session.java:1204) > at quickfix.mina.ThreadPerSessionEventHandlingStrategy$ > MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingS > trategy.java:214) > at quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run( > ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be > cast to quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin( > ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > ... 4 more > Cause: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message > java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to > quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin( > ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > at quickfix.Session.next(Session.java:1204) > at quickfix.mina.ThreadPerSessionEventHandlingStrategy$ > MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingS > trategy.java:214) > at quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run( > ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > > I tried to follow the reference provided here here no success.. > https://stackoverflow.com/questions/30074850/quickfix- > message-cannot-be-cast-to-quickfix-fix50sp2-message > > And this is my log messages > > 8=FIXT.1.1 9=75 35=A 34=2 49=CLIENT 52=20200617-14:19:46.103 56=SERVER > 98=0 108=30 1137=9 10=139 > 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 > 16=0 10=149 > 8=FIXT.1.1 9=112 35=A 34=2 49=SERVER 52=20200617-14:21:08.242 56=CLIENT > 58=Logon Successful. 98=0 108=60 553=STT 554=SERVER 1137=8 10=117 > > > Any one with the help will be appreciated guys... It make me mad for sure! > > Thanks > > Nenge > > > On Tue, Jun 2, 2020 at 6:47 PM Colin DuPlantis <co...@ma...> > wrote: > >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: >> http://www.quickfixj.org/support/ >> >> >> What do you mean by "response data"? Do you mean messages returned by the >> other party? If so, those will be received in your Application >> implementation in fromApp. >> On 6/2/20 5:56 AM, Nenge Masoya wrote: >> >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J Support: http://www.quickfixj.org/support/ >> >> >> Dear team, >> >> I am new with quickfixJ and I Im kindy requesting your help on this, from >> what I see the response of client QuickFixJTemplate when sending message is >> boolean which tells whether the message was successful delivered or not. >> >> For instance, >> >> @Autowired >> private QuickFixJTemplate clientQuickFixJTemplate; >> >> //send message >> >> boolean send = clientQuickFixJTemplate.send(fixMessage, sessionID); >> >> Now, how can I get response data for further implementation? >> >> Thank in advance. >> >> Nenge Masoya >> >> >> _______________________________________________ >> Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users >> >> -- >> Colin DuPlantis >> Chief Architect, Marketcetera >> Download, Run, Trade >> 888.868.4884https://www.marketcetera.com >> >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >> > > > _______________________________________________ > Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users > > > -- > 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 > > |
|
From: Nenge M. <geo...@gm...> - 2020-06-20 02:20:47
|
Thanks Chris.. On Sat, 20 Jun 2020, 02:01 Christoph John, <chr...@ma...> wrote: > Looking at the stack trace, I think your problem is that you are trying to > crack admin messages (at > tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68)). > This is not required. > You only need to do this for application messages, i.e. in your fromApp() > callback. > > Cheers, > Chris. > > On 18.06.20 15:36, Nenge Masoya wrote: > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > Hello Devs, > > I am still facing the issues in reading messages returned from other party > (server) which is using FIX.5.0SP2.... this is my errors message from > events logs > > 20200617-14:19:45: Session FIXT.1.1:CLIENT->SERVER schedule is daily, > 00:00:00-UTC - 22:50:00-UTC > 20200617-14:19:45: Created session: FIXT.1.1:CLIENT->SERVER > 20200617-14:19:45: Configured socket addresses for session: > [/"server-address here"] > 20200617-14:19:45: MINA session created: local=/192.168.91.98:39322, > class org.apache.mina.transport.socket.nio.NioSocketSession, > remote=/"server-address here" > 20200617-14:19:46: Initiated logon request > 20200617-14:19:46: Invalid message: Can't determine ApplVerID from message > 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 > 16=0 10=149 > 20200617-14:19:46: Setting DefaultApplVerID (1137=8) from Logon > 20200617-14:19:46: Error during message processing > quickfix.RuntimeError: java.lang.ClassCastException: quickfix.fixt11.Logon > cannot be cast to quickfix.fix50sp2.Message > at quickfix.Session.next(Session.java:1157) > at quickfix.Session.next(Session.java:1204) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be > cast to quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at > tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > ... 4 more > Cause: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message > java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to > quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at > tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > at quickfix.Session.next(Session.java:1204) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > > I tried to follow the reference provided here here no success.. > > https://stackoverflow.com/questions/30074850/quickfix-message-cannot-be-cast-to-quickfix-fix50sp2-message > > And this is my log messages > > 8=FIXT.1.1 9=75 35=A 34=2 49=CLIENT 52=20200617-14:19:46.103 56=SERVER > 98=0 108=30 1137=9 10=139 > 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 > 16=0 10=149 > 8=FIXT.1.1 9=112 35=A 34=2 49=SERVER 52=20200617-14:21:08.242 56=CLIENT > 58=Logon Successful. 98=0 108=60 553=STT 554=SERVER 1137=8 10=117 > > > Any one with the help will be appreciated guys... It make me mad for sure! > > Thanks > > Nenge > > > On Tue, Jun 2, 2020 at 6:47 PM Colin DuPlantis <co...@ma...> > wrote: > >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: >> http://www.quickfixj.org/support/ >> >> >> What do you mean by "response data"? Do you mean messages returned by the >> other party? If so, those will be received in your Application >> implementation in fromApp. >> On 6/2/20 5:56 AM, Nenge Masoya wrote: >> >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J Support: http://www.quickfixj.org/support/ >> >> >> Dear team, >> >> I am new with quickfixJ and I Im kindy requesting your help on this, from >> what I see the response of client QuickFixJTemplate when sending message is >> boolean which tells whether the message was successful delivered or not. >> >> For instance, >> >> @Autowired >> private QuickFixJTemplate clientQuickFixJTemplate; >> >> //send message >> >> boolean send = clientQuickFixJTemplate.send(fixMessage, sessionID); >> >> Now, how can I get response data for further implementation? >> >> Thank in advance. >> >> Nenge Masoya >> >> >> _______________________________________________ >> Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users >> >> -- >> Colin DuPlantis >> Chief Architect, Marketcetera >> Download, Run, Trade >> 888.868.4884https://www.marketcetera.com >> >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >> > > > _______________________________________________ > Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users > > > -- > 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 > > |
|
From: Christoph J. <chr...@ma...> - 2020-06-19 23:01:32
|
Looking at the stack trace, I think your problem is that you are trying to crack admin messages (at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68)). This is not required. You only need to do this for application messages, i.e. in your fromApp() callback. Cheers, Chris. On 18.06.20 15:36, Nenge Masoya wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > > Hello Devs, > > I am still facing the issues in reading messages returned from other party (server) which is > using FIX.5.0SP2.... this is my errors message from events logs > > 20200617-14:19:45: Session FIXT.1.1:CLIENT->SERVER schedule is daily, 00:00:00-UTC - 22:50:00-UTC > 20200617-14:19:45: Created session: FIXT.1.1:CLIENT->SERVER > 20200617-14:19:45: Configured socket addresses for session: [/"server-address here"] > 20200617-14:19:45: MINA session created: local=/192.168.91.98:39322 <http://192.168.91.98:39322>, > class org.apache.mina.transport.socket.nio.NioSocketSession, remote=/"server-address here" > 20200617-14:19:46: Initiated logon request > 20200617-14:19:46: Invalid message: Can't determine ApplVerID from message 8=FIXT.1.1 9=65 35=2 > 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 16=0 10=149 > 20200617-14:19:46: Setting DefaultApplVerID (1137=8) from Logon > 20200617-14:19:46: Error during message processing > quickfix.RuntimeError: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to > quickfix.fix50sp2.Message > at quickfix.Session.next(Session.java:1157) > at quickfix.Session.next(Session.java:1204) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to > quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > ... 4 more > Cause: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message > java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > at quickfix.Session.next(Session.java:1204) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > > I tried to follow the reference provided here here no success.. > https://stackoverflow.com/questions/30074850/quickfix-message-cannot-be-cast-to-quickfix-fix50sp2-message > > > And this is my log messages > > 8=FIXT.1.1 9=75 35=A 34=2 49=CLIENT 52=20200617-14:19:46.103 56=SERVER 98=0 108=30 1137=9 10=139 > 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 16=0 10=149 > 8=FIXT.1.1 9=112 35=A 34=2 49=SERVER 52=20200617-14:21:08.242 56=CLIENT 58=Logon Successful. 98=0 > 108=60 553=STT 554=SERVER 1137=8 10=117 > > > Any one with the help will be appreciated guys... It make me mad for sure! > > Thanks > > Nenge > > > On Tue, Jun 2, 2020 at 6:47 PM Colin DuPlantis <co...@ma... > <mailto:co...@ma...>> wrote: > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > What do you mean by "response data"? Do you mean messages returned by the other party? If so, > those will be received in your Application implementation in fromApp. > > On 6/2/20 5:56 AM, Nenge Masoya wrote: >> QuickFIX/J Documentation:http://www.quickfixj.org/documentation/ >> QuickFIX/J Support:http://www.quickfixj.org/support/ >> >> >> >> Dear team, >> >> I am new with quickfixJ and I Im kindy requesting your help on this, from what I see the >> response of client QuickFixJTemplate when sending message is boolean which tells whether the >> message was successful delivered or not. >> >> For instance, >> >> @Autowired >> private QuickFixJTemplate clientQuickFixJTemplate; >> >> //send message >> >> boolean send = clientQuickFixJTemplate.send(fixMessage, sessionID); >> Now, how can I get response data for further implementation? >> >> Thank in advance. >> >> Nenge Masoya >> >> >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... <mailto:Qui...@li...> >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users > > -- > Colin DuPlantis > Chief Architect, Marketcetera > Download, Run, Trade > 888.868.4884 > https://www.marketcetera.com > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... <mailto:Qui...@li...> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users -- Christoph John Software Engineering T +49 241 557080-28 chr...@ma... MACD GmbH Oppenhoffallee 103 52066 Aachen, Germany www.macd.com Amtsgericht Aachen: HRB 8151 Ust.-Id: DE 813021663 Geschäftsführer: George Macdonald |
|
From: Christoph J. <chr...@ma...> - 2020-06-19 22:41:15
|
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... > <mailto: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 557080-28 chr...@ma... MACD GmbH Oppenhoffallee 103 52066 Aachen, Germany www.macd.com Amtsgericht Aachen: HRB 8151 Ust.-Id: DE 813021663 Geschäftsführer: George Macdonald |
|
From: Grant B. <gbi...@co...> - 2020-06-19 18:39:40
|
Pretty sure you're on the wrong mailing list. This list is for the Java port. If you're on Python, you're probably using the C++ version with the SWIG wrapper, so you want the C++ mailing list. See http://quickfixengine.org and click "List". As to your actual question, is the error being triggered by the "getGroup" line? Why are you calling "message= quickfix.Message(..)" ? Pretty sure that's not gonna parse using the DataDictionary. Take this question over to the other list, and hopefully some Python users (I'm not one of them) will chime in. On Fri, Jun 19, 2020 at 1:30 PM Nicolas REY <Nik...@ho...> wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > Hi guys, > > > > I am a new user of your package quickfix on Python and I am trying to > parse a MarketDataSnapshotFullRefresh (MsgType “w”). > > > > *I have the following message:* > > 8=FIX.4.4|9=219|35=W|34=4|49=id|52=20200618-14:34:20.738|56=id1|42=20200618-14:34:20.688|55=EUR/USD|262=1|268=2|269=0|270=1.12083|271=500000|269=1|270=1.12084|271=500000|10094=2020.06.18 > 14:34:20.688|10=141| > > > > *I am trying to retrieve fields 270, 271 with the following code:* > > > > message= quickfix.Message('8=FIX.4.4\x019=219\x0135=W\x0134=4\x0149=id\x0152=20200618-14:34:20.738\x0156=id1\x0142=20200618-14:34:20.688\x0155=EURUSD\x01262=1\x01268=2\x01269=0\x01269=1\x01270=1.12083\x01270=1.12084\x01271=500000\x01271=500000\x0110094=2020.06.18 > 14:34:20.688\x0110=141\x01') > > > > group = quickfix44.MarketDataSnapshotFullRefresh.NoMDEntries() > > > > fix_no_entries = quickfix.NoMDEntries() > > message.getField(fix_no_entries) > > no_entries = fix_no_entries.getValue() # print = 2 as expected > > > > message.getGroup(1, group) > > > > *yields the error:* > > > > FieldNotFound: Field not found > > > > I have been trying to understand where I made a mistake but could not find > anything. > > > > Could you tell me if there is an error in my code, or something odd in > source code please. > > > > Thank you a lot for your help, > > Nicolas Rey > > > > > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > -- Grant Birchmeier *Connamara Systems, LLC* *Made-To-Measure Trading Solutions.* Exactly what you need. No more. No less. http://connamara.com -- This email, along with any attachments, is confidential. If you believe you received this message in error, please contact the sender immediately and delete all copies of the message. Thank you from Connamara Systems, LLC. |
|
From: Nicolas R. <Nik...@ho...> - 2020-06-19 18:29:53
|
Hi guys,
I am a new user of your package quickfix on Python and I am trying to parse a MarketDataSnapshotFullRefresh (MsgType "w").
I have the following message:
8=FIX.4.4|9=219|35=W|34=4|49=id|52=20200618-14:34:20.738|56=id1|42=20200618-14:34:20.688|55=EUR/USD|262=1|268=2|269=0|270=1.12083|271=500000|269=1|270=1.12084|271=500000|10094=2020.06.18 14:34:20.688|10=141|
I am trying to retrieve fields 270, 271 with the following code:
message= quickfix.Message('8=FIX.4.4\x019=219\x0135=W\x0134=4\x0149=id\x0152=20200618-14:34:20.738\x0156=id1\x0142=20200618-14:34:20.688\x0155=EURUSD\x01262=1\x01268=2\x01269=0\x01269=1\x01270=1.12083\x01270=1.12084\x01271=500000\x01271=500000\x0110094=2020.06.18 14:34:20.688\x0110=141\x01')
group = quickfix44.MarketDataSnapshotFullRefresh.NoMDEntries()
fix_no_entries = quickfix.NoMDEntries()
message.getField(fix_no_entries)
no_entries = fix_no_entries.getValue() # print = 2 as expected
message.getGroup(1, group)
yields the error:
FieldNotFound: Field not found
I have been trying to understand where I made a mistake but could not find anything.
Could you tell me if there is an error in my code, or something odd in source code please.
Thank you a lot for your help,
Nicolas Rey
|
|
From: Grant B. <gbi...@co...> - 2020-06-19 13:52:08
|
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 ! > > > >> _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > -- Grant Birchmeier *Connamara Systems, LLC* *Made-To-Measure Trading Solutions.* Exactly what you need. No more. No less. http://connamara.com -- This email, along with any attachments, is confidential. If you believe you received this message in error, please contact the sender immediately and delete all copies of the message. Thank you from Connamara Systems, LLC. |
|
From: Alexandre G. <aga...@sa...> - 2020-06-19 13:42:55
|
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 !
>
|
|
From: Grant B. <gbi...@co...> - 2020-06-18 14:37:08
|
*foreheadslap* of course! Can't log anything to a database you can't connect to. Good eye, Christoph! On Thu, Jun 18, 2020 at 9:30 AM Christoph John via Quickfixj-users < qui...@li...> wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > What about only using JDBC for messages and use plain file for logging? > Maybe that will show some kind of error message. > > Am 18. Juni 2020 16:02:20 MESZ schrieb Alexandre Galmiche < > aga...@sa...>: >> >> @Colin, I didn't miss Grant suggestions, but it is not working too. >> @Christoph, thanks for the link. I already read this section :-( . And no >> error message. >> I'll try to find something by tomorrow, after that I will install MySQL >> and make an ODBC connection , which is not the prettiest configuration >> (disappointment). >> >> Cheers ! >> >> >> >> >> *Alexandre GALMICHE - Développeur* >> >> *Salamander* >> >> aga...@sa... | http://www.salamander-soft.com >> >> >> Le jeu. 18 juin 2020 à 16:41, Colin DuPlantis <co...@ma...> a >> écrit : >> >>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: >>> http://www.quickfixj.org/support/ >>> >>> >>> It looks like you're missing the configuration setting recommended by >>> Grant. >>> >>> On Thu, Jun 18, 2020, 5:25 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/ >>>> >>>> >>>> Hi, >>>> Still working on this issue. >>>> The pb is not related to oracle database, proxool and connections. I >>>> tried this simple script and it worked : >>>> $ more testjdbc.java >>>> import java.sql.Connection; >>>> import java.sql.ResultSet; >>>> import java.sql.Statement; >>>> >>>> import org.logicalcobwebs.proxool.ProxoolDataSource; >>>> >>>> >>>> public class testjdbc { >>>> public static void main(String[] args) { >>>> >>>> Connection con = null; >>>> Statement st = null; >>>> ResultSet rs = null; >>>> >>>> try { >>>> ProxoolDataSource ds = new ProxoolDataSource(); >>>> ds.setDriver("oracle.jdbc.OracleDriver"); >>>> ds.setDriverUrl("jdbc:oracle:thin:@localhost:1521:XE"); >>>> ds.setUser("xxx"); >>>> ds.setPassword("xxx"); >>>> ds.setMinimumConnectionCount(5); >>>> ds.setMaximumConnectionCount(10); >>>> >>>> con = ds.getConnection(); >>>> st = con.createStatement(); >>>> rs = st.executeQuery("select sysdate from dual"); >>>> >>>> System.out.println("Value"); >>>> System.out.println("-------"); >>>> while(rs.next()){ >>>> System.out.print(rs.getString("SYSDATE")+"\t"); >>>> } >>>> } catch (Exception e){ >>>> e.printStackTrace(); >>>> } finally{ >>>> try { >>>> rs.close(); >>>> st.close(); >>>> con.close(); >>>> } >>>> catch (Exception e){ >>>> e.printStackTrace(); >>>> } >>>> >>>> } >>>> } >>>> } >>>> >>>> My tables are OK : >>>> SQL> desc messages >>>> Nom NULL ? Type >>>> ----------------------------------------- -------- >>>> ---------------------------- >>>> BEGINSTRING NOT NULL VARCHAR2(8) >>>> SENDERCOMPID NOT NULL VARCHAR2(64) >>>> SENDERSUBID NOT NULL VARCHAR2(64) >>>> SENDERLOCID NOT NULL VARCHAR2(64) >>>> TARGETCOMPID NOT NULL VARCHAR2(64) >>>> TARGETSUBID NOT NULL VARCHAR2(64) >>>> TARGETLOCID NOT NULL VARCHAR2(64) >>>> SESSION_QUALIFIER NOT NULL VARCHAR2(64) >>>> MSGSEQNUM NOT NULL NUMBER(38) >>>> MESSAGE NOT NULL VARCHAR2(4000) >>>> >>>> SQL> desc sessions >>>> Nom NULL ? Type >>>> ----------------------------------------- -------- >>>> ---------------------------- >>>> BEGINSTRING NOT NULL VARCHAR2(8) >>>> SENDERCOMPID NOT NULL VARCHAR2(64) >>>> SENDERSUBID NOT NULL VARCHAR2(64) >>>> SENDERLOCID NOT NULL VARCHAR2(64) >>>> TARGETCOMPID NOT NULL VARCHAR2(64) >>>> TARGETSUBID NOT NULL VARCHAR2(64) >>>> TARGETLOCID NOT NULL VARCHAR2(64) >>>> SESSION_QUALIFIER NOT NULL VARCHAR2(64) >>>> CREATION_TIME NOT NULL TIMESTAMP(6) >>>> INCOMING_SEQNUM NOT NULL NUMBER(38) >>>> OUTGOING_SEQNUM NOT NULL NUMBER(38) >>>> >>>> SQL> >>>> >>>> >>>> I added >>>> >>>> JdbcStoreSessionsTableName=sessions >>>> JdbcStoreMessagesTableName=messages >>>> JdbcLogEventTable=event_log >>>> JdbcLogOutgoingTable=messages_log >>>> JdbcLogIncomingTable=messages_log >>>> in the cfg file >>>> >>>> >>>> I'm still facing the issue. >>>> >>>> >>>> >>>> >>>> *Alexandre GALMICHE - Développeur* >>>> >>>> *Salamander* >>>> >>>> aga...@sa... | http://www.salamander-soft.com >>>> >>>> >>>> Le mar. 16 juin 2020 à 22:17, Colin DuPlantis <co...@ma...> >>>> a écrit : >>>> >>>>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> >>>>> Support: http://www.quickfixj.org/support/ >>>>> >>>>> >>>>> We had a problem integrating with Oracle, though it was some years ago >>>>> now. I forget the details. It was with an older version of QFJ, 1.6.x, >>>>> IIRC. There were several problems: >>>>> >>>>> 1) Getting the right version of ojdbc (though I think you've got that >>>>> right) >>>>> 2) Significant Oracle-related weirdness related to the JDBC connection >>>>> string and Oracle using SIDs or not, or whatever Oracle does. We had to >>>>> create a very bizarre JDBC URL e.g: metc.fix.jdbc.url=jdbc:oracle:thin:@ >>>>> (DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1545)(HOST=yourhost))(CONNECT_DATA=(SERVICE_NAME=yourservice))) >>>>> 3) There was some name-collision problem that required us to >>>>> additionally define JDBCStoreMessagesTableName and >>>>> JDBCStoreSessionsTableName in the QFJ config. I can't remember the details, >>>>> sorry. >>>>> >>>>> So, in conclusion, Oracle is ridiculously complicated (IMO) and >>>>> required a lot of fiddling. There is often an Oracle DBA chained to one of >>>>> their giant boxes who may be able to help with the JDBC URL thing, if >>>>> that's what it is. >>>>> >>>>> I've attached the SQL we used to create the tables, in case that >>>>> helps. Like I said, this was with an old version, so might be outdated. >>>>> >>>>> Bonne chance. >>>>> >>>>> - Colin >>>>> On 6/16/20 9:59 AM, Alexandre Galmiche wrote: >>>>> >>>>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>>> QuickFIX/J Support: http://www.quickfixj.org/support/ >>>>> >>>>> >>>>> Tables are empty and no error message >>>>> >>>>> >>>>> >>>>> >>>>> *Alexandre GALMICHE - Développeur* >>>>> >>>>> *Salamander* >>>>> >>>>> aga...@sa... | http://www.salamander-soft.com >>>>> >>>>> >>>>> Le mar. 16 juin 2020 à 19:01, Philip Whitehouse <ph...@wh...> a >>>>> écrit : >>>>> >>>>>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>>>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> >>>>>> Support: http://www.quickfixj.org/support/ >>>>>> >>>>>> >>>>>> What happens when you try it? >>>>>> >>>>>> Best, >>>>>> >>>>>> Philip Whitehouse >>>>>> >>>>>> > On 16 Jun 2020, at 15:47, Alexandre GALMICHE < >>>>>> aga...@sa...> wrote: >>>>>> > >>>>>> > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>>>> > QuickFIX/J Support: http://www.quickfixj.org/support/ >>>>>> > >>>>>> > >>>>>> > Hi, >>>>>> > >>>>>> > I'm trying to make QFJ an oracle working together : >>>>>> > >>>>>> > - QFJ 2.1.1 (basic installation) >>>>>> > >>>>>> > - Oracle 11.2.0.4 >>>>>> > >>>>>> > >>>>>> > - Added ojdbc6.jar and proxool-0.9.1.jar >>>>>> > >>>>>> > - create the event_log, messages_log, sessions and messages tables >>>>>> (+ sequences + trigger to fill the id for messages_log and event_log) >>>>>> > >>>>>> > >>>>>> > My settings are : >>>>>> > >>>>>> > ## Oracle config >>>>>> > JdbcDriver=oracle.jdbc.driver.OracleDriver >>>>>> > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE >>>>>> > JdbcUser=ORACLEMAN >>>>>> > JdbcPassword=ORACLEMAN >>>>>> > JdbcSessionIdDefaultPropertyValue=n/a >>>>>> > >>>>>> > >>>>>> > Did I miss something ? >>>>>> > >>>>>> > Thanks ! >>>>>> > >>>>>> > >>>>>> > >>>>>> > _______________________________________________ >>>>>> > Quickfixj-users mailing list >>>>>> > Qui...@li... >>>>>> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Quickfixj-users mailing list >>>>>> Qui...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>>> >>>>> -- >>>>> Colin DuPlantis >>>>> Chief Architect, Marketcetera >>>>> Download, Run, Trade >>>>> 888.868.4884https://www.marketcetera.com >>>>> >>>>> _______________________________________________ >>>>> Quickfixj-users mailing list >>>>> Qui...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>>> >>>> _______________________________________________ >>>> Quickfixj-users mailing list >>>> Qui...@li... >>>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>> >>> _______________________________________________ >>> Quickfixj-users mailing list >>> Qui...@li... >>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>> >> _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > -- Grant Birchmeier *Connamara Systems, LLC* *Made-To-Measure Trading Solutions.* Exactly what you need. No more. No less. http://connamara.com -- This email, along with any attachments, is confidential. If you believe you received this message in error, please contact the sender immediately and delete all copies of the message. Thank you from Connamara Systems, LLC. |
|
From: Christoph J. <chr...@ma...> - 2020-06-18 14:30:45
|
What about only using JDBC for messages and use plain file for logging? Maybe that will show some kind of error message. Am 18. Juni 2020 16:02:20 MESZ schrieb Alexandre Galmiche <aga...@sa...>: >QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >QuickFIX/J Support: http://www.quickfixj.org/support/ |
|
From: Grant B. <gbi...@co...> - 2020-06-18 14:14:45
|
I don't see a JdbcURL in your config, nor do I see JdbcSessionIdDefaultPropertyValue=n/a. Those are pretty vital, especially the first one. I feel like maybe we're not seeing the whole configuration file that you used. Can you show us ALL of it (after you've edited out sensitive usernames/pws/urls)? On Thu, Jun 18, 2020 at 9:03 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/ > > > @Colin, I didn't miss Grant suggestions, but it is not working too. > @Christoph, thanks for the link. I already read this section :-( . And no > error message. > I'll try to find something by tomorrow, after that I will install MySQL > and make an ODBC connection , which is not the prettiest configuration > (disappointment). > > Cheers ! > > > > > *Alexandre GALMICHE - Développeur* > > *Salamander* > > aga...@sa... | http://www.salamander-soft.com > > > Le jeu. 18 juin 2020 à 16:41, Colin DuPlantis <co...@ma...> a > écrit : > >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: >> http://www.quickfixj.org/support/ >> >> >> It looks like you're missing the configuration setting recommended by >> Grant. >> >> On Thu, Jun 18, 2020, 5:25 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/ >>> >>> >>> Hi, >>> Still working on this issue. >>> The pb is not related to oracle database, proxool and connections. I >>> tried this simple script and it worked : >>> $ more testjdbc.java >>> import java.sql.Connection; >>> import java.sql.ResultSet; >>> import java.sql.Statement; >>> >>> import org.logicalcobwebs.proxool.ProxoolDataSource; >>> >>> >>> public class testjdbc { >>> public static void main(String[] args) { >>> >>> Connection con = null; >>> Statement st = null; >>> ResultSet rs = null; >>> >>> try { >>> ProxoolDataSource ds = new ProxoolDataSource(); >>> ds.setDriver("oracle.jdbc.OracleDriver"); >>> ds.setDriverUrl("jdbc:oracle:thin:@localhost:1521:XE"); >>> ds.setUser("xxx"); >>> ds.setPassword("xxx"); >>> ds.setMinimumConnectionCount(5); >>> ds.setMaximumConnectionCount(10); >>> >>> con = ds.getConnection(); >>> st = con.createStatement(); >>> rs = st.executeQuery("select sysdate from dual"); >>> >>> System.out.println("Value"); >>> System.out.println("-------"); >>> while(rs.next()){ >>> System.out.print(rs.getString("SYSDATE")+"\t"); >>> } >>> } catch (Exception e){ >>> e.printStackTrace(); >>> } finally{ >>> try { >>> rs.close(); >>> st.close(); >>> con.close(); >>> } >>> catch (Exception e){ >>> e.printStackTrace(); >>> } >>> >>> } >>> } >>> } >>> >>> My tables are OK : >>> SQL> desc messages >>> Nom NULL ? Type >>> ----------------------------------------- -------- >>> ---------------------------- >>> BEGINSTRING NOT NULL VARCHAR2(8) >>> SENDERCOMPID NOT NULL VARCHAR2(64) >>> SENDERSUBID NOT NULL VARCHAR2(64) >>> SENDERLOCID NOT NULL VARCHAR2(64) >>> TARGETCOMPID NOT NULL VARCHAR2(64) >>> TARGETSUBID NOT NULL VARCHAR2(64) >>> TARGETLOCID NOT NULL VARCHAR2(64) >>> SESSION_QUALIFIER NOT NULL VARCHAR2(64) >>> MSGSEQNUM NOT NULL NUMBER(38) >>> MESSAGE NOT NULL VARCHAR2(4000) >>> >>> SQL> desc sessions >>> Nom NULL ? Type >>> ----------------------------------------- -------- >>> ---------------------------- >>> BEGINSTRING NOT NULL VARCHAR2(8) >>> SENDERCOMPID NOT NULL VARCHAR2(64) >>> SENDERSUBID NOT NULL VARCHAR2(64) >>> SENDERLOCID NOT NULL VARCHAR2(64) >>> TARGETCOMPID NOT NULL VARCHAR2(64) >>> TARGETSUBID NOT NULL VARCHAR2(64) >>> TARGETLOCID NOT NULL VARCHAR2(64) >>> SESSION_QUALIFIER NOT NULL VARCHAR2(64) >>> CREATION_TIME NOT NULL TIMESTAMP(6) >>> INCOMING_SEQNUM NOT NULL NUMBER(38) >>> OUTGOING_SEQNUM NOT NULL NUMBER(38) >>> >>> SQL> >>> >>> >>> I added >>> >>> JdbcStoreSessionsTableName=sessions >>> JdbcStoreMessagesTableName=messages >>> JdbcLogEventTable=event_log >>> JdbcLogOutgoingTable=messages_log >>> JdbcLogIncomingTable=messages_log >>> in the cfg file >>> >>> >>> I'm still facing the issue. >>> >>> >>> >>> >>> *Alexandre GALMICHE - Développeur* >>> >>> *Salamander* >>> >>> aga...@sa... | http://www.salamander-soft.com >>> >>> >>> Le mar. 16 juin 2020 à 22:17, Colin DuPlantis <co...@ma...> >>> a écrit : >>> >>>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> >>>> Support: http://www.quickfixj.org/support/ >>>> >>>> >>>> We had a problem integrating with Oracle, though it was some years ago >>>> now. I forget the details. It was with an older version of QFJ, 1.6.x, >>>> IIRC. There were several problems: >>>> >>>> 1) Getting the right version of ojdbc (though I think you've got that >>>> right) >>>> 2) Significant Oracle-related weirdness related to the JDBC connection >>>> string and Oracle using SIDs or not, or whatever Oracle does. We had to >>>> create a very bizarre JDBC URL e.g: metc.fix.jdbc.url=jdbc:oracle:thin:@ >>>> (DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1545)(HOST=yourhost))(CONNECT_DATA=(SERVICE_NAME=yourservice))) >>>> 3) There was some name-collision problem that required us to >>>> additionally define JDBCStoreMessagesTableName and >>>> JDBCStoreSessionsTableName in the QFJ config. I can't remember the details, >>>> sorry. >>>> >>>> So, in conclusion, Oracle is ridiculously complicated (IMO) and >>>> required a lot of fiddling. There is often an Oracle DBA chained to one of >>>> their giant boxes who may be able to help with the JDBC URL thing, if >>>> that's what it is. >>>> >>>> I've attached the SQL we used to create the tables, in case that helps. >>>> Like I said, this was with an old version, so might be outdated. >>>> >>>> Bonne chance. >>>> >>>> - Colin >>>> On 6/16/20 9:59 AM, Alexandre Galmiche wrote: >>>> >>>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>> QuickFIX/J Support: http://www.quickfixj.org/support/ >>>> >>>> >>>> Tables are empty and no error message >>>> >>>> >>>> >>>> >>>> *Alexandre GALMICHE - Développeur* >>>> >>>> *Salamander* >>>> >>>> aga...@sa... | http://www.salamander-soft.com >>>> >>>> >>>> Le mar. 16 juin 2020 à 19:01, Philip Whitehouse <ph...@wh...> a >>>> écrit : >>>> >>>>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> >>>>> Support: http://www.quickfixj.org/support/ >>>>> >>>>> >>>>> What happens when you try it? >>>>> >>>>> Best, >>>>> >>>>> Philip Whitehouse >>>>> >>>>> > On 16 Jun 2020, at 15:47, Alexandre GALMICHE < >>>>> aga...@sa...> wrote: >>>>> > >>>>> > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>>> > QuickFIX/J Support: http://www.quickfixj.org/support/ >>>>> > >>>>> > >>>>> > Hi, >>>>> > >>>>> > I'm trying to make QFJ an oracle working together : >>>>> > >>>>> > - QFJ 2.1.1 (basic installation) >>>>> > >>>>> > - Oracle 11.2.0.4 >>>>> > >>>>> > >>>>> > - Added ojdbc6.jar and proxool-0.9.1.jar >>>>> > >>>>> > - create the event_log, messages_log, sessions and messages tables >>>>> (+ sequences + trigger to fill the id for messages_log and event_log) >>>>> > >>>>> > >>>>> > My settings are : >>>>> > >>>>> > ## Oracle config >>>>> > JdbcDriver=oracle.jdbc.driver.OracleDriver >>>>> > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE >>>>> > JdbcUser=ORACLEMAN >>>>> > JdbcPassword=ORACLEMAN >>>>> > JdbcSessionIdDefaultPropertyValue=n/a >>>>> > >>>>> > >>>>> > Did I miss something ? >>>>> > >>>>> > Thanks ! >>>>> > >>>>> > >>>>> > >>>>> > _______________________________________________ >>>>> > Quickfixj-users mailing list >>>>> > Qui...@li... >>>>> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Quickfixj-users mailing list >>>>> Qui...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>>> >>>> >>>> >>>> _______________________________________________ >>>> Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>> >>>> -- >>>> Colin DuPlantis >>>> Chief Architect, Marketcetera >>>> Download, Run, Trade >>>> 888.868.4884https://www.marketcetera.com >>>> >>>> _______________________________________________ >>>> Quickfixj-users mailing list >>>> Qui...@li... >>>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>> >>> _______________________________________________ >>> Quickfixj-users mailing list >>> Qui...@li... >>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>> >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >> > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > -- Grant Birchmeier *Connamara Systems, LLC* *Made-To-Measure Trading Solutions.* Exactly what you need. No more. No less. http://connamara.com -- This email, along with any attachments, is confidential. If you believe you received this message in error, please contact the sender immediately and delete all copies of the message. Thank you from Connamara Systems, LLC. |
|
From: Alexandre G. <aga...@sa...> - 2020-06-18 14:02:44
|
@Colin, I didn't miss Grant suggestions, but it is not working too. @Christoph, thanks for the link. I already read this section :-( . And no error message. I'll try to find something by tomorrow, after that I will install MySQL and make an ODBC connection , which is not the prettiest configuration (disappointment). Cheers ! *Alexandre GALMICHE - Développeur* *Salamander* aga...@sa... | http://www.salamander-soft.com Le jeu. 18 juin 2020 à 16:41, Colin DuPlantis <co...@ma...> a écrit : > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > It looks like you're missing the configuration setting recommended by > Grant. > > On Thu, Jun 18, 2020, 5:25 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/ >> >> >> Hi, >> Still working on this issue. >> The pb is not related to oracle database, proxool and connections. I >> tried this simple script and it worked : >> $ more testjdbc.java >> import java.sql.Connection; >> import java.sql.ResultSet; >> import java.sql.Statement; >> >> import org.logicalcobwebs.proxool.ProxoolDataSource; >> >> >> public class testjdbc { >> public static void main(String[] args) { >> >> Connection con = null; >> Statement st = null; >> ResultSet rs = null; >> >> try { >> ProxoolDataSource ds = new ProxoolDataSource(); >> ds.setDriver("oracle.jdbc.OracleDriver"); >> ds.setDriverUrl("jdbc:oracle:thin:@localhost:1521:XE"); >> ds.setUser("xxx"); >> ds.setPassword("xxx"); >> ds.setMinimumConnectionCount(5); >> ds.setMaximumConnectionCount(10); >> >> con = ds.getConnection(); >> st = con.createStatement(); >> rs = st.executeQuery("select sysdate from dual"); >> >> System.out.println("Value"); >> System.out.println("-------"); >> while(rs.next()){ >> System.out.print(rs.getString("SYSDATE")+"\t"); >> } >> } catch (Exception e){ >> e.printStackTrace(); >> } finally{ >> try { >> rs.close(); >> st.close(); >> con.close(); >> } >> catch (Exception e){ >> e.printStackTrace(); >> } >> >> } >> } >> } >> >> My tables are OK : >> SQL> desc messages >> Nom NULL ? Type >> ----------------------------------------- -------- >> ---------------------------- >> BEGINSTRING NOT NULL VARCHAR2(8) >> SENDERCOMPID NOT NULL VARCHAR2(64) >> SENDERSUBID NOT NULL VARCHAR2(64) >> SENDERLOCID NOT NULL VARCHAR2(64) >> TARGETCOMPID NOT NULL VARCHAR2(64) >> TARGETSUBID NOT NULL VARCHAR2(64) >> TARGETLOCID NOT NULL VARCHAR2(64) >> SESSION_QUALIFIER NOT NULL VARCHAR2(64) >> MSGSEQNUM NOT NULL NUMBER(38) >> MESSAGE NOT NULL VARCHAR2(4000) >> >> SQL> desc sessions >> Nom NULL ? Type >> ----------------------------------------- -------- >> ---------------------------- >> BEGINSTRING NOT NULL VARCHAR2(8) >> SENDERCOMPID NOT NULL VARCHAR2(64) >> SENDERSUBID NOT NULL VARCHAR2(64) >> SENDERLOCID NOT NULL VARCHAR2(64) >> TARGETCOMPID NOT NULL VARCHAR2(64) >> TARGETSUBID NOT NULL VARCHAR2(64) >> TARGETLOCID NOT NULL VARCHAR2(64) >> SESSION_QUALIFIER NOT NULL VARCHAR2(64) >> CREATION_TIME NOT NULL TIMESTAMP(6) >> INCOMING_SEQNUM NOT NULL NUMBER(38) >> OUTGOING_SEQNUM NOT NULL NUMBER(38) >> >> SQL> >> >> >> I added >> >> JdbcStoreSessionsTableName=sessions >> JdbcStoreMessagesTableName=messages >> JdbcLogEventTable=event_log >> JdbcLogOutgoingTable=messages_log >> JdbcLogIncomingTable=messages_log >> in the cfg file >> >> >> I'm still facing the issue. >> >> >> >> >> *Alexandre GALMICHE - Développeur* >> >> *Salamander* >> >> aga...@sa... | http://www.salamander-soft.com >> >> >> Le mar. 16 juin 2020 à 22:17, Colin DuPlantis <co...@ma...> a >> écrit : >> >>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: >>> http://www.quickfixj.org/support/ >>> >>> >>> We had a problem integrating with Oracle, though it was some years ago >>> now. I forget the details. It was with an older version of QFJ, 1.6.x, >>> IIRC. There were several problems: >>> >>> 1) Getting the right version of ojdbc (though I think you've got that >>> right) >>> 2) Significant Oracle-related weirdness related to the JDBC connection >>> string and Oracle using SIDs or not, or whatever Oracle does. We had to >>> create a very bizarre JDBC URL e.g: metc.fix.jdbc.url=jdbc:oracle:thin:@ >>> (DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1545)(HOST=yourhost))(CONNECT_DATA=(SERVICE_NAME=yourservice))) >>> 3) There was some name-collision problem that required us to >>> additionally define JDBCStoreMessagesTableName and >>> JDBCStoreSessionsTableName in the QFJ config. I can't remember the details, >>> sorry. >>> >>> So, in conclusion, Oracle is ridiculously complicated (IMO) and required >>> a lot of fiddling. There is often an Oracle DBA chained to one of their >>> giant boxes who may be able to help with the JDBC URL thing, if that's what >>> it is. >>> >>> I've attached the SQL we used to create the tables, in case that helps. >>> Like I said, this was with an old version, so might be outdated. >>> >>> Bonne chance. >>> >>> - Colin >>> On 6/16/20 9:59 AM, Alexandre Galmiche wrote: >>> >>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>> QuickFIX/J Support: http://www.quickfixj.org/support/ >>> >>> >>> Tables are empty and no error message >>> >>> >>> >>> >>> *Alexandre GALMICHE - Développeur* >>> >>> *Salamander* >>> >>> aga...@sa... | http://www.salamander-soft.com >>> >>> >>> Le mar. 16 juin 2020 à 19:01, Philip Whitehouse <ph...@wh...> a >>> écrit : >>> >>>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> >>>> Support: http://www.quickfixj.org/support/ >>>> >>>> >>>> What happens when you try it? >>>> >>>> Best, >>>> >>>> Philip Whitehouse >>>> >>>> > On 16 Jun 2020, at 15:47, Alexandre GALMICHE < >>>> aga...@sa...> wrote: >>>> > >>>> > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>>> > QuickFIX/J Support: http://www.quickfixj.org/support/ >>>> > >>>> > >>>> > Hi, >>>> > >>>> > I'm trying to make QFJ an oracle working together : >>>> > >>>> > - QFJ 2.1.1 (basic installation) >>>> > >>>> > - Oracle 11.2.0.4 >>>> > >>>> > >>>> > - Added ojdbc6.jar and proxool-0.9.1.jar >>>> > >>>> > - create the event_log, messages_log, sessions and messages tables (+ >>>> sequences + trigger to fill the id for messages_log and event_log) >>>> > >>>> > >>>> > My settings are : >>>> > >>>> > ## Oracle config >>>> > JdbcDriver=oracle.jdbc.driver.OracleDriver >>>> > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE >>>> > JdbcUser=ORACLEMAN >>>> > JdbcPassword=ORACLEMAN >>>> > JdbcSessionIdDefaultPropertyValue=n/a >>>> > >>>> > >>>> > Did I miss something ? >>>> > >>>> > Thanks ! >>>> > >>>> > >>>> > >>>> > _______________________________________________ >>>> > Quickfixj-users mailing list >>>> > Qui...@li... >>>> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>> >>>> >>>> >>>> _______________________________________________ >>>> Quickfixj-users mailing list >>>> Qui...@li... >>>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>>> >>> >>> >>> _______________________________________________ >>> Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users >>> >>> -- >>> Colin DuPlantis >>> Chief Architect, Marketcetera >>> Download, Run, Trade >>> 888.868.4884https://www.marketcetera.com >>> >>> _______________________________________________ >>> Quickfixj-users mailing list >>> Qui...@li... >>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>> >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >> > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > |
|
From: Christoph J. <chr...@ma...> - 2020-06-18 13:41:15
|
Hi, which version of QFJ are you using? IMHO this should be fixed since version 2.0.0 or 2.1.0. Or I am confusing this with some other error... What is your session config? Cheers, Chris. On 18.06.20 15:36, Nenge Masoya wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > > Hello Devs, > > I am still facing the issues in reading messages returned from other party (server) which is > using FIX.5.0SP2.... this is my errors message from events logs > > 20200617-14:19:45: Session FIXT.1.1:CLIENT->SERVER schedule is daily, 00:00:00-UTC - 22:50:00-UTC > 20200617-14:19:45: Created session: FIXT.1.1:CLIENT->SERVER > 20200617-14:19:45: Configured socket addresses for session: [/"server-address here"] > 20200617-14:19:45: MINA session created: local=/192.168.91.98:39322 <http://192.168.91.98:39322>, > class org.apache.mina.transport.socket.nio.NioSocketSession, remote=/"server-address here" > 20200617-14:19:46: Initiated logon request > 20200617-14:19:46: Invalid message: Can't determine ApplVerID from message 8=FIXT.1.1 9=65 35=2 > 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 16=0 10=149 > 20200617-14:19:46: Setting DefaultApplVerID (1137=8) from Logon > 20200617-14:19:46: Error during message processing > quickfix.RuntimeError: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to > quickfix.fix50sp2.Message > at quickfix.Session.next(Session.java:1157) > at quickfix.Session.next(Session.java:1204) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to > quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > ... 4 more > Cause: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message > java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message > at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) > at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) > at quickfix.Session.fromCallback(Session.java:1845) > at quickfix.Session.verify(Session.java:1791) > at quickfix.Session.nextLogon(Session.java:2129) > at quickfix.Session.next(Session.java:1026) > at quickfix.Session.next(Session.java:1204) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) > at > quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) > at java.lang.Thread.run(Thread.java:748) > > I tried to follow the reference provided here here no success.. > https://stackoverflow.com/questions/30074850/quickfix-message-cannot-be-cast-to-quickfix-fix50sp2-message > > > And this is my log messages > > 8=FIXT.1.1 9=75 35=A 34=2 49=CLIENT 52=20200617-14:19:46.103 56=SERVER 98=0 108=30 1137=9 10=139 > 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 16=0 10=149 > 8=FIXT.1.1 9=112 35=A 34=2 49=SERVER 52=20200617-14:21:08.242 56=CLIENT 58=Logon Successful. 98=0 > 108=60 553=STT 554=SERVER 1137=8 10=117 > > > Any one with the help will be appreciated guys... It make me mad for sure! > > Thanks > > Nenge > > > On Tue, Jun 2, 2020 at 6:47 PM Colin DuPlantis <co...@ma... > <mailto:co...@ma...>> wrote: > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > What do you mean by "response data"? Do you mean messages returned by the other party? If so, > those will be received in your Application implementation in fromApp. > > On 6/2/20 5:56 AM, Nenge Masoya wrote: >> QuickFIX/J Documentation:http://www.quickfixj.org/documentation/ >> QuickFIX/J Support:http://www.quickfixj.org/support/ >> >> >> >> Dear team, >> >> I am new with quickfixJ and I Im kindy requesting your help on this, from what I see the >> response of client QuickFixJTemplate when sending message is boolean which tells whether the >> message was successful delivered or not. >> >> For instance, >> >> @Autowired >> private QuickFixJTemplate clientQuickFixJTemplate; >> >> //send message >> >> boolean send = clientQuickFixJTemplate.send(fixMessage, sessionID); >> Now, how can I get response data for further implementation? >> >> Thank in advance. >> >> Nenge Masoya >> >> >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... <mailto:Qui...@li...> >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users > > -- > Colin DuPlantis > Chief Architect, Marketcetera > Download, Run, Trade > 888.868.4884 > https://www.marketcetera.com > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... <mailto:Qui...@li...> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users -- Christoph John Software Engineering T +49 241 557080-28 chr...@ma... MACD GmbH Oppenhoffallee 103 52066 Aachen, Germany www.macd.com Amtsgericht Aachen: HRB 8151 Ust.-Id: DE 813021663 Geschäftsführer: George Macdonald |
|
From: Nenge M. <geo...@gm...> - 2020-06-18 13:35:11
|
Hello Devs, I am still facing the issues in reading messages returned from other party (server) which is using FIX.5.0SP2.... this is my errors message from events logs 20200617-14:19:45: Session FIXT.1.1:CLIENT->SERVER schedule is daily, 00:00:00-UTC - 22:50:00-UTC 20200617-14:19:45: Created session: FIXT.1.1:CLIENT->SERVER 20200617-14:19:45: Configured socket addresses for session: [/"server-address here"] 20200617-14:19:45: MINA session created: local=/192.168.91.98:39322, class org.apache.mina.transport.socket.nio.NioSocketSession, remote=/"server-address here" 20200617-14:19:46: Initiated logon request 20200617-14:19:46: Invalid message: Can't determine ApplVerID from message 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 16=0 10=149 20200617-14:19:46: Setting DefaultApplVerID (1137=8) from Logon 20200617-14:19:46: Error during message processing quickfix.RuntimeError: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message at quickfix.Session.next(Session.java:1157) at quickfix.Session.next(Session.java:1204) at quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) at quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) at quickfix.Session.fromCallback(Session.java:1845) at quickfix.Session.verify(Session.java:1791) at quickfix.Session.nextLogon(Session.java:2129) at quickfix.Session.next(Session.java:1026) ... 4 more Cause: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message java.lang.ClassCastException: quickfix.fixt11.Logon cannot be cast to quickfix.fix50sp2.Message at quickfix.fix50sp2.MessageCracker.crack(MessageCracker.java:1446) at tz.go.mtp.ats.ClientApplicationAdapter.fromAdmin(ClientApplicationAdapter.java:68) at quickfix.Session.fromCallback(Session.java:1845) at quickfix.Session.verify(Session.java:1791) at quickfix.Session.nextLogon(Session.java:2129) at quickfix.Session.next(Session.java:1026) at quickfix.Session.next(Session.java:1204) at quickfix.mina.ThreadPerSessionEventHandlingStrategy$MessageDispatchingThread.doRun(ThreadPerSessionEventHandlingStrategy.java:214) at quickfix.mina.ThreadPerSessionEventHandlingStrategy$ThreadAdapter.run(ThreadPerSessionEventHandlingStrategy.java:142) at java.lang.Thread.run(Thread.java:748) I tried to follow the reference provided here here no success.. https://stackoverflow.com/questions/30074850/quickfix-message-cannot-be-cast-to-quickfix-fix50sp2-message And this is my log messages 8=FIXT.1.1 9=75 35=A 34=2 49=CLIENT 52=20200617-14:19:46.103 56=SERVER 98=0 108=30 1137=9 10=139 8=FIXT.1.1 9=65 35=2 34=1 49=SERVER 52=20200617-14:21:08.234 56=CLIENT 7=1 16=0 10=149 8=FIXT.1.1 9=112 35=A 34=2 49=SERVER 52=20200617-14:21:08.242 56=CLIENT 58=Logon Successful. 98=0 108=60 553=STT 554=SERVER 1137=8 10=117 Any one with the help will be appreciated guys... It make me mad for sure! Thanks Nenge On Tue, Jun 2, 2020 at 6:47 PM Colin DuPlantis <co...@ma...> wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > What do you mean by "response data"? Do you mean messages returned by the > other party? If so, those will be received in your Application > implementation in fromApp. > On 6/2/20 5:56 AM, Nenge Masoya wrote: > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > Dear team, > > I am new with quickfixJ and I Im kindy requesting your help on this, from > what I see the response of client QuickFixJTemplate when sending message is > boolean which tells whether the message was successful delivered or not. > > For instance, > > @Autowired > private QuickFixJTemplate clientQuickFixJTemplate; > > //send message > > boolean send = clientQuickFixJTemplate.send(fixMessage, sessionID); > > Now, how can I get response data for further implementation? > > Thank in advance. > > Nenge Masoya > > > _______________________________________________ > Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users > > -- > Colin DuPlantis > Chief Architect, Marketcetera > Download, Run, Trade > 888.868.4884https://www.marketcetera.com > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > |
|
From: Colin D. <co...@ma...> - 2020-06-18 12:40:48
|
It looks like you're missing the configuration setting recommended by Grant. On Thu, Jun 18, 2020, 5:25 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/ > > > Hi, > Still working on this issue. > The pb is not related to oracle database, proxool and connections. I tried > this simple script and it worked : > $ more testjdbc.java > import java.sql.Connection; > import java.sql.ResultSet; > import java.sql.Statement; > > import org.logicalcobwebs.proxool.ProxoolDataSource; > > > public class testjdbc { > public static void main(String[] args) { > > Connection con = null; > Statement st = null; > ResultSet rs = null; > > try { > ProxoolDataSource ds = new ProxoolDataSource(); > ds.setDriver("oracle.jdbc.OracleDriver"); > ds.setDriverUrl("jdbc:oracle:thin:@localhost:1521:XE"); > ds.setUser("xxx"); > ds.setPassword("xxx"); > ds.setMinimumConnectionCount(5); > ds.setMaximumConnectionCount(10); > > con = ds.getConnection(); > st = con.createStatement(); > rs = st.executeQuery("select sysdate from dual"); > > System.out.println("Value"); > System.out.println("-------"); > while(rs.next()){ > System.out.print(rs.getString("SYSDATE")+"\t"); > } > } catch (Exception e){ > e.printStackTrace(); > } finally{ > try { > rs.close(); > st.close(); > con.close(); > } > catch (Exception e){ > e.printStackTrace(); > } > > } > } > } > > My tables are OK : > SQL> desc messages > Nom NULL ? Type > ----------------------------------------- -------- > ---------------------------- > BEGINSTRING NOT NULL VARCHAR2(8) > SENDERCOMPID NOT NULL VARCHAR2(64) > SENDERSUBID NOT NULL VARCHAR2(64) > SENDERLOCID NOT NULL VARCHAR2(64) > TARGETCOMPID NOT NULL VARCHAR2(64) > TARGETSUBID NOT NULL VARCHAR2(64) > TARGETLOCID NOT NULL VARCHAR2(64) > SESSION_QUALIFIER NOT NULL VARCHAR2(64) > MSGSEQNUM NOT NULL NUMBER(38) > MESSAGE NOT NULL VARCHAR2(4000) > > SQL> desc sessions > Nom NULL ? Type > ----------------------------------------- -------- > ---------------------------- > BEGINSTRING NOT NULL VARCHAR2(8) > SENDERCOMPID NOT NULL VARCHAR2(64) > SENDERSUBID NOT NULL VARCHAR2(64) > SENDERLOCID NOT NULL VARCHAR2(64) > TARGETCOMPID NOT NULL VARCHAR2(64) > TARGETSUBID NOT NULL VARCHAR2(64) > TARGETLOCID NOT NULL VARCHAR2(64) > SESSION_QUALIFIER NOT NULL VARCHAR2(64) > CREATION_TIME NOT NULL TIMESTAMP(6) > INCOMING_SEQNUM NOT NULL NUMBER(38) > OUTGOING_SEQNUM NOT NULL NUMBER(38) > > SQL> > > > I added > > JdbcStoreSessionsTableName=sessions > JdbcStoreMessagesTableName=messages > JdbcLogEventTable=event_log > JdbcLogOutgoingTable=messages_log > JdbcLogIncomingTable=messages_log > in the cfg file > > > I'm still facing the issue. > > > > > *Alexandre GALMICHE - Développeur* > > *Salamander* > > aga...@sa... | http://www.salamander-soft.com > > > Le mar. 16 juin 2020 à 22:17, Colin DuPlantis <co...@ma...> a > écrit : > >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: >> http://www.quickfixj.org/support/ >> >> >> We had a problem integrating with Oracle, though it was some years ago >> now. I forget the details. It was with an older version of QFJ, 1.6.x, >> IIRC. There were several problems: >> >> 1) Getting the right version of ojdbc (though I think you've got that >> right) >> 2) Significant Oracle-related weirdness related to the JDBC connection >> string and Oracle using SIDs or not, or whatever Oracle does. We had to >> create a very bizarre JDBC URL e.g: metc.fix.jdbc.url=jdbc:oracle:thin:@ >> (DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1545)(HOST=yourhost))(CONNECT_DATA=(SERVICE_NAME=yourservice))) >> 3) There was some name-collision problem that required us to additionally >> define JDBCStoreMessagesTableName and JDBCStoreSessionsTableName in the QFJ >> config. I can't remember the details, sorry. >> >> So, in conclusion, Oracle is ridiculously complicated (IMO) and required >> a lot of fiddling. There is often an Oracle DBA chained to one of their >> giant boxes who may be able to help with the JDBC URL thing, if that's what >> it is. >> >> I've attached the SQL we used to create the tables, in case that helps. >> Like I said, this was with an old version, so might be outdated. >> >> Bonne chance. >> >> - Colin >> On 6/16/20 9:59 AM, Alexandre Galmiche wrote: >> >> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >> QuickFIX/J Support: http://www.quickfixj.org/support/ >> >> >> Tables are empty and no error message >> >> >> >> >> *Alexandre GALMICHE - Développeur* >> >> *Salamander* >> >> aga...@sa... | http://www.salamander-soft.com >> >> >> Le mar. 16 juin 2020 à 19:01, Philip Whitehouse <ph...@wh...> a >> écrit : >> >>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: >>> http://www.quickfixj.org/support/ >>> >>> >>> What happens when you try it? >>> >>> Best, >>> >>> Philip Whitehouse >>> >>> > On 16 Jun 2020, at 15:47, Alexandre GALMICHE < >>> aga...@sa...> wrote: >>> > >>> > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ >>> > QuickFIX/J Support: http://www.quickfixj.org/support/ >>> > >>> > >>> > Hi, >>> > >>> > I'm trying to make QFJ an oracle working together : >>> > >>> > - QFJ 2.1.1 (basic installation) >>> > >>> > - Oracle 11.2.0.4 >>> > >>> > >>> > - Added ojdbc6.jar and proxool-0.9.1.jar >>> > >>> > - create the event_log, messages_log, sessions and messages tables (+ >>> sequences + trigger to fill the id for messages_log and event_log) >>> > >>> > >>> > My settings are : >>> > >>> > ## Oracle config >>> > JdbcDriver=oracle.jdbc.driver.OracleDriver >>> > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE >>> > JdbcUser=ORACLEMAN >>> > JdbcPassword=ORACLEMAN >>> > JdbcSessionIdDefaultPropertyValue=n/a >>> > >>> > >>> > Did I miss something ? >>> > >>> > Thanks ! >>> > >>> > >>> > >>> > _______________________________________________ >>> > Quickfixj-users mailing list >>> > Qui...@li... >>> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>> >>> >>> >>> _______________________________________________ >>> Quickfixj-users mailing list >>> Qui...@li... >>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >>> >> >> >> _______________________________________________ >> Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users >> >> -- >> Colin DuPlantis >> Chief Architect, Marketcetera >> Download, Run, Trade >> 888.868.4884https://www.marketcetera.com >> >> _______________________________________________ >> Quickfixj-users mailing list >> Qui...@li... >> https://lists.sourceforge.net/lists/listinfo/quickfixj-users >> > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > |
|
From: Christoph J. <chr...@ma...> - 2020-06-18 12:34:13
|
Don't know if it applies to you, but did you read this? https://www.quickfixj.org/usermanual/2.1.0/installation.html#oracle So you don't have any error messages? Do you have event messages in your log at all? Try to use a file log and only use DB for messages. Does this yield any error messages? Cheers, Chris. On 18.06.20 14:18, Alexandre Galmiche wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > > Hi, > Still working on this issue. > The pb is not related to oracle database, proxool and connections. I tried this simple script and > it worked : > $ more testjdbc.java > import java.sql.Connection; > import java.sql.ResultSet; > import java.sql.Statement; > > import org.logicalcobwebs.proxool.ProxoolDataSource; > > > public class testjdbc { > public static void main(String[] args) { > > Connection con = null; > Statement st = null; > ResultSet rs = null; > > try { > ProxoolDataSource ds = new ProxoolDataSource(); > ds.setDriver("oracle.jdbc.OracleDriver"); > ds.setDriverUrl("jdbc:oracle:thin:@localhost:1521:XE"); > ds.setUser("xxx"); > ds.setPassword("xxx"); > ds.setMinimumConnectionCount(5); > ds.setMaximumConnectionCount(10); > > con = ds.getConnection(); > st = con.createStatement(); > rs = st.executeQuery("select sysdate from dual"); > > System.out.println("Value"); > System.out.println("-------"); > while(rs.next()){ > System.out.print(rs.getString("SYSDATE")+"\t"); > } > } catch (Exception e){ > e.printStackTrace(); > } finally{ > try { > rs.close(); > st.close(); > con.close(); > } > catch (Exception e){ > e.printStackTrace(); > } > > } > } > } > > My tables are OK : > SQL> desc messages > Nom NULL ? Type > ----------------------------------------- -------- ---------------------------- > BEGINSTRING NOT NULL VARCHAR2(8) > SENDERCOMPID NOT NULL VARCHAR2(64) > SENDERSUBID NOT NULL VARCHAR2(64) > SENDERLOCID NOT NULL VARCHAR2(64) > TARGETCOMPID NOT NULL VARCHAR2(64) > TARGETSUBID NOT NULL VARCHAR2(64) > TARGETLOCID NOT NULL VARCHAR2(64) > SESSION_QUALIFIER NOT NULL VARCHAR2(64) > MSGSEQNUM NOT NULL NUMBER(38) > MESSAGE NOT NULL VARCHAR2(4000) > > SQL> desc sessions > Nom NULL ? Type > ----------------------------------------- -------- ---------------------------- > BEGINSTRING NOT NULL VARCHAR2(8) > SENDERCOMPID NOT NULL VARCHAR2(64) > SENDERSUBID NOT NULL VARCHAR2(64) > SENDERLOCID NOT NULL VARCHAR2(64) > TARGETCOMPID NOT NULL VARCHAR2(64) > TARGETSUBID NOT NULL VARCHAR2(64) > TARGETLOCID NOT NULL VARCHAR2(64) > SESSION_QUALIFIER NOT NULL VARCHAR2(64) > CREATION_TIME NOT NULL TIMESTAMP(6) > INCOMING_SEQNUM NOT NULL NUMBER(38) > OUTGOING_SEQNUM NOT NULL NUMBER(38) > > SQL> > > > I added > > JdbcStoreSessionsTableName=sessions > JdbcStoreMessagesTableName=messages > JdbcLogEventTable=event_log > JdbcLogOutgoingTable=messages_log > JdbcLogIncomingTable=messages_log > in the cfg file > > > I'm still facing the issue. > > > > > *Alexandre GALMICHE - Développeur* > > */Salamander/* > > aga...@sa... <mailto:aga...@sa...> > |http://www.salamander-soft.com <http://www.salamander-soft.com/> > > -- Christoph John Software Engineering T +49 241 557080-28 chr...@ma... MACD GmbH Oppenhoffallee 103 52066 Aachen, Germany www.macd.com Amtsgericht Aachen: HRB 8151 Ust.-Id: DE 813021663 Geschäftsführer: George Macdonald |
|
From: Alexandre G. <aga...@sa...> - 2020-06-18 12:24:51
|
Hi,
Still working on this issue.
The pb is not related to oracle database, proxool and connections. I tried
this simple script and it worked :
$ more testjdbc.java
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import org.logicalcobwebs.proxool.ProxoolDataSource;
public class testjdbc {
public static void main(String[] args) {
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
ProxoolDataSource ds = new ProxoolDataSource();
ds.setDriver("oracle.jdbc.OracleDriver");
ds.setDriverUrl("jdbc:oracle:thin:@localhost:1521:XE");
ds.setUser("xxx");
ds.setPassword("xxx");
ds.setMinimumConnectionCount(5);
ds.setMaximumConnectionCount(10);
con = ds.getConnection();
st = con.createStatement();
rs = st.executeQuery("select sysdate from dual");
System.out.println("Value");
System.out.println("-------");
while(rs.next()){
System.out.print(rs.getString("SYSDATE")+"\t");
}
} catch (Exception e){
e.printStackTrace();
} finally{
try {
rs.close();
st.close();
con.close();
}
catch (Exception e){
e.printStackTrace();
}
}
}
}
My tables are OK :
SQL> desc messages
Nom NULL ? Type
----------------------------------------- --------
----------------------------
BEGINSTRING NOT NULL VARCHAR2(8)
SENDERCOMPID NOT NULL VARCHAR2(64)
SENDERSUBID NOT NULL VARCHAR2(64)
SENDERLOCID NOT NULL VARCHAR2(64)
TARGETCOMPID NOT NULL VARCHAR2(64)
TARGETSUBID NOT NULL VARCHAR2(64)
TARGETLOCID NOT NULL VARCHAR2(64)
SESSION_QUALIFIER NOT NULL VARCHAR2(64)
MSGSEQNUM NOT NULL NUMBER(38)
MESSAGE NOT NULL VARCHAR2(4000)
SQL> desc sessions
Nom NULL ? Type
----------------------------------------- --------
----------------------------
BEGINSTRING NOT NULL VARCHAR2(8)
SENDERCOMPID NOT NULL VARCHAR2(64)
SENDERSUBID NOT NULL VARCHAR2(64)
SENDERLOCID NOT NULL VARCHAR2(64)
TARGETCOMPID NOT NULL VARCHAR2(64)
TARGETSUBID NOT NULL VARCHAR2(64)
TARGETLOCID NOT NULL VARCHAR2(64)
SESSION_QUALIFIER NOT NULL VARCHAR2(64)
CREATION_TIME NOT NULL TIMESTAMP(6)
INCOMING_SEQNUM NOT NULL NUMBER(38)
OUTGOING_SEQNUM NOT NULL NUMBER(38)
SQL>
I added
JdbcStoreSessionsTableName=sessions
JdbcStoreMessagesTableName=messages
JdbcLogEventTable=event_log
JdbcLogOutgoingTable=messages_log
JdbcLogIncomingTable=messages_log
in the cfg file
I'm still facing the issue.
*Alexandre GALMICHE - Développeur*
*Salamander*
aga...@sa... | http://www.salamander-soft.com
Le mar. 16 juin 2020 à 22:17, Colin DuPlantis <co...@ma...> a
écrit :
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support:
> http://www.quickfixj.org/support/
>
>
> We had a problem integrating with Oracle, though it was some years ago
> now. I forget the details. It was with an older version of QFJ, 1.6.x,
> IIRC. There were several problems:
>
> 1) Getting the right version of ojdbc (though I think you've got that
> right)
> 2) Significant Oracle-related weirdness related to the JDBC connection
> string and Oracle using SIDs or not, or whatever Oracle does. We had to
> create a very bizarre JDBC URL e.g: metc.fix.jdbc.url=jdbc:oracle:thin:@
> (DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1545)(HOST=yourhost))(CONNECT_DATA=(SERVICE_NAME=yourservice)))
> 3) There was some name-collision problem that required us to additionally
> define JDBCStoreMessagesTableName and JDBCStoreSessionsTableName in the QFJ
> config. I can't remember the details, sorry.
>
> So, in conclusion, Oracle is ridiculously complicated (IMO) and required a
> lot of fiddling. There is often an Oracle DBA chained to one of their giant
> boxes who may be able to help with the JDBC URL thing, if that's what it is.
>
> I've attached the SQL we used to create the tables, in case that helps.
> Like I said, this was with an old version, so might be outdated.
>
> Bonne chance.
>
> - Colin
> On 6/16/20 9:59 AM, Alexandre Galmiche wrote:
>
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
>
>
> Tables are empty and no error message
>
>
>
>
> *Alexandre GALMICHE - Développeur*
>
> *Salamander*
>
> aga...@sa... | http://www.salamander-soft.com
>
>
> Le mar. 16 juin 2020 à 19:01, Philip Whitehouse <ph...@wh...> a
> écrit :
>
>> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
>> QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support:
>> http://www.quickfixj.org/support/
>>
>>
>> What happens when you try it?
>>
>> Best,
>>
>> Philip Whitehouse
>>
>> > On 16 Jun 2020, at 15:47, Alexandre GALMICHE <
>> aga...@sa...> wrote:
>> >
>> > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
>> > QuickFIX/J Support: http://www.quickfixj.org/support/
>> >
>> >
>> > Hi,
>> >
>> > I'm trying to make QFJ an oracle working together :
>> >
>> > - QFJ 2.1.1 (basic installation)
>> >
>> > - Oracle 11.2.0.4
>> >
>> >
>> > - Added ojdbc6.jar and proxool-0.9.1.jar
>> >
>> > - create the event_log, messages_log, sessions and messages tables (+
>> sequences + trigger to fill the id for messages_log and event_log)
>> >
>> >
>> > My settings are :
>> >
>> > ## Oracle config
>> > JdbcDriver=oracle.jdbc.driver.OracleDriver
>> > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE
>> > JdbcUser=ORACLEMAN
>> > JdbcPassword=ORACLEMAN
>> > JdbcSessionIdDefaultPropertyValue=n/a
>> >
>> >
>> > Did I miss something ?
>> >
>> > Thanks !
>> >
>> >
>> >
>> > _______________________________________________
>> > Quickfixj-users mailing list
>> > Qui...@li...
>> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>>
>>
>>
>> _______________________________________________
>> Quickfixj-users mailing list
>> Qui...@li...
>> https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>>
>
>
> _______________________________________________
> Quickfixj-users mailing lis...@li...://lists.sourceforge.net/lists/listinfo/quickfixj-users
>
> --
> Colin DuPlantis
> Chief Architect, Marketcetera
> Download, Run, Trade
> 888.868.4884https://www.marketcetera.com
>
> _______________________________________________
> Quickfixj-users mailing list
> Qui...@li...
> https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>
|
|
From: Christoph J. <chr...@ma...> - 2020-06-17 21:39:14
|
Hi, QuickFIX/J 2.2.0 has been released. This release includes bug fixes and improvements. Many thanks to all the people who have contributed to this release (see release notes). Release notes can be found here: https://github.com/quickfix-j/quickfixj/wiki/QFJ-2.2.0-release-notes Release can be downloaded from here: https://github.com/quickfix-j/quickfixj/releases/download/QFJ_RELEASE_2_2_0/org.quickfixj-2.2.0-bin.zip Cheers, Chris. -- Christoph John Software Engineering T +49 241 557080-28 chr...@ma... MACD GmbH Oppenhoffallee 103 52066 Aachen, Germany www.macd.com Amtsgericht Aachen: HRB 8151 Ust.-Id: DE 813021663 Geschäftsführer: George Macdonald |
|
From: Colin D. <co...@ma...> - 2020-06-16 18:17:14
|
We had a problem integrating with Oracle, though it was some years ago now. I forget the details. It was with an older version of QFJ, 1.6.x, IIRC. There were several problems: 1) Getting the right version of ojdbc (though I think you've got that right) 2) Significant Oracle-related weirdness related to the JDBC connection string and Oracle using SIDs or not, or whatever Oracle does. We had to create a very bizarre JDBC URL e.g: metc.fix.jdbc.url=jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1545)(HOST=yourhost))(CONNECT_DATA=(SERVICE_NAME=yourservice))) 3) There was some name-collision problem that required us to additionally define JDBCStoreMessagesTableName and JDBCStoreSessionsTableName in the QFJ config. I can't remember the details, sorry. So, in conclusion, Oracle is ridiculously complicated (IMO) and required a lot of fiddling. There is often an Oracle DBA chained to one of their giant boxes who may be able to help with the JDBC URL thing, if that's what it is. I've attached the SQL we used to create the tables, in case that helps. Like I said, this was with an old version, so might be outdated. Bonne chance. - Colin On 6/16/20 9:59 AM, Alexandre Galmiche wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > > Tables are empty and no error message > > > > > *Alexandre GALMICHE - Développeur* > > */Salamander/* > > aga...@sa... <mailto:aga...@sa...> > |http://www.salamander-soft.com <http://www.salamander-soft.com/> > > > > Le mar. 16 juin 2020 à 19:01, Philip Whitehouse <ph...@wh... > <mailto:ph...@wh...>> a écrit : > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> > Support: http://www.quickfixj.org/support/ > > > What happens when you try it? > > Best, > > Philip Whitehouse > > > On 16 Jun 2020, at 15:47, Alexandre GALMICHE > <aga...@sa... > <mailto:aga...@sa...>> wrote: > > > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > > > > Hi, > > > > I'm trying to make QFJ an oracle working together : > > > > - QFJ 2.1.1 (basic installation) > > > > - Oracle 11.2.0.4 > > > > > > - Added ojdbc6.jar and proxool-0.9.1.jar > > > > - create the event_log, messages_log, sessions and messages > tables (+ sequences + trigger to fill the id for messages_log and > event_log) > > > > > > My settings are : > > > > ## Oracle config > > JdbcDriver=oracle.jdbc.driver.OracleDriver > > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE > > JdbcUser=ORACLEMAN > > JdbcPassword=ORACLEMAN > > JdbcSessionIdDefaultPropertyValue=n/a > > > > > > Did I miss something ? > > > > Thanks ! > > > > > > > > _______________________________________________ > > Quickfixj-users mailing list > > Qui...@li... > <mailto:Qui...@li...> > > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > <mailto:Qui...@li...> > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users -- Colin DuPlantis Chief Architect, Marketcetera Download, Run, Trade 888.868.4884 https://www.marketcetera.com |
|
From: Grant B. <gbi...@co...> - 2020-06-16 18:03:32
|
I have used QF/j with Oracle a loooong time ago. Like, 8 years ago, and only
for the message store, not for the logs. But it did work, and I can't
imagine that it has changed all that much.
Looking at my old configs, these seem to be the only relevant settings that
I used:
JdbcURL=jdbc:oracle:thin:oracleman/password@localhost:1521:XE
# absolutely needed by Oracle
JdbcSessionIdDefaultPropertyValue=n/a
Then I used those values to set up a JdbcStoreFactory:
// existing var "settings" is a SessionSettings object
final JdbcStoreFactory factory = new JdbcStoreFactory(settings);
final Dictionary dict = settings.get();
final String url = dict.getString("JdbcURL");
final OracleConnectionPoolDataSource ds = new
OracleConnectionPoolDataSource();
ds.setURL(url);
factory.setDataSource(ds);
This won't create your tables for you, of course. You need to have those
set up first.
I hope this helps. It was a long time ago, so not sure if I can remember
much more. (Mostly I remember hating Oracle. Hated it so much that I made
my app support MySQL as well, so I could avoid running Oracle in dev/test.)
-Grant
On Tue, Jun 16, 2020 at 9:46 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/
>
>
> Hi,
>
> I'm trying to make QFJ an oracle working together :
>
> - QFJ 2.1.1 (basic installation)
>
> - Oracle 11.2.0.4
>
>
> - Added ojdbc6.jar and proxool-0.9.1.jar
>
> - create the event_log, messages_log, sessions and messages tables (+
> sequences + trigger to fill the id for messages_log and event_log)
>
>
> My settings are :
>
> ## Oracle config
> JdbcDriver=oracle.jdbc.driver.OracleDriver
> JdbcURL=jdbc:oracle:thin:@localhost:1521:XE
> JdbcUser=ORACLEMAN
> JdbcPassword=ORACLEMAN
> JdbcSessionIdDefaultPropertyValue=n/a
>
>
> Did I miss something ?
>
> Thanks !
>
>
>
> _______________________________________________
> Quickfixj-users mailing list
> Qui...@li...
> https://lists.sourceforge.net/lists/listinfo/quickfixj-users
>
--
Grant Birchmeier
*Connamara Systems, LLC*
*Made-To-Measure Trading Solutions.*
Exactly what you need. No more. No less.
http://connamara.com
--
This email, along with any attachments, is confidential. If you believe you
received this message in error, please contact the sender immediately and
delete all copies of the message. Thank you from Connamara Systems, LLC.
|
|
From: Alexandre G. <aga...@sa...> - 2020-06-16 17:31:48
|
Tables are empty and no error message *Alexandre GALMICHE - Développeur* *Salamander* aga...@sa... | http://www.salamander-soft.com Le mar. 16 juin 2020 à 19:01, Philip Whitehouse <ph...@wh...> a écrit : > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > What happens when you try it? > > Best, > > Philip Whitehouse > > > On 16 Jun 2020, at 15:47, Alexandre GALMICHE < > aga...@sa...> wrote: > > > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > > > > Hi, > > > > I'm trying to make QFJ an oracle working together : > > > > - QFJ 2.1.1 (basic installation) > > > > - Oracle 11.2.0.4 > > > > > > - Added ojdbc6.jar and proxool-0.9.1.jar > > > > - create the event_log, messages_log, sessions and messages tables (+ > sequences + trigger to fill the id for messages_log and event_log) > > > > > > My settings are : > > > > ## Oracle config > > JdbcDriver=oracle.jdbc.driver.OracleDriver > > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE > > JdbcUser=ORACLEMAN > > JdbcPassword=ORACLEMAN > > JdbcSessionIdDefaultPropertyValue=n/a > > > > > > Did I miss something ? > > > > Thanks ! > > > > > > > > _______________________________________________ > > Quickfixj-users mailing list > > Qui...@li... > > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > |
|
From: Philip W. <ph...@wh...> - 2020-06-16 15:00:55
|
What happens when you try it? Best, Philip Whitehouse > On 16 Jun 2020, at 15:47, Alexandre GALMICHE <aga...@sa...> wrote: > > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J Support: http://www.quickfixj.org/support/ > > > Hi, > > I'm trying to make QFJ an oracle working together : > > - QFJ 2.1.1 (basic installation) > > - Oracle 11.2.0.4 > > > - Added ojdbc6.jar and proxool-0.9.1.jar > > - create the event_log, messages_log, sessions and messages tables (+ sequences + trigger to fill the id for messages_log and event_log) > > > My settings are : > > ## Oracle config > JdbcDriver=oracle.jdbc.driver.OracleDriver > JdbcURL=jdbc:oracle:thin:@localhost:1521:XE > JdbcUser=ORACLEMAN > JdbcPassword=ORACLEMAN > JdbcSessionIdDefaultPropertyValue=n/a > > > Did I miss something ? > > Thanks ! > > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users |
|
From: Alexandre G. <aga...@sa...> - 2020-06-16 14:46:07
|
Hi, I'm trying to make QFJ an oracle working together : - QFJ 2.1.1 (basic installation) - Oracle 11.2.0.4 - Added ojdbc6.jar and proxool-0.9.1.jar - create the event_log, messages_log, sessions and messages tables (+ sequences + trigger to fill the id for messages_log and event_log) My settings are : ## Oracle config JdbcDriver=oracle.jdbc.driver.OracleDriver JdbcURL=jdbc:oracle:thin:@localhost:1521:XE JdbcUser=ORACLEMAN JdbcPassword=ORACLEMAN JdbcSessionIdDefaultPropertyValue=n/a Did I miss something ? Thanks ! |
|
From: Grant B. <gbi...@co...> - 2020-06-09 19:21:28
|
You're on the wrong mailing list. This list is for QuickFIX/j (the Java port of QuickFIX), but you say you're using QuickFIX/n (the C# port). See quickfixn.org/help for information on QuickFIX/n's mailing list. However, I know this ICE connection that you're using, and UDS is a custom message type that ICE invented. I'd put money down that you did not add this message type to your DataDictionary, therefore your engine doesn't recognize it. See http://quickfixn.org/tutorial/custom-fields-groups-and-messages.html On Tue, Jun 9, 2020 at 12:50 PM Ringbretson <Rin...@ke...> wrote: > QuickFIX/J Documentation: http://www.quickfixj.org/documentation/ > QuickFIX/J <http://www.quickfixj.org/documentation/QuickFIX/J> Support: > http://www.quickfixj.org/support/ > > > I'm having the same issue with Quickfix/n and SecurityRequestType(101). > 8=FIX.4.49=224135=UDS49=ICE34=1252=20200609-14:57:30.324 > Message 12 Rejected: Invalid MsgType > > Can you tell me how you resolved the issue? > > > > > -- > Sent from: http://quickfix-j.364392.n2.nabble.com/ > > > _______________________________________________ > Quickfixj-users mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfixj-users > -- Grant Birchmeier *Connamara Systems, LLC* *Made-To-Measure Trading Solutions.* Exactly what you need. No more. No less. http://connamara.com -- This email, along with any attachments, is confidential. If you believe you received this message in error, please contact the sender immediately and delete all copies of the message. Thank you from Connamara Systems, LLC. |
|
From: Ringbretson <Rin...@ke...> - 2020-06-09 17:50:18
|
I'm having the same issue with Quickfix/n and SecurityRequestType(101). 8=FIX.4.49=224135=UDS49=ICE34=1252=20200609-14:57:30.324 Message 12 Rejected: Invalid MsgType Can you tell me how you resolved the issue? -- Sent from: http://quickfix-j.364392.n2.nabble.com/ |
103 messages has been excluded from this view by a project administrator.
