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

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...

• 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

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

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