Advertisement
Guest User

Untitled

a guest
Sep 6th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.15 KB | None | 0 0
  1. 18:11:36.051 [main] INFO  com.loyaltyplant.mock.bootstrap.H2Bootstrap - Started H2 web server http://192.168.7.12:60856
  2. 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'
  3. 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=
  4. 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%
  5. 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'
  6. 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=
  7. 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 (
  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"
  25. Syntax 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:
  43. CREATE 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]
  61. 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