[JBoss JIRA] (TEIIDDES-2359) Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2359?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2359:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1148002|https://bugzilla.redhat.com/show_bug.cgi?id=1148002] from NEW to MODIFIED
> Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON
> -----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2359
> URL: https://issues.jboss.org/browse/TEIIDDES-2359
> Project: Teiid Designer
> Issue Type: Enhancement
> Affects Versions: 8.6.1
> Environment: Windows 7
> Reporter: Matus Makovy
> Attachments: 1.png, 2.png, 3.png, 4.png, 5.png, 6.png, log.txt
>
>
> I have my small web application that should simulate a REST web service (it simply returns XML and JSON strings), when I have annotation @Produces("application/json") and I try to import from this REST JSON, TD gives me an error that server returned response code 406.
> After I change it in my application to @Produces("application/xml") it is OK.
> I tried to force server to log accept-headers that it is sending. Server sends accept-headers: aplication/xml (Log attached)
> Screenshots attached
> TD 8.6.1.Alpha1 + DV 6.1.ER2
> I am not sure, but I think this issue occurs also in 8.3.4
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2367) MongoDB: sampling the data and auto generate schema
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2367?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2367:
----------------------------------------
No, import properties. But I know Designer devs have put artificial barrier to not to complete MongoDB translator import before, I am not sure if they removed it now or not.
I have suggested many times that "Teiid Connection Import" should always go through no matter which data source/translator is being selected, even it returns empty or null DDL. In case of the empty or null DDL create a empty source model, that user can start modeling it by hand. By doing this way, user has created a model that is already hooked up with connection profile for preview etc.
> MongoDB: sampling the data and auto generate schema
> ----------------------------------------------------
>
> Key: TEIIDDES-2367
> URL: https://issues.jboss.org/browse/TEIIDDES-2367
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Teiid Integration
> Affects Versions: 8.7
> Environment: Teiid with MongoDB
> Reporter: Ivan Chan
> Labels: Teiid
>
> Currently, Teiid requires user to generate schema for MongoDB data source manually. I think it would be much nicer if Teiid can sample the data and generate default schema.
> And users may modify the schema to fit their needs or use it as it.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[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*
* 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
was:
*Candidates*
* TEIIDDES-XXXX - XXX
*Completed Upstream*
* TEIIDDES-1037 Data types inported from flat file partially implemented in wizard
* 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*
> * 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
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2210) Using Teiid Connection importer doesn't completely import the DDL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2210?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2210.
------------------------------------
Resolution: Done
Done
> Using Teiid Connection importer doesn't completely import the DDL
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2210
> URL: https://issues.jboss.org/browse/TEIIDDES-2210
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.5
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 8.7, 8.6.1
>
>
> When using Teiid connection importer, there's a couple of issues importing the ddl:
> 1. this property isn't being loaded: "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person'
> 2. NIS for Foreign key isn't being set: CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones')
> Example DDL:
> CREATE FOREIGN TABLE Person (
> PersonObject object OPTIONS (NAMEINSOURCE 'this', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'java.lang.Object'),
> name string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> id integer OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.Integer'),
> email string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person');
> CREATE FOREIGN TABLE PhoneNumber (
> number string OPTIONS (NAMEINSOURCE 'phone.number', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> type string OPTIONS (NAMEINSOURCE 'phone.type', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> Id integer NOT NULL OPTIONS (SELECTABLE FALSE, SEARCHABLE 'Unsearchable', NATIVE_TYPE 'int'),
> CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones')
> ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.PhoneNumber');
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2210) Using Teiid Connection importer doesn't completely import the DDL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2210?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2210:
-----------------------------------
Fix Version/s: 8.7
> Using Teiid Connection importer doesn't completely import the DDL
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2210
> URL: https://issues.jboss.org/browse/TEIIDDES-2210
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.5
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 8.7, 8.6.1
>
>
> When using Teiid connection importer, there's a couple of issues importing the ddl:
> 1. this property isn't being loaded: "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person'
> 2. NIS for Foreign key isn't being set: CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones')
> Example DDL:
> CREATE FOREIGN TABLE Person (
> PersonObject object OPTIONS (NAMEINSOURCE 'this', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'java.lang.Object'),
> name string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> id integer OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.Integer'),
> email string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person');
> CREATE FOREIGN TABLE PhoneNumber (
> number string OPTIONS (NAMEINSOURCE 'phone.number', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> type string OPTIONS (NAMEINSOURCE 'phone.type', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> Id integer NOT NULL OPTIONS (SELECTABLE FALSE, SEARCHABLE 'Unsearchable', NATIVE_TYPE 'int'),
> CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones')
> ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.PhoneNumber');
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2367) MongoDB: sampling the data and auto generate schema
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2367?page=com.atlassian.jira.plu... ]
Ivan Chan commented on TEIIDDES-2367:
-------------------------------------
No, I don't think so. Does Teiid have special importer property to sample the mongodb data and auto-generate schema text?
> MongoDB: sampling the data and auto generate schema
> ----------------------------------------------------
>
> Key: TEIIDDES-2367
> URL: https://issues.jboss.org/browse/TEIIDDES-2367
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Teiid Integration
> Affects Versions: 8.7
> Environment: Teiid with MongoDB
> Reporter: Ivan Chan
> Labels: Teiid
>
> Currently, Teiid requires user to generate schema for MongoDB data source manually. I think it would be much nicer if Teiid can sample the data and generate default schema.
> And users may modify the schema to fit their needs or use it as it.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month
[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*
* TEIIDDES-1037 Data types inported from flat file partially implemented in wizard
* 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
was:
*Candidates*
* TEIIDDES-XXXX - XXX
*Completed Upstream*
* TEIIDDES-1037 Data types inported from flat file partially implemented in wizard
* 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*
> * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard
> * 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
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 1 month