Posts

OIC Gen2 to Gen 3 Upgrade - Key things to be followed

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 invoked

How to get WADL in browser from osb 12c server

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

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. Plai

search wsmkeys in weblogic 12c

Image

XSLT: Normalize the spaces of incoming xml values

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>

OSB 12c custom xquery functions

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:day-of-week-name   ( $date as xs:date? )  as xs:string? {    ('Sunday', 'Monday', 'Tuesday', 'Wednesday',     'Thursday', 'Friday', 'Saturday')       [ns1:day-of-week($date) + 1]  } ;

XQuery functions that supported by OSB

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: