PaaS Partner Community

  • August 12, 2014

Using Oracle’s Edition-Based Redefinition to support multiple SOA Suite revisions with the database adapter by Betty van Dongen

Juergen Kress
PaaS Partner Adoption

SOA_EBRWhen using the Oracle SOA Suite for web service development, chances are that you are also using an Oracle database and that you are at some point in need of a database adapter in one of your SOA composites. If that happens to be the case, you might also encounter the requirement to support multiple composite revisions and keep them as stabile as possible.

This requirement leads to development of multiple SOA composite revisions, but there is only one database. What if you need more database functionality in your new revision? And let’s say, for example, the package specification you are using in the database adapter needs to change. Is that going to be a problem or can you also have multiple database versions? Normally if the package specification changes the older composite revision will fail and you do have a problem in supporting multiple composite revisions. If you are working with an Oracle Database 11g Release 2 or higher one of its killer features, Edition-Based Redefinition, could provide a solution!

This feature was introduced to the database for hot deployment. It is meant to reduce or eliminate application upgrade down-time, as the Oracle documentation explains it (http://docs.oracle.com/cd/E11882_01/appdev.112/e10471/adfns_editions.htm#ADFNS0201).

With EBR it is possible to create multiple releases of your software in the database. When you create a new edition you can install the same software a second time (or more) in the same database without changing the older version of that same software. For hot deployment this means that a new release can be installed in the database next to the current situation and as soon as the new release is installed correctly the old release can be removed from the database. For more details on EBR I’d like to refer to the Oracle documentation. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.