db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Does the XPLAIN feature work in Derby 10.9.1.0
Date Tue, 07 May 2013 23:54:13 GMT


I get the same result:

$ java -cp ~/derby/db-derby-10.9.1.0-bin/lib/derbyrun.jar org.apache.derby.tools.ij
ij version 10.9
ij> connect 'jdbc:derby:xplaindb;create=true';
ij> call syscs_util.syscs_set_runtimestatistics(1);
0 rows inserted/updated/deleted
ij> call syscs_util.syscs_set_xplain_schema('STATS');
0 rows inserted/updated/deleted
ij> call syscs_util.syscs_set_xplain_mode(1);
0 rows inserted/updated/deleted
ij> 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.

I don't know what's wrong, sorry.

But it's happening for me, too.

bryan


Mime
View raw message