SAP Knowledge Base Article - Preview

3064999 - For update query fails with timeout exception. When run, it fails because the cursor is broken - SDK for SAP ASE

Symptom

For update query fails with timeout exception. When run, it fails because the cursor is broken.

java.sql.SQLException: JZ0R2: No result set for this query.
 at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:832)
 at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2637)
 at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:279)
 at com.sap.bcp.incident2080455005.ReproduceJZ0P1.executeSelectForUpdateInCurrentThread(ReproduceJZ0P1.java:91)
 at com.sap.bcp.incident2080455005.ReproduceJZ0P1.main(ReproduceJZ0P1.java:35)
Exception in thread "main" java.sql.SQLException: JZ0P1: Unexpected result type.
 at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:832)
 at com.sybase.jdbc4.tds.Tds.getDoneResult(Tds.java:4060)
 at com.sybase.jdbc4.tds.TdsCursor.close(TdsCursor.java:669)
 at com.sybase.jdbc4.jdbc.SybStatement.doCancel(SybStatement.java:1054)
 at com.sybase.jdbc4.jdbc.SybStatement.close(SybStatement.java:765)
 at com.sybase.jdbc4.jdbc.SybStatement.closeImplicitly(SybStatement.java:735)
 at com.sybase.jdbc4.jdbc.SybStatement.close(SybStatement.java:720)
 at com.sap.bcp.incident2080455005.ReproduceJZ0P1.executeSelectForUpdateInCurrentThread(ReproduceJZ0P1.java:102)
 at com.sap.bcp.incident2080455005.ReproduceJZ0P1.main(ReproduceJZ0P1.java:35)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0 SP03 PL08
  • jConnect
    • JDBC 7.07
    • JDBC 16 ( is version JDBC 7.07 )
  • java

Product

Cloud Integration all versions

Keywords

KBA , BC-SYB-SDK , SDK , Known Error

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.