this ddl gets executed only if we remove datatype lengths/sizes.
CREATE TABLE employee ( empId INTEGER(10) NOT NULL, lastName VARCHAR (30), firstName VARCHAR (30), salary DOUBLE PRECISION (19, 2));
That is correct; not all data types have a corresponding length in their syntax. You can find the Derby data type syntax documented here: http://db.apache.org/derby/docs/10.5/ref/crefsqlj31068.html#crefsqlj31068 thanks, bryan
