Error: Object dateTime cannot be converted to java.sql.timestamp When Invoking Database Adapter (Doc ID 404136.1)

Last updated on APRIL 05, 2007

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.3.1
This problem can occur on any platform.

Symptoms

A BPEL process contains a payload of XSD data type dateTime. The payload is initially published via an incoming FTP adapter, but the source of the data is irrelevant to the error. This payload is inserted into a database column of type DATE, via a database adapter. When executing the BPEL process, the following error is displayed during the Invoke activity, which invokes the database adapter:

...
oracle.toplink.exceptions.ConversionException
Exception Description: The object [xs:datetime 03], of class [class java.lang.String],
could not be converted to [class java.sql.Timestamp].
Internal Exception: java.lang.StringIndexOutOfBoundsException: String index out of range: 10.
</summary>
</part><part name="detail"><detail>
Exception Description: The object [xs:datetime 03], of class [class java.lang.String],
could not be converted to [class java.sql.Timestamp].
Internal Exception: java.lang.StringIndexOutOfBoundsException: String index out of range: 10
</detail>
</part></bindingFault></fault></messages>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms