Menu
▾
▴
Re: [Quickfixj-users] QuickFix/J and oracle
|
From: Alexandre G. <aga...@sa...> - 2020-06-18 12:24:51
|
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
>
|
