SAP Knowledge Base Article - Preview

2340292 - Execute a "select...for update" with SetFetchSize() in jConnect raised execption - SDK for SAP ASE

Symptom

  • After upgrade to ASE 16 using the Jconnect 16 to run "select ... for update" with SetFetchSize() return the following error:
    • com.sybase.jdbc4.jdbc.SybSQLException: Cursor 'jconnect_implicit_1' was declared with a FOR UPDATE clause. This cursor was found to be read only.
      at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131)
      at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247)
      at com.sybase.jdbc4.tds.Tds.getResultSetResult(Tds.java:3993)
      at com.sybase.jdbc4.tds.TdsCursor.open(TdsCursor.java:328)
      at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2600)
      at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:279)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Software Developers Kit (SDK) for Adaptive Server Enterprise (ASE) 16.0
  • jConnect

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase SDK 15.7

Keywords

jconnect_implicit_1, FOR UPDATE, SELECT_OPENS_CURSOR, setFetchSize , KBA , BC-SYB-SDK , SDK , Problem

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.