ddl-auto: update报错, 对象名 'sys.sequences' 无效

ddl-auto: update报错, 对象名 'sys.sequences' 无效

错误信息如下

2019-10-22 10:43:17.278 WARN 2876 — [ restartedMain] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 208, SQLState: S0002
2019-10-22 10:43:17.278 ERROR 2876 — [ restartedMain] o.h.engine.jdbc.spi.SqlExceptionHelper : 对象名 ‘sys.sequences’ 无效。
2019-10-22 10:43:17.284 WARN 2876 — [ restartedMain] ConfigServletWebServerApplicationContext : 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/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation
2019-10-22 10:43:17.286 INFO 2876 — [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated…
2019-10-22 10:43:17.288 INFO 2876 — [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
2019-10-22 10:43:17.289 INFO 2876 — [ restartedMain] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2019-10-22 10:43:17.299 INFO 2876 — [ restartedMain] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with ‘debug’ enabled.
2019-10-22 10:43:17.308 ERROR 2876 — [ restartedMain] o.s.boot.SpringApplication : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘entityManagerFactory’ defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1778) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean 0 ( A b s t r a c t B e a n F a c t o r y . j a v a : 320 )   [ s p r i n g − b e a n s − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . D e f a u l t S i n g l e t o n B e a n R e g i s t r y . g e t S i n g l e t o n ( D e f a u l t S i n g l e t o n B e a n R e g i s t r y . j a v a : 222 )   [ s p r i n g − b e a n s − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . d o G e t B e a n ( A b s t r a c t B e a n F a c t o r y . j a v a : 318 )   [ s p r i n g − b e a n s − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . g e t B e a n ( A b s t r a c t B e a n F a c t o r y . j a v a : 199 )   [ s p r i n g − b e a n s − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . s u p p o r t . A b s t r a c t A p p l i c a t i o n C o n t e x t . g e t B e a n ( A b s t r a c t A p p l i c a t i o n C o n t e x t . j a v a : 1105 )   [ s p r i n g − c o n t e x t − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . s u p p o r t . A b s t r a c t A p p l i c a t i o n C o n t e x t . f i n i s h B e a n F a c t o r y I n i t i a l i z a t i o n ( A b s t r a c t A p p l i c a t i o n C o n t e x t . j a v a : 867 )   [ s p r i n g − c o n t e x t − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . s u p p o r t . A b s t r a c t A p p l i c a t i o n C o n t e x t . r e f r e s h ( A b s t r a c t A p p l i c a t i o n C o n t e x t . j a v a : 549 )   [ s p r i n g − c o n t e x t − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b o o t . w e b . s e r v l e t . c o n t e x t . S e r v l e t W e b S e r v e r A p p l i c a t i o n C o n t e x t . r e f r e s h ( S e r v l e t W e b S e r v e r A p p l i c a t i o n C o n t e x t . j a v a : 141 )   [ s p r i n g − b o o t − 2.1.9. R E L E A S E . j a r : 2.1.9. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b o o t . S p r i n g A p p l i c a t i o n . r e f r e s h ( S p r i n g A p p l i c a t i o n . j a v a : 744 ) [ s p r i n g − b o o t − 2.1.9. R E L E A S E . j a r : 2.1.9. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b o o t . S p r i n g A p p l i c a t i o n . r e f r e s h C o n t e x t ( S p r i n g A p p l i c a t i o n . j a v a : 391 ) [ s p r i n g − b o o t − 2.1.9. R E L E A S E . j a r : 2.1.9. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b o o t . S p r i n g A p p l i c a t i o n . r u n ( S p r i n g A p p l i c a t i o n . j a v a : 312 ) [ s p r i n g − b o o t − 2.1.9. R E L E A S E . j a r : 2.1.9. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b o o t . S p r i n g A p p l i c a t i o n . r u n ( S p r i n g A p p l i c a t i o n . j a v a : 1215 ) [ s p r i n g − b o o t − 2.1.9. R E L E A S E . j a r : 2.1.9. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b o o t . S p r i n g A p p l i c a t i o n . r u n ( S p r i n g A p p l i c a t i o n . j a v a : 1204 ) [ s p r i n g − b o o t − 2.1.9. R E L E A S E . j a r : 2.1.9. R E L E A S E ] a t c o m . z j s r u . h e l l o t e s t . H e l l o t e s t A p p l i c a t i o n . m a i n ( H e l l o t e s t A p p l i c a t i o n . j a v a : 18 ) [ c l a s s e s / : n a ] a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e 0 ( N a t i v e M e t h o d )   [ n a : 1.8. 0 1 81 ] a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e ( N a t i v e M e t h o d A c c e s s o r I m p l . j a v a : 62 )   [ n a : 1.8. 0 1 81 ] a t s u n . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e ( D e l e g a t i n g M e t h o d A c c e s s o r I m p l . j a v a : 43 )   [ n a : 1.8. 0 1 81 ] a t j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e ( M e t h o d . j a v a : 498 )   [ n a : 1.8. 0 1 81 ] a t o r g . s p r i n g f r a m e w o r k . b o o t . d e v t o o l s . r e s t a r t . R e s t a r t L a u n c h e r . r u n ( R e s t a r t L a u n c h e r . j a v a : 49 ) [ s p r i n g − b o o t − d e v t o o l s − 2.1.9. R E L E A S E . j a r : 2.1.9. R E L E A S E ] C a u s e d b y : j a v a x . p e r s i s t e n c e . P e r s i s t e n c e E x c e p t i o n : [ P e r s i s t e n c e U n i t : d e f a u l t ] U n a b l e t o b u i l d H i b e r n a t e S e s s i o n F a c t o r y ; n e s t e d e x c e p t i o n i s o r g . h i b e r n a t e . e x c e p t i o n . S Q L G r a m m a r E x c e p t i o n : U n a b l e t o b u i l d D a t a b a s e I n f o r m a t i o n a t o r g . s p r i n g f r a m e w o r k . o r m . j p a . A b s t r a c t E n t i t y M a n a g e r F a c t o r y B e a n . b u i l d N a t i v e E n t i t y M a n a g e r F a c t o r y ( A b s t r a c t E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 403 )   [ s p r i n g − o r m − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . o r m . j p a . A b s t r a c t E n t i t y M a n a g e r F a c t o r y B e a n . a f t e r P r o p e r t i e s S e t ( A b s t r a c t E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 378 )   [ s p r i n g − o r m − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . o r m . j p a . L o c a l C o n t a i n e r E n t i t y M a n a g e r F a c t o r y B e a n . a f t e r P r o p e r t i e s S e t ( L o c a l C o n t a i n e r E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 341 )   [ s p r i n g − o r m − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t A u t o w i r e C a p a b l e B e a n F a c t o r y . i n v o k e I n i t M e t h o d s ( A b s t r a c t A u t o w i r e C a p a b l e B e a n F a c t o r y . j a v a : 1837 )   [ s p r i n g − b e a n s − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t A u t o w i r e C a p a b l e B e a n F a c t o r y . i n i t i a l i z e B e a n ( A b s t r a c t A u t o w i r e C a p a b l e B e a n F a c t o r y . j a v a : 1774 )   [ s p r i n g − b e a n s − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] . . . 21 c o m m o n f r a m e s o m i t t e d C a u s e d b y : o r g . h i b e r n a t e . e x c e p t i o n . S Q L G r a m m a r E x c e p t i o n : U n a b l e t o b u i l d D a t a b a s e I n f o r m a t i o n a t o r g . h i b e r n a t e . e x c e p t i o n . i n t e r n a l . S Q L S t a t e C o n v e r s i o n D e l e g a t e . c o n v e r t ( S Q L S t a t e C o n v e r s i o n D e l e g a t e . j a v a : 106 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . e x c e p t i o n . i n t e r n a l . S t a n d a r d S Q L E x c e p t i o n C o n v e r t e r . c o n v e r t ( S t a n d a r d S Q L E x c e p t i o n C o n v e r t e r . j a v a : 42 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . e n g i n e . j d b c . s p i . S q l E x c e p t i o n H e l p e r . c o n v e r t ( S q l E x c e p t i o n H e l p e r . j a v a : 113 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . e n g i n e . j d b c . s p i . S q l E x c e p t i o n H e l p e r . c o n v e r t ( S q l E x c e p t i o n H e l p e r . j a v a : 99 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . t o o l . s c h e m a . i n t e r n a l . H e l p e r . b u i l d D a t a b a s e I n f o r m a t i o n ( H e l p e r . j a v a : 140 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . t o o l . s c h e m a . i n t e r n a l . A b s t r a c t S c h e m a M i g r a t o r . d o M i g r a t i o n ( A b s t r a c t S c h e m a M i g r a t o r . j a v a : 96 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . t o o l . s c h e m a . s p i . S c h e m a M a n a g e m e n t T o o l C o o r d i n a t o r . p e r f o r m D a t a b a s e A c t i o n ( S c h e m a M a n a g e m e n t T o o l C o o r d i n a t o r . j a v a : 183 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . t o o l . s c h e m a . s p i . S c h e m a M a n a g e m e n t T o o l C o o r d i n a t o r . p r o c e s s ( S c h e m a M a n a g e m e n t T o o l C o o r d i n a t o r . j a v a : 72 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . i n t e r n a l . S e s s i o n F a c t o r y I m p l . < i n i t > ( S e s s i o n F a c t o r y I m p l . j a v a : 310 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . b o o t . i n t e r n a l . S e s s i o n F a c t o r y B u i l d e r I m p l . b u i l d ( S e s s i o n F a c t o r y B u i l d e r I m p l . j a v a : 467 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . h i b e r n a t e . j p a . b o o t . i n t e r n a l . E n t i t y M a n a g e r F a c t o r y B u i l d e r I m p l . b u i l d ( E n t i t y M a n a g e r F a c t o r y B u i l d e r I m p l . j a v a : 939 )   [ h i b e r n a t e − c o r e − 5.3.12. F i n a l . j a r : 5.3.12. F i n a l ] a t o r g . s p r i n g f r a m e w o r k . o r m . j p a . v e n d o r . S p r i n g H i b e r n a t e J p a P e r s i s t e n c e P r o v i d e r . c r e a t e C o n t a i n e r E n t i t y M a n a g e r F a c t o r y ( S p r i n g H i b e r n a t e J p a P e r s i s t e n c e P r o v i d e r . j a v a : 58 )   [ s p r i n g − o r m − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . o r m . j p a . L o c a l C o n t a i n e r E n t i t y M a n a g e r F a c t o r y B e a n . c r e a t e N a t i v e E n t i t y M a n a g e r F a c t o r y ( L o c a l C o n t a i n e r E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 365 )   [ s p r i n g − o r m − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] a t o r g . s p r i n g f r a m e w o r k . o r m . j p a . A b s t r a c t E n t i t y M a n a g e r F a c t o r y B e a n . b u i l d N a t i v e E n t i t y M a n a g e r F a c t o r y ( A b s t r a c t E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 391 )   [ s p r i n g − o r m − 5.1.10. R E L E A S E . j a r : 5.1.10. R E L E A S E ] . . . 25 c o m m o n f r a m e s o m i t t e d C a u s e d b y : c o m . m i c r o s o f t . s q l s e r v e r . j d b c . S Q L S e r v e r E x c e p t i o n : 对 象 名 ′ s y s . s e q u e n c e s ′ 无 效 。 a t c o m . m i c r o s o f t . s q l s e r v e r . j d b c . S Q L S e r v e r E x c e p t i o n . m a k e F r o m D a t a b a s e E r r o r ( S Q L S e r v e r E x c e p t i o n . j a v a : 259 )   [ m s s q l − j d b c − 6.4.0. j r e 8. j a r : n a ] a t c o m . m i c r o s o f t . s q l s e r v e r . j d b c . S Q L S e r v e r S t a t e m e n t . g e t N e x t R e s u l t ( S Q L S e r v e r S t a t e m e n t . j a v a : 1547 )   [ m s s q l − j d b c − 6.4.0. j r e 8. j a r : n a ] a t c o m . m i c r o s o f t . s q l s e r v e r . j d b c . S Q L S e r v e r S t a t e m e n t . d o E x e c u t e S t a t e m e n t ( S Q L S e r v e r S t a t e m e n t . j a v a : 857 )   [ m s s q l − j d b c − 6.4.0. j r e 8. j a r : n a ] a t c o m . m i c r o s o f t . s q l s e r v e r . j d b c . S Q L S e r v e r S t a t e m e n t 0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105) ~[spring-context-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.1.9.RELEASE.jar:2.1.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:744) [spring-boot-2.1.9.RELEASE.jar:2.1.9.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391) [spring-boot-2.1.9.RELEASE.jar:2.1.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:312) [spring-boot-2.1.9.RELEASE.jar:2.1.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) [spring-boot-2.1.9.RELEASE.jar:2.1.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1204) [spring-boot-2.1.9.RELEASE.jar:2.1.9.RELEASE] at com.zjsru.hellotest.HellotestApplication.main(HellotestApplication.java:18) [classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_181] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_181] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181] at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) [spring-boot-devtools-2.1.9.RELEASE.jar:2.1.9.RELEASE] Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:403) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1837) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774) ~[spring-beans-5.1.10.RELEASE.jar:5.1.10.RELEASE] ... 21 common frames omitted Caused by: org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:140) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:96) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE] ... 25 common frames omitted Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'sys.sequences' 无效。 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) ~[mssql-jdbc-6.4.0.jre8.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) ~[mssql-jdbc-6.4.0.jre8.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857) ~[mssql-jdbc-6.4.0.jre8.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement 0(AbstractBeanFactory.java:320) [springbeans5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [springbeans5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) [springbeans5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) [springbeans5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105) [springcontext5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) [springcontext5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) [springcontext5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) [springboot2.1.9.RELEASE.jar:2.1.9.RELEASE]atorg.springframework.boot.SpringApplication.refresh(SpringApplication.java:744)[springboot2.1.9.RELEASE.jar:2.1.9.RELEASE]atorg.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391)[springboot2.1.9.RELEASE.jar:2.1.9.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:312)[springboot2.1.9.RELEASE.jar:2.1.9.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:1215)[springboot2.1.9.RELEASE.jar:2.1.9.RELEASE]atorg.springframework.boot.SpringApplication.run(SpringApplication.java:1204)[springboot2.1.9.RELEASE.jar:2.1.9.RELEASE]atcom.zjsru.hellotest.HellotestApplication.main(HellotestApplication.java:18)[classes/:na]atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod) [na:1.8.0181]atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [na:1.8.0181]atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [na:1.8.0181]atjava.lang.reflect.Method.invoke(Method.java:498) [na:1.8.0181]atorg.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)[springbootdevtools2.1.9.RELEASE.jar:2.1.9.RELEASE]Causedby:javax.persistence.PersistenceException:[PersistenceUnit:default]UnabletobuildHibernateSessionFactory;nestedexceptionisorg.hibernate.exception.SQLGrammarException:UnabletobuildDatabaseInformationatorg.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:403) [springorm5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378) [springorm5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) [springorm5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1837) [springbeans5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774) [springbeans5.1.10.RELEASE.jar:5.1.10.RELEASE]...21commonframesomittedCausedby:org.hibernate.exception.SQLGrammarException:UnabletobuildDatabaseInformationatorg.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:140) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:96) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939) [hibernatecore5.3.12.Final.jar:5.3.12.Final]atorg.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) [springorm5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [springorm5.1.10.RELEASE.jar:5.1.10.RELEASE]atorg.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) [springorm5.1.10.RELEASE.jar:5.1.10.RELEASE]...25commonframesomittedCausedby:com.microsoft.sqlserver.jdbc.SQLServerException:sys.sequencesatcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) [mssqljdbc6.4.0.jre8.jar:na]atcom.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) [mssqljdbc6.4.0.jre8.jar:na]atcom.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857) [mssqljdbc6.4.0.jre8.jar:na]atcom.microsoft.sqlserver.jdbc.SQLServerStatementStmtExecCmd.doExecute(SQLServerStatement.java:757) ~[mssql-jdbc-6.4.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) ~[mssql-jdbc-6.4.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) ~[mssql-jdbc-6.4.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) ~[mssql-jdbc-6.4.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) ~[mssql-jdbc-6.4.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:659) ~[mssql-jdbc-6.4.0.jre8.jar:na]
at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111) ~[HikariCP-3.2.0.jar:na]
at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) ~[HikariCP-3.2.0.jar:na]
at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.extractMetadata(SequenceInformationExtractorLegacyImpl.java:42) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final]
at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.initializeSequences(DatabaseInformationImpl.java:65) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final]
at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.(DatabaseInformationImpl.java:59) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final]
at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:132) ~[hibernate-core-5.3.12.Final.jar:5.3.12.Final]
… 34 common frames omitted
/

解决方法:

#指定数据库方言 spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.SQLServerDialect
注意:我这里用的是SQLServer数据库,如果你用的是MySql数据库的话,可以换成下面的:

#指定数据库方言 spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MYSQL5Dialect

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值