0 Replies Latest reply on Oct 22, 2018 9:47 AM by pvu

    Error get data from MS SQL Server

    pvu

      I have a dbadapter connect MS SQL Server 2017. My table define columns with datatype is nvarchar.

      I have create store procedure get data from my table. But i excute it from BPEL i see error:

      BINDING.JCA-12563

      Exception occurred when binding was invoked.

      Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'dbReference' failed due to: Unimplemented string conversion.

      Conversion of JDBC type NVARCHAR to String is not supported.

      An attempt was made to convert a Java object to String using an unsupported JDBC type: NVARCHAR.

      Use a data type with a supported JDBC type.

      ".

      The invoked JCA adapter raised a resource exception.

      Please examine the above error message carefully to determine a resolution.

       

      My enviroment:

      - Oracle 12c (12.2.1.0.0)

      - JDBC 7.0 from Microsoft.