org.hibernate.JDBCException: Error during DDL export

Report · Apr 16, 2010

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

Report · Jun 08, 2010

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...

Report · Jan 10, 2011

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.

Report · Jul 02, 2011

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