Changing JNDI Dynamically

Create a composite which inserts employee details into database.



Create one way BPEL process



Modify the XSD and add below details.



Drag drop Database Adapter.



































Assign Input details (eNumber, eName, eDepartment) to DB Input.



In composite.xml add below highlighted property



Create a global variable







Add below property in invoke



Now deploy the composite and test



Now dynamically change the JNDI from EM console and test it



Go to Properties





Change the value highlighted above to the one which is highlighted below



Apply the changes



Now test the service and it is success.

Thank You!!!!

Happy Learning!!!!

Split and Combine Delimited String

Scenario:

Expected Input: a,b,c

1. Split like below

<input>a</input>
<input>b</input>
<input>c</input>

2. Using DVM change a b c to A B C

<input>A</input>
<input>B</input>
<input>C</input>

3. Combine back as below

<input>A;B;C</input>

Expected Output: A;B;C

Solution:

Create a synchronous BPEL





Create XSD as below



Create three variables of type element with the use of above XSD



Drag drop an Assign activity and split the input delimited strings into multiple nodes using Advanced Function oraext:create-nodeset-from-delimited-string







As this is a Advanced function i.e., extension function add the below highlighted from source view



Transform the data from a given format to other format which end system is accepting using DVM







Drag drop an Assign activity and combine the splited notes into single nodeset using String Function oraext:create-delimited-string







Finally Assigning data in variable Var3 to result





Testing:

Input:



Output:

Thank You!!!!

Happy Learning!!!!