Web Development with Clojure, Third Edition (vB17.0): create table syntax invalid

jeremyhuiskamp · 2021-04-11T12:41:47.192Z

Title: Web Development with Clojure, Third Edition, vB17.0 (p9)

The create table guestbook syntax suggested doesn’t seem to be accepted by h2:

Syntax error in SQL statement "CREATE TABLE GUESTBOOK (
ID INTEGER PRIMARY KEY AUTO_INCREMENT[*],
NAME VARCHAR(30),
MESSAGE VARCHAR(30),
TIMESTAMP TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);"; expected "HASH, AUTO_INCREMENT, NOT, NULL, COMMENT, CHECK, REFERENCES, ,, )"; SQL statement:
create table guestbook (
id integer primary key auto_increment,
name varchar(30),
message varchar(30),
timestamp timestamp default current_timestamp
); [42001-200]

From what I can tell, the problem is the order of clauses for the id column. Putting auto_increment before primary key works as intended.

This applies to both the book and the downloadable source code.

The h2 documentation confirms this requirement.

pm9999 · 2021-08-13T23:56:52.498Z

My B17 has 200 for message field but otherwise seems the same as yours. No issue here though.

CREATE TABLE guestbook
(id INTEGER PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(30),
message VARCHAR(200),
timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP);