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