On 10/20/2011 12:13 AM, sreedish wrote:
The information about query execution plan is not getting captured in sysxplain_* tables in the XPLAIN-only mode . But the statistics are captured perfectly if the queries are executed . I need to get the query execution plan without actually executing it . Please help . Error shown when I give a query in XPLAIN-only mode is select * from physicsmarks where P_Id = 34567 ; ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify that autocommit is OFF. I tried with autocommit OFF , but still giving same results . The sysxaplain_* tables are empty after this . Please help .
Sounds like a bug, unfortunately. Perhaps you could open a JIRA issue and one of the developers can spot what's wrong. Things that would help: - include a short script that fully reproduces the problem from scratch in ij. - include the full stack trace of the error, and include the derby.log file - identify which version, precisely, the problem occurs in, and which other versions you have tried As a workaround, since I believe this functionality used to work correctly, you could try going back to an older release of Derby for your development work and see if you can get the XPLAIN processing to work in the older version. thanks, bryan
