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

Bug 361209

Summary: Can not define SQLResultSet and SQLStatement
Product: z_Archived Reporter: Yu Hao <yuhaodl>
Component: EDTAssignee: Project Inbox <edt.compiler-inbox>
Status: CLOSED WONTFIX QA Contact:
Severity: major    
Priority: P3 CC: jspadea, pharmon, svihovec, zhuzhi
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description Yu Hao CLA 2011-10-18 03:22:34 EDT
Build Identifier: 201110170901

Define SQLResultSet or SQLStatement in an egl program, there will fire error:

Description	Resource	Path	Location	Type
IWN.VAL.3433.e 16/10 The type SQLStatement is not instantiable. The reference to this type must be defined as nullable.	sqlvalidation.egl	/demo/EGLSource/client	line 16	EDT Problem
IWN.VAL.3433.e 17/6 The type SQLResultSet is not instantiable. The reference to this type must be defined as nullable.	sqlvalidation.egl	/demo/EGLSource/client	line 17	EDT Problem


Reproducible: Always
Comment 1 Paul Harmon CLA 2011-10-18 09:25:28 EDT
This is the correct behavior. You will need to define the fields for these types as nullable. For example:

myResultSet SQLResultSet?;
myStatement SQLStatement?;

These objects are created as a result of executing (certain) SQL statements. Until the statements are executed, the fields will contain null. Therefore, they must be defined as nullable.
Comment 2 Yu Hao CLA 2011-10-19 22:44:17 EDT
Verified