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

Search for additional results

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