1 Reply Latest reply on Aug 6, 2018 6:49 AM by 3542755

    Conversion of JDBC type DATE to String is not supported SOA 12.2.1.1.0

    3713906

      I have created a OSB business service based on a DB procedure but it gives a below error when testing:

       

       

      The invocation resulted in an error: Invoke JCA outbound service failed with application error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/AMHI_IVR_HospitalDetail/AMHI_IVR_HospitalDetail/WSDLs/getAgentByAgentCodeBS.wsdl [ getAgentByAgentCodeBS_ptt::getAgentByAgentCodeBS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'getAgentByAgentCodeBS' failed due to: Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      ; nested exception is:
      BINDING.JCA-11804
      Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      Use a data type with a supported JDBC type.

       

      com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/AMHI_IVR_HospitalDetail/AMHI_IVR_HospitalDetail/WSDLs/getAgentByAgentCodeBS.wsdl [ getAgentByAgentCodeBS_ptt::getAgentByAgentCodeBS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'getAgentByAgentCodeBS' failed due to: Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      ; nested exception is:
      BINDING.JCA-11804
      Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      Use a data type with a supported JDBC type.

       

      at com.bea.wli.sb.transports.jca.binding.JCATransportOutboundOperationBindingServiceImpl.invoke(JCATransportOutboundOperationBindingServiceImpl.java:171)
      at com.bea.wli.sb.transports.jca.JCATransportEndpoint.sendRequestResponse(JCATransportEndpoint.java:251)
      at com.bea.wli.sb.transports.jca.JCATransportEndpoint.send(JCATransportEndpoint.java:211)
      at com.bea.wli.sb.transports.jca.JCATransportProvider.sendMessageAsync(JCATransportProvider.java:591)
      at sun.reflect.GeneratedMethodAccessor2050.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.bea.wli.sb.transports.Util$1.invoke(Util.java:80)
      at com.sun.proxy.$Proxy219.sendMessageAsync(Unknown Source)
      at com.bea.wli.sb.transports.TransportManagerImpl.sendMessageToService(TransportManagerImpl.java:487)
      at com.bea.wli.sb.transports.TransportManagerImpl.sendMessageAsync(TransportManagerImpl.java:375)
      at com.bea.wli.sb.service.handlerchain.handlers.TransportProviderInvoker.dispatch(TransportProviderInvoker.java:87)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.handlers.EndpointManagementHandler.dispatch(EndpointManagementHandler.java:47)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.handlers.UpdateOutboundStatistics.dispatch(UpdateOutboundStatistics.java:65)
      at com.bea.wli.sb.service.handlerchain.handlers.LoadBalanceFailover$LoadBalanceFailoverHelper.sendMessageAsync(LoadBalanceFailover.java:408)
      at com.bea.wli.sb.service.handlerchain.handlers.LoadBalanceFailover$LoadBalanceFailoverHelper.sendMessageToServiceAsync(LoadBalanceFailover.java:333)
      at com.bea.wli.sb.service.handlerchain.handlers.LoadBalanceFailover$LoadBalanceFailoverHelper.sendMessageToService(LoadBalanceFailover.java:280)
      at com.bea.wli.sb.service.handlerchain.handlers.LoadBalanceFailover.dispatch(LoadBalanceFailover.java:162)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.handlers.OutboundMessageContentHandler.dispatch(OutboundMessageContentHandler.java:70)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.handlers.CheckTxDeadlock.dispatch(CheckTxDeadlock.java:54)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.handlers.ResultCachingHandler.dispatch(ResultCachingHandler.java:113)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.handlers.SetSoapAction.dispatch(SetSoapAction.java:167)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.handlers.OutboundMessagePatternHandler.dispatch(OutboundMessagePatternHandler.java:174)
      at com.bea.wli.sb.service.handlerchain.handlers.AbstractHandler.dispatch(AbstractHandler.java:129)
      at com.bea.wli.sb.service.handlerchain.DefaultOutboundHandlerChain.dispatch(DefaultOutboundHandlerChain.java:114)
      at com.bea.wli.sb.service.dispatcher.TransportDispatcher.dispatch(TransportDispatcher.java:58)
      at com.bea.wli.sb.test.services.TestClient.invoke(TestClient.java:161)
      at com.bea.wli.sb.test.services.TestClient$1.run(TestClient.java:120)
      at com.bea.wli.sb.test.services.TestClient$1.run(TestClient.java:117)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:368)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:163)
      at com.bea.wli.sb.util.security.SecurityUtils.executeAs(SecurityUtils.java:102)
      at com.bea.wli.sb.security.WLSSecurityContextService.executeAs(WLSSecurityContextService.java:55)
      at com.bea.wli.sb.test.services.TestClient.invoke(TestClient.java:123)
      at com.bea.wli.sb.test.services.service.BizProcessor.invoke(BizProcessor.java:47)
      at com.bea.wli.sb.test.services.AbstractServiceProcessor.invoke(AbstractServiceProcessor.java:482)
      at com.bea.wli.sb.test.TestServiceImpl.invoke(TestServiceImpl.java:184)
      at com.bea.wli.sb.test.client.ejb.TestServiceEJBBean.invoke(TestServiceEJBBean.java:172)
      at com.bea.wli.sb.test.client.ejb.TestService_sqr59p_EOImpl.__WL_invoke(Unknown Source)
      at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:35)
      at com.bea.wli.sb.test.client.ejb.TestService_sqr59p_EOImpl.invoke(Unknown Source)
      at com.bea.wli.sb.test.client.ejb.TestService_sqr59p_EOImpl_WLSkel.invoke(Unknown Source)
      at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:645)
      at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:246)
      at weblogic.rmi.internal.BasicServerRef$2.run(BasicServerRef.java:534)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:368)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:163)
      at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:531)
      at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:138)
      at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
      at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
      at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
      at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
      at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
      Caused by: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/AMHI_IVR_HospitalDetail/AMHI_IVR_HospitalDetail/WSDLs/getAgentByAgentCodeBS.wsdl [ getAgentByAgentCodeBS_ptt::getAgentByAgentCodeBS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'getAgentByAgentCodeBS' failed due to: Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      ; nested exception is:
      BINDING.JCA-11804
      Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      Use a data type with a supported JDBC type.

       

      at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.request(JCABindingReferenceImpl.java:321)
      at com.bea.wli.sb.transports.jca.binding.JCATransportOutboundOperationBindingServiceImpl.invoke(JCATransportOutboundOperationBindingServiceImpl.java:166)
      ... 62 more
      Caused by: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/AMHI_IVR_HospitalDetail/AMHI_IVR_HospitalDetail/WSDLs/getAgentByAgentCodeBS.wsdl [ getAgentByAgentCodeBS_ptt::getAgentByAgentCodeBS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'getAgentByAgentCodeBS' failed due to: Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      ; nested exception is:
      BINDING.JCA-11804
      Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      Use a data type with a supported JDBC type.

       

      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.performOperation(WSIFOperation_JCA.java:707)
      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeOperation(WSIFOperation_JCA.java:366)
      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:346)
      at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.invokeWsifProvider(JCABindingReferenceImpl.java:418)
      at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.request(JCABindingReferenceImpl.java:319)
      ... 63 more
      Caused by: BINDING.JCA-11804
      Unimplemented string conversion.
      Conversion of JDBC type DATE to String is not supported.
      An attempt was made to convert a Java object to String using an unsupported JDBC type: DATE.
      Use a data type with a supported JDBC type.

       

      at oracle.tip.adapter.db.sp.sqlserver.TypeConverter.toString(TypeConverter.java:167)
      at oracle.tip.adapter.db.sp.sqlserver.XMLBuilder.DOM(XMLBuilder.java:73)
      at oracle.tip.adapter.db.sp.AbstractXMLBuilder.strongRowSet(AbstractXMLBuilder.java:202)
      at oracle.tip.adapter.db.sp.AbstractXMLBuilder.DOMRowSet(AbstractXMLBuilder.java:162)
      at oracle.tip.adapter.db.sp.AbstractXMLBuilder.DOMRowSet(AbstractXMLBuilder.java:240)
      at oracle.tip.adapter.db.sp.AbstractXMLBuilder.DOMArguments(AbstractXMLBuilder.java:283)
      at oracle.tip.adapter.db.sp.AbstractXMLBuilder.buildDOM(AbstractXMLBuilder.java:263)
      at oracle.tip.adapter.db.sp.SPInteraction.executeStoredProcedure(SPInteraction.java:166)
      at oracle.tip.adapter.db.DBInteraction.executeStoredProcedure(DBInteraction.java:1355)
      at oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:306)
      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.performOperation(WSIFOperation_JCA.java:576)
      ... 67 more
      .