Eclipse Community Forums: DTP » 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window

Home » Eclipse Projects » DTP » 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window

Show: Today's Messages :: Show Polls :: Message Navigator

'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #628642]

Thu, 23 September 2010 14:08

Zach Romans

Messages: 3
Registered: September 2010

Junior Member

Hello,

I'm new to using DTP, trying to see if it will work for me as an alternative to MySQL Workbench (since there is no Solaris port of Workbench and my office "desktop" is a SunRay.)

I'm connected to a MySQL 5.1.x DB with the latest MySQL Connector/J .jar (5.1.13).

When I try to Execute (Graphic|Text) Explain Plan with a complete semi-colon terminated statement selected, the Execution Plan window gets the message:

"Can not issue data manipulation statements with executeQuery()."

I searched and found a couple of forum threads (links below) indicating this isn't implemented. So I guess I'm just looking for confirmation that's what I'm running into here (as opposed to making a dumb DTP-newbie mistake.)

http:// www.eclipse.org/forums/index.php?t=msg&goto=597436&S =2e9825ac3e3afaa09516fe995e5daa1d#msg_597436

http:// www.eclipse.org/forums/index.php?t=msg&th=12958&S=2e 9825ac3e3afaa09516fe995e5daa1d#msg_40689

aTdHvAaNnKcSe

regards,

- z

Report message to a moderator

Re: 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #629229 is a reply to message #628642]

Mon, 27 September 2010 13:55

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

Hi Zach,

I'm guessing you're correct that that particular bit of functionality
wasn't implemented for MySQL enablement yet (I've also asked someone
else to confirm). The MySQL support that was contributed hasn't been
updated in quite a while due to lack of resources or MySQL experts.

We'd love to have someone pick it up and contribute fixes back to the
project however! :)

--Fitz

Zach Romans wrote:
> Hello,
>
> I'm new to using DTP, trying to see if it will work for me as an
> alternative to MySQL Workbench (since there is no Solaris port of
> Workbench and my office "desktop" is a SunRay.)
>
> I'm connected to a MySQL 5.1.x DB with the latest MySQL Connector/J .jar
> (5.1.13).
>
> When I try to Execute (Graphic|Text) Explain Plan with a complete
> semi-colon terminated statement selected, the Execution Plan window gets
> the message:
>
> "Can not issue data manipulation statements with executeQuery()."
>
> I searched and found a couple of forum threads (links below) indicating
> this isn't implemented. So I guess I'm just looking for confirmation
> that's what I'm running into here (as opposed to making a dumb
> DTP-newbie mistake.)
>
> http://www.eclipse.org/forums/index.php?t=msg&goto=59743 6&S=2e9825ac3e3afaa09516fe995e5daa1d#msg_597436
>
>
> http://www.eclipse.org/forums/index.php?t=msg&th=12958&a mp;S=2e9825ac3e3afaa09516fe995e5daa1d#msg_40689
>
>
> aTdHvAaNnKcSe
>
> regards,
>
> - z

Report message to a moderator

Re: 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #630794 is a reply to message #628642]

Tue, 05 October 2010 03:31

Brian Payton

Messages: 154
Registered: July 2009

Senior Member

Hi, can you give the steps you did that lead up to the error message?
I'm having trouble reproducing the problem. (That could be due to my
unfamiliarity with the Plan component.)

(BTW, I did a search in the DTP code and didn't find a executeQuery call
directly associated with the Plan code. I found one in the MySQL
catalog loader, but I don't see how that's involved here.)

On 9/23/2010 7:09 AM, Zach Romans wrote:
> Hello,
>
> I'm new to using DTP, trying to see if it will work for me as an
> alternative to MySQL Workbench (since there is no Solaris port of
> Workbench and my office "desktop" is a SunRay.)
>
> I'm connected to a MySQL 5.1.x DB with the latest MySQL Connector/J .jar
> (5.1.13).
>
> When I try to Execute (Graphic|Text) Explain Plan with a complete
> semi-colon terminated statement selected, the Execution Plan window gets
> the message:
>
> "Can not issue data manipulation statements with executeQuery()."
>
> I searched and found a couple of forum threads (links below) indicating
> this isn't implemented. So I guess I'm just looking for confirmation
> that's what I'm running into here (as opposed to making a dumb
> DTP-newbie mistake.)
>
> http://www.eclipse.org/forums/index.php?t=msg&goto=59743 6&S=2e9825ac3e3afaa09516fe995e5daa1d#msg_597436
>
>
> http://www.eclipse.org/forums/index.php?t=msg&th=12958&a mp;S=2e9825ac3e3afaa09516fe995e5daa1d#msg_40689
>
>
> aTdHvAaNnKcSe
>
> regards,
>
> - z

Report message to a moderator

Re: 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #630961 is a reply to message #628642]

Tue, 05 October 2010 16:05

Zach Romans

Messages: 3
Registered: September 2010

Junior Member

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

Report message to a moderator

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

Report message to a moderator

Re: 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #631046 is a reply to message #628642]

Tue, 05 October 2010 23:33

Zach Romans

Messages: 3
Registered: September 2010

Junior Member

Perhaps the "Execute Text Explain Plan" is part of the Oracle Enterprise Pack for Eclipse (OEPE), and not part of DTP?

Report message to a moderator

Re: 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #631274 is a reply to message #631046]

Wed, 06 October 2010 19:08

Brian Payton

Messages: 154
Registered: July 2009

Senior Member

That could be. DTP has some APIs and features that are not exposed in
the basic DTP installation, and this looks like one of them. Since I
couldn't find a problematic "executeQuery" call in the DTP code, that
call might be in layer above DTP as well.

On 10/5/2010 4:33 PM, Zach Romans wrote:
> Perhaps the "Execute Text Explain Plan" is part of the Oracle Enterprise
> Pack for Eclipse (OEPE), and not part of DTP?

Report message to a moderator

Previous Topic:	Open SQL-File ignores BOM
Next Topic:	ClassCastException on JDBCView.createSupertableLoader() and JDBCTable.createSupertableLoader()

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:57:33 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter