SAP Knowledge Base Article - Preview

2167111 - jConnect:Datatype mismatch on INSERTS Explicit conversion error - SAP ASE

Symptom

  • Upgrading from SAP ASE 15.0.3 to 15.7 (Development/UAT and Production)
  • Upgrade jConnect from 6.05 to 7.07 ESD#5
  • Some inserts failed with the error:
    • XXX.exception.SpaceException: Code : Unknown
    • Description : Error while query: INSERT INTO SOME_TABLE VALUES(?,?,?,?,?,?)
    • JZ0BE: BatchUpdateException: Error occurred while executing batch statement: Explicit conversion from datatype 'IMAGE_LOCATOR' to 'VARCHAR' is not allowed.

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Software Developer Kit (SDK)
  • Sybase Software Develper Kit (SDK)
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK)
  • Old system:
    • ASE 15.0.3: Adaptive Server Enterprise/15.0.3/EBF 17686 ESD#1.1 RELSE/P/Sun_svr4/OS 5.8/ase1503/2681/64-bit/FBO/Thu Au2009
    • jConnect: 6.05
    • mda = installjdbc jConnect (TM) for JDBC(TM)/7.00(Build 26502)/P/EBF17821/JDK16/Tue Apr 6 11:59:33 2010
  •  New System:
    • ASE 15.7 
    • UAT: jConnect = jConnect (TM) for JDBC(TM)/7.07 SP100 (Build 26846)/P/EBF20990/JDK 1.6.0/jdbcmain/OPT/Wed Apr 24 11:30:54 PDT 2013
    • Production = jConnect (TM) for JDBC(TM)/7.07 ESD #5 (Build 26792)/P/EBF20686/JDK 1.6.0/jdbcmain/OPT/Mon Oct 15 11:36:14 PDT 2012
  •  MDA:
    • UAT = installjdbc jConnect (TM) for JDBC(TM)/7.07 SP100 (Build 26846)/P/EBF20990/JDK 1.6.0/jdbcmain/OPT/Wed Apr 24 11:30:54 PDT 2013 Complete
    • PROD = installjdbc jConnect (TM) for JDBC(TM)/7.07 ESD #5 (Build 26792)/P/EBF20686/JDK 1.6.0/jdbcmain/OPT/Mon Oct 15 11:36:14 PDT 2012 Complete.

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

jConn, JDBC, BLOB, binarystream , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

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

Search for additional results

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