[JBoss JIRA] Created: (TEIIDDES-992) Allow the use of pushdown functions without requiring Java programming
by Bernd Groh (JIRA)
Allow the use of pushdown functions without requiring Java programming
----------------------------------------------------------------------
Key: TEIIDDES-992
URL: https://issues.jboss.org/browse/TEIIDDES-992
Project: Teiid Designer
Issue Type: Feature Request
Reporter: Bernd Groh
Currently, in order to use a database function, even if pushdown is required, it is still necessary to add the function interface to a Java class within the connector, and the connector then must be deployed to the server in order to allow for this pushdown function to be used within the Designer. This creates a lot of extra effort every time you want to make use of a new database function. Particularly, given the schema designer doesn't necessarily have access to either the connector code or the server, and then must involve other parties simply to be able to use an additional database function. It would be very beneficial to speedy schema development if that was not necessary, and if, say, the interface could be defined on the Designer side, added to the VDB, and then deployed as part of the VDB.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 8 months
[JBoss JIRA] Created: (TEIIDDES-982) Web Services Connection Profile dialog doesn't provide guidance when CP has no valid Teiid connection properties
by Paul Nittel (JIRA)
Web Services Connection Profile dialog doesn't provide guidance when CP has no valid Teiid connection properties
----------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-982
URL: https://issues.jboss.org/browse/TEIIDDES-982
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.4
Environment: JBDS 4.1.0 CR1
Reporter: Paul Nittel
I'm trying to replicate the Weather example using Designer.
I created (generated?) the invoke procedure and modeled a view whose transformation SQL contains the XML parsing constructs used in the example.
I created a connection profile as part of defining the data source. This process involves the Web Services Data Source dialog (see screenshot). For this I entered the URL as the SOAP endpoint. Al other field were left blank. Test connection returned a success message, yet when I exited the dialog, the resulting profile was in error "There are no valid Teiid connection properties associated with this connection profile". (See the other screenshot.)
Perhaps this is evidence of an underlying bug, but it represents a usability issue since it doesn't clearly explain what's missing or incorrect.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 8 months
[JBoss JIRA] Created: (TEIIDDES-885) Preview Data fails if attempted immediately after "Save" model.
by Barry LaFond (JIRA)
Preview Data fails if attempted immediately after "Save" model.
---------------------------------------------------------------
Key: TEIIDDES-885
URL: https://issues.jboss.org/browse/TEIIDDES-885
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 7.3
Reporter: Barry LaFond
Assignee: Dan Florian
Priority: Critical
Fix For: 7.4
Set up Designer with sample project with source model and connect to Teiid Instance
1) Open Package diagram for model and select Table
2) Select Preview Data action and see successful results
3) Drag diagram component and Save
4) Click Preview Data action right after click save
5) Get query result of: "Remote org.teiid.core.TeiidProcessingException: Failed to find the Connection Factory with JNDI name PREVIEW_42463872-ecd7-46dd-93b1-450354a53b55_PartsProject_PartsSourceB. Please check the name or deploy the Connection Factory with specified name."
6) Wait a few more seconds and try Preview Data again and it'll be successful
Guessing the create/deploy/redeploy VDB and maybe Data Source jobs aren't complete yet or are waiting for auto-build to run or something.
Maybe in the Preview Data action we can check the PreviewManager and stop the action of PVDB jobs are running. Or we schedule/wait the new PVDB jobs until existing are finished running.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 8 months
[JBoss JIRA] Created: (TEIIDDES-953) "Generate SQL Relationships" action allows multiple generations in same model which then results in errors
by Paul Nittel (JIRA)
"Generate SQL Relationships" action allows multiple generations in same model which then results in errors
----------------------------------------------------------------------------------------------------------
Key: TEIIDDES-953
URL: https://issues.jboss.org/browse/TEIIDDES-953
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Fedora 14, OpenJDK Runtime Environment (IcedTea6 1.9.7) (fedora-52.1.9.7.fc14-x86_64)
Reporter: Paul Nittel
I opened the RelationshipsTest project (Model Project Set attached), navigated to TestModel.StoreMovies and generated SQL relationships. I created a new model in which the resulting relationships should be stored. Then, I repeated the operation, but changed the generator options. After saving the model, I found errors like this in the Problems tab:
The name REL0001 is the same (ignoring case) as 1 other object(s) under the same parent fooTooModel.xmi /RelationshipsTest.
I believe it makes sense to add more relationships to the same model when they could be in conflict. Perhaps a warning beforehand? Maybe don't allow it?
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 9 months
[JBoss JIRA] Created: (TEIIDDES-973) Create Table from query
by Joel Tosi (JIRA)
Create Table from query
-----------------------
Key: TEIIDDES-973
URL: https://issues.jboss.org/browse/TEIIDDES-973
Project: Teiid Designer
Issue Type: Feature Request
Components: Transformations
Affects Versions: 7.2
Environment: JBDS 4.0
Reporter: Joel Tosi
Priority: Minor
As a user, I would like to be able to create tables from queries. I would like to be able to set the query property of a virtual table. You cannot directly set the query for the object as a property. The Transform metaphor seems more suited to ETL and complex queries whereas allowing a user to create the virtual table from queries would be more natural.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 9 months