How can I change delimeter in jdbc to create procedure?

Asked Jun 15 '17 at 08:09

Active Jun 15 '17 at 08:18

Viewed 246 times

I am trying to create a mysql procedure dynamically using jdbc. To create it, I need to change delimiter first. However, on executing this statement:

 DELIMITER $$

I am getting error:

Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: 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

How can I resolve this issue?

edited Jun 15 '17 at 08:18

asked Jun 15 '17 at 08:09

Gautam Kumar

refer : https://stackoverflow.com/questions/1267172/mysql-delimiter-error . Let me know if it helps – Prabhat G Jun 15 '17 at 08:18
@PrabhatG Not related. This issue is more of jdbc not supporting this query. – Gautam Kumar Jun 15 '17 at 08:26
can you show us your code please? – Youcef LAIDANI Jun 15 '17 at 08:36
1

I wonder if you actually need to specify the delimiter – Mark Rotteveel Jun 15 '17 at 12:15
related: https://stackoverflow.com/q/11899306/2144390 – Gord Thompson Jun 15 '17 at 13:31

How can I change delimeter in jdbc to create procedure?

0 Answers0