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