JdbcStore with acceptor

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

JdbcStore with acceptor

Diana Susca
QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/



Hi,

I'm trying to create an acceptor using JdbcStore with1.6.2  - we need the application to recover in case of failure.
The problem is, as per the documentation (http://www.quickfixj.org/quickfixj/usermanual/1.5.1/installation.html#oracle) I cannot have a null "SESSION_QUALIFIER".
But also, per documentation (http://www.quickfixj.org/quickfixj/usermanual/1.5.1/usage/configuration.html), the field SessionQualifier can only be used with initiator sessions.

So, as you imagine, I get all kinds of errors when the application starts.

What is the 'official' solution to this issue? I looked it up on google, and mostly people choose to remove the field from the PK.


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Quickfixj-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quickfixj-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: JdbcStore with acceptor

Christoph John
QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/


Did you try JdbcSessionIdDefaultPropertyValue? It is also listed on the configuration page and
sounds like it could be helpful.
"The default value for Session ID bean properties is an empty string. Oracle treats this as a SQL
NULL and that causes problems. This configuration setting allows you to set the default value for
unspecified Session ID properties."

Regards,
Chris.


On 13/02/17 13:41, Diana Susca wrote:

> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
>
>
>
>
> Hi,
>
> I'm trying to create an acceptor using JdbcStore with1.6.2  - we need the application to recover
> in case of failure.
> The problem is, as per the documentation
> (http://www.quickfixj.org/quickfixj/usermanual/1.5.1/installation.html#oracle) I cannot have a
> null "SESSION_QUALIFIER".
> But also, per documentation
> (http://www.quickfixj.org/quickfixj/usermanual/1.5.1/usage/configuration.html), the field
> /SessionQualifier /can only be used with initiator sessions.
>
> So, as you imagine, I get all kinds of errors when the application starts.
>
> What is the 'official' solution to this issue? I looked it up on google, and mostly people choose
> to remove the field from the PK.
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Quickfixj-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quickfixj-users

--
Christoph John
Development & Support
Direct: +49 241 557080-28
Mailto:[hidden email]
       


http://www.macd.com <http://www.macd.com/>
----------------------------------------------------------------------------------------------------
       
----------------------------------------------------------------------------------------------------
MACD GmbH
Oppenhoffallee 103
D-52066 Aachen
Tel: +49 241 557080-0 | Fax: +49 241 557080-10
         Amtsgericht Aachen: HRB 8151
Ust.-Id: DE 813021663

Geschäftsführer: George Macdonald
----------------------------------------------------------------------------------------------------
       
----------------------------------------------------------------------------------------------------

take care of the environment - print only if necessary

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Quickfixj-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quickfixj-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: JdbcStore with acceptor

Diana Susca
QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/



Thank you, it worked.
Using the JdbcSessionIdDefaultPropertyValue property, it was no longer necessary to adjust the Oracle tables.

Regards,
Diana



On Mon, Feb 13, 2017 at 3:23 PM, Christoph John <[hidden email]> wrote:
QuickFIX/J Documentation: <a href="http://www.quickfixj.org/documentation/ QuickFIX/J" rel="noreferrer" target="_blank">http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/


Did you try JdbcSessionIdDefaultPropertyValue? It is also listed on the configuration page and
sounds like it could be helpful.
"The default value for Session ID bean properties is an empty string. Oracle treats this as a SQL
NULL and that causes problems. This configuration setting allows you to set the default value for
unspecified Session ID properties."

Regards,
Chris.


On 13/02/17 13:41, Diana Susca wrote:
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
>
>
>
>
> Hi,
>
> I'm trying to create an acceptor using JdbcStore with1.6.2  - we need the application to recover
> in case of failure.
> The problem is, as per the documentation
> (http://www.quickfixj.org/quickfixj/usermanual/1.5.1/installation.html#oracle) I cannot have a
> null "SESSION_QUALIFIER".
> But also, per documentation
> (http://www.quickfixj.org/quickfixj/usermanual/1.5.1/usage/configuration.html), the field
> /SessionQualifier /can only be used with initiator sessions.
>
> So, as you imagine, I get all kinds of errors when the application starts.
>
> What is the 'official' solution to this issue? I looked it up on google, and mostly people choose
> to remove the field from the PK.
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Quickfixj-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quickfixj-users

--
Christoph John
Development & Support
Direct: <a href="tel:%2B49%20241%20557080-28" value="+4924155708028">+49 241 557080-28
Mailto:[hidden email]



http://www.macd.com <http://www.macd.com/>
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
MACD GmbH
Oppenhoffallee 103
D-52066 Aachen
Tel: <a href="tel:%2B49%20241%20557080-0" value="+492415570800">+49 241 557080-0 | Fax: <a href="tel:%2B49%20241%20557080-10" value="+4924155708010">+49 241 557080-10
         Amtsgericht Aachen: HRB 8151
Ust.-Id: DE 813021663

Geschäftsführer: George Macdonald
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

take care of the environment - print only if necessary

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Quickfixj-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quickfixj-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Quickfixj-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quickfixj-users
Loading...