                        課程
                    
                        /后端開發
                        
                            /Java
                        
                        /2小時學會Spring Boot

連接數據庫啟動報錯報錯

Sat Feb 11 20:48:24 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

2017-02-11 20:48:24.186 ERROR 400 --- [ ? ? ? ? ? main] o.a.tomcat.jdbc.pool.ConnectionPool ? ? ?: Unable to create initial connections of pool.

java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

程序員GG

2017-02-11

源自：2小時學會Spring Boot 5-1

關注問題我要回答

3543

操作

收起

6 回答

慕粉1465633663
2018-02-27

? 請問解決了沒有 ,我也是這個問題

0 回復有任何疑惑可以回復我~

收起回答

qq_慕萊塢8430671
2017-06-17

怎么解決的

？？？？？

0 回復有任何疑惑可以回復我~

收起回答

Hi天涯海角
2017-05-27

有解決的了嗎？

0 回復有任何疑惑可以回復我~

收起回答

風雨詩軒
2017-03-28

你沒有設置數據庫方言，在application.properties添加這一句

spring.jpa.database=oracle

0 回復有任何疑惑可以回復我~

收起回答

蝸牛的殼
2017-03-11

嗨呀，好氣啊，也是出現

?Error?creating?bean?with?name?'entityManagerFactory'?defined?in?class?path?resource?[org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]

這樣的錯誤，找了一個晚上，都沒有找到解決辦法。

0 回復有任何疑惑可以回復我~

收起回答

程序員GG 提問者
2017-02-11

把url: jdbc:mysql://localhost:3306/dbgril?useSSL=false變成這樣就不報上面錯誤，好像是數據庫版本高的原因。

但是依舊連接不了：

2017-02-11?21:10:34.749?ERROR?10760?---?[???????????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:1628)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1081)?~[spring-context-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:856)?~[spring-context-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)?~[spring-context-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122)?~[spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
	at?org.springframework.boot.SpringApplication.refresh(SpringApplication.java:737)?[spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
	at?org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:370)?[spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
	at?org.springframework.boot.SpringApplication.run(SpringApplication.java:314)?[spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
	at?org.springframework.boot.SpringApplication.run(SpringApplication.java:1162)?[spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
	at?org.springframework.boot.SpringApplication.run(SpringApplication.java:1151)?[spring-boot-1.5.1.RELEASE.jar:1.5.1.RELEASE]
	at?com.imooc.GirlApplication.main(GirlApplication.java:10)?[classes/:na]
	at?sun.reflect.NativeMethodAccessorImpl.invoke0(Native?Method)?~[na:1.8.0_31]
	at?sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)?~[na:1.8.0_31]
	at?sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)?~[na:1.8.0_31]
	at?java.lang.reflect.Method.invoke(Method.java:483)?~[na:1.8.0_31]
	at?com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)?[idea_rt.jar:na]
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.Final]
	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.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:353)?~[spring-orm-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:373)?~[spring-orm-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:362)?~[spring-orm-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	at?org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)?~[spring-beans-4.3.6.RELEASE.jar:4.3.6.RELEASE]
	...?21?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]
	...?37?common?frames?omitted

0 回復有任何疑惑可以回復我~

收起回答

time_to_go

我也是報的這個錯，請問你解決了沒

2017-02-24 回復有任何疑惑可以回復我~