bildwelt
E2E FORUM
E2E Bridge E2E Commerce

Oracle database-enabled Publish Subscribe Messaging

E2E Forum General Discussion Oracle database-enabled Publish Subscribe Messaging

This topic contains 3 replies, has 3 voices, and was last updated by  Alfred 4 years, 6 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #498

    Christof
    Blocked

    Does the E2E Bridge support the Oracle DB Publish Subscribe Mechanism?
    http://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_pu.htm

    #499

    Marcel R.
    Blocked

    No, we don’t.

    Maybe Oracle provides a JMS client that can connect to their advanced queuing (AQ) infrastructure. If you follow your link above you find a link to their AQ user guide:
    http://docs.oracle.com/cd/B12037_01/server.101/b10785/toc.htm
    There you find links to documentation about AQ JMS clients.

    #500

    Christof
    Blocked

    Ok, thanks.

    For now we’ll keep things simple and use Oracle Stored Procedures to communicate between E2E Bridge and the customer’s Oracle based ERP system.

    However, I have another question in this regard:

    Our plan is to define a stored procedure that accepts a CLOB data-structure as input. This CLOB will contain an XML message. Now this XML Message can potentially grow quite big: some 10-50MB would not be surprising. The number of calls will be very low (e.g. 1 per week) and the throughput time is not critical.

    Are there any problems foreseeable, or is it worth a try?

    #502

    Alfred
    Moderator

    I see no problem with a message size of 10-50 MB because the limit of the current implementation is that the message must fit into the main memory and this should work with 50 MB.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.