SAP Knowledge Base Article - Preview

3003020 - jConnect: updateRow fails with BigDateTime column in the inital select - SDK for SAP ASE

Symptom

Bigdatetime column being returned in a select statement doesn't allow updateRow() and gives exception

java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ006: Caught IOException: JZ0TC: Attempted conversion between an illegal pair of types.
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:819)
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:1250)
at com.sybase.jdbc4.tds.TdsCursor.handleIOE(TdsCursor.java:992)
at com.sybase.jdbc4.tds.TdsCursor.update(TdsCursor.java:586)
at com.sybase.jdbc4.jdbc.SybCursorResultSet.updateRow(SybCursorResultSet.java:3263)
at testproj.Test.main(Test.java:18)
Caused by: java.io.IOException: JZ006: Caught IOException: JZ0TC: Attempted conversion between an illegal pair of types.
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseIOException(ErrorMessage.java:1021)
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseIOECheckDead(ErrorMessage.java:1117)
at com.sybase.jdbc4.tds.KeyToken.send(KeyToken.java:92)
at com.sybase.jdbc4.tds.TdsCursor.update(TdsCursor.java:579)
... 2 more
Caused by: java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of types.
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:832)
at com.sybase.jdbc4.tds.TdsDataOutputStream.send(TdsDataOutputStream.java:1518)
at com.sybase.jdbc4.tds.KeyToken.send(KeyToken.java:88)
... 3 more


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 7.07 )
  • java

Product

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

Keywords

CR# 823716, CR823716, CR#823716, update, resultset, rs, result, update, query, execute, bigdatetimen, bigdatetime, bigtime, datetime, date, time , 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 for Me (Login required).

Search for additional results

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