October 2011 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1091) New Connection Profile dialog's URL field should not appear editable

by Randall Hauch (Created) (JIRA)

New Connection Profile dialog's URL field should not appear editable -------------------------------------------------------------------- Key: TEIIDDES-1091 URL: https://issues.jboss.org/browse/TEIIDDES-1091 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.4 Reporter: Randall Hauch The "Connection URL" field in the "New Connection Profile" window of the "Import Database via JDBC" wizard is a text area that appears to be editable even when it is a read-only field generated from the other fields. It needs to be much more obvious that it is not editable. -- 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, 9 months

4
5
0 / 0

[JBoss JIRA] (TEIIDDES-1088) Importing from SQL Server, when multiple schemas exist for a login, will not show the tables in the schema

by Barry LaFond (Updated) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1088?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1088: ----------------------------------- Fix Version/s: 7.6 > Importing from SQL Server, when multiple schemas exist for a login, will not show the tables in the schema > ---------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1088 > URL: https://issues.jboss.org/browse/TEIIDDES-1088 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 7.4.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Priority: Blocker > Fix For: 7.4.2, 7.6 > > > When using Designer to import metadata from SQL Server database: jdbc:sqlserver://slntdb02.mw.lab.eng.bos.redhat.com:1433;databaseName=books (user/pw = books/mm) > the issue is the tables are not shown in order to import. This was confirmed by several people. If Squirrel is used, then the underlying tables can be seen under "dbo". -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1088) Importing from SQL Server, when multiple schemas exist for a login, will not show the tables in the schema

by Barry LaFond (Updated) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1088?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1088: ----------------------------------- Fix Version/s: 7.4.2 > Importing from SQL Server, when multiple schemas exist for a login, will not show the tables in the schema > ---------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1088 > URL: https://issues.jboss.org/browse/TEIIDDES-1088 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 7.4.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Priority: Blocker > Fix For: 7.4.2 > > > When using Designer to import metadata from SQL Server database: jdbc:sqlserver://slntdb02.mw.lab.eng.bos.redhat.com:1433;databaseName=books (user/pw = books/mm) > the issue is the tables are not shown in order to import. This was confirmed by several people. If Squirrel is used, then the underlying tables can be seen under "dbo". -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1108) Set Query Timeout at the VDB level

by Van Halbert (Moved) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1108?page=com.atlassian.jira.plu... ] Van Halbert moved TEIID-1770 to TEIIDDES-1108: ---------------------------------------------- Project: Teiid Designer (was: Teiid) Key: TEIIDDES-1108 (was: TEIID-1770) Affects Version/s: (was: 7.3) Component/s: VDB & Execution (was: Server) Fix Version/s: 7.6 (was: 7.6) > Set Query Timeout at the VDB level > ---------------------------------- > > Key: TEIIDDES-1108 > URL: https://issues.jboss.org/browse/TEIIDDES-1108 > Project: Teiid Designer > Issue Type: Feature Request > Components: VDB & Execution > Environment: Windows > Reporter: RAKESH BALGURI > Assignee: Steven Hawkins > Fix For: 7.6 > > > Hi, > We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object. > Please see this discussion for more information http://community.jboss.org/message/600599#600599 > We want the setQueryTimeout to override the default values. -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1108) Set Query Timeout at the VDB level

by Van Halbert (Assigned) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1108?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-1108: ------------------------------------- Assignee: Barry LaFond (was: Steven Hawkins) > Set Query Timeout at the VDB level > ---------------------------------- > > Key: TEIIDDES-1108 > URL: https://issues.jboss.org/browse/TEIIDDES-1108 > Project: Teiid Designer > Issue Type: Feature Request > Components: VDB & Execution > Environment: Windows > Reporter: RAKESH BALGURI > Assignee: Barry LaFond > Fix For: 7.6 > > > Hi, > We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object. > Please see this discussion for more information http://community.jboss.org/message/600599#600599 > We want the setQueryTimeout to override the default values. -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1107) Teiid Designer - SalesForce Connection Profile Should Default to HTTPS

by Paul Nittel (Created) (JIRA)

Teiid Designer - SalesForce Connection Profile Should Default to HTTPS ---------------------------------------------------------------------- Key: TEIIDDES-1107 URL: https://issues.jboss.org/browse/TEIIDDES-1107 Project: Teiid Designer Issue Type: Bug Components: Datatools Integration Affects Versions: 7.5, 7.4.2 Reporter: Paul Nittel Assignee: Barry LaFond The SalesForce connection profile uses http in it's default URL which causes the following error when creating a connection profile: java.lang.Exception: com.sforce.soap.partner.UnexpectedErrorFault: UNSUPPORTED_CLIENT: HTTPS Required at com.metamatrix.modeler.modelgenerator.salesforce.connection.impl.Connection.login(Connection.java:82) at org.teiid.designer.datatools.salesforce.SalesForceConnection.<init>(SalesForceConnection.java:48) at org.teiid.designer.datatools.salesforce.ConnectionFactory.createConnection(ConnectionFactory.java:11) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360) at org.teiid.designer.datatools.salesforce.ui.SalesForceProfileDetailsWizardPage$SalesforcePingJob.createTestConnection(SalesForceProfileDetailsWizardPage.java:405) at org.teiid.designer.datatools.salesforce.ui.SalesForceProfileDetailsWizardPage$SalesforcePingJob.run(SalesForceProfileDetailsWizardPage.java:392) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: com.sforce.soap.partner.UnexpectedErrorFault: UNSUPPORTED_CLIENT: HTTPS Required at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.sun.xml.internal.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:130) at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:108) at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:78) at com.sun.xml.internal.ws.client.sei.SEIStub.invoke(SEIStub.java:107) at $Proxy36.login(Unknown Source) at com.metamatrix.modeler.modelgenerator.salesforce.connection.impl.Connection.login(Connection.java:73) ... 7 more Overriding with the ssl version of the URL gets around this issue. -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1106) Teiid Designer - New Teiid Instance dialog is confusing

