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: <1774118070.1125546245809.JavaMail.jira@ajax.apache.org>
Date: Thu, 1 Sep 2005 05:44:05 +0200 (CEST)
From: "Kathey Marsden (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Resolved: (DERBY-452) Import/export fails for DECIMAL type in
 J2ME/Foundation
In-Reply-To: <1629295337.1121111489560.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-452?page=all ]
     
Kathey Marsden resolved DERBY-452:
----------------------------------

    Fix Version: 10.1.1.1
     Resolution: Fixed

Fixed in 10.1 branch with revision 265639.

> Import/export fails for DECIMAL type in J2ME/Foundation
> -------------------------------------------------------
>
>          Key: DERBY-452
>          URL: http://issues.apache.org/jira/browse/DERBY-452
>      Project: Derby
>         Type: Bug
>   Components: Tools
>     Versions: 10.1.1.0, 10.2.0.0
>  Environment: J2ME/CDC/Foundation using IBM's WCTME 5.7
>     Reporter: Deepa Remesh
>      Fix For: 10.2.0.0, 10.1.1.1
>  Attachments: derby-452.diff, derby-452.status, derbyall_report_j2me.txt
>
> Derby import/export tool has to be modified to work in J2ME/Foundation.
> I tried running the testcase importExport.java and it fails with following exception:
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Test importExport starting
> testing non-existing data file
> Data file not found: extinout/Z.dat
> testing null data file
> Data file cannot be null. 
> testing empty table
> testing empty table with Delimited format
> testing empty table import Field/Char Delimiters
> PASS: setup complete
> testing import/export with default options
> FAIL: exception thrown:
> ERROR 38000: The exception 'SQL Exception: An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'.' was thrown while evaluating an expression.
> ERROR 22005: An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'.
> Test importExport finished
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> The exception is thrown because Derby system procedure for export calls getObject() on a DECIMAL type. This is not supported in J2ME/Foundation. Derby Embedded JSR 169 Functional Spec asks to use alternate JDBC getXXX and setXXX methods (like getString and setString) for DECIMAL type. I think the Derby import/export utility can be modified to call getString and setString for DECIMAL type when using J2ME/Foundation.

-- 
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