[teiid-issues] [JBoss JIRA] (TEIID-3989) PartialResultsWarning not being returned

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13166335#comment-13166335 ] 

Steven Hawkins edited comment on TEIID-3989 at 2/22/16 8:37 AM:
----------------------------------------------------------------

Ramesh that is not the case.   In this case the first union branch is delivering a batch that will likely be feed all the way to the client before the exception from the second branch has been added for delivery.  Only by actually cursoring through the results and re-checking the warnings (it helps to call clearWarnings after checking them) will the PartialResultsWarning be guaranteed to be seen.  The docs to state that partial results should be checked for at the end of the results.

The other caveats are that the partial results warning need not be the head of the warning chain.  So I'll make that update as well.


was (Author: shawkins):
Ramesh that is not the case.  The documentation unfortunately is not as complete as it should be.  The other caveats are that the partial results warning need not be the head of the warning chain, and more importantly it may not be delivered with the initial results.  In this case the first union branch is delivering a batch that will likely be feed all the way to the client before the exception from the second branch has been added for delivery.  Only by actually cursoring through the results and re-checking the warnings (it helps to call clearWarnings after checking them) will the PartialResultsWarning be guaranteed to be seen.  So I'll update the docs with this full accounting.

> PartialResultsWarning not being returned
> ----------------------------------------
>
>                 Key: TEIID-3989
>                 URL: https://issues.jboss.org/browse/TEIID-3989
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Driver
>    Affects Versions: 8.11.3, 9.0
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>         Attachments: TeiidTest.zip, Test-vdb.xml, translator-test.zip
>
>
> I'm trying to follow the example [here|https://docs.jboss.org/author/display/TEIID/Partial+Results+Mode] to return source failure information to my app. Partial results mode does work, but when used with a JBoss AS datasource (as opposed to standalone) {{TeiidSQLWarning}} is returned instead of the expected {{PartialResultsWarning}}.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)