|Re: 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #631032 is a reply to message #630961]
||Tue, 05 October 2010 17:55
| Brian Payton
Registered: July 2009
I'm not sure why, but when it comes to the step of executing the explain |
plan, (Step 6), I don't have "Execute Text Explain Plan" as an available
action in the SQL File editor.
I thought there might be a problem in the latest DTP version (1.8.1),
but I get the same result with DTP 1.6.2. :-(
I also tried this with a Sybase connection (since Sybase supplied the
Execution Plan code, so it would be available there if anywhere), but I
still don't see the action. There must be something I haven't done to
enable it. (I have all the DTP plug-ins in my workspace, so I'm pretty
sure I'm not missing any code.)
On 10/5/2010 9:05 AM, Zach Romans wrote:
> Hi Brian,
> Sure, no problem.
> Step 1) connect to MySQL instance (am using latest 5.1.13 MySQL
> Connector/J .jar)
> Step 2) switch to Database Design Perspective
> Step 3) File -> New SQL File
> Step 4) Select MySQL Connection profile
> Step 5) 'SELECT COUNT(*) FROM <some table>;'
> Step 6) w/ above line selected, right-click -> 'Execute Text Explain Plan'
> Step 7) get "Can not issue data manipulation statements with
> executeQuery()." message in Execution Plan tab
Powered by FUDForum
. Page generated in 0.04760 seconds