SAP Knowledge Base Article - Preview

2885306 - jConnect: The parameter of type 36 did not have a valid value or Connection is already closed - SDK for SAP ASE

Symptom

  • Batch insert fails with parameter using stmt.setCharacterStream
  • Message: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: The parameter of type 36 did not have a valid value.

      or

  • Message: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed
  • Message: JZ0C1: An IOException occurred which closed the connection.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • jConnect
    • JDBC 7.07
    • JDBC 16 ( is version JDBC 7.07 )
  • java

Product

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

Keywords

CR#820924, CR# 820924, CR820924, insert, update, data, incorrect, corruption, java, jconn4.jar, jconn , KBA , BC-SYB-SDK , SDK , 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.