MySQL 5.0 Adapter Limitations

Sales and inquiry support for MySQL 5.0 adapter has ended.

Supported Type
Read Table Limitations
Execute Select SQL Limitations
Write Table Limitations
Execute Update SQL Limitations
Execute Stored Procedure Limitations
Main exception messages

Supported Types

This adapter supports types as follows.

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 type)	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

Yes: Support.
Limited: Support with limitations.
No: Not supported.

Read Table Limitations

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.

FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1638870

DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1639034

DATE, DATETIME type, TIMESTAMP
- Error occurs when data is 0000-00-00 00:00:00.

TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.

YEAR
- Treated as String data.

Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Even if ZEROFILL optional extension attribute is specified, it returns results in which 0s are excluded.

Execute Select SQL Limitations

BIT
- BIT type datathat size is 1 is treated as Boolean.Other sized BIT type is not supported.

FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1638870

DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1639034

DATE, DATETIME type, TIMESTAMP
- Error occurs when data is 0000-00-00 00:00:00.

TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.

YEAR
- Treated as String data.

Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Even if ZEROFILL optional extension attribute is specified, it returns results in which 0s are excluded.

Write Table Limitations

BIT
- BIT type datathat size is 1 is treated as Boolean.Other sized BIT type is not supported.

FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1638870

DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1639034

DATE, DATETIME type, TIMESTAMP
- If the date does not exist, it will not be written correctly.
  For example: "00 month 00 day, 0000" becomes "November 30, 0002".

TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.

YEAR
- Treated as String data.

Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Does not support batch update.

Execute Update SQL Limitations

BIT
- BIT type datathat size is 1 is treated as Boolean.Other sized BIT type is not supported.

FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1638870

DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1639034

DATE, DATETIME type, TIMESTAMP
- If the date does not exist, it will not be written correctly.
  For example: "00 month 00 day, 0000" becomes "November 30, 0002".

TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.

YEAR
- Treated as String data.

Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Does not support batch update.

Execute Stored Procedure Limitations

BIT
- BIT type datathat size is 1 is treated as Boolean.Other sized BIT type is not supported.

FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1638870

DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html#id1639034

CHAR, VARCHAR type, TEXT type, TINYTEXT type, MEDIUMTEXT type, LONGTEXT
- When using the argument that contains a multi-byte character, an error occurs.
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.

YEAR
- Treated as String data.

ENUM, SET
- When using the argument that contains a multi-byte character, an error occurs.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Main exception messages

Exception Name	Message	Cause / Solution
com.mysql.jdbc.CommunicationsException		Cannot connect to the database. Check the host name and port number.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException	Unknown database '<database name>'	Make sure the specified database exists.
java.sql.SQLException	Access denied for user '<username>'@'<terminal name>' (using password: YES)	Check that the correct user name and password is specified.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException	Table '<table name>' doesn't exist	Verify that the specified table name is correct.