[
https://issues.apache.org/jira/browse/DERBY-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12985159#action_12985159
]
Bryan Pendleton commented on DERBY-4783:
----------------------------------------
Hi Nirmal, thanks for continuing to work on the PlanExporter, it is much
appreciated.
It seems that each SELECT statement that we are issuing against the database is
retrieving only a single field. I think it would be better if we could retrieve
all the
columns at once.
That is, instead of issuing:
select stmt_name from SYSXPLAIN_RESULTSETS where STMT_ID = ?
select stmt_type from SYSXPLAIN_RESULTSETS where STMT_ID = ?
select stmt_text from SYSXPLAIN_RESULTSETS where STMT_ID = ?
and so forth, we should just do:
select * from SYSXPLAIN_RESULTSETS where STMT_ID = ?
and then extract each column from that single result by calling:
rs.getString("stmt_name")
rs.getString("stmt_type")
rs.getString("stmt_text")
etc.
> Add all data in XPlain tables into the XML file generated by PlanExporter Tool
> ------------------------------------------------------------------------------
>
> Key: DERBY-4783
> URL: https://issues.apache.org/jira/browse/DERBY-4783
> Project: Derby
> Issue Type: Improvement
> Components: Tools
> Reporter: C.S. Nirmal J. Fernando
> Assignee: C.S. Nirmal J. Fernando
> Priority: Minor
> Attachments: derby-4783-a.diff
>
>
> Rick has suggested this in Derby-4587. I think this way it allows a user to
> create his own style sheets and grab only the data he needed.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
