db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject RE: Does the XPLAIN feature work in Derby 10.9.1.0
Date Wed, 08 May 2013 12:16:03 GMT
Created https://issues.apache.org/jira/browse/DERBY-6216

-----Original Message-----
From: Bergquist, Brett [mailto: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 != 
ij> '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