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 ONE Support launchpad (Login required).

Search for additional results

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