AnsweredAssumed Answered

H2: Cannot figure out why this create table statement is failing

Question asked by laredotornado on Oct 27, 2015
Latest reply on Oct 28, 2015 by vasile.dirla

I'm using the com.h2database:h2:1.4.190 H2 dependency while creating unit tests using Gradle 2.7.  I'm using Liquibase as the tool for genreating my database scripts and it is currently generating this SQL (for a create table …)

CREATE TABLE PUBLIC.my_prefix_sync_address (id VARCHAR(32) DEFAULT '' NOT NULL, address VARCHAR(500) DEFAULT '', city VARCHAR(100) DEFAULT '', state VARCHAR(10) DEFAULT '', zip VARCHAR(10) DEFAULT '', lattitude INT UNSIGNED DEFAULT , longitude INT UNSIGNED DEFAULT , email VARCHAR(200) DEFAULT '', phone VARCHAR(32) DEFAULT '', phone_type VARCHAR(10) DEFAULT '', CONSTRAINT PK_my_prefix_SYNC_ADDRESS PRIMARY KEY (id))

The driver is reporting the error

org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement

There is no other information.  What is wrong with the above SQL ?

Thanks, - Dave