Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » 'Can not issue data manipulation statements with executeQuery()' on Execution Plan window
'Can not issue data manipulation statements with executeQuery()' on Execution Plan window [message #628642] Thu, 23 September 2010 14:08 Go to next message
Zach Romans is currently offline Zach RomansFriend
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
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 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
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
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 Go to previous messageGo to next message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
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
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 Go to previous messageGo to next message
Zach Romans is currently offline Zach RomansFriend
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
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 Go to previous messageGo to next message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
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
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 Go to previous messageGo to next message
Zach Romans is currently offline Zach RomansFriend
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?
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 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
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?
Previous Topic:Open SQL-File ignores BOM
Next Topic:ClassCastException on JDBCView.createSupertableLoader() and JDBCTable.createSupertableLoader()
Goto Forum:
  


Current Time: Mon Dec 22 11:37:32 GMT 2014

Powered by FUDForum. Page generated in 0.02052 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software