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

Like this:

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:

Below that within the <ns1:xml> I am passing an XML any

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

/:-D