[
https://issues.jboss.org/browse/TEIID-147?page=com.atlassian.jira.plugin....
]
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)