[
https://issues.jboss.org/browse/TEIID-3116?page=com.atlassian.jira.plugin...
]
Jan Stastny commented on TEIID-3116:
------------------------------------
I write to confirm, that after setting DatabaseVersion property to a translator via
vdb.xml PartialResultsMode works as expected. As Van mentioned, it would be helpful a note
about that in the doc's. And a sentence or two about what values does the
DatabaseVersion support would be nice. There is some info at
https://docs.jboss.org/author/display/teiid87final/JDBC+Translator, but not with each
translator (sqlserver section mentions that, but oracle does not) and it is not linked
from
https://docs.jboss.org/author/display/TEIID/Partial+Results+Mode.
Teiid Partial Results Mode: unavailability of datasource causes error
(which is not masked)
-------------------------------------------------------------------------------------------
Key: TEIID-3116
URL:
https://issues.jboss.org/browse/TEIID-3116
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 8.7.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Critical
Description of problem:
Querying a vdb-table which is formed as union of two tables from different datasources.
Even though "set partialresultsmode true" is run as initial query, instead of
retreiving 0 rows from a datasources that is down, exception is promoted.
Version-Release number of selected component (if applicable):
DV 6.1 ER1
How reproducible:
Every time
Steps to Reproduce:
1. Define one valid and one invalid datasource(invalid connection-url).
2. Create vdb which maps tables from both datasources.
3. Set partialresultsmode to true
4. Execute query on the given vdb-table
Actual results:
TeiidSQLException
TEIID30498 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498
Capabilities for ORBQT were not avaialable. The command could not be planned properly.
Expected results:
0 rows from invalid datasource.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)