EXPLORE ORACLE FUSION MIDDLEWARE

While working on our local systems we will have some scenario in which we want to connect to SOAINFRA database of IntegratedWeblogicServer. In this post I will explain you how to login to SOAINFRA database of default domain coming with Integrated weblogic server in JDeveloper 12c. SOAINFRA database of IntegratedWeblogicServer runs on Derby server. Prerequisite : IntegratedWeblogicServer must be up and running before proceeding further. Follow the below steps to connect to SOAINFRA database: 1. To connect to weblogic server connection details are required. These connection details can be found from the SOADataSource. For this login to weblogic admin console using url http://localhost:7101/console. 2. After login, click on Data Sources. 3. Open SOADataSource and click on Connection Pool. Copy the connection URL. URL will be like jdbc:derby://localhost:1527/soainfra;ServerName=localhost;databaseName=soainfra Description of URL : HostName : localh...

In this post I will explain you how to generate a unique Id in XSLT. To Generate a unique id in XSLT use oraext:generate-guid() function. See below screen shot to generate unique id in XSLT : Result of XSLT : The function oraext:generate-guid() has generated a unique Id as 2d333136303937343532313436323038. Similarly for each run this function will generate different unique Ids.

There are scenarios when we want to complete commit or complete rollback. This is known as transaction handling. To demonstrate this scenario I am taking following use case. Use Case : Read a file and insert data into Header and Line tables. Data must be inserted into both the tables or it should be complete roll back in case of any exception. Lets start the use case : 1. Drag a file adapter in the Exposed Services. Configure it to read a file from Local directory. For more details to configure a FTP adapter, please go through my previous block : http://exploreofm.blogspot.in/2015/09/soa-12c-how-to-read-file-using-file.html 2. Configure two database adapters to insert data into header and line tables. 3. Create a BPEL process and wire it to the FTP adapter and database adapter. After wiring it your composite should look like as below : 4. Add invoke activity and other assign activity to complete BPEL process. Deploy the service to em co...

In this post I will explain you how to install Oracle SOA Suite 12c. Download latest version of SOA 12c from oracle OTN. Download java 7 and install it to your machine If you don't have java 7 installed, your can download it from below path http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html The further installation is shown in Windows OS. You need to create a JAVA_HOME environment variable. Follow the below path to set JAVA_HOME : Click on Advanced System Settings, go to Advance tab and click on  Environment Variables. Click on New under User Variables. Click ok and Save it. Now java 1.7 has been setup in your machine. We are ready to install JDeveloper 12c. Unzip fmw_12.1.3.0.0_soaqs_Disk1_1of1.zip file which you have downloaded from OTN. Now open a command prompt as a administrator Navigate to the installation folder and run command " %JAVA_HOME%\bin\java -jar fmw_12.1...

In this post I will explain how to read, delete, and archive a file from any location. This post will also explain reading content of file in 12c and configuration of NXSD (Native Format Builder). This post can be applicable for SOA 11g also. File Adapter Configuration : Drag File Adapter to Exposed Services section : Enter file adapter JNDI Name File Adapter have multiple operations read, write, sync and chunked read operations. Here we are using read operation. Enter file source and archive location. If you don't want to archive any file, uncheck the Archive check box. Specify File name pattern to read files based on any pattern. Set Polling frequency. Polling frequency is the interval in which adapter will read the file from the particular location. Now we need to define an NXSD schema, to convert the file data to XML f...