Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 18:11:36.051 [main] INFO com.loyaltyplant.mock.bootstrap.H2Bootstrap - Started H2 web server http://192.168.7.12:60856
- 18: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'
- 18: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=
- 18: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%
- 18: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'
- 18: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=
- 18: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 (
- 'ItemCategoryID'[*] INT NOT NULL AUTO_INCREMENT,
- 'Version' INT NOT NULL,
- 'State' INT NOT NULL,
- 'Priority' INT NOT NULL,
- 'Title' VARCHAR(255) NOT NULL,
- 'Description' TEXT,
- ""POSID"" VARCHAR(45) NOT NULL,
- 'USSFileID' INT NOT NULL,
- 'ParentItemCategoryID' INT DEFAULT NULL,
- PRIMARY KEY (""CATEGORYID""),
- FOREIGN KEY (""PARENTITEMCATEGORYID"")
- REFERENCES ITEMCATEGORY (""ITEMCATEGORYID"")
- ON DELETE CASCADE
- ON UPDATE CASCADE
- )
- ENGINE = INNODB "; ожидалось "identifier"
- Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS ITEMCATEGORY (
- 'ItemCategoryID'[*] INT NOT NULL AUTO_INCREMENT,
- 'Version' INT NOT NULL,
- 'State' INT NOT NULL,
- 'Priority' INT NOT NULL,
- 'Title' VARCHAR(255) NOT NULL,
- 'Description' TEXT,
- ""POSID"" VARCHAR(45) NOT NULL,
- 'USSFileID' INT NOT NULL,
- 'ParentItemCategoryID' INT DEFAULT NULL,
- PRIMARY KEY (""CATEGORYID""),
- FOREIGN KEY (""PARENTITEMCATEGORYID"")
- REFERENCES ITEMCATEGORY (""ITEMCATEGORYID"")
- ON DELETE CASCADE
- ON UPDATE CASCADE
- )
- ENGINE = INNODB "; expected "identifier"; SQL statement:
- CREATE TABLE IF NOT EXISTS ItemCategory (
- 'ItemCategoryID' INT NOT NULL AUTO_INCREMENT,
- 'Version' INT NOT NULL,
- 'State' INT NOT NULL,
- 'Priority' INT NOT NULL,
- 'Title' VARCHAR(255) NOT NULL,
- 'Description' TEXT,
- `PosID` VARCHAR(45) NOT NULL,
- 'USSFileID' INT NOT NULL,
- 'ParentItemCategoryID' INT DEFAULT NULL,
- PRIMARY KEY (`CategoryID`),
- FOREIGN KEY (`ParentItemCategoryID`)
- REFERENCES ItemCategory (`ItemCategoryID`)
- ON DELETE CASCADE
- ON UPDATE CASCADE
- )
- ENGINE = InnoDB [42001-189]
- 18:11:38.797 [main] INFO com.loyaltyplant.mock.bootstrap.H2Bootstrap - Open browser, pointing to web console http://192.168.7.12:60856
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement