[
https://issues.apache.org/jira/browse/DERBY-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13660870#comment-13660870
]
Mike Matrigali commented on DERBY-6216:
---------------------------------------
tried in 10.8 and saw same results. Also set autocommit off to make sure that
was not the issue, but same result.
There is nothing in derby.log about the error.
ij(C1)> call syscs_util.syscs_set_runtimestatistics(1);
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_schema('STATS');
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_mode(1);
0 rows inserted/updated/deleted
ij(C1)> select sql_text from syscs_diag.transaction_table where status !=
'IDLE';
ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify
that autocommit is OFF.
ij(C1)> call syscs_util.syscs_set_runtimestatistics(0);
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_schema('');
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_mode(0);
0 rows inserted/updated/deleted
ij(C1)> autocommit off;
ij(C1)> call syscs_util.syscs_set_runtimestatistics(1);
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_schema('STATS');
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_mode(1);
0 rows inserted/updated/deleted
ij(C1)> select sql_text from syscs_diag.transaction_table where status !=
'IDLE';
ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify
that autocommit is OFF.
ij(C1)> call syscs_util.syscs_set_runtimestatistics(0);
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_schema('');
0 rows inserted/updated/deleted
ij(C1)> call syscs_util.syscs_set_xplain_mode(0);
0 rows inserted/updated/deleted
> XPLAIN feature does not work and gives ERROR XCL16: ResultSet not open
> ----------------------------------------------------------------------
>
> Key: DERBY-6216
> URL: https://issues.apache.org/jira/browse/DERBY-6216
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.9.1.0
> Environment: Solaris 10, MacOS X 10.6, Windows XP
> Reporter: Brett Bergquist
> Labels: features
>
> I am running Derby 10.9.1.0 and am trying to figure out a performance
> problem with query taking too long. I don’t actually want to run the query
> so from the documentation, I try:
> call syscs_util.syscs_set_runtimestatistics(1);
> call syscs_util.syscs_set_xplain_schema('STATS');
> call syscs_util.syscs_set_xplain_mode(1);
> --- my query here
> call syscs_util.syscs_set_runtimestatistics(0);
> call syscs_util.syscs_set_xplain_schema('');
> call syscs_util.syscs_set_xplain_mode(0);
> When it runs my query, I get:
> ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted.
> Verify that autocommit is OFF.
> I try the following with IJ just to see:
> call syscs_util.syscs_set_runtimestatistics(1);
> call syscs_util.syscs_set_xplain_schema('STATS');
> call syscs_util.syscs_set_xplain_mode(1);
> select sql_text from syscs_diag.transaction_table where status != 'IDLE';
> call syscs_util.syscs_set_runtimestatistics(0);
> call syscs_util.syscs_set_xplain_schema('');
> call syscs_util.syscs_set_xplain_mode(0);
> Note I have tried this with real tables as apposed to the
> syscs_diag.transaction_table with the same result. The only reason that I
> posted this with this table is that it is a table that is accessible for any
> database.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
