SAP Knowledge Base Article - Preview

2924291 - The result of paging query which references offset and limit is incorrect - SAP ASE SDK

Symptom

When dynamic_prepare is false , the result of paging query which references offset and limit is incorrect.

[Dynamic_prepare =false, offset=0]
java problematic_source
Value(a): au_pix
Value(a): authors
Value(a): blurbs

[Dynamic_prepare =false, offset=5]
java problematic_source
Value(a): au_pix
Value(a): authors
Value(a): blurbs

When dynamic_prepare is 'true', the result shows correctly.

[Dynamic_prepare =true, offset =0]
java problematic_source
Value(a): au_pix
Value(a): authors
Value(a): blurbs

[Dynamic_prepare =true, offset =5]
java problematic_source
Value(a): roysched
Value(a): sales
Value(a): salesdetail




Read more...

Environment

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

Product

SAP Adaptive Server Enterprise SDK 16.0

Keywords

CR#821652 CR821652, 821652 , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.