Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
10.4.1.3
-
None
-
Normal
-
Deviation from standard
Description
For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
public void setObject(int parameterIndex,
Object x,
int targetSqlType)
and
public void setObject(int parameterIndex,
Objec x,
int targetSqlType,
int scale)
For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.