[
https://issues.jboss.org/browse/TEIID-147?page=com.atlassian.jira.plugin....
]
Steven Hawkins commented on TEIID-147:
--------------------------------------
There are a couple of approaches here. Given our expanded metadata capabilities, the
first approach is conventions/annotations to map a java class/method to a procedure
invocation - I believe derby does something similar.
The other which is more what this was originally thinking of would be similar to pg and
other dbs that support alternative languages inline with the ddl such that there are
conventions for how inputs/outputs and result sets are bound and returned. On this latter
one using the pluggable script engine infrastructure (just like the object_table
construct) you can utilize a variety of vm languages. The only downside is that the
execution of the procedure becomes thread bound.
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)