SAP Knowledge Base Article - Preview

2764093 - "JZ008: Invalid column index value 2" may be raised if ENABLE_BULK_LOAD is true - SDK for ASE

Symptom

When you set true to ENABLE_BULK_LOAD connection property of jConnect in a Java application and try to insert rows, you might receive JZ008 error as below.

java.sql.SQLException: JZ008: Invalid column index value 2.
        at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
        at com.sybase.jdbc3.tds.RowFormatToken.mapColumn(Unknown Source)
        at com.sybase.jdbc3.tds.TdsResultSet.getColumn(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybResultSet.getColumn(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybResultSet.getString(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybBCP.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.a(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source)
        at TestBulkEnable.insertBulk(TestBulkEnable.java:84)
        at TestBulkEnable.main(TestBulkEnable.java:133)


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.0
  • jConnect
    • JDBC 6.0.5

Product

Sybase SDK 15.0

Keywords

JZ008, Invalid column index value, ENABLE_BULK_LOAD, sp_drv_bcpmetadata , KBA , BC-SYB-SDK , SDK , How To

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.