2 Replies Latest reply on Oct 31, 2012 8:27 AM by user11243772

    OSB JCA Adapter performance issue


      We have to use OSB as an ESB at integration level which need to populate the result from local services e.g. from DB as well as from external services. Actually we need to use switch [split -join] and connector [individual proxy for individual services] features.

      As for external services, we do not have questions but to access data from local system e.g. Database, whether it will be a performance issue in OSB, in case if we are using JCA Adapter and exposing it as a service? Because some one objected that accessing JCA layer in OSB will be a performance issue.

      If some one can shed the light on it, it will be great.

      Thanks & Regards,

      V D
        • 1. Re: OSB JCA Adapter performance issue

          Have a look at the Developer Guide for OSB... Oracle JCA Adapter for Database is supported... Have a look at the limitations, there's nothing mentioning performance...

          Also have a look at the following blogs... One of them even suggests that jca performs better than xquery with fn-bea:execute-sql...

          If you are still in doubt open a SR with Oracle Support...

          Hope this helps...

          • 2. Re: OSB JCA Adapter performance issue
            Thanks for your reply.

            The conern more is if there is finegrained call to the DB from OSB? other wise we may need to use stored procedure to make coarsegrained.
            And also to make this call to DB, some business decision need to happen which eventually will be in OSB onlly.