My Oracle Support Banner

Conversion Of JDBC Type TIMESTAMP WITH TIME ZONE To String Is Not Supported After Upgrading 12.2.1.4 (Doc ID 2757263.1)

Last updated on MARCH 04, 2021

Applies to:

Oracle SOA Suite - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.4.0 version, Fabric

Conversion of JDBC type TIMESTAMP WITH TIME ZONE to String is not supported after upgrading 12.2.1.4

Upgraded middleware from 12.1.3.0 to 12.2.1.4.

After upgrade, DB adapter call from OSB business service gets the error:

ERROR
-----------------------

error while running business service -

Caused By: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/elhub.service.pro.marketProcessLogQueryService/Resources/v1/WSDLs/esb/DBAdp_QueryMarketProcessLogOnMeteringPoint_db.wsdl [ DBAdp_QueryMarketProcessLogOnMeteringPoint_db_ptt::DBAdp_QueryMarketProcessLogOnMeteringPoint_db(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'DBAdp_QueryMarketProcessLogOnMeteringPoint_db' failed due to: Unimplemented string conversion.
Conversion of JDBC type TIMESTAMP WITH TIME ZONE to String is not supported.
An attempt was made to convert a Java object to String using an unsupported JDBC type: TIMESTAMP WITH TIME ZONE.
; nested exception is:
  BINDING.JCA-11804
Unimplemented string conversion.
Conversion of JDBC type TIMESTAMP WITH TIME ZONE to String is not supported.
An attempt was made to convert a Java object to String using an unsupported JDBC type: TIMESTAMP WITH TIME ZONE.
Use a data type with a supported JDBC type.



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
References


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