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
Hi,

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

Outcomes