Re: Does the XPLAIN feature work in Derby 10.9.1.0

[Bryan Pendleton]

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