Skip to content

Instantly share code, notes, and snippets.

@juven
Created September 1, 2011 15:53
Show Gist options
  • Save juven/1186477 to your computer and use it in GitHub Desktop.
Save juven/1186477 to your computer and use it in GitHub Desktop.
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement " CREATE TABLE hash_file ( sha1 varchar(41) NOT NULL, container_sha1 varchar(41) default NULL, path varchar(400) NOT NULL, fileSize int(11) NOT NULL, "; expected "identifier"; SQL statement:
CREATE TABLE hash_file ( sha1 varchar(41) NOT NULL, container_sha1 varchar(41) default NULL, path varchar(400) NOT NULL, fileSize int(11) NOT NULL, -- This could be joined in from the hash table, but that may be pointless. lastModified bigint(20) NOT NULL, CONSTRAINT hash_file_pk PRIMARY KEY (sha1, path, filename, extension), CONSTRAINT hash_file_fk FOREIGN KEY (sha1) REFERENCES hash(sha1) CONSTRAINT hash_file_container_fk FOREIGN KEY (container_sha1) REFERENCES hash(sha1) ) [42001-158]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment