MySQL

Create the MySQL database user with required privileges and database for BPEL Service Engine persistence.

To create the MySQL database user

1. Log into MySQL as root. For example, from the command prompt enter: mysql -h host -u root -p.

   You need to include the MySQL bin folder in the path. You can omit the host if you are connecting from the same machine.

2. Execute the following script using the default values:

   CREATE DATABASE BPELSE_USER_DB; GRANT ALL ON BPELSE_USER_DB.* TO 'BPELSE_USER'@'%' IDENTIFIED BY 'BPELSE_USER';

   Click Here, for more information and to download the scripts for MySQL.

Setting max_allowed_packet

When a MySQL client or the mySQL server gets a packet that is larger than the max_allowed_packet bytes, it issues a "Packet too large" error and closes the connection. By default this value is configured low. You must increase this value for large messages. Set the value of this parameter to the size of the biggest message you anticipate.

To set max_allowed_packet:

1. Open the "my.ini" file under the MySQL server install directory.

2. Search for the "max_allowed_packet" parameter. If the file does not have it, add the parameter to the file.

3. Set the value as needed. To set the value to 1GB, enter the value as one of the following:max_allowed_packet=1073741824 max_allowed_packet=1G

4. Restart the MySQL Server.

For more information see Setting max_allowed_packet and Using Options to Set Program Variables.

The current version of the JDBC driver for MySQL, MySQL Connector/J, version 5.1.6, has a bug which can cause errors when an XA connection is used. As such, using this driver can cause fatal exceptions in the BPEL Service Engine. A patch for MySQL Connector/J version 5.1.6, is available, and will be included in subsequent releases of MySQL Connector/J. For more information on the patch, see http://bugs.mysql.com/bug.php?id=35489.