当前位置: 代码网 > it编程>编程语言>Java > 解决springboot连接数据库异常问题(Could not obtain connection metadata)

解决springboot连接数据库异常问题(Could not obtain connection metadata)

2025年12月11日 Java 我要评论
springboot连接数据库异常. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | 

springboot连接数据库异常

. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: spring boot :: (v2.1.1.release) 2019-01-03 01:55:05.206 info 32152 --- [ restartedmain] com.example.demo.demoapplication : starting demoapplication on 01-pc with pid 32152 (c:\users\01\ideaprojects\demo\target\classes started by 01 in c:\users\01\ideaprojects\demo) 2019-01-03 01:55:05.221 info 32152 --- [ restartedmain] com.example.demo.demoapplication : no active profile set, falling back to default profiles: default 2019-01-03 01:55:05.284 info 32152 --- [ restartedmain] .e.devtoolspropertydefaultspostprocessor : devtools property defaults active! set 'spring.devtools.add-properties' to 'false' to disable 2019-01-03 01:55:05.299 info 32152 --- [ restartedmain] .e.devtoolspropertydefaultspostprocessor : for additional web related logging consider setting the 'logging.level.web' property to 'debug' 2019-01-03 01:55:06.428 info 32152 --- [ restartedmain] .s.d.r.c.repositoryconfigurationdelegate : bootstrapping spring data repositories in default mode. 2019-01-03 01:55:06.459 info 32152 --- [ restartedmain] .s.d.r.c.repositoryconfigurationdelegate : finished spring data repository scanning in 0ms. found 0 repository interfaces. 2019-01-03 01:55:06.898 info 32152 --- [ restartedmain] trationdelegate$beanpostprocessorchecker : bean 'org.springframework.transaction.annotation.proxytransactionmanagementconfiguration' of type [org.springframework.transaction.annotation.proxytransactionmanagementconfiguration$$enhancerbyspringcglib$$6345fb53] is not eligible for getting processed by all beanpostprocessors (for example: not eligible for auto-proxying) 2019-01-03 01:55:06.929 info 32152 --- [ restartedmain] trationdelegate$beanpostprocessorchecker : bean 'org.springframework.hateoas.config.hateoasconfiguration' of type [org.springframework.hateoas.config.hateoasconfiguration$$enhancerbyspringcglib$$e2c64885] is not eligible for getting processed by all beanpostprocessors (for example: not eligible for auto-proxying) 2019-01-03 01:55:07.527 info 32152 --- [ restartedmain] o.s.b.w.embedded.tomcat.tomcatwebserver : tomcat initialized with port(s): 8080 (http) 2019-01-03 01:55:07.558 info 32152 --- [ restartedmain] o.apache.catalina.core.standardservice : starting service [tomcat] 2019-01-03 01:55:07.558 info 32152 --- [ restartedmain] org.apache.catalina.core.standardengine : starting servlet engine: apache tomcat/9.0.13 2019-01-03 01:55:07.574 info 32152 --- [ restartedmain] o.a.catalina.core.aprlifecyclelistener : the apr based apache tomcat native library which allows optimal performance in production environments was not found on the java.library.path: [c:\download\java\jdk1.8.0_111\bin;c:\windows\sun\java\bin;c:\windows\system32;c:\windows;d:\xfj\other\sqlite-tools-win32-x86-3240000;c:\download\java\jdk1.8.0_111\bin;c:\download\java\jdk1.8.0_111\jre\bin;c:\app\01\product\11.2.0\client_1\bin;c:\app\01\product\11.2.0\dbhome_1\bin;c:\program files (x86)\intel\icls client\;c:\program files\intel\icls client\;c:\windows\system32;c:\windows;c:\windows\system32\wbem;c:\windows\system32\windowspowershell\v1.0\;c:\program files\intel\intel(r) management engine components\dal;c:\program files (x86)\intel\intel(r) management engine components\dal;c:\program files\intel\intel(r) management engine components\ipt;c:\program files (x86)\intel\intel(r) management engine components\ipt;c:\program files (x86)\nvidia corporation\physx\common;c:\program files\lenovo\fingerprint manager pro\;c:\program files (x86)\common files\lenovo;c:\programdata\lenovo\readyapps;c:\program files (x86)\microsoft sql server\100\tools\binn\;c:\program files\microsoft sql server\100\tools\binn\;c:\program files\microsoft sql server\100\dts\binn\;c:\program files (x86)\microsoft sql server\100\tools\binn\vsshell\common7\ide\;c:\program files (x86)\microsoft visual studio 9.0\common7\ide\privateassemblies\;c:\program files (x86)\microsoft sql server\100\dts\binn\;c:\program files (x86)\inno setup 5;c:\program files\git\cmd;c:\download\java\apache\apache-maven-3.3.9\bin;c:\program files\tortoisesvn\bin;c:\download\java\instantclient_11_2;c:\program files (x86)\microsoft visual studio6\vc98\bin;c:\program files (x86)\microsoft visual studio6\vc98\include;c:\program files (x86)\microsoft visual studio6\vc98\lib;c:\programdata\chocolatey\bin;c:\program files\microsoft\web platform installer\;c:\program files (x86)\microsoft asp.net\asp.net web pages\v1.0\;c:\program files (x86)\windows kits\8.0\windows performance toolkit\;c:\program files\microsoft sql server\110\tools\binn\;c:\program files\intel\wifi\bin\;c:\program files\common files\intel\wirelesscommon\;c:\program files\nodejs\;c:\program files (x86)\ssh communications security\ssh secure shell;c:\users\01\appdata\local\programs\fiddler;c:\program files\intel\wifi\bin\;c:\program files\common files\intel\wirelesscommon\;c:\users\01\appdata\roaming\npm;.] 2019-01-03 01:55:07.730 info 32152 --- [ restartedmain] o.a.c.c.c.[tomcat].[localhost].[/] : initializing spring embedded webapplicationcontext 2019-01-03 01:55:07.730 info 32152 --- [ restartedmain] o.s.web.context.contextloader : root webapplicationcontext: initialization completed in 2431 ms 2019-01-03 01:55:08.013 info 32152 --- [ restartedmain] com.zaxxer.hikari.hikaridatasource : datebookhikaricp - starting... 2019-01-03 01:55:09.503 error 32152 --- [ restartedmain] com.zaxxer.hikari.pool.hikaripool : datebookhikaricp - exception during pool initialization. com.microsoft.sqlserver.jdbc.sqlserverexception: login failed for user ''. clientconnectionid:44f1557c-09a9-4175-b304-9f8f298b89de at com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdatabaseerror(sqlserverexception.java:216) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdstokenhandler.oneof(tdsparser.java:254) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdsparser.parse(tdsparser.java:84) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.sendlogon(sqlserverconnection.java:2908) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.logon(sqlserverconnection.java:2234) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.access$000(sqlserverconnection.java:41) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection$logoncommand.doexecute(sqlserverconnection.java:2220) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdscommand.execute(iobuffer.java:5696) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.executecommand(sqlserverconnection.java:1715) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.connecthelper(sqlserverconnection.java:1326) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.login(sqlserverconnection.java:991) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.connect(sqlserverconnection.java:827) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverdriver.connect(sqlserverdriver.java:1012) ~[sqljdbc4-1.0.jar:na] at com.zaxxer.hikari.util.driverdatasource.getconnection(driverdatasource.java:119) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.poolbase.newconnection(poolbase.java:369) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.poolbase.newpoolentry(poolbase.java:198) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.createpoolentry(hikaripool.java:467) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.checkfailfast(hikaripool.java:541) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.<init>(hikaripool.java:115) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.hikaridatasource.getconnection(hikaridatasource.java:112) [hikaricp-3.2.0.jar:na] at org.springframework.jdbc.datasource.datasourceutils.fetchconnection(datasourceutils.java:151) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.jdbc.datasource.datasourceutils.dogetconnection(datasourceutils.java:115) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.jdbc.datasource.datasourceutils.getconnection(datasourceutils.java:78) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.jdbc.core.jdbctemplate.execute(jdbctemplate.java:324) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.boot.jdbc.embeddeddatabaseconnection.isembedded(embeddeddatabaseconnection.java:123) [spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatedefaultddlautoprovider.getdefaultddlauto(hibernatedefaultddlautoprovider.java:42) [spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatejpaconfiguration.lambda$getvendorproperties$1(hibernatejpaconfiguration.java:142) [spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatesettings.getddlauto(hibernatesettings.java:41) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernateproperties.determineddlauto(hibernateproperties.java:130) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernateproperties.getadditionalproperties(hibernateproperties.java:99) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernateproperties.determinehibernateproperties(hibernateproperties.java:91) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatejpaconfiguration.getvendorproperties(hibernatejpaconfiguration.java:143) [spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.jpabaseconfiguration.entitymanagerfactory(jpabaseconfiguration.java:138) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatejpaconfiguration$$enhancerbyspringcglib$$821cbdc2.cglib$entitymanagerfactory$4(<generated>) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatejpaconfiguration$$enhancerbyspringcglib$$821cbdc2$$fastclassbyspringcglib$$e5d7166c.invoke(<generated>) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.cglib.proxy.methodproxy.invokesuper(methodproxy.java:244) ~[spring-core-5.1.3.release.jar:5.1.3.release] at org.springframework.context.annotation.configurationclassenhancer$beanmethodinterceptor.intercept(configurationclassenhancer.java:363) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatejpaconfiguration$$enhancerbyspringcglib$$821cbdc2.entitymanagerfactory(<generated>) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.8.0_111] at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) ~[na:1.8.0_111] at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) ~[na:1.8.0_111] at java.lang.reflect.method.invoke(method.java:498) ~[na:1.8.0_111] at org.springframework.beans.factory.support.simpleinstantiationstrategy.instantiate(simpleinstantiationstrategy.java:154) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.constructorresolver.instantiate(constructorresolver.java:622) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.constructorresolver.instantiateusingfactorymethod(constructorresolver.java:607) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.instantiateusingfactorymethod(abstractautowirecapablebeanfactory.java:1288) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbeaninstance(abstractautowirecapablebeanfactory.java:1127) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:538) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:498) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.lambda$dogetbean$0(abstractbeanfactory.java:320) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:222) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:318) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:199) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.getbean(abstractapplicationcontext.java:1083) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.finishbeanfactoryinitialization(abstractapplicationcontext.java:853) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:546) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.boot.web.servlet.context.servletwebserverapplicationcontext.refresh(servletwebserverapplicationcontext.java:142) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.refresh(springapplication.java:775) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.refreshcontext(springapplication.java:397) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:316) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:1260) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:1248) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at com.example.demo.demoapplication.main(demoapplication.java:10) ~[classes/:na] at sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.8.0_111] at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) ~[na:1.8.0_111] at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) ~[na:1.8.0_111] at java.lang.reflect.method.invoke(method.java:498) ~[na:1.8.0_111] at org.springframework.boot.devtools.restart.restartlauncher.run(restartlauncher.java:49) ~[spring-boot-devtools-2.1.1.release.jar:2.1.1.release] 2019-01-03 01:55:09.550 info 32152 --- [ restartedmain] o.hibernate.jpa.internal.util.loghelper : hhh000204: processing persistenceunitinfo [ name: default ...] 2019-01-03 01:55:09.596 info 32152 --- [ restartedmain] org.hibernate.version : hhh000412: hibernate core {5.3.7.final} 2019-01-03 01:55:09.612 info 32152 --- [ restartedmain] org.hibernate.cfg.environment : hhh000206: hibernate.properties not found 2019-01-03 01:55:09.752 info 32152 --- [ restartedmain] o.hibernate.annotations.common.version : hcann000001: hibernate commons annotations {5.0.4.final} 2019-01-03 01:55:09.879 info 32152 --- [ restartedmain] com.zaxxer.hikari.hikaridatasource : datebookhikaricp - starting... 2019-01-03 01:55:10.911 error 32152 --- [ restartedmain] com.zaxxer.hikari.pool.hikaripool : datebookhikaricp - exception during pool initialization. com.microsoft.sqlserver.jdbc.sqlserverexception: login failed for user ''. clientconnectionid:7c692f97-05cc-4c9b-9a53-23ae5124a322 at com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdatabaseerror(sqlserverexception.java:216) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdstokenhandler.oneof(tdsparser.java:254) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdsparser.parse(tdsparser.java:84) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.sendlogon(sqlserverconnection.java:2908) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.logon(sqlserverconnection.java:2234) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.access$000(sqlserverconnection.java:41) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection$logoncommand.doexecute(sqlserverconnection.java:2220) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdscommand.execute(iobuffer.java:5696) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.executecommand(sqlserverconnection.java:1715) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.connecthelper(sqlserverconnection.java:1326) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.login(sqlserverconnection.java:991) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.connect(sqlserverconnection.java:827) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverdriver.connect(sqlserverdriver.java:1012) ~[sqljdbc4-1.0.jar:na] at com.zaxxer.hikari.util.driverdatasource.getconnection(driverdatasource.java:119) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.poolbase.newconnection(poolbase.java:369) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.poolbase.newpoolentry(poolbase.java:198) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.createpoolentry(hikaripool.java:467) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.checkfailfast(hikaripool.java:541) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.<init>(hikaripool.java:115) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.hikaridatasource.getconnection(hikaridatasource.java:112) [hikaricp-3.2.0.jar:na] at org.hibernate.engine.jdbc.connections.internal.datasourceconnectionproviderimpl.getconnection(datasourceconnectionproviderimpl.java:122) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator$connectionproviderjdbcconnectionaccess.obtainconnection(jdbcenvironmentinitiator.java:180) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator.initiateservice(jdbcenvironmentinitiator.java:68) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator.initiateservice(jdbcenvironmentinitiator.java:35) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.boot.registry.internal.standardserviceregistryimpl.initiateservice(standardserviceregistryimpl.java:94) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.service.internal.abstractserviceregistryimpl.createservice(abstractserviceregistryimpl.java:263) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:237) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:214) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.id.factory.internal.defaultidentifiergeneratorfactory.injectservices(defaultidentifiergeneratorfactory.java:152) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.service.internal.abstractserviceregistryimpl.injectdependencies(abstractserviceregistryimpl.java:286) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:243) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:214) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.boot.internal.inflightmetadatacollectorimpl.<init>(inflightmetadatacollectorimpl.java:179) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.boot.model.process.spi.metadatabuildingprocess.complete(metadatabuildingprocess.java:119) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.metadata(entitymanagerfactorybuilderimpl.java:904) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.build(entitymanagerfactorybuilderimpl.java:935) [hibernate-core-5.3.7.final.jar:5.3.7.final] at org.springframework.orm.jpa.vendor.springhibernatejpapersistenceprovider.createcontainerentitymanagerfactory(springhibernatejpapersistenceprovider.java:57) [spring-orm-5.1.3.release.jar:5.1.3.release] at org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.createnativeentitymanagerfactory(localcontainerentitymanagerfactorybean.java:365) [spring-orm-5.1.3.release.jar:5.1.3.release] at org.springframework.orm.jpa.abstractentitymanagerfactorybean.buildnativeentitymanagerfactory(abstractentitymanagerfactorybean.java:390) [spring-orm-5.1.3.release.jar:5.1.3.release] at org.springframework.orm.jpa.abstractentitymanagerfactorybean.afterpropertiesset(abstractentitymanagerfactorybean.java:377) [spring-orm-5.1.3.release.jar:5.1.3.release] at org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.afterpropertiesset(localcontainerentitymanagerfactorybean.java:341) [spring-orm-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods(abstractautowirecapablebeanfactory.java:1804) [spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1741) [spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:576) [spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:498) [spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.lambda$dogetbean$0(abstractbeanfactory.java:320) [spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:222) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:318) [spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:199) [spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.getbean(abstractapplicationcontext.java:1083) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.finishbeanfactoryinitialization(abstractapplicationcontext.java:853) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:546) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.boot.web.servlet.context.servletwebserverapplicationcontext.refresh(servletwebserverapplicationcontext.java:142) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.refresh(springapplication.java:775) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.refreshcontext(springapplication.java:397) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:316) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:1260) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:1248) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at com.example.demo.demoapplication.main(demoapplication.java:10) ~[classes/:na] at sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.8.0_111] at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) ~[na:1.8.0_111] at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) ~[na:1.8.0_111] at java.lang.reflect.method.invoke(method.java:498) ~[na:1.8.0_111] at org.springframework.boot.devtools.restart.restartlauncher.run(restartlauncher.java:49) ~[spring-boot-devtools-2.1.1.release.jar:2.1.1.release] 2019-01-03 01:55:10.911 warn 32152 --- [ restartedmain] o.h.e.j.e.i.jdbcenvironmentinitiator : hhh000342: could not obtain connection to query metadata : login failed for user ''. clientconnectionid:7c692f97-05cc-4c9b-9a53-23ae5124a322 2019-01-03 01:55:10.911 info 32152 --- [ restartedmain] org.hibernate.dialect.dialect : hhh000400: using dialect: org.hibernate.dialect.sqlserver2012dialect 2019-01-03 01:55:10.942 info 32152 --- [ restartedmain] o.h.e.j.e.i.lobcreatorbuilderimpl : hhh000422: disabling contextual lob creation as connection was null 2019-01-03 01:55:11.067 info 32152 --- [ restartedmain] j.localcontainerentitymanagerfactorybean : initialized jpa entitymanagerfactory for persistence unit 'default' 2019-01-03 01:55:11.067 info 32152 --- [ restartedmain] com.zaxxer.hikari.hikaridatasource : datebookhikaricp - starting... 2019-01-03 01:55:12.099 error 32152 --- [ restartedmain] com.zaxxer.hikari.pool.hikaripool : datebookhikaricp - exception during pool initialization. com.microsoft.sqlserver.jdbc.sqlserverexception: login failed for user ''. clientconnectionid:9c54fed4-c58d-4315-8079-dee28fc85543 at com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdatabaseerror(sqlserverexception.java:216) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdstokenhandler.oneof(tdsparser.java:254) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdsparser.parse(tdsparser.java:84) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.sendlogon(sqlserverconnection.java:2908) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.logon(sqlserverconnection.java:2234) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.access$000(sqlserverconnection.java:41) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection$logoncommand.doexecute(sqlserverconnection.java:2220) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.tdscommand.execute(iobuffer.java:5696) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.executecommand(sqlserverconnection.java:1715) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.connecthelper(sqlserverconnection.java:1326) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.login(sqlserverconnection.java:991) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverconnection.connect(sqlserverconnection.java:827) ~[sqljdbc4-1.0.jar:na] at com.microsoft.sqlserver.jdbc.sqlserverdriver.connect(sqlserverdriver.java:1012) ~[sqljdbc4-1.0.jar:na] at com.zaxxer.hikari.util.driverdatasource.getconnection(driverdatasource.java:119) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.poolbase.newconnection(poolbase.java:369) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.poolbase.newpoolentry(poolbase.java:198) ~[hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.createpoolentry(hikaripool.java:467) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.checkfailfast(hikaripool.java:541) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.pool.hikaripool.<init>(hikaripool.java:115) [hikaricp-3.2.0.jar:na] at com.zaxxer.hikari.hikaridatasource.getconnection(hikaridatasource.java:112) [hikaricp-3.2.0.jar:na] at org.springframework.jdbc.datasource.datasourceutils.fetchconnection(datasourceutils.java:151) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.jdbc.datasource.datasourceutils.dogetconnection(datasourceutils.java:115) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.jdbc.datasource.datasourceutils.getconnection(datasourceutils.java:78) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.jdbc.core.jdbctemplate.execute(jdbctemplate.java:324) [spring-jdbc-5.1.3.release.jar:5.1.3.release] at org.springframework.boot.jdbc.embeddeddatabaseconnection.isembedded(embeddeddatabaseconnection.java:123) [spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.datasourceinitializedpublisher.lambda$isinitializingdatabase$0(datasourceinitializedpublisher.java:114) [spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernatesettings.getddlauto(hibernatesettings.java:41) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernateproperties.determineddlauto(hibernateproperties.java:130) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernateproperties.getadditionalproperties(hibernateproperties.java:99) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.hibernateproperties.determinehibernateproperties(hibernateproperties.java:91) ~[spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.datasourceinitializedpublisher.isinitializingdatabase(datasourceinitializedpublisher.java:116) [spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.datasourceinitializedpublisher.publisheventifrequired(datasourceinitializedpublisher.java:96) [spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.autoconfigure.orm.jpa.datasourceinitializedpublisher.postprocessafterinitialization(datasourceinitializedpublisher.java:88) [spring-boot-autoconfigure-2.1.1.release.jar:2.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.applybeanpostprocessorsafterinitialization(abstractautowirecapablebeanfactory.java:434) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1749) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:576) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:498) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.lambda$dogetbean$0(abstractbeanfactory.java:320) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:222) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:318) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:199) ~[spring-beans-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.getbean(abstractapplicationcontext.java:1083) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.finishbeanfactoryinitialization(abstractapplicationcontext.java:853) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:546) ~[spring-context-5.1.3.release.jar:5.1.3.release] at org.springframework.boot.web.servlet.context.servletwebserverapplicationcontext.refresh(servletwebserverapplicationcontext.java:142) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.refresh(springapplication.java:775) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.refreshcontext(springapplication.java:397) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:316) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:1260) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at org.springframework.boot.springapplication.run(springapplication.java:1248) ~[spring-boot-2.1.1.release.jar:2.1.1.release] at com.example.demo.demoapplication.main(demoapplication.java:10) ~[classes/:na] at sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.8.0_111] at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) ~[na:1.8.0_111] at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) ~[na:1.8.0_111] at java.lang.reflect.method.invoke(method.java:498) ~[na:1.8.0_111] at org.springframework.boot.devtools.restart.restartlauncher.run(restartlauncher.java:49) ~[spring-boot-devtools-2.1.1.release.jar:2.1.1.release] 2019-01-03 01:55:12.835 info 32152 --- [ restartedmain] o.s.s.concurrent.threadpooltaskexecutor : initializing executorservice 'applicationtaskexecutor' 2019-01-03 01:55:12.897 warn 32152 --- [ restartedmain] awebconfiguration$jpawebmvcconfiguration : spring.jpa.open-in-view is enabled by default. therefore, database queries may be performed during view rendering. explicitly configure spring.jpa.open-in-view to disable this warning 2019-01-03 01:55:13.381 warn 32152 --- [ restartedmain] o.s.b.d.a.optionallivereloadserver : unable to start livereload server 2019-01-03 01:55:13.459 info 32152 --- [ restartedmain] o.s.b.w.embedded.tomcat.tomcatwebserver : tomcat started on port(s): 8080 (http) with context path '' 2019-01-03 01:55:13.459 info 32152 --- [ restartedmain] com.example.demo.demoapplication : started demoapplication in 9.036 seconds (jvm running for 10.219)

