错误：HHH000299：无法完成模式更新java.lang.NullPointerException [英] ERROR: HHH000299: Could not complete schema update java.lang.NullPointerException
本文介绍了错误：HHH000299：无法完成模式更新java.lang.NullPointerException的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在以下环境中安装了Web应用程序。
$ b
- JPA 2.0
- Spring 3.2.2
- MySQL 5.6.11
- Hibernate 4.2.0 CR1
- Apache Tomcat 7.0.35
我的配置直到现在都在 application-context.xml <？xml version =1.0编码
< beans xmlns =http://www.springframework.org/schema/beans
xmlns：xsi =http://www.w3.org/2001/XMLSchema-instance
xmlns：p =http://www.springframework.org/schema/p
xmlns：aop =http://www.springframework.org/schema/aop
xmlns ：tx =http://www.springframework.org/schema/tx
xmlns：context =http://www.springframework.org/schema/context
xsi：schemaLocation = http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/ aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema /context/spring-context-3.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd\"> ;
< bean id =dataSourceclass =org.springframework.jdbc.datasource.DriverManagerDataSource>
< property name =driverClassNamevalue =com.mysql.jdbc.Driver/>
< property name =urlvalue =jdbc：mysql：// localhost：3306 / social_networking？zeroDateTimeBehavior = convertToNull/>
< property name =usernamevalue =root/>
< property name =passwordvalue =root/>
< / bean>
< bean id =entityManagerFactoryclass =org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean>
< property name =persistenceUnitNamevalue =WebAppPU/>
< property name =dataSourceref =dataSource/>
< property name =jpaVendorAdapter>
< bean class =org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter>
< property name =showSqlvalue =true/>
< property name =generateDdlvalue =true/>
< property name =databasePlatformvalue =org.hibernate.dialect.HSQLDialect/>
< / bean>
< / property>
< property name =jpaDialect>
< bean class =org.springframework.orm.jpa.vendor.HibernateJpaDialect/>
< / property>
< / bean>
< bean class =org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor/>
< bean id =transactionManagerclass =org.springframework.orm.jpa.JpaTransactionManager>
< property name =entityManagerFactoryref =entityManagerFactory/>
< / bean>
< tx：注解驱动的事务管理器=transactionManager/>
< bean id =testDAOServiceclass =admin.dao.TestDAO/>
< / beans>
persistence.xml 包含以下xml 。
$ b
<？xml version =1.0encoding =UTF-8？> ;
< persistence version =2.0xmlns =http://java.sun.com/xml/ns/persistencexmlns：xsi =http://www.w3.org/2001/XMLSchema-实例xsi：schemaLocation =http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd\">
< persistence-unit name =WebAppPUtransaction-type =RESOURCE_LOCAL>
<！ - < provider> org.eclipse.persistence.jpa.PersistenceProvider< / provider> - >
< provider> org.hibernate.ejb.HibernatePersistence< / provider>
< class> model.Test< / class>
< exclude-unlisted-classes> false< / exclude-unlisted-classes>
<属性>
< property name =javax.persistence.jdbc.urlvalue =jdbc：mysql：// localhost：3306 / social_networking？zeroDateTimeBehavior = convertToNull/>
< property name =javax.persistence.jdbc.passwordvalue =root/>
< property name =javax.persistence.jdbc.drivervalue =com.mysql.jdbc.Driver/>
< property name =javax.persistence.jdbc.uservalue =root/>
<！ - < property name =hibernate.hbm2ddl.autovalue =create-drop/> - >
< / properties>
< / persistence-unit>
< /余辉>
以下是目前唯一的实体类。
封装模型;我们已经试过对这个已经成功的实体执行插入操作。
@Entity
public class Test实现Serializable {
@Id
@GeneratedValue（strategy = GenerationType.IDENTITY）
@Basic可选= false）
@Column（name =id，nullable = false）
private Integer id;
@Column（name =description，length = 45）
私有字符串描述;
private static final long serialVersionUID = 1L;
public Test（）{}
public Test（Integer id）{
this.id = id;
}
// Getters和setter。
$ / code> 尽管应用程序正在运行，但可以在服务器控制台上看到以下异常。
$ b
错误：HHH000299：无法完成模式更新
java.lang.NullPointerException
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences（DatabaseMetadata.java:156）
at org.hibernate.tool.hbm2ddl.DatabaseMetadata。< init>（DatabaseMetadata.java:70）
at org.hibernate.tool.hbm2ddl.DatabaseMetadata。< init>（DatabaseMetadata.java:63）
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute（SchemaUpdate.java:196）
在org.hibernate.tool.hbm2ddl.SchemaUpdate.execute（SchemaUpdate.java:178）
at org.hibernate.internal.SessionFactoryImpl。< init>（SessionFactoryImpl.java:505）
at org .hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:1742）
在org.hibernate.ejb.EntityManagerFactoryImpl。< init>（EntityMan agerFactoryImpl.java:94）
在org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory（Ejb3Configuration.java:905）
在org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory（Ejb3Configuration.java:890）
at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory（HibernatePersistence.java:74）
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory（LocalContainerEntityManagerFactoryBean.java:288）
at org.springframework .orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet（AbstractEntityManagerFactoryBean.java:310）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory.java:1547）
at org.springframework.beans .factory.support.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1485）$ or
at org.springframework.beans.factory.support.A bstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:524）
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:461）
at org.springframework.beans.factory.support。 AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:295）
在org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java:223）
在org.springframework.beans.factory.support .AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:292）
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:194）
at org.springframework.context.support.AbstractApplicationContext .getBean（AbstractApplicationContext.java:1117）
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization（AbstractApplicationContext.java:922）
at org.sprin gframework.context.support.AbstractApplicationContext.refresh（AbstractApplicationContext.java:479）
处org.springframework.web org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext（ContextLoader.java:389）
。 context.ContextLoader.initWebApplicationContext（ContextLoader.java:294）
处org.apache.catalina.core.StandardContext org.springframework.web.context.ContextLoaderListener.contextInitialized（ContextLoaderListener.java:112）
。 listenerStart（StandardContext.java:4797）
at org.apache.catalina.core.StandardContext.startInternal（StandardContext.java:5291）
at org.apache.catalina.util.LifecycleBase.start（LifecycleBase。 java：150）
at org.apache.catalina.core.StandardContext.reload（StandardContext.java:3926）
at org.apache.catalina.manager.ManagerServlet.reload（ManagerServlet.java:954）
在org.apache.catalina.manager.ManagerServlet.doGet（ManagerServlet.java:364）
在javax.servle t.http.HttpServlet.service（HttpServlet.java:621）
位于javax.servlet.http.HttpServlet.service（HttpServlet.java:728）
位于org.apache.catalina.core.ApplicationFilterChain。 internalDoFilter（ApplicationFilterChain.java:305）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:210）
在org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter（SetCharacterEncodingFilter。的java：108）处org.apache.catalina.core.ApplicationFilterChain.doFilter org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:243）
（ApplicationFilterChain.java:210）
at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:222）
at org.apache.catalina.core.StandardContextValve.invoke（StandardContextValve.java:123）
at org.apache.catalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:581）
at org.apache.catalina.core.StandardHostV alve.invoke（StandardHostValve.java:171）
at org.apache.catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:99）
at org.apache.catalina.valves.AccessLogValve.invoke（ AccessLogValve.java:936）
at org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:118）
at org.apache.catalina.connector.CoyoteAdapter.service（CoyoteAdapter.java： 407）
at org.apache.coyote.http11.AbstractHttp11Processor.process（AbstractHttp11Processor.java:1004）
at org.apache.coyote.AbstractProtocol $ AbstractConnectionHandler.process（AbstractProtocol.java:589）
at org.apache.tomcat.util.net.AprEndpoint $ SocketProcessor.run（AprEndpoint.java:1822）$ b $ java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1110）
在java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:603）$ b $在java.lang.Thread.run（Thread.java:722）
试图使用以下公关operty在 persistence.xml 文件中，但没有帮助。
$ b
< property name =hibernate.hbm2ddl.autovalue =update/>
可能是什么原因？
解决方案
看起来你错误地混合了Hibernate方言和数据库。在原始问题中，您有一个MySQL数据库和一个方言 org.hibernate.dialect.HSQLDialect （请参阅下面的第一个代码块）。
在您的解决方案中，您有MySQL数据库和 org.hibernate.dialect.MySQL5Dialect 的正确方言（请参阅下面的第二个代码块）。
如果您已将原始版本中的 databasePlatform 更改为MySQL方言，那么它也会起作用。
原文：
< bean id =entityManagerFactoryclass =org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean>
...
< property name =jpaVendorAdapter>
< bean class =org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter>
...
< property name =databasePlatformvalue =org.hibernate.dialect.HSQLDialect/>
< / bean>
< / property>
...
< / bean>
工作：
< persistence version =2.0xmlns =http://java.sun.com/xml/ns/persistence
xmlns：xsi =http： //www.w3.org/2001/XMLSchema-instance
xsi：schemaLocation =http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ NS /持久性/ persistence_2_0.xsd>
< persistence-unit name =WebAppPUtransaction-type =RESOURCE_LOCAL>
...
<属性>
...
< property name =hibernate.dialectvalue =org.hibernate.dialect.MySQLDialect/>
...
< / properties>
< / persistence-unit>
< /余辉>
I have a web application in the following environment.
- JPA 2.0
- Spring 3.2.2
- MySQL 5.6.11
- Hibernate 4.2.0 CR1
- Apache Tomcat 7.0.35
My configurations until now in the application-context.xml file are as under.
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/social_networking?zeroDateTimeBehavior=convertToNull" />
<property name="username" value="root" />
<property name="password" value="root" />
</bean>
<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="persistenceUnitName" value="WebAppPU"/>
<property name="dataSource" ref="dataSource" />
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="showSql" value="true"/>
<property name="generateDdl" value="true"/>
<property name="databasePlatform" value="org.hibernate.dialect.HSQLDialect"/>
</bean>
</property>
<property name="jpaDialect">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
</property>
</bean>
<bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor"/>
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>
<tx:annotation-driven transaction-manager="transactionManager"/>
<bean id="testDAOService" class="admin.dao.TestDAO"/>
</beans>
The persistence.xml contains the following xml.
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="WebAppPU" transaction-type="RESOURCE_LOCAL">
<!--<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>-->
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>model.Test</class>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/social_networking?zeroDateTimeBehavior=convertToNull"/>
<property name="javax.persistence.jdbc.password" value="root"/>
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
<property name="javax.persistence.jdbc.user" value="root"/>
<!--<property name="hibernate.hbm2ddl.auto" value="create-drop"/>-->
</properties>
</persistence-unit>
</persistence>
And the following is the only entity class right now. I have tried to perform an insert operation with this entity which has been succeeded.
package model;
@Entity
public class Test implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "id", nullable = false)
private Integer id;
@Column(name = "description", length = 45)
private String description;
private static final long serialVersionUID = 1L;
public Test() {}
public Test(Integer id) {
this.id = id;
}
// Getters and setter.
}
Although the application runs, the following exception can be seen on the server console.
ERROR: HHH000299: Could not complete schema update
java.lang.NullPointerException
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:156)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:70)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:63)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:505)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1742)
at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:94)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:890)
at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:288)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1547)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:922)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3926)
at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:954)
at org.apache.catalina.manager.ManagerServlet.doGet(ManagerServlet.java:364)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Tried to use the following property inside the persistence.xml file but didn't help.
<property name="hibernate.hbm2ddl.auto" value="update"/>
What might be the reason?
解决方案
It looks like you're incorrectly mixing Hibernate dialects and databases. In your original issue you have a MySQL database and a dialect of org.hibernate.dialect.HSQLDialect (see first code block below).
In your solution you have the MySQL database and the correct dialect of org.hibernate.dialect.MySQL5Dialect (see second code block below).
If you had changed the databasePlatform in the original to be the MySQL dialect it would have worked as well.
Original:
<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
...
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
...
<property name="databasePlatform" value="org.hibernate.dialect.HSQLDialect"/>
</bean>
</property>
...
</bean>
Working:
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="WebAppPU" transaction-type="RESOURCE_LOCAL">
...
<properties>
...
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
...
</properties>
</persistence-unit>
</persistence>
这篇关于错误：HHH000299：无法完成模式更新java.lang.NullPointerException的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
