org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [bean.xml]: Invocation of init method failed; nested exception is

时间：2023-03-09 04:26:23
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [bean.xml]: Invocation of init method failed; nested exception is

在复制xml文件进行修改的时候，我经常将不小心对原文件进行修改，而导致创建bean出错。报错如下所示：

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 [bean.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: Error creating DatabaseInformation for schema migration

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:753)

    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)

    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)

    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:446)

    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:328)

    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)

    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4727)

    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5189)

    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)

    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1107)

    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1841)

    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

    at java.lang.Thread.run(Thread.java:745)

Caused by: org.hibernate.exception.SQLGrammarException: Error creating DatabaseInformation for schema migration

    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)

    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)

    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)

    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:101)

    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:470)

    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:444)

    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:708)

    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724)

    at org.springframework.orm.hibernate5.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:416)

    at org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:401)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)

    ... 25 more

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'ssh_crm.rdb$generators' doesn't exist

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

    at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)

    at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)

    at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)

    at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:177)

    at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.extractMetadata(SequenceInformationExtractorLegacyImpl.java:42)

    at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.initializeSequences(DatabaseInformationImpl.java:64)

    at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.<init>(DatabaseInformationImpl.java:60)

    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:123)

    ... 34 more

十一月 12, 2018 2:06:54 下午 org.apache.catalina.core.StandardContext startInternal

严重: One or more listeners failed to start. Full details will be found in the appropriate container log file

十一月 12, 2018 2:06:54 下午 org.apache.catalina.core.StandardContext startInternal

严重: Context [/ssh_crm02] startup failed due to previous errors

十一月 12, 2018 2:06:54 下午 org.apache.catalina.core.ApplicationContext log

信息: Closing Spring root WebApplicationContext

十一月 12, 2018 2:06:54 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc

警告: The web application [ssh_crm02] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

十一月 12, 2018 2:06:54 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads

警告: The web application [ssh_crm02] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hgensx9z1t839g1qrvr6y|357ebd47]-AdminTaskTimer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:

 java.lang.Object.wait(Native Method)

 java.util.TimerThread.mainLoop(Timer.java:552)

 java.util.TimerThread.run(Timer.java:505)

十一月 12, 2018 2:06:54 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads

警告: The web application [ssh_crm02] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hgensx9z1t839g1qrvr6y|357ebd47]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:

 java.lang.Object.wait(Native Method)

 com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:635)

十一月 12, 2018 2:06:54 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads

警告: The web application [ssh_crm02] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hgensx9z1t839g1qrvr6y|357ebd47]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:

 java.lang.Object.wait(Native Method)

 com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:635)

十一月 12, 2018 2:06:54 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads

警告: The web application [ssh_crm02] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hgensx9z1t839g1qrvr6y|357ebd47]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:

 java.lang.Object.wait(Native Method)

 com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:635)

十一月 12, 2018 2:06:54 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads

警告: The web application [ssh_crm02] appears to have started a thread named [Timer-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:

 java.lang.Object.wait(Native Method)

 java.lang.Object.wait(Object.java:502)

 java.util.TimerThread.mainLoop(Timer.java:526)

 java.util.TimerThread.run(Timer.java:505)

相关文章