Can't send SQL statement containing 'DELIMITER $$'

[Denis Lemberger]

Hello all

When I send via java.sql.Connection an SQL string that contains the 'DELIMITER' statement (e.g. when I want to create a stored procedure), I get the exception:

"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 $$ (...)"

When I omit this 'DELIMITER' statement, I get the exception:

"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 '; CREATE (...)"

I found out that it works fine when I *isolate* the CREATE statement (with no other statements before or after), but that's not what I need, because I must execute an sql script that contains many statements, the CREATE statement among them.

Any ideas how I can accomplish this?

Many thanx in advance
:-Denis