db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-452) Import/export fails for DECIMAL type in J2ME/Foundation
Date Mon, 11 Jul 2005 19:51:29 GMT
Import/export fails for DECIMAL type in J2ME/Foundation
-------------------------------------------------------

         Key: DERBY-452
         URL: http://issues.apache.org/jira/browse/DERBY-452
     Project: Derby
        Type: Improvement
  Components: Tools  
 Environment: J2ME/CDC/Foundation using IBM's WCTME 5.7
    Reporter: Deepa Remesh


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


Mime
View raw message