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

[Mark Addleman (JIRA)]

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

Mark Addleman commented on TEIID-147:
-------------------------------------

On the first option, I'd prefer a convention-based approach rather than annotations because annotation support in Clojure is still experimental.  I don't know how well other languages support annotations.  Spit-balling an idea: to better support dynamically compiled languages, clients could register one or more stored-proc factories.  Each factory could return an array/iterable of stored procedures, each of which implemented some interface.  

It seems like these two options address two different use cases.  The first option addresses stored procedures authored in a language-aware IDE.  The second option seems like it is better suited to stored procedures are better authored in a text file.  As I see it, the primary difference between the two is whether the IDE could understand the stored procedure as a language or simply as text.  Of course, if the IDE understands the stored procedure as a real language, the programmer has access to all of the IDE niceties.

My vote is for the first option.

> 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)