Anyone have trouble issuing a DELIMITER command via JDBC driver?
Posted by: Jon Rue
Date: December 12, 2006 01:42PM

I've run into problems trying to change the delimiter from Java programs. Whenever I issue the command DELIMITER $$ I receive the error:

Error code 1064, SQL state 42000: 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 $$' at line 1.

I've looked through the bugs and this forum but have yet to see any similar issues. Is it just me? Here are the details of my setup:

MySQL 5.0.27 using both the Connector/J 3.1.14 and 5.0.3 driver.
Java 1.5.0_09, NetBeans 5.5 IDE

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.