OIC, Oracle SOA, OSB, Weblogic

Recently I had worked on OIC Gen2 to Gen 3 Upgrade. B elow is the impact analysis by executing OIC Gen2 to OIC3 upgrade for one of the non-prod instance as pilot work. Below are the few notes from upgrade experience. Upgrade Issues encountered Post OIC3 upgrade, the OIC Gen2 activity stream will not be available, unless the activity stream is redirected to OCI object storage. Instance ID is String (alphanumeric) in OIC3 but data type is Integer in OIC Gen2 - This has huge impact on almost all the integrations as we heavily persisted the instance ID for E2Etracking purpose as part of the orchestration. OIC3 File Sever IP changed. OIC3 SFTP connections needs to be updated. Also if any of the participating application is doing any IP whitelisting, new OIC3 IP has to be added. OIC3 doesn’t support the Basic Authentication for any of the OOTB OIC REST API (Connections, Integrations etc). The same API inv...

http://host:port/sbresource?WADL/ProjectName/WADL/WADLFileName&HTML=true Example http://localhost:8200/sbresource?WADL/ManageCustomer/WADL/REST_ManageCustomer&HTML=true

SOAP vs. REST comparison table Although REST is very popular these days, SOAP still has its place in the world of web services. To help you choose between them, here’s a comparison table of SOAP and REST, that highlights the main differences between the two API styles:   SOAP REST Meaning Simple Object Access Protocol Representational State Transfer Design Standardized protocol with pre-defined rules to follow. Architectural style with loose guidelines and recommendations. Approach Function-driven (data available as services, e.g.: “getUser”) Data-driven (data available as resources, e.g. “user”). Statefulness Stateless by default, but it’s possible to make a SOAP API stateful. Stateless (no server-side sessions). Caching API calls cannot be cached. API calls can be cached. Security WS-Security with SSL support. Built-in ACID compliance. Supports HTTPS and SSL. Performance Requires more bandwidth and computing power. Requires fewer resources. Message format Only XML. ...

This xslt can remove the tailing whitespaces in xml. <?xml version="1.0"?> <xsl:stylesheet version="1.0"   xmlns:xsl="http://www.w3.org/1999/XSL/Transform">   <xsl:template match="/">     <xsl:apply-templates />   </xsl:template>   <xsl:template match="*">     <xsl:copy>       <xsl:for-each select="@*">         <xsl:attribute name="{name()}">           <xsl:value-of select="normalize-space()"/>         </xsl:attribute>       </xsl:for-each>       <xsl:apply-templates/>     </xsl:copy>   </xsl:template>   <xsl:template match="text()">     <xsl:value-of select="normalize-space()"/>   </xsl:template> </xsl:stylesheet>

Here are the some of OSB custom xquery function that came across: 1.        mmddyyyy  to date  conversion: declare function ns1:mmddyyyy-to-date   ( $dateString as xs:string? )  as xs:date? {    if (empty($dateString))     then ()    else      xs:date(concat(substring($dateString,7,4),'-',             substring($dateString,1,2),'-',             substring($dateString,4,2)))  } ; 2.        day of week:  declare function ns1:day-of-week   ( $date as xs:date? )  as xs:integer? {   if (empty($date))   then ()   else xs:integer(($date - xs:date('1901-01-06'))           div xs:dayTimeDuration('P1D')) mod 7  } ; 3.        day of week name:  declare function ns1:...

NAMESPACES ------------------------------------------------------------------------ xml=http://www.w3.org/XML/1998/namespace fn=http://www.w3.org/2004/07/xpath-functions op=http://www.w3.org/2004/07/xpath-operators err=http://www.w3.org/2004/07/xqt-errors fn-bea=http://www.bea.com/xquery/xquery-functions op-bea=http://www.bea.com/xquery/xquery-operators dt-bea=http://www.bea.com/xquery/xquery-datatypes var-bea=http://www.bea.com/xquery/xquery-variables xf-aug02=http://www.w3.org/2002/08/xquery-function op-aug02=http://www.w3.org/2002/08/xquery-operators xs=http://www.w3.org/2001/XMLSchema xsd=http://www.w3.org/2001/XMLSchema xdt=http://www.w3.org/2004/07/xpath-datatypes local=http://www.w3.org/2004/07/xquery-local-functions declare default function namespace "http://www.w3.org/2004/07/xpath-functions XQUERY FUNCTIONS ------------------------------------------------------------------------ fn:node-name($arg as node()?) as xs:QName? fn:...

1.Why Oracle Service Bus 11g ? What are the Key Benefits and Advantages? 1. Service Virtualization :  A core principle of SOA is to ensure that any service consumer can access any service provider - and from any platform. This has been considered as key principle in OSB and it provides robust way of Vitalizing the Service. It's a great value add in SOA Architecture. 2. Loose Coupling :  OSB provides loose coupling by mediating between Service provided and Consumer. Without mediation Service consumer and provider will create dependency to each other. A change in single side provider/consumer will lead to the change dependent consumer/provider respectively. OSB bridges the gap of transport, message format, security technology etc. 3. Location Transparency :  It's a strategy to hide physical location of actual physical location of service endpoints from the Service Consumer. All Service consumers should know only single logical machine & port name for each service...