· 8 years ago · Feb 23, 2018, 07:42 PM
1org.h2.jdbc.JdbcSQLException: Unknown data type: "ENUM"; SQL statement:
2CREATE CACHED TABLE PUBLIC.POWERPLANT(
3 POWERPLANTID INT NOT NULL,
4 ORGNAME VARCHAR(25) NOT NULL,
5 ISACTIVE BOOL NOT NULL,
6 MINPOWER INT NOT NULL,
7 MAXPOWER INT NOT NULL,
8 RAMPRATE INT,
9 RAMPRATESECS INT,
10 POWERPLANTTYPE ENUM('OnOffType','RampUpType'),
11 CREATEDAT TIMESTAMP NOT NULL,
12 UPDATEDAT TIMESTAMP NOT NULL
13) [50004-186]
14 at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
15 at org.h2.message.DbException.get(DbException.java:179)
16 at org.h2.message.DbException.get(DbException.java:155)
17 at org.h2.command.Parser.parseColumnWithType(Parser.java:3990)
18 at org.h2.command.Parser.parseColumnForTable(Parser.java:3853)
19 at org.h2.command.Parser.parseCreateTable(Parser.java:5761)
20 at org.h2.command.Parser.parseCreate(Parser.java:4149)
21 at org.h2.command.Parser.parsePrepared(Parser.java:350)
22 at org.h2.command.Parser.parse(Parser.java:305)
23 at org.h2.command.Parser.parse(Parser.java:277)
24
25db.url = "jdbc:h2:~/path/to/db/file;MODE=MySQL;INIT=CREATE DOMAIN IF NOT EXISTS enum as VARCHAR(255);IFEXISTS=TRUE"