[jae]

i am unable to create a mysql stored procedure using the DBExplorer. according to this post: http://forums.mysql.com/read.php?39,57499,57549#msg-57549, it should be possible if the java code uses a CallableStatement, but i’m not sure if myeclipse is doing this.

the “DELIMITER $” statement is the cause of the problem. if i remove it, the proc will compile fine (provided i remove the guts, which is obviously no good). i can run create the proc using the mysql command line tool without any issues.

i should note that while i am using an unsupported eclipse installation (3.2M4), i do see this problem when i use 3.1.1 as well, so i do not believe this is being caused by M4.

please let me know if you need futher information.

—–

simple stored proc to exhibit problem:

DELIMITER $

CREATE PROCEDURE insertLoadAverage
(
)
BEGIN

DECLARE hostID BIGINT;

END$

DELIMITER ;

myeclipse config:

*** Date: Thu Mar 09 17:09:58 EST 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_05

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.1 GA
Build id: 20060228-4.1.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.2.0
Build id: I20051102-1600

Eclipse Platform

Version: 3.1.0
Build id: I20051102-1600

Eclipse RCP

Version: 3.1.0.v20051027
Build id: I20051102-1600

Eclipse Java Development Tools

Version: 3.1.0
Build id: I20051102-1600

Eclipse Plug-in Development Environment

Version: 3.1.0
Build id: I20051102-1600

Eclipse Project SDK

Version: 3.1.0
Build id: I20051102-1600

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
D:\eclipse\ide\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
d38_44
-clean
-vm
C:\WINDOWS\system32\javaw.exe

exception:

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DELIMITER $
DROP PROCEDURE IF EXISTS insertLoadAverage$
CREATE PROCEDURE ins’ at line 5
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlExecProgress.java:220)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgress.java:177)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

[Haris Peco]

jgangemi ,

Mysql procedure isn’t supported (for now)

Best

[jae]

boo, hiss! 🙂

is there any eta on when this may become supported?

[blanchjj]

I just both the professional version and for me it is very important that MyEclipse support MySQL stored procedure.
I should be simple to solve this issue, it look like a dlimiter problem…
Any Idea when you will support this?
Thanks a lot.

[Author]

Posts