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

Hello, In Oracle SOA 12C, Oracle added few new adapters which can be used across with BPM/BPEL/OSB components. One of them is "Microsoft Message Queueing".  Microsoft Message Queuing is similar to weblogic JMS queues, difference is it's a Microsoft technologies. Microsoft Message Queuing provide most of the all functionalities and use case implementation which are provide by JMS queues. During the design of SOA applications it is inevitable that from time to time you will need to interface with Microsoft-based applications. While technologies like SOAP and REST do a great job when  request-reply  communication is needed, most people struggle when a  messaging-based  communication is required. This blog will present two approaches to get messaging working between Microsoft and  SOA Suite 12c . Before going to implementation part, let c what is it and why we should use it. What is MSMQ: Microsoft Message Queueing (MSMQ) is a message ...

What is transaction management??? Two words with complex level of understanding, Many of us are still not able to understand what is transaction management and how it work, or how can some one control this transaction. Their are many implementation of transaction management based on technologies in which you are implementing it but TRANSACTION MANAGEMENT term remain same for all. Today we will talk about transaction management in respect of oracle soa... As per oracle documents, " A  transaction  is a logical unit of work that contains one or more SQL statements. A transaction is an atomic unit. The effects of all the SQL statements in a transaction can be either all  committed  (applied to the database) or all  rolled back  (undone from the database)." Points to keep in mind when designing transaction management: Commit :  Committing  a transaction means making permanent the changes performed by the SQL statements with...