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

[Colin D. <co...@ma...>]

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