SAP Knowledge Base Article - Preview

2077479 - jConnect 7 - Update of BigDecimal to ASA looses scale because metadata returns data type int instead of numeric


  • When using jConnect 7 a numeric data type fails to store the fractional portion when using a parameterized query Using SQL Anywhere and jConnect 7.07 ESD #5 [jConnect (TM) for JDBC(TM)/7.07 ESD #5 (Build 2 6792)/P/EBF20686/JDK 1.6.0/jdbcmain/OPT/Mon Oct 15 11:36:14 PDT 2012]
  • As an example when updating a select value such as 2.01, the value 2.00 is sent in the dynamic update statement, losing the scale of 2 originally set in the application
  • This happens when using the BigDecimal data type in the JDBC application



  • SDK for SAP ASE 15.7
    • jConnect for JDBC 7.0
  • SDK for SAP ASE 16.0
    • jConnect for JDBC 16.0


SAP Adaptive Server Enterprise SDK 16.0 ; SAP SQL Anywhere 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7


"Software Developer Kit", "Adaptive Server Enterprise", DBLIB, dblib, CTLIB, ctlib, OCS , 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.