遇到问题了，一直连接不上数据库，数据库一直无法自动创建表？请问谁有好的解决方法吗？万分感谢！！！-慕课网

遇到问题了，一直连接不上数据库，数据库一直无法自动创建表？请问谁有好的解决方法吗？万分感谢！！！

来源：5-4 添加事务管理-Spring整合Hibernate

Z大神

2018-08-17 12:29

警告: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: javax/xml/bind/JAXBException
8月 17, 2018 12:21:09 下午 org.springframework.web.context.ContextLoader initWebApplicationContext
严重: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: javax/xml/bind/JAXBException
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1699)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:573)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:495)
   at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:740)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:869)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:409)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:291)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4643)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5109)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
   at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
   at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
   at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943)
   at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
   at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
   at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
   at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943)
   at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:258)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:682)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.base/java.lang.reflect.Method.invoke(Method.java:564)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:350)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492)
Caused by: java.lang.NoClassDefFoundError: javax/xml/bind/JAXBException
   at org.hibernate.boot.spi.XmlMappingBinderAccess.<init>(XmlMappingBinderAccess.java:43)
   at org.hibernate.boot.MetadataSources.<init>(MetadataSources.java:86)
   at org.springframework.orm.hibernate5.LocalSessionFactoryBean.getMetadataSources(LocalSessionFactoryBean.java:386)
   at org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:421)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1758)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1695)
   ... 42 more
Caused by: java.lang.ClassNotFoundException: javax.xml.bind.JAXBException
   at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1309)
   at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1138)
   ... 48 more

8月 17, 2018 12:21:09 下午 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: javax/xml/bind/JAXBException
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1699)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:573)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:495)
   at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:740)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:869)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:409)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:291)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4643)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5109)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
   at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
   at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
   at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943)
   at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
   at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
   at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
   at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943)
   at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:258)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:682)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.base/java.lang.reflect.Method.invoke(Method.java:564)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:350)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492)
Caused by: java.lang.NoClassDefFoundError: javax/xml/bind/JAXBException
   at org.hibernate.boot.spi.XmlMappingBinderAccess.<init>(XmlMappingBinderAccess.java:43)
   at org.hibernate.boot.MetadataSources.<init>(MetadataSources.java:86)
   at org.springframework.orm.hibernate5.LocalSessionFactoryBean.getMetadataSources(LocalSessionFactoryBean.java:386)
   at org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:421)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1758)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1695)
   ... 42 more
Caused by: java.lang.ClassNotFoundException: javax.xml.bind.JAXBException
   at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1309)
   at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1138)
   ... 48 more

8月 17, 2018 12:21:09 下午 org.apache.catalina.core.StandardContext startInternal
严重: One or more listeners failed to start. Full details will be found in the appropriate container log file
8月 17, 2018 12:21:09 下午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/ssh] startup failed due to previous errors
8月 17, 2018 12:21:09 下午 org.apache.catalina.core.ApplicationContext log
信息: Closing Spring root WebApplicationContext
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.catalina.loader.WebappClassLoaderBase (file:/D:/apache-tomcat-9.0.10/lib/catalina.jar) to field java.io.ObjectStreamClass$Caches.localDescs
WARNING: Please consider reporting this to the maintainers of org.apache.catalina.loader.WebappClassLoaderBase
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
8月 17, 2018 12:21:09 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-nio-8080"]
8月 17, 2018 12:21:09 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-nio-8009"]
8月 17, 2018 12:21:09 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 3402 ms

写回答关注

4回答

情有独钟: 2018-08-27 09:40:28

<props>
       <prop key="hibernate.dialect">org.hibernate.dialect.MySQL57Dialect</prop>
       <prop key="hibernate.show_sql">true</prop>
       <prop key="hibernate.format_sql">true</prop>
       <prop key="hibernate.hbm2ddl.auto">update</prop>
</props>

和你问题一样，这样就行了，key值前都加上hibernate

0 1

qq_懵懂的岁月_0

2018-08-23 15:09:33

好了兄弟手动建表吧。反正你以后写项目弄到也是先建立表在反向生成实体类和配置文件。

0 1
慕粉3927180

2018-08-21 22:21:05

1、修改表引擎方法
alter table table_name engine=innodb;
2、查看系统支持的存储引擎
show engines;

0 1
慕粉3927180

2018-08-21 22:18:10

hibernate的xml文件里的方言配置的问题，添加上MySQL的版本号(我的是5)即可，

<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop>
还有，检查一下你的MySQL的存储引擎是否是InnoDB，如不是请修改。
看你的mysql现在已提供什么存储引擎:
mysql> show engines;
1、MyISAM管理非事务表，提供高速存储和检索以及全文搜索能力，如果再应用中执行大量select操作，应该选择MyISAM
2、InnoDB用于事务处理，具有ACID事务支持等特性，如果在应用中执行大量insert和update操作，应该选择InnoDB

0 1

基于SSH实现员工管理系统之框架整合篇

本视频教程主要介绍环境搭建和SSH框架整合，逐层深入理解学习

49832 学习 · 344 问题

查看课程

相似问题

发布到tomcat报错，数据库无法自动建表。

回答 1

无法自动创建表

回答 1

我的数据库是sqlserver 连接到保存数据为null

回答 1

数据库中没有数据

回答 2

数据库还是没有数据

回答 1

打开慕课网App查看更多内容