HIbernate, hbm2ddl schema export: script error

[manuel aldana]

hello, i am running hibernate 3.

i am using Ant to export my schema to my MySQL database.

first i exported my schema without generating a sql-script file. all went fine.

when i am setting output=foo.sql to write a ddl-script to a file and want to run it manually on mysql command-line, mysql reports an error.

the error is that hbm2ddl did not put an ';' at the end of 'drop table if exists any_table'. after adding ';' to this command the script works fine.

two questions:
1)any similar problems?
2)why does the on-the-fly export work? through setting quite="no" i can see the run ddl-code and it is the same as in the failed output sql-script.

thank you.

[andy tom]

www.gov.cn

[manuel aldana]

is that supposed to be spam or did you forget to write text??

[manuel aldana]

i found my answer .

while exporting (for MySQL) you have to set the hbm2ddl attribute delimiter=";".