[JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin... ]
Mark Drilling updated TEIID-2998:
---------------------------------
Attachment: FirefoxSheet.png
screencap of sheet created in firefox
> problems with DDL returned for dynamic vdb with google spreadsheet source
> -------------------------------------------------------------------------
>
> Key: TEIID-2998
> URL: https://issues.jboss.org/browse/TEIID-2998
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt
>
>
> I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters)
> See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet.
> Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin... ]
Mark Drilling updated TEIID-2998:
---------------------------------
Attachment: ChromeSheet.png
screencap of sheet created in Chrome
> problems with DDL returned for dynamic vdb with google spreadsheet source
> -------------------------------------------------------------------------
>
> Key: TEIID-2998
> URL: https://issues.jboss.org/browse/TEIID-2998
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt
>
>
> I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters)
> See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet.
> Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source
by Mark Drilling (JIRA)
Mark Drilling created TEIID-2998:
------------------------------------
Summary: problems with DDL returned for dynamic vdb with google spreadsheet source
Key: TEIID-2998
URL: https://issues.jboss.org/browse/TEIID-2998
Project: Teiid
Issue Type: Bug
Components: AdminApi
Affects Versions: 8.7
Reporter: Mark Drilling
Assignee: Steven Hawkins
Attachments: GoogleSpreadsheetJIRA.txt
I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters)
See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet.
Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin... ]
Mark Drilling updated TEIID-2998:
---------------------------------
Attachment: GoogleSpreadsheetJIRA.txt
> problems with DDL returned for dynamic vdb with google spreadsheet source
> -------------------------------------------------------------------------
>
> Key: TEIID-2998
> URL: https://issues.jboss.org/browse/TEIID-2998
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Attachments: GoogleSpreadsheetJIRA.txt
>
>
> I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters)
> See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet.
> Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2996) Ability to disable keepAlive
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2996?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2996:
---------------------------------------
There will be a set of changes here:
1. allow for disabling the ping keep alive check on the server-side
2. allow for disabling the ping on the client-side (ideally this should be done as part of the handshake)
3. allow for even stickier Teiid connections so that multiple hosts can be specified, but no automatic load balancing is used.
> Ability to disable keepAlive
> ----------------------------
>
> Key: TEIID-2996
> URL: https://issues.jboss.org/browse/TEIID-2996
> Project: Teiid
> Issue Type: Enhancement
> Components: Server
> Affects Versions: 7.7.10
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
>
> offer an option to disable the ping/keep alive as the connections will always be associated with a given socket.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2997) 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2997?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2997.
-----------------------------------
Resolution: Rejected
>From http://www.odata.org/documentation/odata-version-2-0/batch-processing/
"If the set of HTTP Request headers of a Batch request are valid (the Content-Type is set to multipart/mixed, etc.) the server returns a 202 Accepted HTTP response code to indicate that the request has been accepted for processing, but that the processing has not yet been completed."
202 is a valid response.
> 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-2997
> URL: https://issues.jboss.org/browse/TEIID-2997
> Project: Teiid
> Issue Type: Feature Request
> Components: OData
> Reporter: K Prashanthi
> Assignee: Steven Hawkins
>
> Hi,
> I am trying to send multiple xml inputs through odata batch in POSTMAN rest client. But i am getting 202 Accepted response and i do not see the data being reflected in the backend.
> URL- http://<host>:<port>/odata/<vdb>/<view>/$batch
> Headers:
> Content-Type:multipart/mixed
> boundary: batch
> Request Body:
> --batch
> POST /$batch HTTP/1.1
> Content-Type: multipart/mixed; boundary=changeset
> --changeset
> Content-Type: application/xml
> Content-Transfer-Encoding: binary
> POST
> Content-Type:application/xml
> Content-Length:1024
>
> XML INPUT-1
>
>
> --changeset
> Content-Type:application/xml
> Content-Transfer-Encoding: binary
> POST
> Content-Type:application/xml
> Content-Length:1024
> XMl Input-2
> --changeset--
> --batch--
> Please suggest.
> Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2997) 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
by K Prashanthi (JIRA)
[ https://issues.jboss.org/browse/TEIID-2997?page=com.atlassian.jira.plugin... ]
K Prashanthi commented on TEIID-2997:
-------------------------------------
oh.. sorry i will post this question in forum.
> 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-2997
> URL: https://issues.jboss.org/browse/TEIID-2997
> Project: Teiid
> Issue Type: Feature Request
> Components: OData
> Reporter: K Prashanthi
> Assignee: Steven Hawkins
>
> Hi,
> I am trying to send multiple xml inputs through odata batch in POSTMAN rest client. But i am getting 202 Accepted response and i do not see the data being reflected in the backend.
> URL- http://<host>:<port>/odata/<vdb>/<view>/$batch
> Headers:
> Content-Type:multipart/mixed
> boundary: batch
> Request Body:
> --batch
> POST /$batch HTTP/1.1
> Content-Type: multipart/mixed; boundary=changeset
> --changeset
> Content-Type: application/xml
> Content-Transfer-Encoding: binary
> POST
> Content-Type:application/xml
> Content-Length:1024
>
> XML INPUT-1
>
>
> --changeset
> Content-Type:application/xml
> Content-Transfer-Encoding: binary
> POST
> Content-Type:application/xml
> Content-Length:1024
> XMl Input-2
> --changeset--
> --batch--
> Please suggest.
> Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2997) 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2997?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2997:
-------------------------------------
Is this a question or you asserting that there is bug in the software? Questions need to be asked in forum first, if they are confirmed as bugs then you can log an issue.
Please attach a testcase showing the behavior.
> 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-2997
> URL: https://issues.jboss.org/browse/TEIID-2997
> Project: Teiid
> Issue Type: Feature Request
> Components: OData
> Reporter: K Prashanthi
> Assignee: Steven Hawkins
>
> Hi,
> I am trying to send multiple xml inputs through odata batch in POSTMAN rest client. But i am getting 202 Accepted response and i do not see the data being reflected in the backend.
> URL- http://<host>:<port>/odata/<vdb>/<view>/$batch
> Headers:
> Content-Type:multipart/mixed
> boundary: batch
> Request Body:
> --batch
> POST /$batch HTTP/1.1
> Content-Type: multipart/mixed; boundary=changeset
> --changeset
> Content-Type: application/xml
> Content-Transfer-Encoding: binary
> POST
> Content-Type:application/xml
> Content-Length:1024
>
> XML INPUT-1
>
>
> --changeset
> Content-Type:application/xml
> Content-Transfer-Encoding: binary
> POST
> Content-Type:application/xml
> Content-Length:1024
> XMl Input-2
> --changeset--
> --batch--
> Please suggest.
> Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2997) 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
by K Prashanthi (JIRA)
K Prashanthi created TEIID-2997:
-----------------------------------
Summary: 202 Accepted response for odata batch requests (while sending multiple POST xml requests)
Key: TEIID-2997
URL: https://issues.jboss.org/browse/TEIID-2997
Project: Teiid
Issue Type: Feature Request
Components: OData
Reporter: K Prashanthi
Assignee: Steven Hawkins
Hi,
I am trying to send multiple xml inputs through odata batch in POSTMAN rest client. But i am getting 202 Accepted response and i do not see the data being reflected in the backend.
URL- http://<host>:<port>/odata/<vdb>/<view>/$batch
Headers:
Content-Type:multipart/mixed
boundary: batch
Request Body:
--batch
POST /$batch HTTP/1.1
Content-Type: multipart/mixed; boundary=changeset
--changeset
Content-Type: application/xml
Content-Transfer-Encoding: binary
POST
Content-Type:application/xml
Content-Length:1024
XML INPUT-1
--changeset
Content-Type:application/xml
Content-Transfer-Encoding: binary
POST
Content-Type:application/xml
Content-Length:1024
XMl Input-2
--changeset--
--batch--
Please suggest.
Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months