org.hibernate.JDBCException: Error during DDL export

[ytrye]

Hi does anyone know anything about this error.  I get this when I am trying to work with hibernate in coldfusion 9 and the error is very generic.  Can anyone please point me in the right direction ?

Thanks

Faheem

[Remento48]

The error is related to your ORM setup in your table_name.cfc files.

Adobe has instructions for enabling ORM logging:

http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSED380324-6CBE-47cb-9E5E-26B66ACA9E81.html

I have not figured out how to get the logging to work yet... what a PITA...

[lelander]

I've got the same troubles.  Yes, it's related to Hibernate, related to the objects we are creating, but that doesn't help.  I can run the code on OSX/MySQL, but not on Win/MS-SQL.

[JamesRLamar]

I had same issue.

Change THIS.ormsettings.dialect = "MySQLwithInnoDB"

to

THIS.ormsettings.dialect = "MySQL"

or just play with different dialect settings. Full list of supported dialects found here, http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSED380324-6CBE-47cb-9E5E-26B66ACA9E81.html.

Other option is to make sure your Many-to-Many relationships are defined correctly. Make sure they properly identify the same Foreign Key and the same datatype.

Hope that helps