Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3989

PartialResultsWarning not being returned

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.0, 8.12.5, 8.13.2
    • 8.11.3, 9.0
    • JDBC Driver
    • None
    • Hide

      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:

      <datasource jndi-name="java:/teiidDS" pool-name="teiidDS" enabled="true">
        <connection-url>jdbc:teiid:test@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>
      

      Build and deploy attached TeiidTest2 web app.

      Show
      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: <datasource jndi-name= "java:/teiidDS" pool-name= "teiidDS" enabled= " true " > <connection-url>jdbc:teiid:test@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> 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.

      I'm trying to follow the example here to return source failure information to my app. Partial results mode does work, but I'm getting TeiidSQLWarning instead of the expected PartialResultsWarning.

        1. Test-vdb.xml
          0.4 kB
        2. TeiidTest.zip
          4 kB
        3. translator-test.zip
          9 kB
        4. TeiidTest2.zip
          4 kB

              rhn-engineering-shawkins Steven Hawkins
              tom9729 Tom Arnold (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: