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

Bug 322949

Summary: Add support for ResultSet metadata at design-time for Custom SQL
Product: z_Archived Reporter: Mike Norman <michael.norman>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: eclipselink.dbws-inbox
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://wiki.eclipse.org/EclipseLink/Development/DBWS/CustomSQLDesignTimeSchema
Whiteboard:
Attachments:
Description Flags
add support for design-time schema gen for SQLOperations none

Description Mike Norman CLA 2010-08-17 16:01:25 EDT 
Normally DBWS processes the metadata for custom SQL stmts at run-time -
the information is returned using SXF (the Simplified XML Format, very much
like a rowset).

If the WHERE clause can be reliably parsed, then at design-time an additional
term (1=0) can be added to ensures that no 'real' data is returned but the
ResultSet should have metadata from which an eclipselink-dbws-schema.xsd file
can be built.

(Alternatively, if the user is presented with a GUI, they can 'eye-ball'
the correct place in the WHERE clause)
Comment 1 Mike Norman CLA 2010-09-27 14:21:45 EDT 
Created attachment 179673 [details]
add support for design-time schema gen for SQLOperations
Comment 2 Mike Norman CLA 2010-09-30 12:08:59 EDT 
see SVN revision: 8268
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:34:51 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink