Amazon RDS for MySQL 5.7 Adapter Limitations

Supported Types

The types supported in this adapter are the following.

Type name	Support	Remarks
BOOL (BOOLEAN)	Yes	Alias of tinyint(1)
BIT	Limited
TINYINT	Yes
TINYINT UNSIGNED	Yes
MEDIUMINT	Yes
MEDIUMINT UNSIGNED	Yes
SMALLINT	Yes
SMALLINT UNSIGNED	Yes
INT (INTEGER)	Yes
INT UNSIGNED (INTEGER UNSIGNED)	Yes
BIGINT	Yes
BIGINT UNSIGNED	Yes
FLOAT	Limited
FLOAT UNSIGNED	Limited
DOUBLE	Limited
DOUBLE UNSIGNED	Limited
REAL	Limited
REAL UNSIGNED	Limited
DECIMAL (NUMERIC)	Yes
DECIMAL UNSIGNED (NUMERIC UNSIGNED)	Yes
DATE	Limited
DATETIME	Limited
TIMESTAMP	Limited
TIME	Limited
YEAR	Limited
CHAR	Limited
VARCHAR	Limited
BINARY	Yes
VARBINARY	Yes
TINYBLOB	Yes
TINYTEXT	Limited
BLOB	Yes
TEXT	Limited
MEDIUMBLOB	Yes
MEDIUMTEXT	Limited
LONGBLOB	Yes
LONGTEXT	Limited
ENUM	Limited
SET	Limited
JSON	No

BIT
- BIT type data whose size is 1 is handled as boolean. Other sized BIT type data are not supported.
FLOAT, FLOAT UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DOUBLE, DOUBLE UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DATE, DATETIME, TIMESTAMP
- An error occurs when data is 0000-00-00 00:00:00.
TIME
- The supported range is from 00:00:00 to 23:59:59. In other cases, an error occurs.
YEAR
- Data is handled as String.
Even when an optional extended attribute ZEROFILL is specified, the result is returned excluding 0.

BIT
- BIT type data whose size is 1 is handled as boolean. Other sized BIT type data are not supported.
FLOAT, FLOAT UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DOUBLE, DOUBLE UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DATE, DATETIME, TIMESTAMP
- An error occurs when data is 0000-00-00 00:00:00.
TIME
- The supported range is from 00:00:00 to 23:59:59. In other cases, an error occurs.
YEAR
- Data is handled as String.
Even when an optional extended attribute ZEROFILL is specified, the result is returned excluding 0.

BIT
- BIT type data whose size is 1 is handled as boolean. Other sized BIT type data are not supported.
FLOAT, FLOAT UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DOUBLE, DOUBLE UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DATE, DATETIME, TIMESTAMP
- In the case of non-existent date, it is not written correctly.
  Example: When the date is “0000/00/00”, it will be “0002/11/30”.
TIME
- The supported range is from 00:00:00 to 23:59:59. In other cases, an error occurs.
YEAR
- Data is handled as String.

BIT
- BIT type data whose size is 1 is handled as boolean. Other sized BIT type data are not supported.
FLOAT, FLOAT UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DOUBLE, DOUBLE UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DATE, DATETIME, TIMESTAMP
- In the case of non-existent date, it is not written correctly.
  Example: When the date is “0000/00/00”, it will be “0002/11/30”.
TIME
- The supported range is from 00:00:00 to 23:59:59. In other cases, an error occurs.
YEAR
- Data is handled as String.

BIT
- BIT type data whose size is 1 is handled as boolean. Other sized BIT type data are not supported.
FLOAT, FLOAT UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
DOUBLE, DOUBLE UNSIGNED
- There are precautions for the precision with MySQL floating points.
  For more details, refer to “MySQL Reference Manual” (https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html).
CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
- An error occurs when an argument with multi-byte characters is used.
TIME
- The supported range is from 00:00:00 to 23:59:59. In other cases, an error occurs.
YEAR
- Data is handled as String.
ENUM, SET
- An error occurs when an argument with multi-byte characters is used.

Exception name		Cause	Solution
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException		Unable to connect to the database.	Check [Host name] or [Port number] of the global resource.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException		Unable to connect to the database.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException	Unknown database '<database name>'	The database is not found.	Specify an existing database in [Database name] of global resource.
java.sql.SQLException	Access denied for user '<user name>'@'<terminal name>'(using password: YES)	The user name or the password is incorrect.	Check [User name] or [Password] of the global resource.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException	Table '<table name>' doesn't exist	The table does not exist.	Specify an existing table in [Table name].