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 NOVEMBER 15, 2023

Applies to:

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

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