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

[Alexandre G. <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
>