My Oracle Support Banner

DBAdapter that Returns Object Containing TIMESTAMP WITH TIME ZONE Fails (Doc ID 2214067.1)

Last updated on OCTOBER 05, 2017

Applies to:

Oracle Service Bus - Version and later
Information in this document applies to any platform.


On FMW (SOA or Oracle Service Bus)

DBAdapter that returns objects containing TIMESTAMP WITH TIME ZONE fails with the error below:

Object XML conversion error.
An error occurred while converting a Java object to XML.
Unable to convert the XSD element TSWTZ whose JDBC type is TIMESTAMP WITH TIME ZONE to a corresponding XML document element. Cause: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to oracle.sql.TIMESTAMPTZ
Analyze the error and correct if possible. Contact oracle support if error is not fixable. This exception is considered not retriable, likely due to a modelling mistake.
at oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableException(
at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(
at oracle.tip.adapter.db.sp.SPUtil.createResourceException(
at oracle.tip.adapter.db.sp.AbstractXMLBuilder.DOMArguments(
at oracle.tip.adapter.db.sp.AbstractXMLBuilder.buildDOM(
at oracle.tip.adapter.db.sp.SPInteraction.executeStoredProcedure(
at oracle.tip.adapter.db.DBInteraction.executeStoredProcedure(
at oracle.tip.adapter.db.DBInteraction.execute(



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

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