Re: Anyone have trouble issuing a DELIMITER command via JDBC driver?
Posted by: Jon Rue
Date: December 13, 2006 11:23AM

Thank you for the explanation. I've been converting an application to use MySQL and the helper class that abstracts the idiosyncrasies of a particular sql dialect was giving me fits. There is a getNextSqlBlock method that reads through a buffer from a given starting index and returns the index that marks the end of next statement. I was hopeful that I could pass the DELIMITER statement in and thus simplify the work my method does. I see now that I will have to parse out the DELIMITER statements myself and keep track of any delimiter changes encountered in the sql scripts.

Thanks again!

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.