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, Today we are going to configure UMS adapter in SOA to download mail attachment & push it on file/FTP location. ·          Click on Email Driver properties. ·         In EM FMW Control, open the User Messaging Service node in the navigator and select the usermessagingdriver-email for the relevant managed server. From the context menu, select Email Driver Properties. When there no configuration yet, you will create a new one. If you already configured the SOA Suite for outbound mail traffic, you can edit that configuration for the inbound direction. ·          Click on create ·          In the property overview, there are some properties to set: Press the OK button at the top of the page to apply all configuration changes. The Email Receiving protocol for GMail is IMAP. The Incoming Mail...

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

In 12c, the OWSM security policy configuration is saved to a separate file called wsm-assembly.xml In order to update values in wsm-assembly.xml, the service needs to use the <policySet>. e.g. A configuration plan is required to change both a HTTP port number, and the csf-key used by the oracle/wss_username_token_client_policy OWSM policy. Replacement without configuration plan: Open wsm-assembly.xml file and add below code <?xml version='1.0' encoding='windows-1252'?> <orawsp:wsm-assembly xmlns:orawsp="http://schemas.oracle.com/ws/2006/01/policy" xmlns:mds="http://xmlns.oracle.com/mds">    <sca11:policySet xmlns:sca11="http://docs.oasis-open.org/ns/opencsa/sca/200912" name="policySet" appliesTo="SCA-REST-REFERENCE()" attachTo="REFERENCE('Get_Service_Now')" orawsp:highId="2" xml:id="SCA-REST-REFERENCE__REFERENCE__Get_Service_Now__"> ...

What is LDAP Adapter: The Oracle LDAP adapter provides bi-directional connectivity with LDAP V3- compliant directory servers. The chapter provides information on how to model the LDAP adapter as a reference to perform CRUD (Create, Read, Update and Delete) operations and how to model the LDAP adapter as an inbound publication service on a directory server. Information describing various users, applications, files, printers, and other resources accessible from a network is often collected into a special database called an LDAP directory. Access to LDAP directories is a basic requirement of enterprise workflows. The LDAP Adapter Configuration Wizard provides a graphical and intuitive interface to model LDAP services to send requests to and receive responses from LDAP servers. LDAP (Lightweight Directory Access Protocol), is an Internet protocol for accessing information directories. A directory service is a distributed database application designed to manage the entries and attribu...

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

This summary is not available. Please click here to view the post.