[teiid-issues] [JBoss JIRA] Commented: (TEIID-908) Enable access to the query plan without reference to Teiid classes.
[
https://jira.jboss.org/jira/browse/TEIID-908?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIID-908:
--------------------------------------
To be a little more concrete about possible implementations:
assuming that you still want to use the PlanNode API one possibility given access to the
statement object:
PlanNode plan =
statement.unwrap(com.metamatrix.jdbc.api.Statement.class).getPlanDescription();
which allows you to safely get to our api without casting.
Another option would be
... statement.executeQuery("select .... option showplan");
... statement.executeQuery("showplan [text|xml]");
which would create a resultset containing a single column/row with either the text or the
SQL/XML representation.
Enable access to the query plan without reference to Teiid classes.
-------------------------------------------------------------------
Key: TEIID-908
URL: https://jira.jboss.org/jira/browse/TEIID-908
Project: Teiid
Issue Type: Feature Request
Components: JDBC Driver
Affects Versions: 6.2.0
Environment: Eclipse Data Tools Platform connection to Teiid.
Reporter: John Doyle
Assignee: Steven Hawkins
Eclipse Data Tools provides a framework for getting/displaying a query plan and I want to
implement it as part of our DTP plug-ins. Currently you can only get the query plan from
the MMStatement class, but DTP works only with the JDBC interfaces. Access to the query
plan via the JDBC APIs and core java classes will enable us to plug into the framework.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira