MySQL 5.0 Adapter Limitations

Sales and inquiry support for MySQL 5.0 adapter has ended.

Supported Types

This adapter supports types as follows.
Type name SupportRemarks
BOOL
(BOOLEAN)
Yesalias 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 
MEDIUMBLOBYes 
MEDIUMTEXT Limited 
LONGBLOB Yes 
LONGTEXTLimited 
ENUM Limited 
SET Limited 

Read Table Limitations

Execute Select SQL Limitations

Write Table Limitations

Execute Update SQL Limitations

Execute Stored Procedure Limitations

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.