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.