In this article I will show how we can record an XML content using DbAdapter BPEL.
Below is a table Describe Command to display the details and field where I will perform the Insert XML
Below I created a simple project in BPEL called GravaXMLBpel
We can then create a DbAdapter to Insert Only option (but may be the Merge smoothly), in my case I called GravaXMLDBAdapter
Now I’m importing the table PROJECT
We created so our DBAdapter.
Now create a BPEL normally and connect with your DBAdapter.
Open your xsd that is your BPEL created, in my case it is GravaXMLBPELProcess.xsd
Edit your input element and create two fields just to be those who need to perform recording in the table.
Now within your BPEL drag the Invoke component and plug in your Adapter and drag a Transformation to we turn our input on our Invoke
Double-click on your Transform and then we turn our input with the input variable of our Adapter.
Click OK and your Transformation will open, then turn the IdDepartamento with projectno and xml field on the right corresponding to your table, click the right button navigate to the Add XSL Node option and choose copy-of
Then connect the xml on your left with the copy-of the right hand side
Save everything and make deploy the project and we will test:
See below our XML content inserted in the table XML field PROJECT
Doubts ? Leave your comment and download the Projet BPEL
Hugs and see you soon