Skip to main content
M
mikeweb85
Participant
March 17, 2014
Answered

ColdFusion cluster scheduled tasks

  • March 17, 2014
  • 1 reply
  • 549 views

I am having issues enabling scheduled tasks in ColdFusion 10. I have go so far as to set MySQL (5.1.73) to use lower case table names and be case insensitive in comparison.  After that didnt work, i dropped the databse and ran `tables_mysql_innodb.sql` (C:\ColdFusion10\cfusion\lib\quartz\scripts) and trien to enable schedule task clustering and continue to recieve this error message: `Error while creating tables for cluster setup for datasource cf_tasks. Verify the connection. The supported databases for cluster setup are MySQL, Microsoft SQL Server and Oracle'. I didn't have the `Create Tables for Cluster Setup` option selected.

This topic has been closed for replies.
Correct answer mikeweb85

nevermind. the INNODB.sql file packaged with CF10 was in complete. Combine the table struction from the MyISAM version with INNODB and boom.

1 reply

M
mikeweb85AuthorCorrect answer
Participant
March 17, 2014

nevermind. the INNODB.sql file packaged with CF10 was in complete. Combine the table struction from the MyISAM version with INNODB and boom.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices