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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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.