When you create a database poller in the OSB you will encounter that empty values in the database will appear in your request as xsi:nil="true".

When calling another service with values like

When you are building a composite using the SOA Suite you quite often want to call an external webservice. These services can have a form of security on them....wss-username-token in our example. To attach the policy to the service in BPEL is quite forwards.

When you create a database adapter using JDeveloper, the Date fields in the database will be modelled as DateTime fields in the xsd. Often you will only want Date fields.

A simple way to convert the DateTime fields to Date fields using XQuery is like this:

<ns3:Geboortedatum>{ data(xs:date(substring-before($pollSfStudentoplCollection1/ns4:PollSfStudentopl[1]/ns4:geboortedatum/text(),'T'))) }</ns3:Geboortedatum>