Resolution:
Description:
============
BC Server could not create a Database schema with MySQL v5.5.8 or above store.

Environment:
============
BusinessConnect 5.x
MySQL Server 5.5.8

Symptoms:
=========
The BusinessConnect server will not create an installation with "Manage Installation" when using MySQL v5.5.8 as a backend database. The exception will look like:

"Installation Creation Failed . com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=InnoDB' at line 9 "

Cause:
======
The MySQL syntax has been changed from 'Type=InnoDB' to 'ENGINE=InnoDB' in 'create table' statement since v5.5.8.


Resolution:
===========
Use a lower version of MySQL with BusinessConnect.