！！！求大牛解答有关hybris suite 连接mysql的问题 下面初始化hybris代码

Question

[java] INFO [main] [Initialization] Initialize system ...
[java] Thread Thread[main,5,main] -> done destroy
[java] INFO [main] [Initialization] ###############################################################
[java] INFO [main] [Initialization] Please wait. This step can take some minutes to complete.
[java] INFO [main] [Initialization] If you do not receive any feedback on this page in this time, consult the applicationserver logs for possible errors.
[java] INFO [main] [Initialization] Dropping old and creating new empty system ...
[java] INFO [main] [Initialization] ### Starting type system initialization
[java] INFO [main] [Initialization] >>> Creating schema and type system...
[java] INFO [main] [HybrisSchemaGenerator] Reading type system Information.
[java] INFO [main] [HybrisSchemaGenerator] Read type system Information. Time taken 1.024 s
[java] INFO [main] [HybrisSchemaGenerator] Preparing Db model.
[java] INFO [main] [DatabaseModelGenerator] Prepared Database Model with (670) tables.
[java] INFO [main] [HybrisSchemaGenerator] Prepared Db model. Time taken 1.881 s
[java] INFO [main] [HybrisSchemaGenerator] Preparing Statements
[java] INFO [main] [HybrisSchemaGenerator] Prepared Statements. Time taken 2.282 s
[java] INFO [main] [DefaultDbScriptsExecutor] ###### Executing DDL Drop Statements in batch mode ##########
[java] INFO [main] [DefaultDbScriptsExecutor] Executed 404 Statements. Time taken: 541.7 ms
[java] INFO [main] [DefaultDbScriptsExecutor] ###### Executing DDL Statements in batch mode ###############
[java] ERROR [main] [DefaultDbScriptsExecutor] problem executing sql [reason: StatementCallback; bad SQL grammar [ CREATE TABLE addressprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_addressprops ON addressprops (REALNAME); CREATE INDEX nameidx_addressprops ON addressprops (NAME); CREATE INDEX itempk_addressprops ON addressprops (ITEMPK); CREATE TABLE mediaprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_mediaprops ON mediaprops (REALNAME); CREATE INDEX nameidx_mediaprops ON mediaprops (NAME); CREATE INDEX itempk_mediaprops ON mediaprops (ITEMPK); CREATE TABLE numberseries ( hjmpTS BIGINT, serieskey VARCHAR(255) NULL, seriestype INTEGER DEFAULT 0, currentValue BIGINT, template VARCHAR(255) NULL, PRIMARY KEY (serieskey) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE orderentryprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX itempk_orderentryprops ON orderentryprops (ITEMPK); CREATE INDEX realnameidx_orderentryprops ON orderentryprops (REALNAME); CREATE INDEX nameidx_orderentryprops ON orderentryprops (NAME); CREATE TABLE orderprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_orderprops ON orderprops (REALNAME); CREATE INDEX itempk_orderprops ON orderprops (ITEMPK); CREATE INDEX nameidx_orderprops ON orderprops (NAME); CREATE TABLE productprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_productprops ON productprops (REALNAME); CREATE INDEX itempk_productprops ON productprops (ITEMPK); CREATE INDEX nameidx_productprops ON productprops (NAME); CREATE TABLE props ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_props ON props (REALNAME); CREATE INDEX nameidx_props ON props (NAME); CREATE INDEX itempk_props ON props (ITEMPK)]; nested exception is java.sql.BatchUpdateException: Table 'hybris.props' doesn't exist]
[java] ERROR [main] [Initialization] problem executing sql [reason: StatementCallback; bad SQL grammar [ CREATE TABLE addressprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_addressprops ON addressprops (REALNAME); CREATE INDEX nameidx_addressprops ON addressprops (NAME); CREATE INDEX itempk_addressprops ON addressprops (ITEMPK); CREATE TABLE mediaprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_mediaprops ON mediaprops (REALNAME); CREATE INDEX nameidx_mediaprops ON mediaprops (NAME); CREATE INDEX itempk_mediaprops ON mediaprops (ITEMPK); CREATE TABLE numberseries ( hjmpTS BIGINT, serieskey VARCHAR(255) NULL, seriestype INTEGER DEFAULT 0, currentValue BIGINT, template VARCHAR(255) NULL, PRIMARY KEY (serieskey) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE orderentryprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX itempk_orderentryprops ON orderentryprops (ITEMPK); CREATE INDEX realnameidx_orderentryprops ON orderentryprops (REALNAME); CREATE INDEX nameidx_orderentryprops ON orderentryprops (NAME); CREATE TABLE orderprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_orderprops ON orderprops (REALNAME); CREATE INDEX itempk_orderprops ON orderprops (ITEMPK); CREATE INDEX nameidx_orderprops ON orderprops (NAME); CREATE TABLE productprops ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_productprops ON productprops (REALNAME); CREATE INDEX itempk_productprops ON productprops (ITEMPK); CREATE INDEX nameidx_productprops ON productprops (NAME); CREATE TABLE props ( hjmpTS BIGINT, ITEMPK BIGINT, ITEMTYPEPK BIGINT, NAME VARCHAR(255) NULL, LANGPK BIGINT, REALNAME VARCHAR(255) NULL, TYPE1 INTEGER DEFAULT 0, VALUESTRING1 TEXT, VALUE1 LONGBLOB NULL, PRIMARY KEY (ITEMPK, NAME, LANGPK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin; CREATE INDEX realnameidx_props ON props (REALNAME); CREATE INDEX nameidx_props ON props (NAME); CREATE INDEX itempk_props ON props (ITEMPK)]; nested exception is java.sql.BatchUpdateException: Table 'hybris.props' doesn't exist]

Answer 1

http://blog.csdn.net/berryreload/article/details/40618219