My Oracle Support Banner

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

Last updated on AUGUST 10, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.