Resolution:
Description:
============
Configuring the MySQL database with the correct character set when used with BusinessConnect

Environment:
============
BusinessConnect 5.X
MySQL Server 5.0

Symptoms:
=========

The BusinessConnect server will not start and will throw Java exceptions related to the MySQL database.  The exception will look like:

W.BusinessConnect-Single_Server Error [bw.logger] BW-EXT-LOG-100000  While executing: select * from BC_SCHEDULED_TASK where HANDLER = ?  AND TASKTYPE = ?  AND INSTALLATIONNAME = ?  ORDER BY TS ASC , TASKID ASC : Table 'bc.bc_scheduled_task' doesn't exist
    at com.tibco.ax.fw.db.DbAccess$DBQueryMaker.execute(Unknown Source)
    at com.tibco.ax.fw.db.DbAccess.retrieveTransactionContext(Unknown Source)
   .
   .
   .
Subexception stack trace follows:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bc.bc_scheduled_task' doesn't exist
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
   .
   .
   .

Cause:
======
The MySQL database is configured with a non latin1character set.  BusinessConnect will not work correctly if the MySQL character set is set to anything other than latin1

Resolution:
===========
Update this setting in the MySQL.ini file:

default-character-set=latin1