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

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

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
>