我不能在窗户上运行弹簧启动罐

Question

我开始做喷射机，我用的是窗户。基本上，我可以使用maven生成一个Jar文件，但是当我尝试运行我的Jar文件时，它不能很好地工作。听起来好像找不到hibernate属性。

我的错误：

2017-01-15 16:03:12.454  INFO 19012 --- [main] org.hibernate.Version                    : 
    HHH000412: Hibernate Core    {5.0.11.Final} 
2017-01-15 16:03:12.473  INFO 19012 --- [main] org.hibernate.cfg.Environment            : 
    HHH000206: hibernate.properties not found 
2017-01-15 16:03:12.480  INFO 19012 --- [main] org.hibernate.cfg.Environment            : 
    HHH000021: Bytecode provider name : javassist 
2017-01-15 16:03:13.122  INFO 19012 --- [main] o.hibernate.annotations.common.Version   : 
    HCANN000001: Hibernate Commons Annotations {5.0.1.Final} 
2017-01-15 16:03:16.112  WARN 19012 --- [main] o.h.e.j.e.i.JdbcEnvironmentInitiator     : 
    HHH000342: Could not obtain connection to query metadata : Access denied for user root 'root'@'localhost' (using password: YES) 
2017-01-15 16:03:16.135  WARN 19012 --- [main] ationConfigEmbeddedWebApplicationContext : 
    Exception encountered during context initialization - cancelling refresh attempt: 
        org.springframework.beans.factory.BeanCreationException: 
            Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: 
                Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: 
                    Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] 
2017-01-15 16:03:16.149  INFO 19012 --- [main] o.apache.catalina.core.StandardService   : 
    Stopping service Tomcat    
2017-01-15 16:03:16.234  WARN 19012 --- [main] o.s.boot.SpringApplication               : 
    Error handling failed (Error creating bean with name 'delegatingApplicationListener' defined in class path resource [org/springframework/security/config/annotation/web/configuration/WebSecurityConfiguration.class]:    
        BeanPostProcessor before instantiation of bean  failed; nested exception is org.springframework.beans.factory.BeanCreationException: 
            Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': 
                Initialization of bean failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: 
                    No bean named 'org.springframework.context.annotation.ConfigurationClassPostProcessor.importRegistry' is defined)
2017-01-15 16:03:16.275 ERROR 19012 --- [main] o.s.boot.SpringApplication               : 
    Application startup failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: 
        Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: 
            Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1583) ~[spring-beans-4.3.3.RELEASE.jar !/:4.3.3.RELEASE]
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) ~[spring-beans-4.3.3.RELEASE.jar!/:    4.3.3.RELEASE]
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1076) ~[spring-context-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:851) ~[spring-context-4.3.3.RELEASE.jar!/:4 .3.3.RELEASE]
                at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541) ~[spring-context-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
                at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:761) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
                at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:371) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
                at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
                at org.springframework.boot.SpringApplication.run(SpringApplication.java:1186) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
                at org.springframework.boot.SpringApplication.run(SpringApplication.java:1175) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
                at com.SimonSaysApplication.main(SimonSaysApplication.java:32) [classes!/:0.0.1-SNAPSHOT]
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_77]
                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_77]
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_77]
                at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_77]
                at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [simonsays-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
                at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [simonsays-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
                at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [simonsays-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
                at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:58) [simonsays-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT] 
            Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
                at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:264) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:228) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:847) ~[hibernate-entitymanager-5.0.11.Final.jar!/:5.0.11.Fin al]
                at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:874) ~[hibernate-entitymanager-5.0.11.Final.jar!/:5.0.11.Final]
                at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) ~[spring-orm-4 .3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:353) ~[spring-orm-4.3.3.RE LEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:373) ~[spring-orm-4.3.3.RELEASE.jar!/:4 .3.3.RELEASE]
                at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:362) ~[spring-orm-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1642) ~[spring-beans-4.3.3.RELEASE. jar!/:4.3.3.RELEASE]
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1579) ~[spring-beans-4.3.3.RELEASE.jar !/:4.3.3.RELEASE]            
                ... 24 common frames omitted 
            Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
                at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:100) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:54) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:137) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
                at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:254) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]            
                ... 40 common frames omitted

我的hibernate配置位于\src\main\resources\application.properties上。

db.driver = com.mysql.jdbc.Driver
db.url = jdbc:mysql://localhost:3306/simonsays?characterEncoding=UTF-8&useSSL=false
db.username = root
db.password = 1234

#Hibernate configuration
hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
hibernate.show_sql = false
hibernate.hbm2ddl.auto = update
entitymanager.packagesToScan = com

我该怎么处理呢？

更新

使用mvn spring-boot:run运行时，可能会得到不同的结果。

• 与以前的错误不同，我可以看到我的数据库，但当它打开tomcat时，我得到了一个奇怪的错误： 描述： 配置为侦听端口444的Tomcat连接器启动失败。端口可能已经在使用，或者连接器可能配置错误。 操作： 验证连接器的配置，标识并停止侦听端口444的任何进程，或将此应用程序配置为在另一个端口上侦听。

Answer 1

好吧，我想我解决了这个问题：

首先，我试图构建一个可以运行的jar，因为没有加载我的配置，所以它不能正常工作，然后我使用以下方法获得了更好的结果：

mvn spring-boot:run

但是我得到了一个tomcat错误，因为SSL，然后我必须禁用SSL并将端口更改为8080，并且它正在运行。

Answer 2

看起来您的DB正在根据错误Access denied for use r 'root'@'localhost' (using password: YES)拒绝连接。您能否尝试使用MySQL CLI或MySQL工作台登录到您的数据库，使用与application.properties中相同的凭据？

Answer 3

您的日志显示db拒绝连接：

  HHH000342: Could not obtain connection to query metadata : 
Access denied for user root 'root'@'localhost' (using password: YES) 

因此，请尝试使用您在应用程序中提供的凭据访问DB，如果它正确，请将其与127.0.0.1或本地系统的IP绑定，而不是如Alex所说的本地主机。