Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 358836

Summary:

New Record Wizard: XML data type in DB2 Express could not be converted in EGL

Product:

z_Archived

Reporter:

Thomas Wu <wxwu>

Component:

EDT

Assignee:

Zhi Zhu <zhuzhi>

Status:

CLOSED FIXED

QA Contact:

Severity:

major

Priority:

CC:

zhuzhi

Version:

unspecified

Target Milestone:

---

Hardware:

OS:

Windows XP

Whiteboard:

Attachments:

Description	Flags
xml data type error	none
screenshot	none

Description Thomas Wu

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

2011-09-25 22:27:10 EDT

Created attachment 203981 [details]
xml data type error

Comment 2 Zhi Zhu

2011-09-27 05:26:57 EDT

since dbchar is not supported, fix it in the future

Comment 3 Zhi Zhu

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

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

2011-10-20 21:22:15 EDT

Please verify it using tomorrow's build

Comment 6 Thomas Wu

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

2011-10-23 21:43:58 EDT

Created attachment 205776 [details]
screenshot

Comment 8 Zhi Zhu

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

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

2011-11-01 10:33:38 EDT

Verified in build of 20111031