Hi
I have tables whith dozens of fields which I want to populate during deploy using hbm2ddl create-drop.
I naturally ordered such complex insert statements into several lines. The effect was that the SchemaExport.importScript throws the error "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 '' at line 1". I struggled now several hours to find what's going wrong, since executing such a insert statement in the MySQLQueryBrowser showed no problem.
Finally, when stepping through the source-Code, I found that this method (SchemaExport.importScript) executes line by line, regardless if the statements are delimited by ';' like one would expect for sql scripts.
Is there a way to configure the hbm2ddl tool in order that it recognizes multiline statements and executes them correctly? If not I would consider that as a must have for a next version. (Because writing and - especially - maintaining insert statements with dozens of fields within one line is not a real option.)
Tks
Heri

Not to downplay the seriousness of such a limitation, but: isn't the purpose of hbm2ddl to avoid writing a lot of custom SQL? If you're writing the whole "CREATE TABLE" statement out by hand anyway, just put in a .sql file or in an Ant SQL task.

I'm not talking of create-statements, but insert-statements for an initial fill with test data.
What you mean by "just put in a .sql file"?