jwjuiYrd

1CREATE TABLE `warps` (
2  `id`             INTEGER PRIMARY KEY NOT NULL         AUTO_INCREMENT,
3  `name`           varchar(32)         NOT NULL,
4  `creator`        varchar(32)         NOT NULL,
5  `world`          varchar(32)         NOT NULL,
6  `welcomeMessage` varchar(100)        NOT NULL,
7  `position`       TEXT                NOT NULL,
8  `invitedPlayers` TEXT                NOT NULL,
9  `blacklist`      TEXT                NOT NULL,
10  `publicAll`      boolean             NOT NULL,
11  `visits`         int                 NOT NULL         DEFAULT 0
12);
13	
14private void checkTable() {
15        this.connection = this.getConnection();
16        try (PreparedStatement ps = this.connection.prepareStatement(CREATE_TABLE_QUERY)) {
17            ps.execute();
18        } catch (SQLException ex) {
19            this.logger.error("Error creating/check table in database.", ex);
20        }
21    }
22
23private Connection getConnection() {
24    try {
25        if ((this.connection == null) || (this.connection.isClosed())) {
26            reconnect();
27        }
28    } catch (SQLException e) {
29        logger.error(e.getMessage(), e);
30    }
31    return this.connection;
32}
33
34private void reconnect() throws SQLException {
35    if (this.connection != null) {
36        this.connection.close();
37    }
38    this.connection = this.openConnection();
39}
40
41private Connection openConnection() throws SQLException {
42    return DriverManager.getConnection("jdbc:h2://" + this.plugin.getConfDir().toString() + File.separatorChar + "warps" + ";mode=MySQL", "User", "");
43}
44	
45org.h2.jdbc.JdbcSQLException: Синтаксическая ошибка в выражении SQL "CREATE TABLE IF NOT EXISTS ""WARPS"" (""ID"" INT PRIMARY KEY NOT NULL AUTO_INCREMENT[*], ""NAME"" VARCHAR(32) NOT NULL, ""CREATOR"" VARCHAR(32) NOT NULL, ""WORLD"" VARCHAR(32) NOT NULL, ""WELCOMEMESSAGE"" VARCHAR(100) NOT NULL, ""POSITION"" TEXT NOT NULL, ""INVITEDPLAYERS"" TEXT NOT NULL, ""BLACKLIST"" TEXT NOT NULL, ""PUBLICALL"" BOOLEAN NOT NULL,""VISITS"" INT NOT NULL DEFAULT 0); "; ожидалось "CHECK, REFERENCES, ,, )"
46Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS ""WARPS"" (""ID"" INT PRIMARY KEY NOT NULL AUTO_INCREMENT[*], ""NAME"" VARCHAR(32) NOT NULL, ""CREATOR"" VARCHAR(32) NOT NULL, ""WORLD"" VARCHAR(32) NOT NULL, ""WELCOMEMESSAGE"" VARCHAR(100) NOT NULL, ""POSITION"" TEXT NOT NULL, ""INVITEDPLAYERS"" TEXT NOT NULL, ""BLACKLIST"" TEXT NOT NULL, ""PUBLICALL"" BOOLEAN NOT NULL,""VISITS"" INT NOT NULL DEFAULT 0); "; expected "CHECK, REFERENCES, ,, )"; SQL statement:
47CREATE TABLE IF NOT EXISTS `warps` (`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL, `creator` varchar(32) NOT NULL, `world` varchar(32) NOT NULL, `welcomeMessage` varchar(100) NOT NULL, `position` TEXT NOT NULL, `invitedPlayers` TEXT NOT NULL, `blacklist` TEXT NOT NULL, `publicAll` boolean NOT NULL,`visits` INT NOT NULL DEFAULT 0); [42001-196]