1. Using the MySQL Adapter with Oracle Integration Generation 2
  2. Understand the MySQL Adapter
  3. MySQL Adapter Restrictions

MySQL Adapter Restrictions

Note the following MySQL Adapter restrictions.

  • The MySQL Adapter can only be used with the on-premises connectivity agent.
  • The database password length cannot exceed 20 characters.
  • Database schema names with hyphens (-) are not supported.
  • The MySQL Adapter supports processing message payloads up to 10 MB in size. In the case of polling, you must set the Rejected Value property to REJECTED on the Polling Strategy and Options page. If the incoming message is greater then the 10 MB threshold size, that particular record is updated to REJECTED instead of READ. If the outbound operation returns a response greater than the 10 MB threshold size, the response message is ignored and a fault response is sent to the calling client.
  • All integrations that include stored procedure, PureSQL, or operation on table database operations must finish within 240 seconds. Otherwise, the query times out and a Limit Exceeded error occurs.

Note:

There are overall service limits for Oracle Integration. A service limit is the quota or allowance set on a resource. See Service Limits.