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

Bug 328185

Summary: SQL Results View should try to use column accessors
Product: [Tools] Data Tools Reporter: Shenxue Zhou <shenxue.zhou>
Component: SQL Results ViewAssignee: dtp.sqldevtools-inbox <dtp.sqldevtools-inbox>
Status: NEW --- QA Contact:
Severity: normal    
Priority: P3 CC: bpayton
Version: 1.8.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:

Description Shenxue Zhou CLA 2010-10-19 18:24:15 EDT
Build Identifier: M20100909-0800

For standard sql types, SQL Results View displays query result nicely. But when it comes to non-standard types, for example, xml types, SQL Results View would display object references for them. 

One way to resolve this issue would be for SQL Results View to use columns accessors. That way user can supply his/her own column accessors for columns with non-standard types. I think Table editor does that.

Reproducible: Always
Comment 1 Brian Payton CLA 2011-02-18 20:46:42 EST
I think you should be able to use the resultSetViewer extension point for this.  (See resultSetViewer.exsd in the plugin org.eclipse.datatools.sqltools.result.ui.)

See also the resultSetOutputter extension point in the plugin org.eclipse.datatools.sqltools.result.