最后发现application.yml配置写错了

spring:
  datasource:
    driver-class-name: com.microsoft.sqlserver.jdbc.sqlserverdriver
    url: jdbc:sqlserver://127.0.0.1:1433;databasename=card
    data-username: sa
    data-password: sa
    type: com.zaxxer.hikari.hikaridatasource
    hikari:
      minimum-idle: 5
      maximum-pool-size: 15
      auto-commit: true
      idle-timeout: 30000
      pool-name: datebookhikaricp
      max-lifetime: 1800000
      connection-timeout: 30000
      connection-test-query: select 1
  jpa:
    database: sql_server
    show-sql: true

正确如下

spring:
  datasource:
    driver-class-name: com.microsoft.sqlserver.jdbc.sqlserverdriver
    url: jdbc:sqlserver://127.0.0.1:1433;databasename=card
    username: sa
    password: sa
    type: com.zaxxer.hikari.hikaridatasource
    hikari:
      minimum-idle: 5
      maximum-pool-size: 15
      auto-commit: true
      idle-timeout: 30000
      pool-name: datebookhikaricp
      max-lifetime: 1800000
      connection-timeout: 30000
      connection-test-query: select 1
  jpa:
    database: sql_server
    show-sql: true

总结

以上为个人经验,希望能给大家一个参考,也希望大家多多支持代码网。

(0)

相关文章:

版权声明:本文内容由互联网用户贡献,该文观点仅代表作者本人。本站仅提供信息存储服务,不拥有所有权,不承担相关法律责任。 如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 2386932994@qq.com 举报,一经查实将立刻删除。

发表评论

验证码:
Copyright © 2017-2026  代码网 保留所有权利. 粤ICP备2024248653号
站长QQ:2386932994 | 联系邮箱:2386932994@qq.com