I am seeing an error thrown by the database adapter when invoking a stored procedure that the value being provided for a xsd:dataTime field is not a valid ISO 8601 datetime format (when in fact I believe it is valid).
Here is the relevant xsd snippet from the db adapter service xsd:
<element name="START_DATE" type="dateTime" db:type="DATE" minOccurs="0" nillable="true"/>
Here are the various flavors of the XML that I tried to execute the db adapter service with:
Does not work:
<START_DATE>2007-06-27T11:38:20.988Z</START_DATE>
This seems to be a valid datetime format as per ISO 8601 (as per http://www.w3.org/TR/NOTE-datetime). This is one of the valid formats specified in the db adapter guide as well (see section A.1.8 dateTime Conversion Exceptions).
All of the below work just fine:
<START_DATE>2007-06-27T11:38:20.988</START_DATE>
<START_DATE>2007-06-27T11:38:20Z</START_DATE>
<START_DATE>2007-06-27T11:38:20+05:00</START_DATE>
<START_DATE>2007-06-27T11:38:20.988+05:00</START_DATE>
Following is the error stack trace that I see with the first datetime format specified above.
<2007-06-27 09:50:51,910> <ERROR> <default.collaxa.cube.ws> <AdapterFramework::Outbound> file:/rb1/oracle/product/rubiconas/bpel/domains/default/tmp/.bpel_CreatePurchaseOrderOracle11iProviderSubProcess_4.0_ab0e1fa3dedd55e37e2a23763ad1a2e3.tmp/ValidatePurchaseOrderDBConsumerService.wsdl [ ValidatePurchaseOrderDBConsumerService_ptt::ValidatePurchaseOrderDBConsumerService(InputParameters,OutputParameters) ] - Could not invoke operation 'ValidatePu
rchaseOrderDBConsumerService' against the 'Database Adapter' due to:
ORABPEL-11814
Invalid ISO8601 datetime specification.
The date or timestamp specification 2007-06-27T11:38:20.988Z is not ISO8601 compliant.
Check to ensure that the date or timestamp being specified conforms with the ISO8601 standard. Contact oracle support if error is not fixable.
Wondering if others have run into this issue as well.