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

[Tom Arnold (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tom Arnold updated TEIID-3989:
------------------------------
    Steps to Reproduce: 
Install Teiid server and create application user {{teiid/Teiid-123}}.

Build and deploy attached {{translator-test}} and deploy {{Test-vdb.xml}}. The VDB has two models, the second one has a translator override which causes it to throw a socket exception (and rethrow as {{TranslatorException}}).

Update {{standalone-teiid.xml}} with this datasource:

{code}
<datasource jndi-name="java:/teiidDS" pool-name="teiidDS" enabled="true">
  <connection-url>jdbc:teiid:test at mm://localhost:31000;partialResultsMode=true</connection-url>
  <driver>teiid</driver>
  <pool>
    <prefill>false</prefill>
    <use-strict-min>false</use-strict-min>
    <flush-strategy>FailingConnectionOnly</flush-strategy>
  </pool>
  <security>
    <user-name>teiid</user-name>
    <password>Teiid-123</password>
  </security>
</datasource>
{code}

Build and deploy attached {{TeiidTest2}} web app.

- http://localhost:8080/test/?test=ds - Use bundled JDBC driver and create TeiidDataSource. This works as documented.
- http://localhost:8080/test/?test=driver - Use bundled JDBC driver and DriverManager. This works as documented.
- http://localhost:8080/test/?test=jboss - Use JBoss AS datasource and Teiid client module. This returns TeiidSQLWarninginstead of PartialResultsWarning.

  was:
Install Teiid server and create application user {{teiid/Teiid-123}}.

Build and deploy attached {{translator-test}} and deploy {{Test-vdb.xml}}. The VDB has two models, the second one has a translator override which causes it to throw a socket exception (and rethrow as {{TranslatorException}}).

Update {{standalone-teiid.xml}} with this datasource:

{code}
<datasource jndi-name="java:/teiidDS" pool-name="teiidDS" enabled="true">
  <connection-url>jdbc:teiid:test at mm://localhost:31000;partialResultsMode=true</connection-url>
  <driver>teiid</driver>
  <pool>
    <prefill>false</prefill>
    <use-strict-min>false</use-strict-min>
    <flush-strategy>FailingConnectionOnly</flush-strategy>
  </pool>
  <security>
    <user-name>teiid</user-name>
    <password>Teiid-123</password>
  </security>
</datasource>
{code}

Build and deploy attached {{TeiidTest}} web app.

- http://localhost:8080/test/?test=ds - Use bundled JDBC driver and create TeiidDataSource. This works as documented.
- http://localhost:8080/test/?test=driver - Use bundled JDBC driver and DriverManager. This works as documented.
- http://localhost:8080/test/?test=jboss - Use JBoss AS datasource and Teiid client module. This returns TeiidSQLWarninginstead of PartialResultsWarning.



> 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, TeiidTest2.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)