fap63jA1

118:11:36.051 [main] INFO  com.loyaltyplant.mock.bootstrap.H2Bootstrap - Started H2 web server http://192.168.7.12:60856
218:11:36.513 [main] INFO  com.loyaltyplant.mock.bootstrap.TestingDatabaseBootstrap - Parse script 'file:/C:/Users/fomichev/workspace/LPSERVER/lpserver/DigitalOrdering/../DB/LastVersion/196/CREATE%20TABLES%20DB196%202016.07.10.sql'
318:11:36.804 [main] INFO  com.loyaltyplant.mock.bootstrap.TestingDatabaseBootstrap - Applying parsed scripts to ds0: url=jdbc:h2:mem:test;MODE=MySQL;INIT=CREATE SCHEMA IF NOT EXISTS Wasabi\;SET SCHEMA Wasabi user=
418:11:38.149 [main] INFO  com.loyaltyplant.mock.bootstrap.TestingDatabaseBootstrap - StopWatch 'Setup database': running time (millis) = 114; [Bootstrap userEntitySource] took 8 = 7%; [Bootstrap components] took 17 = 15%; [Bootstrap users] took 0 = 0%; [Bootstrap languageEntitySource] took 25 = 22%; [Damn i18n] took 55 = 48%; [Bootstrap roleEntitySource] took 9 = 8%
518:11:38.751 [main] INFO  com.loyaltyplant.mock.bootstrap.TestingDatabaseBootstrap - Parse script 'file:/C:/Users/fomichev/workspace/LPSERVER/sk_ipl_build/targets/debug/DigitalOrdering/test-classes/DOtables.sql'
618:11:38.757 [main] INFO  com.loyaltyplant.mock.bootstrap.TestingDatabaseBootstrap - Applying parsed scripts to ds0: url=jdbc:h2:mem:test;MODE=MySQL;INIT=CREATE SCHEMA IF NOT EXISTS Wasabi\;SET SCHEMA Wasabi user=
718:11:38.759 [main] WARN  org.springframework.context.support.GenericApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bootstrapPosDatabase' defined in com.loyaltyplant.digitalordering.delivery.logic.handler.PosIntegrationTest$Context: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Синтаксическая ошибка в выражении SQL "CREATE TABLE IF NOT EXISTS ITEMCATEGORY (
8  'ItemCategoryID'[*]       INT          NOT NULL  AUTO_INCREMENT,
9  'Version'              INT          NOT NULL,
10  'State'                INT          NOT NULL,
11  'Priority'             INT          NOT NULL,
12  'Title'                VARCHAR(255) NOT NULL,
13  'Description'          TEXT,
14  ""POSID""                VARCHAR(45)  NOT NULL,
15  'USSFileID'            INT          NOT NULL,
16  'ParentItemCategoryID' INT                    DEFAULT NULL,
17  PRIMARY KEY (""CATEGORYID""),
18  FOREIGN KEY (""PARENTITEMCATEGORYID"")
19  REFERENCES ITEMCATEGORY (""ITEMCATEGORYID"")
20    ON DELETE CASCADE
21    ON UPDATE CASCADE
22
23)
24  ENGINE = INNODB "; ожидалось "identifier"
25Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS ITEMCATEGORY (
26  'ItemCategoryID'[*]       INT          NOT NULL  AUTO_INCREMENT,
27  'Version'              INT          NOT NULL,
28  'State'                INT          NOT NULL,
29  'Priority'             INT          NOT NULL,
30  'Title'                VARCHAR(255) NOT NULL,
31  'Description'          TEXT,
32  ""POSID""                VARCHAR(45)  NOT NULL,
33  'USSFileID'            INT          NOT NULL,
34  'ParentItemCategoryID' INT                    DEFAULT NULL,
35  PRIMARY KEY (""CATEGORYID""),
36  FOREIGN KEY (""PARENTITEMCATEGORYID"")
37  REFERENCES ITEMCATEGORY (""ITEMCATEGORYID"")
38    ON DELETE CASCADE
39    ON UPDATE CASCADE
40
41)
42  ENGINE = INNODB "; expected "identifier"; SQL statement:
43CREATE TABLE IF NOT EXISTS ItemCategory (
44  'ItemCategoryID'       INT          NOT NULL  AUTO_INCREMENT,
45  'Version'              INT          NOT NULL,
46  'State'                INT          NOT NULL,
47  'Priority'             INT          NOT NULL,
48  'Title'                VARCHAR(255) NOT NULL,
49  'Description'          TEXT,
50  `PosID`                VARCHAR(45)  NOT NULL,
51  'USSFileID'            INT          NOT NULL,
52  'ParentItemCategoryID' INT                    DEFAULT NULL,
53  PRIMARY KEY (`CategoryID`),
54  FOREIGN KEY (`ParentItemCategoryID`)
55  REFERENCES ItemCategory (`ItemCategoryID`)
56    ON DELETE CASCADE
57    ON UPDATE CASCADE
58
59)
60  ENGINE = InnoDB [42001-189]
6118:11:38.797 [main] INFO  com.loyaltyplant.mock.bootstrap.H2Bootstrap - Open browser, pointing to web console http://192.168.7.12:60856