Book a Demo

Author Topic: EA - issue with code engineering and MySQL 5.0  (Read 3284 times)

GW

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
EA - issue with code engineering and MySQL 5.0
« on: April 15, 2014, 11:54:48 pm »
Hello there,

I work with Enterprise Architect version 9.2.922.
My project is a data model with some tables, triggers and one stored procedure.

I use the menu "Code engineering / generate DDL" to generate the whole DDL in a single file and I run it in MySQL. v5.0.

All works fine except the stored procedure.

EA automatically add the delimiter around the procedure with "DELIMITER //" at the top and "//" at the end.
That's a good thing but EA add also a semi colon ";" after that and MySQL does not accept this extra semi colon, it says :
"ERROR 1065 (42000) at line x: Query was empty".

Does anyone knows a way to change the behavior of EA so that the generated procedure does not end with a semi colon ";", but only with the specific delimiter "//"  ?