[JBoss JIRA] Created: (TEIIDDES-923) Passing NULL into a Procedure in Preview Causes Exception
by Ted Jones (JIRA)
Passing NULL into a Procedure in Preview Causes Exception
---------------------------------------------------------
Key: TEIIDDES-923
URL: https://issues.jboss.org/browse/TEIIDDES-923
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 7.4
Reporter: Ted Jones
I have a virtual procedure that accepts one parameter that may be null. When I pass a value in it works fine but when I check the NULL checkbox fir the input variable I get the following exception, "Remote org.teiid.api.exception.query.QueryValidatorException: Bind variables (represented as "?") were found but are allowed only in prepared or callable statements."
Here is the generated query from preview: select * from ( exec RestfulBooks.getBooks(?) ) AS X_X
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 3 months
[JBoss JIRA] (TEIIDDES-1102) Improve the SQL Results View
by Mark Drilling (Created) (JIRA)
Improve the SQL Results View
----------------------------
Key: TEIIDDES-1102
URL: https://issues.jboss.org/browse/TEIIDDES-1102
Project: Teiid Designer
Issue Type: Enhancement
Components: Views
Affects Versions: 7.4
Reporter: Mark Drilling
Recommendations to improve the user experience with SQL Results view. Example screenshot will be attached.
1) When a query is successful, it should remain on the 'result' tab. Instead, the results table is displayed for a second - then it flips to the 'status' tab. It should stay on the results. An unsuccessful query should show the status and remain there.
2) The results are shown on a tab labeled 'Result1'. I don't see a way to get multiple result tabs. If that's the case, it should just be labeled 'Results' instead of 'Result1'
3) For Preview queries, the 'Connection Profile' column value is not user readable. It is something like 'Transient.org.teiid.datatools.connectivity.connectionProfile'. For previews, it should be something that makes sense to the user - maybe 'Preview - localhost - Teiid Connection' (to be consistent with other connectionProfile infos).
--
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, 3 months
[JBoss JIRA] Created: (TEIIDDES-882) Create new SOAP service connection profile.
by John Doyle (JIRA)
Create new SOAP service connection profile.
-------------------------------------------
Key: TEIIDDES-882
URL: https://issues.jboss.org/browse/TEIIDDES-882
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 7.2, 7.1, 7.3
Reporter: John Doyle
For the WSDL into Relational Model Importer we take advantage of the DTP provided Web Service Data Source connection profile. We really only did this because of time constraints. That profile has attributes that don't make sense for Teiid Designer and are ignored by Designer. We really need our own dedicated connection profile that provides the correct interface to the user and enables us to satisfy existing issues we cannot solve with the DTP profile.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 3 months
[JBoss JIRA] Created: (TEIIDDES-942) Need better indication of Error in Query Plan retrieval
by Mark Drilling (JIRA)
Need better indication of Error in Query Plan retrieval
-------------------------------------------------------
Key: TEIIDDES-942
URL: https://issues.jboss.org/browse/TEIIDDES-942
Project: Teiid Designer
Issue Type: Enhancement
Components: Datatools Integration
Affects Versions: 7.1.1
Reporter: Mark Drilling
Priority: Minor
It should be obvious to the user on the "Execution Plan" tab if a query error prevents retrieval of the Query Plan.
- Executed a user query. The Execution Plan just showed the original SQL and nothing else...
- Further examination of the server log showed plan debug output, but there was a source error on execution
- I switched over to the "Message Log" tab in designer to find the message "An exception occurred fetching the Query Plan"
Request that the Execution Plan tab show a problem message, instead of just showing the original SQL.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 3 months
[JBoss JIRA] Created: (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure statements for RestEasy XML, File Translator and Web Service Translator procedures
by Barry LaFond (JIRA)
Add ability to edit/generate Create Virtual Procedure statements for RestEasy XML, File Translator and Web Service Translator procedures
----------------------------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-987
URL: https://issues.jboss.org/browse/TEIIDDES-987
Project: Teiid Designer
Issue Type: Enhancement
Components: Editors, Transformations
Affects Versions: 7.4
Reporter: Barry LaFond
Fix For: 7.5
Designer includes "Generate xxxx procedures" options in the New Model Wizard.
Also have a RestEasy use-case that requires getXXXX virtual procedures that contain SQL like:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT XMLELEMENT(NAME parts, XMLAGG(XMLELEMENT(NAME part, XMLFOREST(VirtualParts_Supplier.PARTS.PART_ID, VirtualParts_Supplier.PARTS.PART_NAME, VirtualParts_Supplier.PARTS.PART_COLOR, VirtualParts_Supplier.PARTS.PART_WEIGHT)))) AS result FROM VirtualParts_Supplier.PARTS WHERE VirtualParts_Supplier.getParts.partId_in = VirtualParts_Supplier.PARTS.PART_ID;
END
Would be nice to have a framework where "wizards" can be accessed to create/edit the content of this SQL if the basic structure is a Set Query (SELECT * FROM XXX)for these specific use-cases.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] Created: (TEIIDDES-1043) Test Connection on LDAP Connection Profile Wizard page does not enable
by Barry LaFond (JIRA)
Test Connection on LDAP Connection Profile Wizard page does not enable
----------------------------------------------------------------------
Key: TEIIDDES-1043
URL: https://issues.jboss.org/browse/TEIIDDES-1043
Project: Teiid Designer
Issue Type: Bug
Components: Datatools Integration
Affects Versions: 7.4, 7.5, 7.4.2
Reporter: Barry LaFond
Fix For: 7.6
Filling in required info in new LDAP connection profile does not enable the "Test Connection" button.
Looks like a "setPingButtonEnabled(true);" call needs to be made at the end of the LdapProfileDetailsWizardPage.validate() method, but adding the code ends up throwing an NPE when pressed.
So, it looks like there is no IConnectionFactoryProvider/IConnectionFactory contributed for the LDAP connection to use to "ping" the DB. This would have to be completed in order for the Test Connection button to not throw an NPE
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] Created: (TEIIDDES-676) Add good defaults to XML Schema Import Wizard
by John Verhaeg (JIRA)
Add good defaults to XML Schema Import Wizard
---------------------------------------------
Key: TEIIDDES-676
URL: https://jira.jboss.org/browse/TEIIDDES-676
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 7.1
Reporter: John Verhaeg
We should choose good defaults throughout this wizard, such as:
- Pre-select the "from file system" option (vs. "via URL") on the first page
- Auto-populate the "From directory" field to the user folder and remember whatever the user finally chooses thereafter. Working with a selection dialog that only allows you to choose a folder is too different from the norm to not be awkward. Always takes me a few seconds to remember why the *file* I'm trying to select is grayed-out.
- Auto-populate the "Into folder" field if there is only one folder, a single project folder, in the workspace.
- Provide a way to create a project so the user doesn't have to exit the entire wizard if they forget to first do that.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1109) Error while validating Web service operation transformation points to source in underlying error-free model
by Paul Nittel (Created) (JIRA)
Error while validating Web service operation transformation points to source in underlying error-free model
-----------------------------------------------------------------------------------------------------------
Key: TEIIDDES-1109
URL: https://issues.jboss.org/browse/TEIIDDES-1109
Project: Teiid Designer
Issue Type: Bug
Components: Validation
Affects Versions: 7.4.2
Reporter: Paul Nittel
Priority: Critical
I'm executing the Updateable Web Service test and have encountered a new error.
I'm working on the operation that does inserts. The SQL is sending the update info to the view model that has the INSERT transformation. When I validate the procedure, I get ERROR: Products.PRODUCTSYMBOLS does not exist.
That actually exists as a source underlying the Updates model, not the Web Service. So how can the underlying transformation be valid and this one not be? (At least relative to this particular table in question.)
I'd be happy to find out it was something I did incorrectly, but the error message is pretty weak in conveying meaningful information.
Given the ubiquitous nature of Web services, I'm marking this bug as "critical". It could be a blocker, but I'll let someone else make that call.
--
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, 5 months
[JBoss JIRA] Created: (TEIIDDES-652) Rose importer fails with multiple exceptions
by Paul Nittel (JIRA)
Rose importer fails with multiple exceptions
--------------------------------------------
Key: TEIIDDES-652
URL: https://jira.jboss.org/browse/TEIIDDES-652
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Environment: JBDS H30
Reporter: Paul Nittel
Fix For: 7.1.1
Attachments: NestedClass.mdl
I used the Rose importer to import the attached .mdl file. I checked all objects as I progressed through the wizard. Eventually I received:
Error 2010-10-06 10:26:05.71
java.lang.UnsupportedOperationException
at org.eclipse.uml2.common.util.DerivedEObjectEList$DerivedListIterator.add(DerivedEObjectEList.java:278)
at java.util.AbstractSequentialList.add(AbstractSequentialList.java:129)
at org.eclipse.uml2.common.util.DerivedEObjectEList.addUnique(DerivedEObjectEList.java:636)
at org.eclipse.uml2.common.util.DerivedEObjectEList.add(DerivedEObjectEList.java:623)
at java.util.AbstractList.add(AbstractList.java:91)
at com.metamatrix.rose.internal.handler.UmlHandler.createClass(UmlHandler.java:589)
at com.metamatrix.rose.internal.handler.AbstractRoseHandler.visitObject(AbstractRoseHandler.java:239)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverseObject(RoseWalker.java:45)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverse(RoseWalker.java:63)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverseList(RoseWalker.java:52)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverse(RoseWalker.java:67)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverseObject(RoseWalker.java:46)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverse(RoseWalker.java:63)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverseObject(RoseWalker.java:46)
at org.eclipse.emf.importer.rose.builder.RoseWalker.traverse(RoseWalker.java:40)
at com.metamatrix.rose.internal.RoseImporter.parseUnits(RoseImporter.java:869)
at com.metamatrix.rose.internal.RoseImporter.parseSelectedUnits(RoseImporter.java:598)
at com.metamatrix.rose.internal.ui.wizard.RoseImportWizard$4.run(RoseImportWizard.java:354)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
If a model is created it is incomplete.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 5 months