Oracle SOA Blogs- Sandeep

Hi Everyone, Recently i come with a requirement about Hadoop Hive integration in Oracle SOA, For same i wrote a blog which you can find on below link. https://oraclesoaosbbpmapi.blogspot.com/2019/03/hadoop-hive-data-base-fetching-records.html After successfully configuring hive in weblogic, We faced a new issue which is about connection. Before going deep about issue and solution let's see how HIVE DB manage connection on server side. when ever we make a data base connection for HIVE DB, it create an internal session and generates a session id which is valid for a specific period of time which is configured on server level. After that period of time Hive create a new session id and process the query. How weblogic data source manage connection: When we create a data source in weblogic, We define a connection pool size by which we can use existing connections which are not in use by any other resource by which weblogic minimize the connection cost. Issue due to...

Hello, Today we are going to see how we can invoke a REST API which is secured with private key & certificate which requires two way SSL for successful invocation. Before starting development what we need: Certificate.pfx file This PFX file contain a CERTIFICATE AND KEY, which will be used for two way SSL REST API URL like "https://SERVERURL/URL/connect/token" JAVA implementation: We need to use below external JAR's for making HTTP Call. Below is sample JAVA code for same: package com.api.client; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; import java.io.InputStreamReader; import java.io.OutputStream; import java.net.HttpURLConnection; import java.net.InetSocketAddress; import java.net.Proxy; import java.net.URL; import java.security.KeyStore; import java.security.SecureRandom; import java.util.logging.Logger; import javax.net.ssl.HttpsURLConn...

Hello Everyone, Today i am going to discuss how we can invoke a NTLM based SOAP service into OSB, Oracle SOA 12C have this feature in-built but you can use it only when you have env up to date with latest patch. Here i am going to discuss how we can do it in OSB. There is no direct way to do it in OSB too but with help of JAVA HTTP we can do it. Create a JAVA project in Eclipse. Import below three jars and attach them in build path so it can be used as class path. Java class Code: package com.teamshare.java.client.http; import org.apache.commons.httpclient.HttpClient; import org.apache.commons.httpclient.HttpStatus; import org.apache.commons.httpclient.NTCredentials; import org.apache.commons.httpclient.auth.AuthScope; import org.apache.commons.httpclient.methods.PostMethod; import org.apache.commons.httpclient.methods.StringRequestEntity; public class TeamShareClient { public TeamShareClient() { } public static void main(String[] args) { ...

Most existing web applications are connected through web services, which are commonly known as SOAP services. More and more users are relying on mobile devices for communication, and they’re looking for lighter ways to access enterprise information on the go. REST services are the answer for the mobile device platform, because they get rapid responses and fast access to data. Oracle SOA Suite 12 c  provides a complete set of service infrastructure components for designing, deploying, and managing composite applications. Oracle SOA Suite 12 c  enables services to be created, managed, and orchestrated into composite applications and business processes. Some time we have need to send HTTP headers in REST service, In OSB we use header component and add what ever is needed but in oracle SOA 12C it's little bit different. Let see how we can do it. Create one SOA Application. Create one SOA Sample project inside SOA Application. Go to composite and drag drop REST ...

Hello everyone, Some time we have a need to configure connection time & socket time in rest adapter so it can live for a while and full fill our purpose. For increasing connection timeout & readtime out you can do following thing: Go to composite.xml Search for your rest adapter reference. Add below properties:  <reference name="UserDetailsAccess" ui:wsdlLocation="WSDLs/UserDetailsAccess.wsdl">         <interface.wsdl interface="*******"/>         <binding.rest config="Adapters/UserDetailsAccess.wadl"                       location="hURL">         <property name="http.connTimeout" many="false" override="may">5000000</property>          <property name="http.chunkSize" many="false" override="may">9</property>          <property name="htt...

Hi all,   today i experienced a little task to change the "Production mode" settings to FALSE in weblogic domain because due to production mode web service test client was not working. Setting up the mode to true was easy and straight forward but a little trick comes where for some reasons we had to rollback that change to test some issues.  If you want to know what are the differences between the two modes check this post  To configure all servers in a domain to run in production mode:  Login to Weblogic Console In the left pane of the WebLogic Console, under Domain Structure, select the domain name.  Select Configuration > General and select the Production Mode check box.  Click Save, and then, to activate these changes, in the Change Center, click Activate Changes. Start and stop any servers that are currently running. Here are the steps to configure all servers in a domain back to development mode. Weblogic server stor...