Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.web.servlet.ServletRegistrationBean]: Factory method ‘h2Console’ threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dataSource’ defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker’: Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #2 of URL [file:/G:/zou/%e8%af%be%e7%a8%8b%e8%b5%84%e6%96%99/spring-security-master/spring-security/chap08/uaa/target/classes/schema.sql]: CREATE TABLE mooc_permissions ( id BIGINT NOT NULL AUTO_INCREMENT, permission_name VARCHAR(50) NOT NULL, display_name VARCHAR(50) NOT NULL, PRIMARY KEY (id), CONSTRAINT uk_mooc_permissions_permission_name UNIQUE (permission_name) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement “CREATE TABLE MOOC_PERMISSIONS ( ID BIGINT NOT NULL AUTO_INCREMENT, PERMISSION_NAME VARCHAR(50) NOT NULL, DISPLAY_NAME VARCHAR(50) NOT NULL, PRIMARY KEY (ID), CONSTRAINT UK_MOOC_PERMISSIONS_PERMISSION_NAME UNIQUE (PERMISSION_NAME) ) ENGINE =[*] INNODB DEFAULT CHARSET = UTF8MB4”; expected “identifier”; SQL statement:
CREATE TABLE mooc_permissions ( id BIGINT NOT NULL AUTO_INCREMENT, permission_name VARCHAR(50) NOT NULL, display_name VARCHAR(50) NOT NULL, PRIMARY KEY (id), CONSTRAINT uk_mooc_permissions_permission_name UNIQUE (permission_name) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 [42001-200]
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:650) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
… 59 common frames omitted