Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Message-ID: <201836914.1125000489259.JavaMail.jira@ajax.apache.org>
Date: Thu, 25 Aug 2005 22:08:09 +0200 (CEST)
From: "Deepa Remesh (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-518) Data type mismatch error for boolean to
 DECIMAL conversion in J2ME
In-Reply-To: <50975041.1124408274126.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

    [ http://issues.apache.org/jira/browse/DERBY-518?page=comments#action_12320040 ] 

Deepa Remesh commented on DERBY-518:
------------------------------------

I am referring to "TABLE B-5 Conversions Performed by setObject Between Java Object Types and Target JDBC Types". I change my previous statement to instances of Double,Long, Float,Integer can be converted to DECIMAL. I was also basing on SQLDecimal methods and trying to match as closely as possible. As you mentioned, the code for conversion of Number looks like dead code.


> Data type mismatch error for boolean to DECIMAL conversion in J2ME
> ------------------------------------------------------------------
>
>          Key: DERBY-518
>          URL: http://issues.apache.org/jira/browse/DERBY-518
>      Project: Derby
>         Type: Bug
>   Components: JDBC
>  Environment: J2ME/CDC/Foundation Profile
>     Reporter: Deepa Remesh
>     Assignee: Deepa Remesh
>     Priority: Minor
>      Fix For: 10.2.0.0, 10.1.1.1
>  Attachments: derby-518.diff, derby-518.status
>
> The test jdbcapi/resultset.java gives the following error when run in J2ME/CDC/FP :
> Testing nullif(?,DECIMAL(10,5)) with setBoolean
> ERROR XCL12: An attempt was made to put a data value of type 'boolean' into a data value of type 'DECIMAL'.
> I found that setValue(boolean) is not implemented in BigIntegerDecimal, which is the class used for DECIMAL in J2ME. This is implemented in SQLDecimal and a similar implementation can be provided in BigIntegerDecimal.
> On looking at the setValue methods in these classes, I also found that setValue(Object) is implemented in SQLDecimal but not in BigIntegerDecimal.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira