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

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: