10:36 a.m.
Ramesh Reddy created TEIID-2158:
-----------------------------------
Summary: Generate a Rest based service automatically based on deployed VDB
Key: TEIID-2158
URL: https://issues.jboss.org/browse/TEIID-2158
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 8.2
Currently to enable REST based services on top of the VDB, Designer provides a mechanism
for user to define metadata on the procedure and gives hooks to generate Rest service
based WAR file to deploy into a application server.
To support OpenShift efforts it would be good to provide this functionality out of box,
when Teiid is deployed into the JBoss AS (never in embedded).
To define a scenario,
- user creates a VDB and defines one or more models
- then user creates a virtual procedure with following metadata in the options clause
REST:METHOD = GET|PUT|POST|DELETE (mandatory)
REST:URI = uri (mandatory)
REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from procedures
return parameter)
REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the
binary data is returned this character set will be used to convert)
where REST namesspace is defined as
SET NAMESPACE 'http://teiid.org/rest' AS REST;
- user deploys a VDB
- a jax-rs based war is created and deployed automatically at the end of vdb deployment
- if vdb is un-deployed, this jax-rs war will also be undeployed
Questions?
1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define
the DDL based metadata this is difficult.
2) Apart from above procedures, does a generic procedure that executes a add-hoc query
helpful? The restriction here is the results will be in a pre-defined format not user
defined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:11 a.m.
[
https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2158:
-------------------------------------
Added initial implementation of generation of REST services. Please see
https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB for more details how
it can used on the VDB. Based on feedback, i would like fix both above questions before
resolving it.
Generate a Rest based service automatically based on deployed VDB
-----------------------------------------------------------------
Key: TEIID-2158
URL: https://issues.jboss.org/browse/TEIID-2158
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Labels: jax-rs, resteasy, teiid
Fix For: 8.2
Currently to enable REST based services on top of the VDB, Designer provides a mechanism
for user to define metadata on the procedure and gives hooks to generate Rest service
based WAR file to deploy into a application server.
To support OpenShift efforts it would be good to provide this functionality out of box,
when Teiid is deployed into the JBoss AS (never in embedded).
To define a scenario,
- user creates a VDB and defines one or more models
- then user creates a virtual procedure with following metadata in the options clause
REST:METHOD = GET|PUT|POST|DELETE (mandatory)
REST:URI = uri (mandatory)
REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from
procedures return parameter)
REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the
binary data is returned this character set will be used to convert)
where REST namesspace is defined as
SET NAMESPACE 'http://teiid.org/rest' AS REST;
- user deploys a VDB
- a jax-rs based war is created and deployed automatically at the end of vdb deployment
- if vdb is un-deployed, this jax-rs war will also be undeployed
Questions?
1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define
the DDL based metadata this is difficult.
2) Apart from above procedures, does a generic procedure that executes a add-hoc query
helpful? The restriction here is the results will be in a pre-defined format not user
defined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:39 a.m.
[
https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2158:
----------------------------------
Attachment: rest.patch
This looks good. Here's a patch with some possible refinements to handle return
parameters and charsets.
I don't think that the explicit parameter transformation handling is needed as we will
already convert if possible to the correctly typed literal.
What do you mean in question 1 in reference to DDL?
What security would be in effect with the current code? There wouldn't be any
correct?
Do we need an abstract getConnection method? Seems like you could just pass the
vdbname/version in the execute method. That could also give you more control over how the
connection is created, if pass through is needed etc.
We may also still be able to do some form of connection pooling, either on a per vdb basis
and use identity assertion, or globably and add an enhancement to switch vdbs as well.
Generate a Rest based service automatically based on deployed VDB
-----------------------------------------------------------------
Key: TEIID-2158
URL: https://issues.jboss.org/browse/TEIID-2158
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Labels: jax-rs, resteasy, teiid
Fix For: 8.2
Attachments: rest.patch
Currently to enable REST based services on top of the VDB, Designer provides a mechanism
for user to define metadata on the procedure and gives hooks to generate Rest service
based WAR file to deploy into a application server.
To support OpenShift efforts it would be good to provide this functionality out of box,
when Teiid is deployed into the JBoss AS (never in embedded).
To define a scenario,
- user creates a VDB and defines one or more models
- then user creates a virtual procedure with following metadata in the options clause
REST:METHOD = GET|PUT|POST|DELETE (mandatory)
REST:URI = uri (mandatory)
REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from
procedures return parameter)
REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the
binary data is returned this character set will be used to convert)
where REST namesspace is defined as
SET NAMESPACE 'http://teiid.org/rest' AS REST;
- user deploys a VDB
- a jax-rs based war is created and deployed automatically at the end of vdb deployment
- if vdb is un-deployed, this jax-rs war will also be undeployed
Questions?
1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define
the DDL based metadata this is difficult.
2) Apart from above procedures, does a generic procedure that executes a add-hoc query
helpful? The restriction here is the results will be in a pre-defined format not user
defined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:34 p.m.
[
https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2158:
-------------------------------------
Thanks Steve. I realized that I did the check for parameter for return but did not account
in the execute call.
Q1) What I meant is the DDL is defined per model, and security information need to be
defined per VDB, for that global scope Teiid does not have means to define this extension
metadata other than vdb.xml properties. I did not like defining security extensions on
vdb.xml
I was planning on "HTTPBasic" as default, but right now I have commented it out
for feed back.
Good suggestion about getConnection, will implement that.
Generate a Rest based service automatically based on deployed VDB
-----------------------------------------------------------------
Key: TEIID-2158
URL: https://issues.jboss.org/browse/TEIID-2158
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Labels: jax-rs, resteasy, teiid
Fix For: 8.2
Attachments: rest.patch
Currently to enable REST based services on top of the VDB, Designer provides a mechanism
for user to define metadata on the procedure and gives hooks to generate Rest service
based WAR file to deploy into a application server.
To support OpenShift efforts it would be good to provide this functionality out of box,
when Teiid is deployed into the JBoss AS (never in embedded).
To define a scenario,
- user creates a VDB and defines one or more models
- then user creates a virtual procedure with following metadata in the options clause
REST:METHOD = GET|PUT|POST|DELETE (mandatory)
REST:URI = uri (mandatory)
REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from
procedures return parameter)
REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the
binary data is returned this character set will be used to convert)
where REST namesspace is defined as
SET NAMESPACE 'http://teiid.org/rest' AS REST;
- user deploys a VDB
- a jax-rs based war is created and deployed automatically at the end of vdb deployment
- if vdb is un-deployed, this jax-rs war will also be undeployed
Questions?
1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define
the DDL based metadata this is difficult.
2) Apart from above procedures, does a generic procedure that executes a add-hoc query
helpful? The restriction here is the results will be in a pre-defined format not user
defined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:19 p.m.
[
https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2158:
-------------------------------------
* Localized the "getConnection" call.
* Added HTTPBasic authentication, with option to turn it off. Check the document for the
allowed properties.
* With HttpBasic security, pass-through-authentication can be added as an option. Be sure
to configure the embedded transport with security-domain before you can do that
* Added an implicit rest service at URI "/query", that takes a parameter named
"sql" with inbound SQL statement that takes a sql command that must generates a
XML document or JSON document. See document for an example. BTW, this only works with
"POST" method.
Generate a Rest based service automatically based on deployed VDB
-----------------------------------------------------------------
Key: TEIID-2158
URL: https://issues.jboss.org/browse/TEIID-2158
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Labels: jax-rs, resteasy, teiid
Fix For: 8.2
Attachments: rest.patch
Currently to enable REST based services on top of the VDB, Designer provides a mechanism
for user to define metadata on the procedure and gives hooks to generate Rest service
based WAR file to deploy into a application server.
To support OpenShift efforts it would be good to provide this functionality out of box,
when Teiid is deployed into the JBoss AS (never in embedded).
To define a scenario,
- user creates a VDB and defines one or more models
- then user creates a virtual procedure with following metadata in the options clause
REST:METHOD = GET|PUT|POST|DELETE (mandatory)
REST:URI = uri (mandatory)
REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from
procedures return parameter)
REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the
binary data is returned this character set will be used to convert)
where REST namesspace is defined as
SET NAMESPACE 'http://teiid.org/rest' AS REST;
- user deploys a VDB
- a jax-rs based war is created and deployed automatically at the end of vdb deployment
- if vdb is un-deployed, this jax-rs war will also be undeployed
Questions?
1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define
the DDL based metadata this is difficult.
2) Apart from above procedures, does a generic procedure that executes a add-hoc query
helpful? The restriction here is the results will be in a pre-defined format not user
defined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:06 a.m.
[
https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-2158.
---------------------------------
Resolution: Done
Will handle any additional enhancements or bugs are separate issues.
Generate a Rest based service automatically based on deployed VDB
-----------------------------------------------------------------
Key: TEIID-2158
URL: https://issues.jboss.org/browse/TEIID-2158
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Labels: jax-rs, resteasy, teiid
Fix For: 8.2
Attachments: rest.patch
Currently to enable REST based services on top of the VDB, Designer provides a mechanism
for user to define metadata on the procedure and gives hooks to generate Rest service
based WAR file to deploy into a application server.
To support OpenShift efforts it would be good to provide this functionality out of box,
when Teiid is deployed into the JBoss AS (never in embedded).
To define a scenario,
- user creates a VDB and defines one or more models
- then user creates a virtual procedure with following metadata in the options clause
REST:METHOD = GET|PUT|POST|DELETE (mandatory)
REST:URI = uri (mandatory)
REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from
procedures return parameter)
REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the
binary data is returned this character set will be used to convert)
where REST namesspace is defined as
SET NAMESPACE 'http://teiid.org/rest' AS REST;
- user deploys a VDB
- a jax-rs based war is created and deployed automatically at the end of vdb deployment
- if vdb is un-deployed, this jax-rs war will also be undeployed
Questions?
1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define
the DDL based metadata this is difficult.
2) Apart from above procedures, does a generic procedure that executes a add-hoc query
helpful? The restriction here is the results will be in a pre-defined format not user
defined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:47 a.m.
[
https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-2158.
---------------------------------
Generate a Rest based service automatically based on deployed VDB
-----------------------------------------------------------------
Key: TEIID-2158
URL: https://issues.jboss.org/browse/TEIID-2158
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Labels: jax-rs, resteasy, teiid
Fix For: 8.2
Attachments: rest.patch
Currently to enable REST based services on top of the VDB, Designer provides a mechanism
for user to define metadata on the procedure and gives hooks to generate Rest service
based WAR file to deploy into a application server.
To support OpenShift efforts it would be good to provide this functionality out of box,
when Teiid is deployed into the JBoss AS (never in embedded).
To define a scenario,
- user creates a VDB and defines one or more models
- then user creates a virtual procedure with following metadata in the options clause
REST:METHOD = GET|PUT|POST|DELETE (mandatory)
REST:URI = uri (mandatory)
REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from
procedures return parameter)
REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the
binary data is returned this character set will be used to convert)
where REST namesspace is defined as
SET NAMESPACE 'http://teiid.org/rest' AS REST;
- user deploys a VDB
- a jax-rs based war is created and deployed automatically at the end of vdb deployment
- if vdb is un-deployed, this jax-rs war will also be undeployed
Questions?
1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define
the DDL based metadata this is difficult.
2) Apart from above procedures, does a generic procedure that executes a add-hoc query
helpful? The restriction here is the results will be in a pre-defined format not user
defined.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4415
days inactive
4505
days old
6 comments
2 participants
participants (2)
-
Ramesh Reddy (JIRA) -
Steven Hawkins (JIRA)