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
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.
SAP Knowledge Base Article - Preview