SAP Knowledge Base Article - Preview

2057638 - jConnect: Wrong numeric value inserted in table - SDK for SAP ASE

Symptom

  • Wrong numeric value inserted in table when using jconnect
  • See below some outputs.
    • Using batch to update null decimal values and non decimal values to not null (ID 1: setBigDecimal, ID 2: setDouble)
      ID: 1 should be: 12345.54321, was (double): 12345.54321
      ID: 1 should be: 12345.54321, was (big decimal): 12345.54321
      ID: 2 should be: 12345.54321, was (double): 0.12345
      ID: 2 should be: 12345.54321, was (big decimal): 0.12345
    • Using batch for updating null decimal value to non null in other row and non decimal value to non null value in other row
      ID: 3 should be: null, was (double): 0.0
      ID: 3 should be: null, was (big decimal): null
      ID: 4 should be: 12345.54321, was (double): 1.234554321E9
      D: 4 should be: 12345.54321, was (big decimal): 1234554321.00000
    • Updating row by row null decimal value to not null using null value for non decimal value
      ID: 5 should be: null, was (double): 0.0
      ID: 5 should be: null, was (big decimal): null
      ID: 6 should be: 12345.54321, was (double): 12345.54321
      ID: 6 should be: 12345.54321, was (big decimal): 12345.54321
    • Reusing same PreparedStatement to update null decimal value to non null in other row and non decimal value to non null value in other row
      D: 7 should be: null, was (double): 0.0
      ID: 7 should be: null, was (big decimal): null
      ID: 8 should be: 12345.54321, was (double): 1.234554321E9
      ID: 8 should be: 12345.54321, was (big decimal): 1234554321.00000

 


Read more...

Environment

    • SAP Sybase Software Developer Kit (SDK) 15.7
    • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0v
    • jConnect
      • JDBC 7.07
      • JDBC 16 ( is version JDBC 7.07 )

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-SDK , SDK , Bug Filed

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.