Railo, ORM and MySQL 5.5.x gotcha

On February 1, 2012, in ColdFusion, Railo, by Anuj Gakhar

I was testing the ORM stuff in the latest version of Railo (3.3.1.000 final) and after setting up the ORM settings in Application.cfc, when I tried to run the code, I could not get Railo to create the database tables, even with dbcreate=”dropcreate”. Here is my code, that was not working :-

this.ormsettings = {
		cfclocation 		= 'model',
		dialect 			= "MySQLwithInnoDB",
		dbcreate 			= "dropcreate",
		eventHandling 		= true,
		logSQl 				= true,
		autoManageSession 	= false,
		flushAtRequestEnd 	= true,
		eventHandler	    = "model.ORMEventHandler"
	};

The above code would not create the database tables even with ORMReload() or ORMFlush(). Then I came across this Railo Issue which clarifies what the issue is. Looks like with MySQL 5.5.x, the dialect needs to be MySQL5. Here is the correct code that works :-

this.ormsettings = {
		cfclocation 		= 'model',
		dialect 			= "MySQL5",
		dbcreate 			= "dropcreate",
		eventHandling 		= true,
		logSQl 				= true,
		autoManageSession 	= false,
		flushAtRequestEnd 	= true,
		eventHandler	    = "model.ORMEventHandler"
	};

Not sure why MySQL5 needs a separate dialect – maybe someone can shed some more light on this?

Tagged with:  

3 Responses to Railo, ORM and MySQL 5.5.x gotcha

  1. Seth says:

    This was immensely helpful to me. Thanks for taking the time to share it with the world. I spent all night trying to get the dbcreate setting to have an effect and with your post I’ve gotten it working.

  2. Kevin says:

    I can’t believe it took so long to find this… Thanks!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 445 other subscribers

© 2011 Anuj Gakhar
%d bloggers like this: