SAP Knowledge Base Article - Preview

2124820 - 'JZ0TC: Attempted conversion between an illegal pair of types' when using literals and parameters in SQL statement with jConnect - SAP SDK

Symptom

  • Using addBatch/executeBatch on statement similar to this: INSERT INTO JCONN4_TEST (TYPE,UPDATE,DESCRIPTION) values ('M', ?, ?)") with ENABLE_BULK_LOAD=BCP and error occurs:
    • java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of types.

Read more...

Environment

  • jConnect 7.07 and higher (16.0)
  • SDK for SAP ASE 15.7 or 16.0 (contains the jConnect JDBC driver)
  • ASE 15.7 and higher

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

Keywords

Bulk Load Failure , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.