Oracle SOASuite Basics

SOA Suite Components

• Mediator and Service Bus—Disambiguation

Similar to Mediator, Oracle Service Bus also performs mediation activities in Oracle SOA Suite.While both the Mediator and the Service Bus can perform such tasks as interface and data mapping, routing,
and filtering, their scopes are very different: the Mediator is a component that performs intra-composite mediation, to connect components within a given composite. The Service Bus on the other hand is in charge of inter-composite mediation, that is to say that it connects differentcomposites together—and while doing that, it can also carry out other fundamental tasks of a service bus such as service virtualization, protocol translation, service pooling, and so on.

• Relationship of Applications, Projects, and Composites in JDeveloper

A JDeveloper (JDev) application contains one or more JDev projects. When you are developing SOA technologies, a JDev project is equal to a composite application.

CreditCardApplication
|
|---- JDev Project ( CCValidation) ---- SOA Composite (CCValidation )
|
|----JDev Project ( AccountRegistration) ---- SOA Composite ( AccountRegistration )

• About the Adapter Wizards

Most adapter wizards follow a common flow explained in below diagram -

 

First give name to the new adapter. Then establish a connection to the target system: it could be a database, some application—or even just a file system (in which case, it is not really a connection, but simply a path). After this, select an operation—the operations that are offered by the wizard will of course be different for each target system: a database will offer the expected SQL operations
(select, insert, delete, and a few more), a file system will be read or write, and so on. Finally, in the last stage,  specify the objects on which you are going to be operating: database tables, specific files, or directories in the file system, records in an application and so on.


Will add more to it.

Understanding Taskflow Train

Understanding navigations in Taskflow with train

This post illustrate different kind of manipulation with navigation in Taskflow with train.

Create Taskflow with train

A taskflow with train can be created by selecting CreateTrain checkbox in CreateTaskflow wizard.

Add train component to each train stop view.

Change the label for the train stop in the train component -
Select the train stop (view activity) in the diagram and look at the property inspector, choose the Train Stop tab and set the value of display-name property to a string or an EL Expression

1. Simple Train -

Added a input parameter skipValue to Taskflow for later use. Value passed is the name of viewActivity.

Use skip property of train stop to stop access to a viewActivity of the Train -

 Using the taskflow parameter to update the skip property of activity to skip the train sequence.

By default a train is sequential. For a non-sequential behaviour pass modify the sequential property of the TrainStop. 

Drag and drop the taskflow as a region on page and analyze the output.

Navigation to stview4 can be done directly. It's no more sequential. 

Also stview3 is skipped in train navigation. 

2. Complex Train - 

How to call a view activity between two train stops -

Created a taskflow with train having three view activity.  Here we are trying to make a method call when navigating from view1 to view2 .

Drag and drop wildCard Control Flow rule and method. Use control flow case as mentioned in below diagram. 

ctView1 contains a button with action "addText".

For direct navigation without calling method use train. To invoke methodcall use button with action "addText".

Application can be download from here.

Use SQL subquery and SQL OPERATOR ( IN, BETWEEN) in ViewCriteria

Use SQL subquery and SQL OPERATOR ( IN, BETWEEN) in ViewCriteria

This post will illustrate how to use IN,BETWEEN operators in ViewCriteria. How to use the SQL subquery with ViewCriteria.

In this application, HRAppModuleImpl.java contains a method applyCustomCriteria() with three input parameters - departmentIdVar, lowSalaryVar, and highSalaryVar. Expose this method and test .

Below steps explains the code in snapshot below-

1.Create ViewCriteria using createViewCriteria().

2.Create ViewCriteriaRow using createViewCriteriaRow().

3.Create String with required where Clause.

4.Create ViewCriteriaItem  using ensureCriteriaItem. 

5.Use setOperator() to set the sqlOperator. Use JboCompOper. class to find list of supported operators.

6.Use setValue() method of ViewCriteriaItem to set value . Incase of IN/BETWEEN operator, add multiple values. For sql subquery for IN operator, simply use setValue.

8.Use addElement method to ViewCriteriaRow to VC.

9.Use applyViewCriteria to apply created viewCriteria.

 Expose Method -

Run AM and pass parameters to method -

Project can be downloaded from here.

Tips and Tricks for JDeveloper customization

JDeveloper Customization Tips -

1. Customize user's working directory
By default, JDeveloper’s user directory is the \system subdirectory of the <JDev_Home>
directory, such as C:\Oracle\Middleware\jdeveloper\system—that is, where it
stores user preferences, such as information about the appearance of the IDE. If you want to use
a different directory, start JDeveloper with the –J-Dide.user.dir flag. For example -
"F:\SOASuite11gR1PS2\JDeveloper\jdeveloper\jdeveloper.exe -J-Dide.user.dir=F:\mywork"

Add following flag to shortcut  "-J-Dide.user.dir=<path>"

2. If you don't want to IDE to open the last time opened files, add following flag.

      -noreopen

3. When you open SqlWorksheet in Jdeveloper, it prompts to save the sql file. To avoid that follow below instruction 

How to install SOA Suite and Jdeveloper On Windows

                            Installing the Oracle SOA Suite Server and the Oracle JDeveloper

1. Pre-Installation Tasks 
    a) Installer Download -
        JDK Installer Download - Download JDK 6 from here.
        Download rest of the installer packages from OTN -
        First, you will need to have an OTN account to download packages,
        you can sign up here,it’s free.
       Then head to SOA Suite HomePage and click on the "Downloads" tab.

        Download each of the below mentioned packages -
            SOA Suite PS1 (11.1.1.2.0)
            SOA Suite PS1 (11.1.1.3.0)
            WebLogic Server (10.3.3) generic
            Repository Creation Utility (11.1.1.3.0)
            Oracle Jdeveloper 11g (11.1.1.3.0)
            Oracle XE latest version

2. JDK Installation -
Below screenshots will guide you for JDK installation.

3. Jdeveloper & embedded Weblogic Server -

Run the "jdevstudio11113install.jar" installer.
Below screens will guide you for jdeveloper installation.

Choose the directory cautiously.

 

 4. Update the JDeveloper to the SOA module-

Run Jdeveloper and follow screenshots.

5. Install WebLogic Server

Run the "wls1033_oepe111150_win32.exe" installer. 

Below screens will guide you for jdeveloper installation.

Select the directory as shown in below screenshot. 

6. Oracle XE installation -

Run the OracleXE.exe installer.

7. Configuring Database -

Before installing schemas using RCU, you need to configure the database.
Update the number of process "alter system set processes=200 scope=spfile"

Restart the Database and verify the changes.

8. RCU ( Repository Creation Utility )-

Unzip the ofm_rcu_win_11.1.1.3.0_disk1_1of1.zip to C:/stageSOA folder.

Navigate to stageSOAfolder and run rcuHome\BIN\rcu.bat . A wizard will be launched that will configure your database by creating the required users. Screenshots will guide you through the wizard.

Click ignore and proceed.

Password - soainfra 

9. SOASuite PS1(11.1.1.2.0)-

Unzip the ofm_soa_generic_11.1.1.2.0_disk1_1of1.zip and run the setup.exe from disk1.

Choose the WebLogic Home in which you installed WebLogic Server.

Make sure Oracle Home has a proper value.

10. SOA Suite PS1 (11.1.1.3.0)-

Unzip the ofm_soa_generic_11.1.1.3.0_disk1_1of1.zip and run the setup.exe from disk1.

Make sure you have selected the proper Oracle Middleware Home and Oracle Home Directory.