[ http://issues.apache.org/jira/browse/DERBY-452?page=all ]
Kathey Marsden reassigned DERBY-452:
------------------------------------
Assign To: Deepa Remesh
> 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
> Assignee: Deepa Remesh
> Fix For: 10.2.0.0, 10.1.2.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
