Issue Details (XML | Word | Printable)

Key: DERBY-452
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Deepa Remesh
Reporter: Deepa Remesh
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

Import/export fails for DECIMAL type in J2ME/Foundation

Created: 12/Jul/05 04:41 AM   Updated: 01/Dec/05 04:05 PM
Return to search
Component/s: Tools
Affects Version/s: 10.1.1.0, 10.2.1.6
Fix Version/s: 10.1.2.1, 10.2.1.6

Time Tracking:
Not Specified

File Attachments:
  Size
File Licensed for inclusion in ASF works derby-452.diff 2005-07-14 10:27 AM Deepa Remesh 3 kB
File Licensed for inclusion in ASF works derby-452.status 2005-07-14 10:27 AM Deepa Remesh 0.4 kB
Text File Licensed for inclusion in ASF works derbyall_report_j2me.txt 2005-07-14 10:27 AM Deepa Remesh 205 kB
Environment: J2ME/CDC/Foundation using IBM's WCTME 5.7

Resolution Date: 30/Sep/05 02:19 AM


 Description  « Hide
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.







 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Deepa Remesh made changes - 13/Jul/05 01:47 AM
Field Original Value New Value
Assignee Deepa Remesh [ deepa ]
Deepa Remesh made changes - 14/Jul/05 10:27 AM
Attachment derby-452.status [ 12311230 ]
Attachment derby-452.diff [ 12311229 ]
Attachment derbyall_report_j2me.txt [ 12311231 ]
Daniel John Debrunner made changes - 16/Jul/05 08:12 AM
Affects Version/s 10.2.0.0 [ 11187 ]
Type Improvement [ 4 ] Bug [ 1 ]
Affects Version/s 10.1.1.0 [ 10993 ]
Fix Version/s 10.2.0.0 [ 11187 ]
Deepa Remesh made changes - 16/Jul/05 09:21 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Deepa Remesh made changes - 16/Jul/05 09:21 AM
Status Resolved [ 5 ] Closed [ 6 ]
Deepa Remesh made changes - 30/Aug/05 04:14 AM
Status Closed [ 6 ] Reopened [ 4 ]
Assignee Deepa Remesh [ deepa ]
Resolution Fixed [ 1 ]
Kathey Marsden made changes - 01/Sep/05 12:43 PM
Resolution Fixed [ 1 ]
Status Reopened [ 4 ] Resolved [ 5 ]
Fix Version/s 10.1.1.1 [ 12310155 ]
Deepa Remesh made changes - 02/Sep/05 10:16 AM
Status Resolved [ 5 ] Closed [ 6 ]
Deepa Remesh made changes - 30/Sep/05 02:18 AM
Resolution Fixed [ 1 ]
Status Closed [ 6 ] Reopened [ 4 ]
Deepa Remesh made changes - 30/Sep/05 02:19 AM
Fix Version/s 10.1.1.1 [ 12310332 ]
Deepa Remesh made changes - 30/Sep/05 02:19 AM
Resolution Fixed [ 1 ]
Status Reopened [ 4 ] Closed [ 6 ]
Kathey Marsden made changes - 01/Dec/05 04:05 PM
Assignee Deepa Remesh [ deepa ]