Kbase P187898: SQL: JDBC driver returns zero decimal values in scientific notation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/18/2011 |
|
Status: Unverified
SYMPTOM(s):
SQL: JDBC driver returns zero decimal values in scientific notation
The JDBC driver, returns the zero values in scientific notation for fields whose DECIMALS attribute is 7 or more.
When the scale, i.e. the number of digits to the right of the decimal point, of a decimal column is greater than 6 the JDBC driver returns its zero values in scientific notation. For example, it returns 0E-7 instead of 0.0000000.
The JDBC driver returns zero values in scientific notation when column scale (i.e. the number of digits to the right of the decimal point) is greater than 6.
This issue has been reproduced using the OpenEdge Architect SQL Editor, the OpenEdge SQL Explorer Tool and a stand alone Java Program.
FACT(s) (Environment):
If the scale is less than 7 or the value is not equal to zero, the field (column) is displayed in its proper decimal format as expected.
This issue is not reproducible under 10.1A or 10.1B that use java version "1.4.2_06". Hence, it is a regression bug.
The standalone Bug.java program used to reproduce this issue under OpenEdge 10.1C, OpenEdge 10.2A and OpenEdge 10.2B is attached in the note below.
All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2A
OpenEdge 10.2B
OpenEdge 10.2B04
CAUSE:
Bug# OE00207707
CAUSE:
This issue started with OpenEdge use of java version "1.5.0_11". That is in OpenEdge 10.1C and later. It may be related to the changes to the BigDecimal toString method in JDK 1.5.
FIX:
None at this time