Re: Anyone have trouble issuing a DELIMITER command via JDBC driver?

[Mark Matthews]

Hi,

You don't need "delimiter" to create a stored procedure using Connector/J or any other client that isn't "mysql". The delimiter exists *only* to tell "mysql" that you're done typing, and that the command should be sent to the server. With other *libraries*, that's done by the very fact that you've called some method to send the string representing the command to the server.

Also, there is no good reason for client libraries to be parsing the SQL sent to them more than they absolutely need to, it will cause performance degradation for every one who uses them.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html