10-26 17:46:39 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります CREATE SEQUENCE SEQUENCE_STRATEGY_ID AS[*] INTEGER START WITH 1 INCREMENT BY 100 CREATE SEQUENCE MY_SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 CREATE TABLE DEPARTMENT(DEPARTMENT_ID INTEGER NOT NULL PRIMARY KEY, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER) CREATE TABLE ADDRESS(ADDRESS_ID INTEGER NOT NULL PRIMARY KEY, STREET VARCHAR(20), VERSION INTEGER) CREATE TABLE EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID INTEGER,ADDRESS_ID INTEGER,VERSION INTEGER, CONSTRAINT FK_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID) REFERENCES DEPARTMENT(DEPARTMENT_ID), CONSTRAINT FK_ADDRESS_ID FOREIGN KEY(ADDRESS_ID) REFERENCES ADDRESS(ADDRESS_ID)) CREATE TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL, DEPARTMENT_ID2 INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER, CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1, DEPARTMENT_ID2)) CREATE TABLE COMP_KEY_ADDRESS(ADDRESS_ID1 INTEGER NOT NULL, ADDRESS_ID2 INTEGER NOT NULL, STREET VARCHAR(20), VERSION INTEGER, CONSTRAINT PK_COMP_KEY_ADDRESS PRIMARY KEY(ADDRESS_ID1, ADDRESS_ID2)) CREATE TABLE COMP_KEY_EMPLOYEE(EMPLOYEE_ID1 INTEGER NOT NULL, EMPLOYEE_ID2 INTEGER NOT NULL, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID1 INTEGER,MANAGER_ID2 INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID1 INTEGER,DEPARTMENT_ID2 INTEGER,ADDRESS_ID1 INTEGER,ADDRESS_ID2 INTEGER,VERSION INTEGER, CONSTRAINT PK_COMP_KEY_EMPLOYEE PRIMARY KEY(EMPLOYEE_ID1, EMPLOYEE_ID2), CONSTRAINT FK_COMP_KEY_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID1, DEPARTMENT_ID2) REFERENCES COMP_KEY_DEPARTMENT(DEPARTMENT_ID1, DEPARTMENT_ID2), CONSTRAINT FK_COMP_KEY_ADDRESS_ID FOREIGN KEY(ADDRESS_ID1, ADDRESS_ID2) REFERENCES COMP_KEY_ADDRESS(ADDRESS_ID1, ADDRESS_ID2)) CREATE TABLE ID_GENERATOR(PK VARCHAR(20) NOT NULL PRIMARY KEY, VALUE INTEGER NOT NULL) CREATE TABLE MY_ID_GENERATOR(MY_PK VARCHAR(20) NOT NULL PRIMARY KEY, MY_VALUE INTEGER NOT NULL) CREATE TABLE AUTO_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE IDENTITY_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE SEQUENCE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE SEQUENCE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE TABLE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE TABLE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE USER SA PASSWORD "" ADMIN SET WRITE_DELAY 60 INSERT INTO DEPARTMENT VALUES(1,10,'ACCOUNTING','NEW YORK',1) INSERT INTO DEPARTMENT VALUES(2,20,'RESEARCH','DALLAS',1) INSERT INTO DEPARTMENT VALUES(3,30,'SALES','CHICAGO',1) INSERT INTO DEPARTMENT VALUES(4,40,'OPERATIONS','BOSTON',1) INSERT INTO ADDRESS VALUES(1,'STREET 1',1) INSERT INTO ADDRESS VALUES(2,'STREET 2',1) INSERT INTO ADDRESS VALUES(3,'STREET 3',1) INSERT INTO ADDRESS VALUES(4,'STREET 4',1) INSERT INTO ADDRESS VALUES(5,'STREET 5',1) INSERT INTO ADDRESS VALUES(6,'STREET 6',1) INSERT INTO ADDRESS VALUES(7,'STREET 7',1) INSERT INTO ADDRESS VALUES(8,'STREET 8',1) INSERT INTO ADDRESS VALUES(9,'STREET 9',1) INSERT INTO ADDRESS VALUES(10,'STREET 10',1) INSERT INTO ADDRESS VALUES(11,'STREET 11',1) INSERT INTO ADDRESS VALUES(12,'STREET 12',1) INSERT INTO ADDRESS VALUES(13,'STREET 13',1) INSERT INTO ADDRESS VALUES(14,'STREET 14',1) INSERT INTO EMPLOYEE VALUES(1,7369,'SMITH',13,'1980-12-17',800,2,1,1) INSERT INTO EMPLOYEE VALUES(2,7499,'ALLEN',6,'1981-02-20',1600,3,2,1) INSERT INTO EMPLOYEE VALUES(3,7521,'WARD',6,'1981-02-22',1250,3,3,1) INSERT INTO EMPLOYEE VALUES(4,7566,'JONES',9,'1981-04-02',2975,2,4,1) INSERT INTO EMPLOYEE VALUES(5,7654,'MARTIN',6,'1981-09-28',1250,3,5,1) INSERT INTO EMPLOYEE VALUES(6,7698,'BLAKE',9,'1981-05-01',2850,3,6,1) INSERT INTO EMPLOYEE VALUES(7,7782,'CLARK',9,'1981-06-09',2450,1,7,1) INSERT INTO EMPLOYEE VALUES(8,7788,'SCOTT',4,'1982-12-09',3000.0,2,8,1) INSERT INTO EMPLOYEE VALUES(9,7839,'KING',NULL,'1981-11-17',5000,1,9,1) INSERT INTO EMPLOYEE VALUES(10,7844,'TURNER',6,'1981-09-08',1500,3,10,1) INSERT INTO EMPLOYEE VALUES(11,7876,'ADAMS',8,'1983-01-12',1100,2,11,1) INSERT INTO EMPLOYEE VALUES(12,7900,'JAMES',6,'1981-12-03',950,3,12,1) INSERT INTO EMPLOYEE VALUES(13,7902,'FORD',4,'1981-12-03',3000,2,13,1) INSERT INTO EMPLOYEE VALUES(14,7934,'MILLER',7,'1982-01-23',1300,1,14,1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(1,1,10,'ACCOUNTING','NEW YORK',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(2,2,20,'RESEARCH','DALLAS',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(3,3,30,'SALES','CHICAGO',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(4,4,40,'OPERATIONS','BOSTON',1) INSERT INTO COMP_KEY_ADDRESS VALUES(1,1,'STREET 1',1) INSERT INTO COMP_KEY_ADDRESS VALUES(2,2,'STREET 2',1) INSERT INTO COMP_KEY_ADDRESS VALUES(3,3,'STREET 3',1) INSERT INTO COMP_KEY_ADDRESS VALUES(4,4,'STREET 4',1) INSERT INTO COMP_KEY_ADDRESS VALUES(5,5,'STREET 5',1) INSERT INTO COMP_KEY_ADDRESS VALUES(6,6,'STREET 6',1) INSERT INTO COMP_KEY_ADDRESS VALUES(7,7,'STREET 7',1) INSERT INTO COMP_KEY_ADDRESS VALUES(8,8,'STREET 8',1) INSERT INTO COMP_KEY_ADDRESS VALUES(9,9,'STREET 9',1) INSERT INTO COMP_KEY_ADDRESS VALUES(10,10,'STREET 10',1) INSERT INTO COMP_KEY_ADDRESS VALUES(11,11,'STREET 11',1) INSERT INTO COMP_KEY_ADDRESS VALUES(12,12,'STREET 12',1) INSERT INTO COMP_KEY_ADDRESS VALUES(13,13,'STREET 13',1) INSERT INTO COMP_KEY_ADDRESS VALUES(14,14,'STREET 14',1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(1,1,7369,'SMITH',13,13,'1980-12-17',800,2,2,1,1,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(2,2,7499,'ALLEN',6,6,'1981-02-20',1600,3,3,2,2,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(3,3,7521,'WARD',6,6,'1981-02-22',1250,3,3,3,3,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(4,4,7566,'JONES',9,9,'1981-04-02',2975,2,2,4,4,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(5,5,7654,'MARTIN',6,6,'1981-09-28',1250,3,3,5,5,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(6,6,7698,'BLAKE',9,9,'1981-05-01',2850,3,3,6,6,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(7,7,7782,'CLARK',9,9,'1981-06-09',2450,1,1,7,7,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(8,8,7788,'SCOTT',4,4,'1982-12-09',3000.0,2,2,8,8,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(9,9,7839,'KING',NULL,NULL,'1981-11-17',5000,1,1,9,9,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(10,10,7844,'TURNER',6,6,'1981-09-08',1500,3,3,10,10,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(11,11,7876,'ADAMS',8,8,'1983-01-12',1100,2,2,11,11,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(12,12,7900,'JAMES',6,6,'1981-12-03',950,3,3,12,12,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(13,13,7902,'FORD',4,4,'1981-12-03',3000,2,2,13,13,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(14,14,7934,'MILLER',7,7,'1982-01-23',1300,1,1,14,14,1) INSERT INTO ID_GENERATOR VALUES('TABLE_STRATEGY_ID', 1) Syntax error in SQL statement CREATE SEQUENCE SEQUENCE_STRATEGY_ID AS[*] INTEGER START WITH 1 INCREMENT BY 100 CREATE SEQUENCE MY_SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 CREATE TABLE DEPARTMENT(DEPARTMENT_ID INTEGER NOT NULL PRIMARY KEY, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER) CREATE TABLE ADDRESS(ADDRESS_ID INTEGER NOT NULL PRIMARY KEY, STREET VARCHAR(20), VERSION INTEGER) CREATE TABLE EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID INTEGER,ADDRESS_ID INTEGER,VERSION INTEGER, CONSTRAINT FK_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID) REFERENCES DEPARTMENT(DEPARTMENT_ID), CONSTRAINT FK_ADDRESS_ID FOREIGN KEY(ADDRESS_ID) REFERENCES ADDRESS(ADDRESS_ID)) CREATE TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL, DEPARTMENT_ID2 INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER, CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1, DEPARTMENT_ID2)) CREATE TABLE COMP_KEY_ADDRESS(ADDRESS_ID1 INTEGER NOT NULL, ADDRESS_ID2 INTEGER NOT NULL, STREET VARCHAR(20), VERSION INTEGER, CONSTRAINT PK_COMP_KEY_ADDRESS PRIMARY KEY(ADDRESS_ID1, ADDRESS_ID2)) CREATE TABLE COMP_KEY_EMPLOYEE(EMPLOYEE_ID1 INTEGER NOT NULL, EMPLOYEE_ID2 INTEGER NOT NULL, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID1 INTEGER,MANAGER_ID2 INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID1 INTEGER,DEPARTMENT_ID2 INTEGER,ADDRESS_ID1 INTEGER,ADDRESS_ID2 INTEGER,VERSION INTEGER, CONSTRAINT PK_COMP_KEY_EMPLOYEE PRIMARY KEY(EMPLOYEE_ID1, EMPLOYEE_ID2), CONSTRAINT FK_COMP_KEY_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID1, DEPARTMENT_ID2) REFERENCES COMP_KEY_DEPARTMENT(DEPARTMENT_ID1, DEPARTMENT_ID2), CONSTRAINT FK_COMP_KEY_ADDRESS_ID FOREIGN KEY(ADDRESS_ID1, ADDRESS_ID2) REFERENCES COMP_KEY_ADDRESS(ADDRESS_ID1, ADDRESS_ID2)) CREATE TABLE ID_GENERATOR(PK VARCHAR(20) NOT NULL PRIMARY KEY, VALUE INTEGER NOT NULL) CREATE TABLE MY_ID_GENERATOR(MY_PK VARCHAR(20) NOT NULL PRIMARY KEY, MY_VALUE INTEGER NOT NULL) CREATE TABLE AUTO_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE IDENTITY_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE SEQUENCE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE SEQUENCE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE TABLE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE TABLE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE USER SA PASSWORD "" ADMIN SET WRITE_DELAY 60 INSERT INTO DEPARTMENT VALUES(1,10,'ACCOUNTING','NEW YORK',1) INSERT INTO DEPARTMENT VALUES(2,20,'RESEARCH','DALLAS',1) INSERT INTO DEPARTMENT VALUES(3,30,'SALES','CHICAGO',1) INSERT INTO DEPARTMENT VALUES(4,40,'OPERATIONS','BOSTON',1) INSERT INTO ADDRESS VALUES(1,'STREET 1',1) INSERT INTO ADDRESS VALUES(2,'STREET 2',1) INSERT INTO ADDRESS VALUES(3,'STREET 3',1) INSERT INTO ADDRESS VALUES(4,'STREET 4',1) INSERT INTO ADDRESS VALUES(5,'STREET 5',1) INSERT INTO ADDRESS VALUES(6,'STREET 6',1) INSERT INTO ADDRESS VALUES(7,'STREET 7',1) INSERT INTO ADDRESS VALUES(8,'STREET 8',1) INSERT INTO ADDRESS VALUES(9,'STREET 9',1) INSERT INTO ADDRESS VALUES(10,'STREET 10',1) INSERT INTO ADDRESS VALUES(11,'STREET 11',1) INSERT INTO ADDRESS VALUES(12,'STREET 12',1) INSERT INTO ADDRESS VALUES(13,'STREET 13',1) INSERT INTO ADDRESS VALUES(14,'STREET 14',1) INSERT INTO EMPLOYEE VALUES(1,7369,'SMITH',13,'1980-12-17',800,2,1,1) INSERT INTO EMPLOYEE VALUES(2,7499,'ALLEN',6,'1981-02-20',1600,3,2,1) INSERT INTO EMPLOYEE VALUES(3,7521,'WARD',6,'1981-02-22',1250,3,3,1) INSERT INTO EMPLOYEE VALUES(4,7566,'JONES',9,'1981-04-02',2975,2,4,1) INSERT INTO EMPLOYEE VALUES(5,7654,'MARTIN',6,'1981-09-28',1250,3,5,1) INSERT INTO EMPLOYEE VALUES(6,7698,'BLAKE',9,'1981-05-01',2850,3,6,1) INSERT INTO EMPLOYEE VALUES(7,7782,'CLARK',9,'1981-06-09',2450,1,7,1) INSERT INTO EMPLOYEE VALUES(8,7788,'SCOTT',4,'1982-12-09',3000.0,2,8,1) INSERT INTO EMPLOYEE VALUES(9,7839,'KING',NULL,'1981-11-17',5000,1,9,1) INSERT INTO EMPLOYEE VALUES(10,7844,'TURNER',6,'1981-09-08',1500,3,10,1) INSERT INTO EMPLOYEE VALUES(11,7876,'ADAMS',8,'1983-01-12',1100,2,11,1) INSERT INTO EMPLOYEE VALUES(12,7900,'JAMES',6,'1981-12-03',950,3,12,1) INSERT INTO EMPLOYEE VALUES(13,7902,'FORD',4,'1981-12-03',3000,2,13,1) INSERT INTO EMPLOYEE VALUES(14,7934,'MILLER',7,'1982-01-23',1300,1,14,1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(1,1,10,'ACCOUNTING','NEW YORK',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(2,2,20,'RESEARCH','DALLAS',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(3,3,30,'SALES','CHICAGO',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(4,4,40,'OPERATIONS','BOSTON',1) INSERT INTO COMP_KEY_ADDRESS VALUES(1,1,'STREET 1',1) INSERT INTO COMP_KEY_ADDRESS VALUES(2,2,'STREET 2',1) INSERT INTO COMP_KEY_ADDRESS VALUES(3,3,'STREET 3',1) INSERT INTO COMP_KEY_ADDRESS VALUES(4,4,'STREET 4',1) INSERT INTO COMP_KEY_ADDRESS VALUES(5,5,'STREET 5',1) INSERT INTO COMP_KEY_ADDRESS VALUES(6,6,'STREET 6',1) INSERT INTO COMP_KEY_ADDRESS VALUES(7,7,'STREET 7',1) INSERT INTO COMP_KEY_ADDRESS VALUES(8,8,'STREET 8',1) INSERT INTO COMP_KEY_ADDRESS VALUES(9,9,'STREET 9',1) INSERT INTO COMP_KEY_ADDRESS VALUES(10,10,'STREET 10',1) INSERT INTO COMP_KEY_ADDRESS VALUES(11,11,'STREET 11',1) INSERT INTO COMP_KEY_ADDRESS VALUES(12,12,'STREET 12',1) INSERT INTO COMP_KEY_ADDRESS VALUES(13,13,'STREET 13',1) INSERT INTO COMP_KEY_ADDRESS VALUES(14,14,'STREET 14',1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(1,1,7369,'SMITH',13,13,'1980-12-17',800,2,2,1,1,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(2,2,7499,'ALLEN',6,6,'1981-02-20',1600,3,3,2,2,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(3,3,7521,'WARD',6,6,'1981-02-22',1250,3,3,3,3,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(4,4,7566,'JONES',9,9,'1981-04-02',2975,2,2,4,4,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(5,5,7654,'MARTIN',6,6,'1981-09-28',1250,3,3,5,5,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(6,6,7698,'BLAKE',9,9,'1981-05-01',2850,3,3,6,6,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(7,7,7782,'CLARK',9,9,'1981-06-09',2450,1,1,7,7,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(8,8,7788,'SCOTT',4,4,'1982-12-09',3000.0,2,2,8,8,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(9,9,7839,'KING',NULL,NULL,'1981-11-17',5000,1,1,9,9,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(10,10,7844,'TURNER',6,6,'1981-09-08',1500,3,3,10,10,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(11,11,7876,'ADAMS',8,8,'1983-01-12',1100,2,2,11,11,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(12,12,7900,'JAMES',6,6,'1981-12-03',950,3,3,12,12,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(13,13,7902,'FORD',4,4,'1981-12-03',3000,2,2,13,13,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(14,14,7934,'MILLER',7,7,'1982-01-23',1300,1,1,14,14,1) INSERT INTO ID_GENERATOR VALUES('TABLE_STRATEGY_ID', 1); SQL statement: CREATE SEQUENCE SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 CREATE SEQUENCE MY_SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 CREATE TABLE DEPARTMENT(DEPARTMENT_ID INTEGER NOT NULL PRIMARY KEY, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER) CREATE TABLE ADDRESS(ADDRESS_ID INTEGER NOT NULL PRIMARY KEY, STREET VARCHAR(20), VERSION INTEGER) CREATE TABLE EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID INTEGER,ADDRESS_ID INTEGER,VERSION INTEGER, CONSTRAINT FK_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID) REFERENCES DEPARTMENT(DEPARTMENT_ID), CONSTRAINT FK_ADDRESS_ID FOREIGN KEY(ADDRESS_ID) REFERENCES ADDRESS(ADDRESS_ID)) CREATE TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL, DEPARTMENT_ID2 INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER, CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1, DEPARTMENT_ID2)) CREATE TABLE COMP_KEY_ADDRESS(ADDRESS_ID1 INTEGER NOT NULL, ADDRESS_ID2 INTEGER NOT NULL, STREET VARCHAR(20), VERSION INTEGER, CONSTRAINT PK_COMP_KEY_ADDRESS PRIMARY KEY(ADDRESS_ID1, ADDRESS_ID2)) CREATE TABLE COMP_KEY_EMPLOYEE(EMPLOYEE_ID1 INTEGER NOT NULL, EMPLOYEE_ID2 INTEGER NOT NULL, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID1 INTEGER,MANAGER_ID2 INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID1 INTEGER,DEPARTMENT_ID2 INTEGER,ADDRESS_ID1 INTEGER,ADDRESS_ID2 INTEGER,VERSION INTEGER, CONSTRAINT PK_COMP_KEY_EMPLOYEE PRIMARY KEY(EMPLOYEE_ID1, EMPLOYEE_ID2), CONSTRAINT FK_COMP_KEY_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID1, DEPARTMENT_ID2) REFERENCES COMP_KEY_DEPARTMENT(DEPARTMENT_ID1, DEPARTMENT_ID2), CONSTRAINT FK_COMP_KEY_ADDRESS_ID FOREIGN KEY(ADDRESS_ID1, ADDRESS_ID2) REFERENCES COMP_KEY_ADDRESS(ADDRESS_ID1, ADDRESS_ID2)) CREATE TABLE ID_GENERATOR(PK VARCHAR(20) NOT NULL PRIMARY KEY, VALUE INTEGER NOT NULL) CREATE TABLE MY_ID_GENERATOR(MY_PK VARCHAR(20) NOT NULL PRIMARY KEY, MY_VALUE INTEGER NOT NULL) CREATE TABLE AUTO_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE IDENTITY_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE SEQUENCE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE SEQUENCE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE TABLE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE TABLE TABLE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)) CREATE USER SA PASSWORD "" ADMIN SET WRITE_DELAY 60 INSERT INTO DEPARTMENT VALUES(1,10,'ACCOUNTING','NEW YORK',1) INSERT INTO DEPARTMENT VALUES(2,20,'RESEARCH','DALLAS',1) INSERT INTO DEPARTMENT VALUES(3,30,'SALES','CHICAGO',1) INSERT INTO DEPARTMENT VALUES(4,40,'OPERATIONS','BOSTON',1) INSERT INTO ADDRESS VALUES(1,'STREET 1',1) INSERT INTO ADDRESS VALUES(2,'STREET 2',1) INSERT INTO ADDRESS VALUES(3,'STREET 3',1) INSERT INTO ADDRESS VALUES(4,'STREET 4',1) INSERT INTO ADDRESS VALUES(5,'STREET 5',1) INSERT INTO ADDRESS VALUES(6,'STREET 6',1) INSERT INTO ADDRESS VALUES(7,'STREET 7',1) INSERT INTO ADDRESS VALUES(8,'STREET 8',1) INSERT INTO ADDRESS VALUES(9,'STREET 9',1) INSERT INTO ADDRESS VALUES(10,'STREET 10',1) INSERT INTO ADDRESS VALUES(11,'STREET 11',1) INSERT INTO ADDRESS VALUES(12,'STREET 12',1) INSERT INTO ADDRESS VALUES(13,'STREET 13',1) INSERT INTO ADDRESS VALUES(14,'STREET 14',1) INSERT INTO EMPLOYEE VALUES(1,7369,'SMITH',13,'1980-12-17',800,2,1,1) INSERT INTO EMPLOYEE VALUES(2,7499,'ALLEN',6,'1981-02-20',1600,3,2,1) INSERT INTO EMPLOYEE VALUES(3,7521,'WARD',6,'1981-02-22',1250,3,3,1) INSERT INTO EMPLOYEE VALUES(4,7566,'JONES',9,'1981-04-02',2975,2,4,1) INSERT INTO EMPLOYEE VALUES(5,7654,'MARTIN',6,'1981-09-28',1250,3,5,1) INSERT INTO EMPLOYEE VALUES(6,7698,'BLAKE',9,'1981-05-01',2850,3,6,1) INSERT INTO EMPLOYEE VALUES(7,7782,'CLARK',9,'1981-06-09',2450,1,7,1) INSERT INTO EMPLOYEE VALUES(8,7788,'SCOTT',4,'1982-12-09',3000.0,2,8,1) INSERT INTO EMPLOYEE VALUES(9,7839,'KING',NULL,'1981-11-17',5000,1,9,1) INSERT INTO EMPLOYEE VALUES(10,7844,'TURNER',6,'1981-09-08',1500,3,10,1) INSERT INTO EMPLOYEE VALUES(11,7876,'ADAMS',8,'1983-01-12',1100,2,11,1) INSERT INTO EMPLOYEE VALUES(12,7900,'JAMES',6,'1981-12-03',950,3,12,1) INSERT INTO EMPLOYEE VALUES(13,7902,'FORD',4,'1981-12-03',3000,2,13,1) INSERT INTO EMPLOYEE VALUES(14,7934,'MILLER',7,'1982-01-23',1300,1,14,1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(1,1,10,'ACCOUNTING','NEW YORK',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(2,2,20,'RESEARCH','DALLAS',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(3,3,30,'SALES','CHICAGO',1) INSERT INTO COMP_KEY_DEPARTMENT VALUES(4,4,40,'OPERATIONS','BOSTON',1) INSERT INTO COMP_KEY_ADDRESS VALUES(1,1,'STREET 1',1) INSERT INTO COMP_KEY_ADDRESS VALUES(2,2,'STREET 2',1) INSERT INTO COMP_KEY_ADDRESS VALUES(3,3,'STREET 3',1) INSERT INTO COMP_KEY_ADDRESS VALUES(4,4,'STREET 4',1) INSERT INTO COMP_KEY_ADDRESS VALUES(5,5,'STREET 5',1) INSERT INTO COMP_KEY_ADDRESS VALUES(6,6,'STREET 6',1) INSERT INTO COMP_KEY_ADDRESS VALUES(7,7,'STREET 7',1) INSERT INTO COMP_KEY_ADDRESS VALUES(8,8,'STREET 8',1) INSERT INTO COMP_KEY_ADDRESS VALUES(9,9,'STREET 9',1) INSERT INTO COMP_KEY_ADDRESS VALUES(10,10,'STREET 10',1) INSERT INTO COMP_KEY_ADDRESS VALUES(11,11,'STREET 11',1) INSERT INTO COMP_KEY_ADDRESS VALUES(12,12,'STREET 12',1) INSERT INTO COMP_KEY_ADDRESS VALUES(13,13,'STREET 13',1) INSERT INTO COMP_KEY_ADDRESS VALUES(14,14,'STREET 14',1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(1,1,7369,'SMITH',13,13,'1980-12-17',800,2,2,1,1,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(2,2,7499,'ALLEN',6,6,'1981-02-20',1600,3,3,2,2,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(3,3,7521,'WARD',6,6,'1981-02-22',1250,3,3,3,3,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(4,4,7566,'JONES',9,9,'1981-04-02',2975,2,2,4,4,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(5,5,7654,'MARTIN',6,6,'1981-09-28',1250,3,3,5,5,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(6,6,7698,'BLAKE',9,9,'1981-05-01',2850,3,3,6,6,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(7,7,7782,'CLARK',9,9,'1981-06-09',2450,1,1,7,7,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(8,8,7788,'SCOTT',4,4,'1982-12-09',3000.0,2,2,8,8,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(9,9,7839,'KING',NULL,NULL,'1981-11-17',5000,1,1,9,9,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(10,10,7844,'TURNER',6,6,'1981-09-08',1500,3,3,10,10,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(11,11,7876,'ADAMS',8,8,'1983-01-12',1100,2,2,11,11,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(12,12,7900,'JAMES',6,6,'1981-12-03',950,3,3,12,12,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(13,13,7902,'FORD',4,4,'1981-12-03',3000,2,2,13,13,1) INSERT INTO COMP_KEY_EMPLOYEE VALUES(14,14,7934,'MILLER',7,7,'1982-01-23',1300,1,1,14,14,1) INSERT INTO ID_GENERATOR VALUES('TABLE_STRATEGY_ID', 1) [42000-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSQLException(Message.java:66) at org.h2.message.Message.getSyntaxError(Message.java:93) at org.h2.command.Parser.getSyntaxError(Parser.java:440) at org.h2.command.Parser.prepareCommand(Parser.java:220) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:46:39 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: テーブル MY_ID_GENERATOR が見つかりません Table MY_ID_GENERATOR not found; SQL statement: INSERT INTO MY_ID_GENERATOR VALUES('TableStrategy2', 1) [42S02-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSQLException(Message.java:66) at org.h2.command.Parser.readTableOrView(Parser.java:3911) at org.h2.command.Parser.readTableOrView(Parser.java:3891) at org.h2.command.Parser.parseInsert(Parser.java:783) at org.h2.command.Parser.parsePrepared(Parser.java:338) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.parse(Parser.java:232) at org.h2.command.Parser.prepareCommand(Parser.java:204) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:47:44 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります CREATE TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL, DEPARTMENT_ID2 INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER, CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1, DEPARTMENT_ID2)) CREATE[*] TABLE COMP_KEY_ADDRESS(ADDRESS_ID1 INTEGER NOT NULL, ADDRESS_ID2 INTEGER NOT NULL, STREET VARCHAR(20), VERSION INTEGER, CONSTRAINT PK_COMP_KEY_ADDRESS PRIMARY KEY(ADDRESS_ID1, ADDRESS_ID2)) Syntax error in SQL statement CREATE TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL, DEPARTMENT_ID2 INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER, CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1, DEPARTMENT_ID2)) CREATE[*] TABLE COMP_KEY_ADDRESS(ADDRESS_ID1 INTEGER NOT NULL, ADDRESS_ID2 INTEGER NOT NULL, STREET VARCHAR(20), VERSION INTEGER, CONSTRAINT PK_COMP_KEY_ADDRESS PRIMARY KEY(ADDRESS_ID1, ADDRESS_ID2)); SQL statement: CREATE TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL, DEPARTMENT_ID2 INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER, CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1, DEPARTMENT_ID2)) CREATE TABLE COMP_KEY_ADDRESS(ADDRESS_ID1 INTEGER NOT NULL, ADDRESS_ID2 INTEGER NOT NULL, STREET VARCHAR(20), VERSION INTEGER, CONSTRAINT PK_COMP_KEY_ADDRESS PRIMARY KEY(ADDRESS_ID1, ADDRESS_ID2)) [42000-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSQLException(Message.java:66) at org.h2.message.Message.getSyntaxError(Message.java:93) at org.h2.command.Parser.getSyntaxError(Parser.java:440) at org.h2.command.Parser.prepareCommand(Parser.java:220) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:48:48 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります CREATE SEQUENCE SEQUENCE_STRATEGY_ID AS[*] INTEGER START WITH 1 INCREMENT BY 100 Syntax error in SQL statement CREATE SEQUENCE SEQUENCE_STRATEGY_ID AS[*] INTEGER START WITH 1 INCREMENT BY 100; SQL statement: CREATE SEQUENCE SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 [42000-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSQLException(Message.java:66) at org.h2.message.Message.getSyntaxError(Message.java:93) at org.h2.command.Parser.getSyntaxError(Parser.java:440) at org.h2.command.Parser.prepareCommand(Parser.java:220) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:48:48 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります CREATE SEQUENCE MY_SEQUENCE_STRATEGY_ID AS[*] INTEGER START WITH 1 INCREMENT BY 100 Syntax error in SQL statement CREATE SEQUENCE MY_SEQUENCE_STRATEGY_ID AS[*] INTEGER START WITH 1 INCREMENT BY 100; SQL statement: CREATE SEQUENCE MY_SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 [42000-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSQLException(Message.java:66) at org.h2.message.Message.getSyntaxError(Message.java:93) at org.h2.command.Parser.getSyntaxError(Parser.java:440) at org.h2.command.Parser.prepareCommand(Parser.java:220) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:51:17 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります DROP PROCEDURE[*] NO_PARAM; 期待されるステートメント TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE Syntax error in SQL statement DROP PROCEDURE[*] NO_PARAM; expected TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE; SQL statement: DROP PROCEDURE NO_PARAM [42001-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSyntaxError(Message.java:98) at org.h2.command.Parser.getSyntaxError(Parser.java:449) at org.h2.command.Parser.parseDrop(Parser.java:1055) at org.h2.command.Parser.parsePrepared(Parser.java:306) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.parse(Parser.java:236) at org.h2.command.Parser.prepareCommand(Parser.java:204) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:51:17 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります DROP PROCEDURE[*] SIMPLETYPE_PARAM; 期待されるステートメント TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE Syntax error in SQL statement DROP PROCEDURE[*] SIMPLETYPE_PARAM; expected TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE; SQL statement: DROP PROCEDURE SIMPLETYPE_PARAM [42001-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSyntaxError(Message.java:98) at org.h2.command.Parser.getSyntaxError(Parser.java:449) at org.h2.command.Parser.parseDrop(Parser.java:1055) at org.h2.command.Parser.parsePrepared(Parser.java:306) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.parse(Parser.java:236) at org.h2.command.Parser.prepareCommand(Parser.java:204) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:51:17 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります DROP PROCEDURE[*] DTO_PARAM; 期待されるステートメント TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE Syntax error in SQL statement DROP PROCEDURE[*] DTO_PARAM; expected TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE; SQL statement: DROP PROCEDURE DTO_PARAM [42001-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSyntaxError(Message.java:98) at org.h2.command.Parser.getSyntaxError(Parser.java:449) at org.h2.command.Parser.parseDrop(Parser.java:1055) at org.h2.command.Parser.parsePrepared(Parser.java:306) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.parse(Parser.java:236) at org.h2.command.Parser.prepareCommand(Parser.java:204) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:51:17 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります DROP PROCEDURE[*] ONE_RESULT; 期待されるステートメント TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE Syntax error in SQL statement DROP PROCEDURE[*] ONE_RESULT; expected TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE; SQL statement: DROP PROCEDURE ONE_RESULT [42001-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSyntaxError(Message.java:98) at org.h2.command.Parser.getSyntaxError(Parser.java:449) at org.h2.command.Parser.parseDrop(Parser.java:1055) at org.h2.command.Parser.parsePrepared(Parser.java:306) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.parse(Parser.java:236) at org.h2.command.Parser.prepareCommand(Parser.java:204) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 10-26 17:51:17 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります DROP PROCEDURE[*] TWO_RESULTS; 期待されるステートメント TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE Syntax error in SQL statement DROP PROCEDURE[*] TWO_RESULTS; expected TABLE, INDEX, USER, SEQUENCE, CONSTANT, TRIGGER, VIEW, ROLE, ALIAS, SCHEMA, ALL, DOMAIN, TYPE, DATATYPE, AGGREGATE; SQL statement: DROP PROCEDURE TWO_RESULTS [42001-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSyntaxError(Message.java:98) at org.h2.command.Parser.getSyntaxError(Parser.java:449) at org.h2.command.Parser.parseDrop(Parser.java:1055) at org.h2.command.Parser.parsePrepared(Parser.java:306) at org.h2.command.Parser.parse(Parser.java:260) at org.h2.command.Parser.parse(Parser.java:236) at org.h2.command.Parser.prepareCommand(Parser.java:204) at org.h2.engine.Session.prepareLocal(Session.java:172) at org.h2.engine.Session.prepareCommand(Session.java:154) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:971) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:144) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 11-25 21:21:56 jdbc[0]: SQLException org.h2.jdbc.JdbcSQLException: Table L not found [42S02-55] at org.h2.message.Message.getSQLException(Message.java:65) at org.h2.message.Message.getSQLException(Message.java:47) at org.h2.command.ddl.DropTable.prepareDrop(DropTable.java:54) at org.h2.command.ddl.DropTable.update(DropTable.java:83) at org.h2.command.CommandContainer.update(CommandContainer.java:64) at org.h2.command.Command.executeUpdate(Command.java:121) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:155) at org.h2.server.web.WebThread.getResult(WebThread.java:1211) at org.h2.server.web.WebThread.query(WebThread.java:881) at org.h2.server.web.WebThread.process(WebThread.java:344) at org.h2.server.web.WebThread.processRequest(WebThread.java:117) at org.h2.server.web.WebThread.run(WebThread.java:144) 01-17 23:45:53 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: テーブル NO_ID が見つかりません Table NO_ID not found [42S02-62] at org.h2.message.Message.getSQLException(Message.java:89) at org.h2.message.Message.getSQLException(Message.java:93) at org.h2.message.Message.getSQLException(Message.java:71) at org.h2.command.ddl.DropTable.prepareDrop(DropTable.java:55) at org.h2.command.ddl.DropTable.update(DropTable.java:85) at org.h2.command.CommandContainer.update(CommandContainer.java:64) at org.h2.command.Command.executeUpdate(Command.java:122) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:155) at org.h2.server.web.WebThread.getResult(WebThread.java:1392) at org.h2.server.web.WebThread.query(WebThread.java:1054) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 01-17 23:45:53 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: テーブル OWNER_OF_NO_ID が見つかりません Table OWNER_OF_NO_ID not found [42S02-62] at org.h2.message.Message.getSQLException(Message.java:89) at org.h2.message.Message.getSQLException(Message.java:93) at org.h2.message.Message.getSQLException(Message.java:71) at org.h2.command.ddl.DropTable.prepareDrop(DropTable.java:55) at org.h2.command.ddl.DropTable.update(DropTable.java:85) at org.h2.command.CommandContainer.update(CommandContainer.java:64) at org.h2.command.Command.executeUpdate(Command.java:122) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:155) at org.h2.server.web.WebThread.getResult(WebThread.java:1392) at org.h2.server.web.WebThread.query(WebThread.java:1054) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 04-02 10:03:06 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: テーブル CONSTRAINT_CHECKING が見つかりません Table CONSTRAINT_CHECKING not found [42S02-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSQLException(Message.java:66) at org.h2.command.ddl.DropTable.prepareDrop(DropTable.java:55) at org.h2.command.ddl.DropTable.update(DropTable.java:85) at org.h2.command.CommandContainer.update(CommandContainer.java:64) at org.h2.command.Command.executeUpdate(Command.java:123) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158) 04-08 11:16:51 jdbc[2]: SQLException org.h2.jdbc.JdbcSQLException: テーブル PATTERN が見つかりません Table PATTERN not found [42S02-60] at org.h2.message.Message.getSQLException(Message.java:84) at org.h2.message.Message.getSQLException(Message.java:88) at org.h2.message.Message.getSQLException(Message.java:66) at org.h2.command.ddl.DropTable.prepareDrop(DropTable.java:55) at org.h2.command.ddl.DropTable.update(DropTable.java:85) at org.h2.command.CommandContainer.update(CommandContainer.java:64) at org.h2.command.Command.executeUpdate(Command.java:123) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156) at org.h2.server.web.WebThread.getResult(WebThread.java:1387) at org.h2.server.web.WebThread.query(WebThread.java:1049) at org.h2.server.web.WebThread.process(WebThread.java:375) at org.h2.server.web.WebThread.processRequest(WebThread.java:131) at org.h2.server.web.WebThread.run(WebThread.java:158)