[teiid-issues] [JBoss JIRA] (TEIID-147) Support for JAVA Stored Procedures

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12984019#comment-12984019 ] 

Steven Hawkins commented on TEIID-147:
--------------------------------------

>  Each factory could return an array/iterable of stored procedures, each of which implemented some interface. 

The further we get down that path, the more things start to look like our typical connector api - albeit with a little more ease of use.  

Have a look at the handling for scalar functions - see MetadataFactory.addFunction(String, Class) and the internal org.teiid.query.function.TeiidFunction annotation that we use for some of the system functions.  Some amount of that convention / logic could be added for procedures as well.

>  The second option seems like it is better suited to stored procedures are better authored in a text file.

The though here is more about Teiid Designer users who want some additional language flexibility without getting too much into things like modules, classloaders, etc.  However as you point out without good IDE support it's unlikely that you'd actually want to use this path.

> Support for JAVA Stored Procedures
> ----------------------------------
>
>                 Key: TEIID-147
>                 URL: https://issues.jboss.org/browse/TEIID-147
>             Project: Teiid
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: Query Engine
>    Affects Versions: 9.x
>            Reporter: Ramesh Reddy
>             Fix For: 9.0
>
>
> Currently the Stored procedure support is lacking for both our procedure language and XQuery. Procedure support could be extended to java (or groovy) code, which will provide a powerful engine to execute a arbitrary queries. 



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)