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

Last updated on DECEMBER 14, 2016

Applies to:

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

Symptoms

On FMW 12.1.3.0.161018 (SOA or Oracle Service Bus)

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

BINDING.JCA-11807
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(DBResourceException.java:690)
at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:656)
at oracle.tip.adapter.db.sp.SPUtil.createResourceException(SPUtil.java:180)
at oracle.tip.adapter.db.sp.oracle.XMLBuilder.DOM(XMLBuilder.java:203)
at oracle.tip.adapter.db.sp.oracle.XMLBuilder.DOMStruct(XMLBuilder.java:152)
at oracle.tip.adapter.db.sp.oracle.XMLBuilder.DOM(XMLBuilder.java:183)
at oracle.tip.adapter.db.sp.AbstractXMLBuilder.DOMArguments(AbstractXMLBuilder.java:284)
at oracle.tip.adapter.db.sp.AbstractXMLBuilder.buildDOM(AbstractXMLBuilder.java:262)
at oracle.tip.adapter.db.sp.SPInteraction.executeStoredProcedure(SPInteraction.java:158)
at oracle.tip.adapter.db.DBInteraction.executeStoredProcedure(DBInteraction.java:1302)
at oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:307)

 

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