"BINDING.JCA-11636 Caused by: java.text.ParseException: Unparseable date" with "BINDING.JCA-11814 Invalid ISO8601 datetime specification" when Invoking a Database Adapter (Doc ID 1449110.1)

Last updated on JANUARY 21, 2022

Applies to:

Symptoms

A 11.1.1.3.0 SOA Suite Composite Application which assigns a date time to a variable for input to a database using a Database Adapter, receives the following errors when calling the DBAdapter :

ERRORS:
--------------
Could not invoke operation 'assignDateOperation' against the 'Database Adapter' due to: [[
BINDING.JCA-11814
Invalid ISO8601 datetime specification.
The date or timestamp specification 2012-02-22 11:47:18.437 is not ISO8601 compliant.
A date or timestamp specification that is not ISO8601 compliant was encountered.
Check to ensure that the specified date or timestamp conforms with the ISO8601 standard: yyyy-MM-ddTHH:mm:ss.SSSZ.

BINDING.JCA-12563
Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'logEventDBImpl' failed due to: Invalid ISO8601 datetime specification.
The date or timestamp specification 2012-02-22 11:47:18.437 is not ISO8601 compliant.
A date or timestamp specification that is not ISO8601 compliant was encountered.
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.

BINDING.JCA-11636
Could Not Convert Timestamp Exception.
Unable to convert a string value in the xml to a java.sql.Timestamp.
Even though databases accept strings representing timestamps in a variety of formats, the adapter only accepts strings representing them in xml ISO dateTime format.
The input value must be in iso 8601 xs:dateTime format, i.e. YYYY-MM-DDTHH:MM:SS.sss-07:00

..
Caused by: java.text.ParseException: Unparseable date: "2012-02-22 11:47:18.437"

Cause