how to cahnge delimiter in Mysql from a java program

[Sarath]

Hi all,

I have a small problem.
I have to change the default delimiter of MySql from ';' to '$'.

When i give the command "delimiter $" in the MySql command prompt it
works fine.
But when i do the same thing from my code :

statement.execute("DELIMITER $")

it gives this error,
"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 $' " Exception.

If any one has any clue... pls tell me where it is going wrong.

thank you,
Sarath

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

I have a small problem.
I have to change the default delimiter of MySql from ';' to '$'.

When i give the command "delimiter $" in the MySql command prompt it
works fine.
But when i do the same thing from my code :

statement.execute("DELIMITER $")

it gives this error,
"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 $' " Exception.

If any one has any clue... pls tell me where it is going wrong.

What JDBC driver version are you using ?

Arne