Description:
Access tables that contain double precision fields are not migrated. The error occurs during the 'Create Objects' step. Following is the log:
Initializing JDBC driver.
Driver class com.mysql.jdbc.Driver
Opening connection.
Connection jdbc:mysql://localhost:3306/?user=root&password=appoint
Deactivate foreign key constraints.
SET FOREIGN_KEY_CHECKS = 0;
Drop schema test if it already exists.
DROP DATABASE IF EXISTS `test`;
Creating schema test ...
CREATE DATABASE `test`
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Creating tables ...
Creating table tChecks ...
CREATE TABLE `test`.`tChecks` (
`CheckID` INTEGER(10) NOT NULL AUTO_INCREMENT,
`MfgID` INTEGER(10) NULL,
`CheckNumber` INTEGER(10) NULL,
`CheckDate` DATETIME NULL,
`DepositDate` DATETIME NULL,
`Amount` (nil) NULL,
`CheckStatus` VARCHAR(10) NULL,
`OpenAmount` (nil) NULL,
UNIQUE INDEX `CheckID` (`CheckID`),
INDEX `MfgID` (`MfgID`)
)
ENGINE = INNODB;
An error occured while executing the SQL statement.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(nil) NULL,
`CheckStatus` VARCHAR(10) NULL,
`OpenAmount` (nil) NULL,
UN' at line 7
Creating views ...
Creating procedures ...
Reactivate foreign key constraints.
SET FOREIGN_KEY_CHECKS = 1;
Both the 'Amount' and 'Open Amount' fields are defined as:
Data Type: Number
Field Size: Double
Format: Standard
Decimal Places: 2
Default Value: 0
Required: No
Indexed: No
When I change the field size to 'Single' the migration works but amounts to the right of the decimal place are lost.
How to repeat:
Create an Access table with a similar field and run the Migration utility.