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

[Grant B. <gbi...@co...>]

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.