Каркас Spring boot или mvc + security + работа с бд

Failed to load the widgetset: ./../VAADIN/widgetsets/AppWidgetset/AppWidgetset.nocache.js?1554576692244

Откройте файл gwt.xml и убедитесь, что он выбран в проводнике проекта в eclipse
Убедитесь, что установлен ваш Vaadin в плагине eclipse.
Найдите кнопку Compile Widgetset на панели инструментов Eclipse, которая входит в состав плагина vaadin и выглядит как механизм. Нажмите
Шаг 3 скомпилирует набор виджета для вас
Перезагрузите сервер и запустите приложение

        <dependency>
            <groupId>com.vaadin</groupId>
            <artifactId>vaadin-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>

<dependencyManagement>
    <dependencies>
        <dependency>
            <groupId>com.vaadin</groupId>
            <artifactId>vaadin-bom</artifactId>
            <version>10.0.11</version>
            <type>pom</type>
            <scope>import</scope>
        </dependency>
    </dependencies>
</dependencyManagement>

import com.vaadin.data.

Currently used inmemory hsqldb. 
To use different database add application.yml file and configure the properties:
spring:
 
    datasource:
        name: <name>
        url: <db url>
        username: <db user>
        password: <db pass>
        driver-class: <driver>

spring:
  datasource:
    name: ticketssystem
    url: jdbc:mysql://localhost:3306
    username: root
    password: ""
    driver-class: com.mysql.cj.jdbc.Driver

java.sql.SQLException: The server time zone value 'RTZ 2 (çèìà)' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

spring:
  datasource:
    name: mysql
    url: jdbc:mysql://localhost:3306/ticketssystem?useLegacyDatetimeCode=false;serverTimezone=UTC
    username: root
    password: ""
    driver-class: com.mysql.cj.jdbc.Driver

java.sql.SQLException: The server time zone value 'RTZ 2 (çèìà)' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

    url: jdbc:mysql://localhost:3306/ticketssystem?verifyServerCertificate=false&useSSL=false&requireSSL=false&useLegacyDatetimeCode=false&serverTimezone=UTC

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration.setFilterChainProxySecurityConfigurer(org.springframework.security.config.annotation.ObjectPostProcessor,java.util.List) throws java.lang.Exception; nested exception is org.springframework.beans.factory.BeanExpressionException: Expression parsing failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityConfig': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.it.service.UserService com.it.server.SecurityConfig.userService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userService': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.it.repository.UserRepository com.it.service.UserService.userRepository; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRepository': Cannot create inner bean '(inner bean)#4ff9f673' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#4ff9f673': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: 
Migration V1_000__sample.sql failed
-----------------------------------
SQL State  : 42000
Error Code : 1064
Message    : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY DEFAULT AS IDENTITY,
    val1 varchar(255) not null,
    val2 varchar(255) not null' at line 2
Location   : db/migration/V1_000__sample.sql (C:\Projects\Eclipse\ticket-ex\target\classes\db\migration\V1_000__sample.sql)
Line       : 1
Statement  : CREATE TABLE TEST_TABLE (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY,
    val1 varchar(255) not null,
    val2 varchar(255) not null
)

Table: schema_version
Columns:
version_rank int(11) 
installed_rank int(11) 
version varchar(50) PK 
description varchar(200) 
type varchar(20) 
script varchar(1000) 
checksum int(11) 
installed_by varchar(100) 
installed_on timestamp 
execution_time int(11) 
success tinyint(1)

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration.setFilterChainProxySecurityConfigurer(org.springframework.security.config.annotation.ObjectPostProcessor,java.util.List) throws java.lang.Exception; nested exception is org.springframework.beans.factory.BeanExpressionException: Expression parsing failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityConfig': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.it.service.UserService com.it.server.SecurityConfig.userService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userService': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.it.repository.UserRepository com.it.service.UserService.userRepository; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRepository': Cannot create inner bean '(inner bean)#371b5cce' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#371b5cce': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.api.FlywayException: Validate failed. Migration Checksum mismatch for migration 1.000

Could not autowire. No beans of 'UserService' type found.
Inspection info:Checks autowiring problems in a bean class.