Eclipse Community Forums: DTP » SQLResultRunnable for UserDefinedFunction (UDF)

Help

Home

Home » Eclipse Projects » DTP » SQLResultRunnable for UserDefinedFunction (UDF)

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

SQLResultRunnable for UserDefinedFunction (UDF) [message #10829]

Wed, 19 April 2006 11:56

Eclipse User

Originally posted by: anil.samuel.gmail.com

Hi

DTP - 0.9.0.200604141

I am using the default Run action for Routine class, which uses
RoutineEditor. This causes
org.eclipse.datatools.sqltools.routineeditor.launching.SPLau nchConfigurationDelegate
to handle the launching, where this issue is.

Issue is that current implementation uses
org.eclipse.datatools.sqltools.sqleditor.result.SimpleSQLRes ultRunnable
to handle the UDF type launching. If this was changed to be similar to
the case of Stored Procedure, then the plugin provider can provide a
org.eclipse.datatools.sqltools.core.services.ExecutionServic e instance
to handle it.

Any thoughts ?

Regards
Anthos

Report message to a moderator

Re: SQLResultRunnable for UserDefinedFunction (UDF) [message #11469 is a reply to message #10829]

Mon, 24 April 2006 06:17

Hui Cao

Messages: 14
Registered: July 2009

Junior Member

Anil Samuel wrote:

> Hi

> DTP - 0.9.0.200604141

> I am using the default Run action for Routine class, which uses
> RoutineEditor. This causes
>
org.eclipse.datatools.sqltools.routineeditor.launching.SPLau nchConfigurationDelegate
> to handle the launching, where this issue is.

> Issue is that current implementation uses
> org.eclipse.datatools.sqltools.sqleditor.result.SimpleSQLRes ultRunnable
> to handle the UDF type launching. If this was changed to be similar to
> the case of Stored Procedure, then the plugin provider can provide a
> org.eclipse.datatools.sqltools.core.services.ExecutionServic e instance
> to handle it.

> Any thoughts ?

> Regards
> Anthos

Hi Anthos,
This sounds good, and I'll look into it. BTW, the Derby catalog loader
can't populate Derby Function objects well, as mentioned in BZ:129334.
Just curious, what kind of customization do you plan to do in the case of
UDF?

Regards
Hui Cao
DTP SQL Dev Tools committer
Sybase Inc

Report message to a moderator

Re: SQLResultRunnable for UserDefinedFunction (UDF) [message #11542 is a reply to message #11469]

Thu, 27 April 2006 05:01

Eclipse User

Originally posted by: anil.samuel.gmail.com

Hi Hui

I am working on extending DTP for Oracle DB connectivity.

I am planning to use
?=schema.function(?,..)
in case of UDF.

Did that make sense ?

Anthos
Hui Cao wrote:
>
> Hi Anthos,
> This sounds good, and I'll look into it. BTW, the Derby catalog loader
> can't populate Derby Function objects well, as mentioned in BZ:129334.
> Just curious, what kind of customization do you plan to do in the case
> of UDF?
>
> Regards
> Hui Cao
> DTP SQL Dev Tools committer
> Sybase Inc
>
>

Report message to a moderator