[teiid-issues] [JBoss JIRA] Commented: (TEIID-908) Enable access to the query plan without reference to Teiid classes.

[Steven Hawkins (JIRA)]

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

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