Eclipse Community Forums: DTP » How to provide my own Result Set Viewer

Help

Home

Home » Eclipse Projects » DTP » How to provide my own Result Set Viewer

Show: Today's Messages :: Show Polls :: Message Navigator

How to provide my own Result Set Viewer [message #597538]

Thu, 27 May 2010 21:08

Jane Thalen

Messages: 9
Registered: April 2010

Junior Member

Can I plug into DTP's Result Set Viewer and provide my own functionality?

Window - Preferences - Data management - SQL Development - SQL Results View Options - Result Set Viewer Options

There is a combo box where you can select a viewer. There is only one option, the default viewer.

Please can you point me to help for how to provide my own viewer.

Thanks in advance!

Report message to a moderator

Re: How to provide my own Result Set Viewer [message #597545 is a reply to message #597538]

Fri, 04 June 2010 20:27

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

Jane Thalen wrote:
> Please can you point me to help for how to provide my own viewer.
> Thanks in advance!

Hi Jane... Brian Payton is probably the guy you need input from - he's
on vacation this week but will be back next week. I'll ask him about
this at our weekly meeting on Tuesday. Sorry I can't help more at the
moment.
--Fitz

Report message to a moderator

Re: How to provide my own Result Set Viewer [message #597595 is a reply to message #597538]

Thu, 24 June 2010 22:25

Brian Payton

Messages: 154
Registered: July 2009

Senior Member

Hi Jane,

You need to create a class that extends the
ExternalResultSetViewerProvider abstract class, and register that class
as the result set viewer provider with the system, using the
resultSetViewer extension point. Here's a template for code that would
go in the plugin.xml for your extension plugin. Let's say you wanted
to create a customized result set viewer for Derby:

<extension
point="org.eclipse.datatools.sqltools.result.ui.resultSetViewer "
id="com.ibm.datatools.data.extensions.externalResultSetViewer ">
<externalViewer
vendor="Derby"
id="Derby Result Set Viewer"
default_viewer_name="Derby Result Set Viewer"

class=" org.eclipse.datatools.enablement.apache.derby.result.DerbyRe sultSetViewerProvider "/>
</extension>

The getViewer method of your result set viewer provider class should
return a TableViewer object, which normally will be a subclass of
ExternalTableViewer. Override whatever methods you need to in both
ExternalResultSetViewerProvider and ExternalResultSetViewer to create
your customized result set viewer.

Jane Thalen wrote:
> Can I plug into DTP's Result Set Viewer and provide my own functionality?
>
> Window - Preferences - Data management - SQL Development - SQL Results
> View Options - Result Set Viewer Options
>
> There is a combo box where you can select a viewer. There is only one
> option, the default viewer.
>
> Please can you point me to help for how to provide my own viewer.
> Thanks in advance!

Report message to a moderator

Previous Topic:	How to provide my own Result Set Viewer
Next Topic:	creating an IConnectionProfile using ConnectionProfileFactory.createConnection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:57:18 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter