db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3128) embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified scale does not adjust scale
Date Fri, 12 Oct 2007 16:56:50 GMT
embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified
scale does not adjust scale
-----------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-3128
                 URL: https://issues.apache.org/jira/browse/DERBY-3128
             Project: Derby
          Issue Type: Bug
          Components: JDBC
            Reporter: Kathey Marsden
            Priority: Minor


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.




-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message