Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 358836 - New Record Wizard: XML data type in DB2 Express could not be converted in EGL
Summary: New Record Wizard: XML data type in DB2 Express could not be converted in EGL
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Zhi Zhu CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-25 22:23 EDT by Thomas Wu CLA
Modified: 2017-02-23 14:16 EST (History)
1 user (show)

See Also:

Attachments
xml data type error (205.76 KB, image/jpeg)
2011-09-25 22:27 EDT, Thomas Wu CLA 		no flags Details
screenshot (70.29 KB, image/pjpeg)
2011-10-23 21:43 EDT, Thomas Wu CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Wu CLA 2011-09-25 22:23:58 EDT 
Build Identifier: 20110923

XML data type in DB2 Express will not be converted anything through new record wizard in EDT, which will lead to compiling errors in generated egl records file.

Reproducible: Always

Steps to Reproduce:
1. Install DB2 express and its sample DB.
2. New an EGL project.
3. Try to convert all the tables in sample DB to EGL records file.

Actual results: The XML data type in tables could not be generated into egl, nothing will be generated at here.
Comment 1 Thomas Wu CLA 2011-09-25 22:27:10 EDT 
Created attachment 203981 [details]
xml data type error
Comment 2 Zhi Zhu CLA 2011-09-27 05:26:57 EDT 
since dbchar is not supported, fix it in the future
Comment 3 Zhi Zhu CLA 2011-10-12 02:33:05 EDT 
Currently Mapping Db2 XML data type to EGL string since EGL does not support XML type.

EGLSQLRetrieveUtility
Comment 4 Lisa Lasher CLA 2011-10-20 15:06:26 EDT 
Changing the target from Future to 070 Final.  This problem is fixed for now, within the restrictions of 0.7.0 functionality.   Support for additional datatypes will be tracked in separate work items for 1.0.
Comment 5 Zhi Zhu CLA 2011-10-20 21:22:15 EDT 
Please verify it using tomorrow's build
Comment 6 Thomas Wu CLA 2011-10-23 21:42:24 EDT 
I verified in build of 20111023, but the issue is still exist. Please refer to screenshot.
Comment 7 Thomas Wu CLA 2011-10-23 21:43:58 EDT 
Created attachment 205776 [details]
screenshot
Comment 8 Zhi Zhu CLA 2011-10-24 01:16:07 EDT 
EGLSQLRetrieveUtility
DataToolsSqlColumnTemplate
DataToolsSqlTableTemplate

-os ${target.os} -ws ${target.ws} -arch ${target.arch} -nl ${target.nl} -consoleLog


-Dosgi.requiredJavaVersion=1.5 -Xms40m -Xmx1024m -XX:MaxPermSize=256M -XX:MaxPermSize=256m
Comment 9 Zhi Zhu CLA 2011-10-24 02:36:47 EDT 
Worked with Thomas to investigate the problem, the bug is caused by his environment, so fix it
Comment 10 Thomas Wu CLA 2011-11-01 10:33:38 EDT 
Verified in build of 20111031