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