[JBoss JIRA] (TEIIDDES-2229) Merge various fixes from master into 8.6.1
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2229?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2229:
-----------------------------------
Description:
*Candidates*
* TEIIDDES-XXXX - XXX
*Completed Upstream*
*Merged*
* TEIIDDES-1037 Data types inported from flat file partially implemented in wizard
* TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource
* TEIIDDES-2210 Using Teiid Connection importer doesn't completely import the DDL
* TEIIDDES-2287 Error Generating REST Transformation with Teiid Reserved Word
* TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation
* TEIIDDES-2323 Rest Importer should encode the both "default" and provided values before submitting query
* TEIIDDES-2336 Data lost performing Back and Next actions in WS to Source Model (REST) importer
* TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna
* TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception
* TEIIDDES-2350 Select Datatype Dialog UI issue
* TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL
* TEIIDDES-2356 Import DDL file from workspace location does not work. File not found
* TEIIDDES-2362 removed column object type when trying to ADD row-base security filter
* TEIIDDES-2358 REST WS import issues with translator and data source
* TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON
was:
*Candidates*
* TEIIDDES-XXXX - XXX
*Completed Upstream*
* TEIIDDES-1037 Data types inported from flat file partially implemented in wizard
* TEIIDDES-2210 Using Teiid Connection importer doesn't completely import the DDL
* TEIIDDES-2287 Error Generating REST Transformation with Teiid Reserved Word
* TEIIDDES-2323 Rest Importer should encode the both "default" and provided values before submitting query
* TEIIDDES-2336 Data lost performing Back and Next actions in WS to Source Model (REST) importer
* TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception
* TEIIDDES-2350 Select Datatype Dialog UI issue
* TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL
* TEIIDDES-2356 Import DDL file from workspace location does not work. File not found
* TEIIDDES-2362 removed column object type when trying to ADD row-base security filter
* TEIIDDES-2358 REST WS import issues with translator and data source
* TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON
*Merged*
* TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource
* TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation
* TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna
> Merge various fixes from master into 8.6.1
> ------------------------------------------
>
> Key: TEIIDDES-2229
> URL: https://issues.jboss.org/browse/TEIIDDES-2229
> Project: Teiid Designer
> Issue Type: Task
> Components: Patch Release
> Affects Versions: 8.5.1, 8.6.1
> Reporter: Ted Jones
> Assignee: Johnathon Lee
> Priority: Blocker
> Fix For: 8.6.1
>
>
> *Candidates*
> * TEIIDDES-XXXX - XXX
> *Completed Upstream*
> *Merged*
> * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard
> * TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource
> * TEIIDDES-2210 Using Teiid Connection importer doesn't completely import the DDL
> * TEIIDDES-2287 Error Generating REST Transformation with Teiid Reserved Word
> * TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation
> * TEIIDDES-2323 Rest Importer should encode the both "default" and provided values before submitting query
> * TEIIDDES-2336 Data lost performing Back and Next actions in WS to Source Model (REST) importer
> * TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna
> * TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception
> * TEIIDDES-2350 Select Datatype Dialog UI issue
> * TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL
> * TEIIDDES-2356 Import DDL file from workspace location does not work. File not found
> * TEIIDDES-2362 removed column object type when trying to ADD row-base security filter
> * TEIIDDES-2358 REST WS import issues with translator and data source
> * TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2369) WS Rest Connection Profile property page issues
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2369?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2369:
----------------------------------------
1) requires the following change to PropertyPage. Basically the *value.getType()* is not a string and needs to be checked against the *Parameter.Type* types.
{code}
private StringBuilder buildParameterString() {
StringBuilder parameterString = new StringBuilder();
if (this.parameterMap==null) return parameterString;
Map<String, Parameter> parameterMap = this.parameterMap;
for (String key : parameterMap.keySet()) {
Parameter value = parameterMap.get(key);
if (value.getType().equals(Parameter.Type.URI)) {
parameterString.append("/").append(value.getDefaultValue()); //$NON-NLS-1$
}
if (value.getType().equals(Parameter.Type.Query)) {
if (parameterString.length()==0 || !parameterString.toString().contains("?")){ //$NON-NLS-1$
parameterString.append("?"); //$NON-NLS-1$
}else{
parameterString.append("&"); //$NON-NLS-1$
}
parameterString.append(key).append("=").append(value.getDefaultValue()); //$NON-NLS-1$
}
}
return parameterString;
}
{code}
To address 2)
03:08:38 PM) blafond: In the bowels of the connection profile management code... trying to persist/save a REST profile with parameters
(03:10:00 PM) blafond: It's getting the "value" of the parameters map and treating it as a "string" and it's coming back null. Guessing the generic definition on exiting Eclipse is to try and persist it with a null also. hence the parameters are not restored
(03:14:36 PM) tejones: Ah right
(03:16:47 PM) blafond: tejones: so maybe think about how you want to structure those properties under the hood so you can load/save. Maybe have a key prefix'd to all the parameters? i.e. "rest_parameter:output", and "rest_parameter:q"
(03:17:01 PM) blafond: your UI can strip the prefix on presentation/edit time
(03:18:07 PM) tejones: blafond: yeah.. that would work
> WS Rest Connection Profile property page issues
> -----------------------------------------------
>
> Key: TEIIDDES-2369
> URL: https://issues.jboss.org/browse/TEIIDDES-2369
> Project: Teiid Designer
> Issue Type: Bug
> Components: Datatools Integration
> Affects Versions: 8.6
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.6.1
>
>
> 1) The URL preview isn't getting updated correctly
> 2) The parameters are getting lost after closing and restarting Eclipse/Designer.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2370) Refresh Widget value issues with WS Rest Import Wizard
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2370:
--------------------------------------
Summary: Refresh Widget value issues with WS Rest Import Wizard
Key: TEIIDDES-2370
URL: https://issues.jboss.org/browse/TEIIDDES-2370
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export, Web Services Support
Affects Versions: 8.6
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 8.6.1, 8.7
Changing selected connection profile on first page doesn't update all fields correctly
Causing new "Show Contents" action/dialog to not work correctly (see TEIIDDES-2328)
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2369) WS Rest Connection Profile property page issues
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2369:
--------------------------------------
Summary: WS Rest Connection Profile property page issues
Key: TEIIDDES-2369
URL: https://issues.jboss.org/browse/TEIIDDES-2369
Project: Teiid Designer
Issue Type: Bug
Components: Datatools Integration
Affects Versions: 8.6
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 8.6.1
1) The URL preview isn't getting updated correctly
2) The parameters are getting lost after closing and restarting Eclipse/Designer.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2328) Rest Importer: Show the response document
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2328?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2328:
--------------------------------------
Assignee: Barry LaFond (was: Ted Jones)
> Rest Importer: Show the response document
> -----------------------------------------
>
> Key: TEIIDDES-2328
> URL: https://issues.jboss.org/browse/TEIIDDES-2328
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Affects Versions: 8.6
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Fix For: 8.6.1, 8.7
>
> Attachments: showdocument.png
>
>
> I used the one of the REST APIs from [http://nycpulse.herokuapp.com/api]
> For this JIRA, I was using [http://mtaapi.herokuapp.com/times?hour=10&minute=25]
> The importer says the response document is bad, see the attached screen shot. The repose is like
> {code}
> {
> "result": [
> {
> "arrival": "10:25:00",
> "id": "242N",
> "lat": "40.662742",
> "lon": "-73.95085",
> "name": "Sterling St"
> },
> {
> "arrival": "10:25:00",
> "id": "242N",
> "lat": "40.662742",
> "lon": "-73.95085",
> "name": "Sterling St"
> },
> {
> "arrival": "10:25:30",
> "id": "A09S",
> "lat": "40.840719",
> "lon": "-73.939561",
> "name": "168 St"
> }
> }
> {code}
> So, that looks like valid JSON to me. So, two part question
> 1) Why importer complaining? fix any errors as such
> 2) The gist of this JIRA, instead of showing link to some response file, that I have no way to check the contents if wanted, show the response document itself. This pattern is not new, CSV importer and XML importer do show the document to user, which IMO is much more valuable and gives visual indication right away what they are working with.
> I even say this needs to be done File based importer too (create JIRA if you decide to work on this separately)
>
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1898) Connection Profile requires a password for preview
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1898?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1898:
-----------------------------------
Fix Version/s: (was: 8.6.1)
Assignee: Barry LaFond (was: Ted Jones)
> Connection Profile requires a password for preview
> --------------------------------------------------
>
> Key: TEIIDDES-1898
> URL: https://issues.jboss.org/browse/TEIIDDES-1898
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.2
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Fix For: 8.7
>
>
> Some data sources can work without user name and/or password for connecting to the source. So, those properties are not mandatory and requiring them for preview is unnecessary if they are not defined.
> In this example, Hive Connection profile was created with username but with out password, when the Teiid Connection importer used and them a connection profile is set on it to use the preview, it failed until a dummy password is provided
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month