|
|
|
|
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 21:55 |
Brian Payton Messages: 154 Registered: July 2009 |
Senior Member |
|
|
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.03976 seconds