db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject Is there a unit test in Derby for the XPLAIN feature
Date Sat, 11 May 2013 11:28:09 GMT
Is there a unit test in Derby for the XPLAIN feature?  I would be interested in know if it
is passing if there is. 
________________________________________
From: Bergquist, Brett [BBergquist@canoga.com]
Sent: Tuesday, May 07, 2013 8:11 PM
To: derby-dev@db.apache.org
Subject: RE: Does the XPLAIN feature work in Derby 10.9.1.0

Okay, thanks.   I will open a JIRA on it.
________________________________________
From: Bryan Pendleton [bpendleton.derby@gmail.com]
Sent: Tuesday, May 07, 2013 7:54 PM
To: derby-dev@db.apache.org
Subject: Re: Does the XPLAIN feature work in Derby 10.9.1.0

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