dbflute / dbflute-core

DBFlute core libraries for Java8
http://dbflute.seasar.org/
23 stars 18 forks source link

DBFlute Engine: upgrade H2 database JDBC driver embedded in engine #123

Open jflute opened 2 years ago

jflute commented 2 years ago

however compatibility problem

since 1.4.200:

"TRUNCATE" は無効なパラメータ番号です, 期待される番号: "1"
Invalid parameter count for "TRUNCATE", expected count: "1"; SQL statement:

where dfloc.BIRTHDATE <= truncate(dateadd(month, dfloc.VERSION_NO, ?), dfloc.MEMBER_ID)

on 2.1.210:

Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: SQLステートメントに文法エラーがあります "create table MEMBER(\000a    MEMBER_ID INTEGER [*]IDENTITY NOT NULL PRIMARY KEY,\000a    MEMBER_NAME VARCHAR(200) NOT NULL,\000a    MEMBER_ACCOUNT VARCHAR(50) NOT NULL,\000a    MEMBER_STATUS_CODE CHAR(3) NOT NULL,\000a    FORMALIZED_DATETIME DATETIME,\000a    BIRTHDATE DATE,\000a    REGISTER_DATETIME DATETIME NOT NULL,\000a    REGISTER_USER VARCHAR(200) NOT NULL,\000a    UPDATE_DATETIME DATETIME NOT NULL,\000a    UPDATE_USER VARCHAR(200) NOT NULL,\000a    VERSION_NO BIGINT NOT NULL\000a)"; 期待されるステートメント "ARRAY, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO_INCREMENT, DEFAULT, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, COMMENT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, AUTO_INCREMENT, ,, )"
Syntax error in SQL statement "create table MEMBER(\000a    MEMBER_ID INTEGER [*]IDENTITY NOT NULL PRIMARY KEY,\000a    MEMBER_NAME VARCHAR(200) NOT NULL,\000a    MEMBER_ACCOUNT VARCHAR(50) NOT NULL,\000a    MEMBER_STATUS_CODE CHAR(3) NOT NULL,\000a    FORMALIZED_DATETIME DATETIME,\000a    BIRTHDATE DATE,\000a    REGISTER_DATETIME DATETIME NOT NULL,\000a    REGISTER_USER VARCHAR(200) NOT NULL,\000a    UPDATE_DATETIME DATETIME NOT NULL,\000a    UPDATE_USER VARCHAR(200) NOT NULL,\000a    VERSION_NO BIGINT NOT NULL\000a)"; expected "ARRAY, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO_INCREMENT, DEFAULT, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, COMMENT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, AUTO_INCREMENT, ,, )"; SQL statement:
create table MEMBER(
    MEMBER_ID INTEGER IDENTITY NOT NULL PRIMARY KEY,
    MEMBER_NAME VARCHAR(200) NOT NULL,
    MEMBER_ACCOUNT VARCHAR(50) NOT NULL,
    MEMBER_STATUS_CODE CHAR(3) NOT NULL,
    FORMALIZED_DATETIME DATETIME,
    BIRTHDATE DATE,
    REGISTER_DATETIME DATETIME NOT NULL,
    REGISTER_USER VARCHAR(200) NOT NULL,
    UPDATE_DATETIME DATETIME NOT NULL,
    UPDATE_USER VARCHAR(200) NOT NULL,
    VERSION_NO BIGINT NOT NULL
) [42001-210]