Oracle SOA Blogs- Sandeep

JCA Properties for Oracle File and FTP Adapters: ConcurrentThreshold:  The maximum number of translation activities that can be allowed to execute in parallel for a particular outbound scenario. The translation step during the outbound operation is CPU-intensive and must be guarded because it might cause other applications or threads to starve. The maximum value is  100 . Lenient :  If set to  true , then the Orcle File Adapter does not complain if it does not have enough permission to read or write to the inbound directory. The default value of this property is  false . NumberMessages :  This property is used for outbound batching. The outgoing file is created when the number of messages condition is met. The parameter is of type  int and is not mandatory. The default value is  1 . Recursive :  If this property is set to  true , then the adapter can process all the sub-directories under the main input directory recurs...

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

Hi Everyone, Today we are going to see how we can execute a Select statement in Hadoop Hive data base using oracle soa DB adapter. Before going into configuration & deployment steps, One thing oracle SOA/Weblogic does not have default built in support to connect over HIVE DB, to full fill same we have to use external JAR's of hadoop hive which will be configured in oracle weblogic. Following is list of JAR's which will be used inside configuration. hive-jdbc-1.2.1-standalone.jar hadoop-common.jar JDev configuration for Data base connection: Click on Driver Class "Add button". Driver class:org.apache.hive.jdbc.HiveDriver Libaray: Add Jar "Hive-jdbc-1.2.1-standalone" Add class path for both jar. Check Connection Status, If you have configured JAR correctly with exact version number of DB. It will work. SOA Project configuration: Create one SOA application. Drag & Drop DB adapter You can't use standard impl...

" If you do nothing on dispatch policies in OSB proxy or business services, all is done in the Default Workmanager. But since some constructions, not only service call-outs, need other threads to finish the job,  you can get stuck threads because the workmanager's threadpool gets empty having all or near to all threads waiting , leaving no threads to pickup work to free the others.  If all threads in the default queue become stuck, the server changes its health state to "critical. If all threads in weblogic.admin.HTTP, weblogic.admin.RMI, or a user-defined execute queue become stuck, the server changes its health state to "warning. Work Managers have a Ignore Stuck Thread options that gives the ability to execute long running jobs.  " Based on our need we can create one of following work manager's: For OSB to work optimally and prevent floading WebLogic’s threadpool with hogged/stuck threads you should create 3 FairShareRequest classes ...

Hello Everyone, Hope you enjoy blogging!!!!! Today i am going to explain how we can use TOPIC in oracle SOA where we will publish message into Queue from one service and other services will consume message from topic. Steps to create JMS TOPIC: 1. Click on Services Menu 2. Click on Messaging Sub-menu 3. Click on JMS Modules. 4. Click on SoaJmsModule. 5. Click new 6. Select Distributed Topic anc click next             1. Enter Name "ProjTopic"             2. Enter JNDI Name "jms/ProjTopic".             3. Click on Advanced Target             4. Select SubDeployments "SoaSubDeployments" from dorp down.             5. Select Server "SoaJmsServer1" "SoaJmsServer2" from server list  ...

xquery version "1.0" encoding "utf-8"; (:: OracleAnnotationVersion "1.0" ::) declare namespace www="http://www.inc.teamshare.gems.com"; (:: import schema at "../Schemas/GemsTeamshareData.xsd" ::) declare namespace pul="http://xmlns.oracle.com/pcbpel/adapter/db/top/Pull_GEMS_INCREMENTAL_DATA"; (:: import schema at "../Schemas/Pull_GEMS_INCREMENTAL_DATA_table.xsd" ::) declare variable $inputVariable.GemsIncrementalDataCollection as element() (:: schema-element(pul:GemsIncrementalDataCollection) ::) external; declare variable $TempListExtractData as element() (:: schema-element(www:TeamShareData) ::) external; declare function local:funcJsonteamshare($inputVariable.GemsIncrementalDataCollection as element() (:: schema-element(pul:GemsIncrementalDataCollection) ::),                                          $TempListExtractData as element() (:: schema-element(www:TeamShareDa...

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, From last few days i am learning about multiple use case implementation of Oracle ICS, i did not find it difficult as it is using all of the concepts used in Oracle SOA. If you know about API Managers then you are at right place to learn about how ICS can be used with API Manager or you can say how API manager can help you to expose your ICS integration to world with help of API management. If you don't know about  Oracle ICS  or  Oracle Cloud API Manager , I will suggest to have a look over above links. Here in this post we will discuss " how do you expose these ICS services using standard API methods"?? As we know  all the Oracle products have an “API first” strategy, so it wasn’t too difficult to setup an ICS flow to automatically publish new services into the API Platform. You can use your any existing activated integration which can expose from API, We will only see API based integration expose only. The first thing to do was to get in...