[JBoss JIRA] (TEIID-2158) Generate a Rest based service automatically based on deployed VDB
by Ramesh Reddy (JIRA)
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
12 years, 2 months
[JBoss JIRA] (TEIID-2244) dynamic VDB, UDF class not found
by David Eichmann (JIRA)
David Eichmann created TEIID-2244:
-------------------------------------
Summary: dynamic VDB, UDF class not found
Key: TEIID-2244
URL: https://issues.jboss.org/browse/TEIID-2244
Project: Teiid
Issue Type: Bug
Affects Versions: 8.1
Environment: OS X 10.7.5
Reporter: David Eichmann
Assignee: Steven Hawkins
I'm attempting to deploy a UDF in a dynamic VDB and getting a ClassNotFound:
14:45:41,654 ERROR org.jboss.threads.executor (teiid-async-threads - 4) Task execution failed for task org.teiid.jboss.VDBService$6@3327d4d9: org.teiid.core.TeiidRuntimeException: TEIID30387 Could not load UDF "institute", since its invocation class "edu.uiowa.tagUtil.grantParser.nih" could not be found.
at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:321) teiid-engine-8.1.0.Final.jar:8.1.0.Final
at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:232) teiid-engine-8.1.0.Final.jar:8.1.0.Final
at org.teiid.query.function.FunctionTree.(FunctionTree.java:106) teiid-engine-8.1.0.Final.jar:8.1.0.Final
at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:84) teiid-runtime-8.1.0.Final.jar:8.1.0.Final
at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:333) teiid-runtime-8.1.0.Final.jar:8.1.0.Final
at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:287) teiid-runtime-8.1.0.Final.jar:8.1.0.Final
at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:166) teiid-runtime-8.1.0.Final.jar:8.1.0.Final
at org.teiid.jboss.VDBService.access$800(VDBService.java:89) teiid-jboss-integration-8.1.0.Final.jar:8.1.0.Final
at org.teiid.jboss.VDBService$6.run(VDBService.java:385) teiid-jboss-integration-8.1.0.Final.jar:8.1.0.Final
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:801)
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:842)
at java.lang.Thread.run(Thread.java:680) Teiid 8.1 - dynamic VDB, UDF class not found
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: java.lang.ClassNotFoundException: edu.uiowa.tagUtil.grantParser.nih from [Module "org.jboss.teiid:main" from local module loader @671ff436 (roots: /Users/eichmann/downloads/jboss/jboss-as-7.1.1.Final/modules)]
at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190) jboss-modules.jar:1.1.1.GA
at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468) jboss-modules.jar:1.1.1.GA
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456) jboss-modules.jar:1.1.1.GA
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:423) jboss-modules.jar:1.1.1.GA
at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398) jboss-modules.jar:1.1.1.GA
at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120) jboss-modules.jar:1.1.1.GA
at java.lang.Class.forName0(Native Method) Teiid 8.1 - dynamic VDB, UDF class not found
at java.lang.Class.forName(Class.java:247) Teiid 8.1 - dynamic VDB, UDF class not found
at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:44) teiid-engine-8.1.0.Final.jar:8.1.0.Final
at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:311) teiid-engine-8.1.0.Final.jar:8.1.0.Final
... 14 more
re Ramesh, the class loader for DDL is not getting properly set.
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2252) Add a jdbc import option to disable all name qualification
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2252:
-------------------------------------
Summary: Add a jdbc import option to disable all name qualification
Key: TEIID-2252
URL: https://issues.jboss.org/browse/TEIID-2252
Project: Teiid
Issue Type: Enhancement
Components: JDBC Connector
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.2
If importing from a single schema, which is the default for the connection, no qualification is needed on teiid names nor name in source. No combination of import properties currently supports that option.
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2288) Convert simple client example to quick start
by Van Halbert (JIRA)
Van Halbert created TEIID-2288:
----------------------------------
Summary: Convert simple client example to quick start
Key: TEIID-2288
URL: https://issues.jboss.org/browse/TEIID-2288
Project: Teiid
Issue Type: Sub-task
Components: Build/Kits
Affects Versions: 8.2
Reporter: Van Halbert
Assignee: Van Halbert
Convert the simple client example to a quick start. This will also be the referenced quick start in the other quick starts for executing example queries.
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2268) NullPointer Exception genetated while querying table built from WSDL query
by Paul Richardson (JIRA)
Paul Richardson created TEIID-2268:
--------------------------------------
Summary: NullPointer Exception genetated while querying table built from WSDL query
Key: TEIID-2268
URL: https://issues.jboss.org/browse/TEIID-2268
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 8.2
Reporter: Paul Richardson
Assignee: Steven Hawkins
Attachments: server.log
Using designer 8, I deploy the state service example models (found [here|https://github.com/phantomjinx/teiid-soap-example]) to an 8.2 beta1 teiid server. The models deploy successfully and the teiid connection in designer displays the catalog and stateService/stateServiceView schemas.
However, running the following query
{{exec stateServiceView.getAllStateInfo();}}
results in a generic TeiidException in designer's status view.
This exception comes from a NullPointerException that is displayed in the jboss server log.
The log of the jboss server is attached, detailing the following events:
# start of the server with the stateService data source and USStates vdb already deployed
# connection and execution of the query from designer
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2172) Load balancing configuration can result in extraneous "invalid session" messages
by Marc Shirley (JIRA)
Marc Shirley created TEIID-2172:
-----------------------------------
Summary: Load balancing configuration can result in extraneous "invalid session" messages
Key: TEIID-2172
URL: https://issues.jboss.org/browse/TEIID-2172
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 7.4.4
Environment: Clustered environment with load balancing enabled for the Teiid data source
Reporter: Marc Shirley
Assignee: Steven Hawkins
When set up in a load balancing configuration with "SET NEW INSTANCE" as the check valid connection SQL in the datasource definition, repeated messages indicating an invalid session are created, similar to:
2012-08-24 10:39:58,818 WARN [org.teiid.SECURITY] (New I/O server worker #1-3) Processing exception 'The specified session ID "5Wt/6zzmsLy2" is invalid. It cannot be found in the userbase.' for session R8ZxYqjZzf/S. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:315). Enable more detailed logging to see the entire stacktrace.
Not sure if this would be a defect in regards to the conditions that are resulting in the messages to be generated (ie, the old session id shouldn't be being reused), or an enhancement to clarify or adjust the log message or priority to indicate whether this will actually affect the query being submitted.
--
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
12 years, 2 months
[JBoss JIRA] (TEIID-2225) ResultSet.isLast() blocks in non-continuous query mode
by Mark Addleman (JIRA)
Mark Addleman created TEIID-2225:
------------------------------------
Summary: ResultSet.isLast() blocks in non-continuous query mode
Key: TEIID-2225
URL: https://issues.jboss.org/browse/TEIID-2225
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 8.1
Reporter: Mark Addleman
Assignee: Steven Hawkins
I am executing a query using submitExecute(StatementCallback) under non-continuous mode. In the onRow() method of the callback, I execute ResultSet.isLast(). The query is against an execution whose next() method initially throws DataNotAvailable.NO_POLLING. Some time later, it calls ExecutionContext.dataAvailable(). After 255 rows reported through the callback's onRow(), ResultSet.isLast() hangs.
I know that the entire result set is ultimately returned from the execution's next() and it returns null at the last call.
See https://community.jboss.org/thread/205559?tstart=0 for more detail
--
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
12 years, 2 months