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 ONE Support launchpad (Login required).

Search for additional results

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