by Paul Nittel (Created) (JIRA)

Teiid Designer - New Teiid Instance dialog is confusing ------------------------------------------------------- Key: TEIIDDES-1106 URL: https://issues.jboss.org/browse/TEIIDDES-1106 Project: Teiid Designer Issue Type: Enhancement Components: Teiid Integration Affects Versions: 7.4 Reporter: Paul Nittel Assignee: Barry LaFond Priority: Critical Fix For: 7.6 Attachments: New Teiid Instance dialog.png The "New Teiid Instance" dialog is extremely confusing, and it's not clear at all how to fill out the values on this dialog. First of all, I have no idea what "Label" means. I can guess, and I'm probably right, but seems like the name of the instance (shown in the server list) should be at the top of the dialog, but "Host" is there. Seems backwards. And generally these kinds of things are referred to as "names" not "label". (Label to me is a tag that is applied, whereas a name is the string/key by which something can referred.) Secondly, the 'Test' button (which is in the Admin area) only works when you've specified the JDBC connection info, which is in a different area. If that's the case, then it should be moved outside of both sections. Note that if I put a bogus username and password in the "Teiid JDBC Connection Info" section, I can test the Admin connection successfully. So my guess is that the 'Test' button *should* be enabled and functional even when the JDBC Connection Info username and password are not filled in. (Maybe this should be a separate BUG?) Also, shouldn't the 'Test' button be disabled if it cannot be used (perhaps with a mouse-over that says what's required to use it)? Thirdly, I found many of the items on the dialog to be very confusing and unclear as to what they really represent, why I'm entering this information now, and how it relates to things in the actual server. Perhaps users with more Teiid experience have come to learn what they all mean, but it's likely pretty confusing for new users or users like me that don't regularly use Teiid. Why is the Admin connection info needed? I know it's because Teiid Designer can deploy new VDBs. But then why is the JDBC connection info needed? Again, I know that Teiid Designer can connect to a deployed VDB. But why does the URL have "<vdbname>" in it? Perhaps because it's used as a template? And if so, then might the username and password often be different for different VDBs? If so, then why do I have to specify it here? All of this should be explained (perhaps with a help button). And better yet, I should be able to specify where the Teiid server is without having to specify any connection info, and when Teiid Designer needs the connection info and it's not there, it should prompt me and save it. I would have expected that the Teiid Instance dialog has the server information and, if any VDB connectivity is shown then all of the available VDBs are shown (with ways of caching/storing the connection info for each). -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1105) Teiid Designer - Import of Salesforce model does not map the BusinessHours table columns correctly

by Paul Nittel (Created) (JIRA)

Teiid Designer - Import of Salesforce model does not map the BusinessHours table columns correctly -------------------------------------------------------------------------------------------------- Key: TEIIDDES-1105 URL: https://issues.jboss.org/browse/TEIIDDES-1105 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.4 Reporter: Paul Nittel Assignee: Mark Drilling Fix For: 7.6 Import from salesforce instance does appear to be mapping the BusinessHours column types correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time based datatype. It either does not get mapped or it maps to a string. -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1104) Teiid Designer - Using Flat File Importer, it doesn't recognize "\n" or "\r\n" in the file

by Paul Nittel (Created) (JIRA)

Teiid Designer - Using Flat File Importer, it doesn't recognize "\n" or "\r\n" in the file ------------------------------------------------------------------------------------------ Key: TEIIDDES-1104 URL: https://issues.jboss.org/browse/TEIIDDES-1104 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.4.2 Reporter: Paul Nittel Trying to use the Import from Flat File option, but it doesn't recognize linefeeds of "\n" or "\r\n". -- 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, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1103) Teiid Designer - Improve the SQL Results View

by Paul Nittel (Created) (JIRA)

Teiid Designer - Improve the SQL Results View --------------------------------------------- Key: TEIIDDES-1103 URL: https://issues.jboss.org/browse/TEIIDDES-1103 Project: Teiid Designer Issue Type: Enhancement Components: Views Affects Versions: 7.4 Reporter: Paul Nittel Attachments: SQLResultsView.png 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, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2011