hibernate 多对一 映射出错

liangjingniu 2016-06-05 12:36:04
Customer.hbm.xml
<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">



<hibernate-mapping>

    <class name="com.liangjing.hibernate.entities.n21.Customer" table="CUSTOMERS">

    

        <id name="customerId" type="java.lang.Integer">

            <column name="CUSTOMER_ID" />

            <generator class="native" />

        </id>

        

        <property name="customerName" type="java.lang.String">

            <column name="CUSTOMER_NAME" />

        </property>

        

    </class>

    

</hibernate-mapping>



Order.hbm.xml
<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">



<hibernate-mapping>



    <class name="com.liangjing.hibernate.entities.n21.Order" table="ORDERS">

        <id name="orderId" type="java.lang.Integer">

            <column name="ORDER_ID" />

            <generator class="native" />

        </id>

        

        <property name="orderName" type="java.lang.String">

            <column name="ORDER_NAME" />

        </property>

        

        <many-to-one name="customer" class="com.liangjing.hibernate.entities.n21.Customer">

            <column name="CUSTOMER_ID" />

        </many-to-one>

        

    </class>

    

</hibernate-mapping>


测试
	@Test

	public void testMany2One(){

		Customer customer = new Customer();

		customer.setCustomerName("AA");

		

		Order order1 = new Order();

		order1.setOrderName("ORDER-1");

		

		Order order2 = new Order();

		order2.setOrderName("ORDER-2");

		

		order1.setCustomer(customer);

		order2.setCustomer(customer);

		

		session.save(customer);

		session.save(order1);

		session.save(order2);

	}


用的是MySQL数据库，如果数据库里不存在 customers和orders两张表的话 运行没有问题，但如果更改参数再运行时，就会报错： Table not found: customers。
具体错误
org.hibernate.tool.schema.spi.SchemaManagementException: Attempt to resolve foreign key metadata from JDBC metadata failed to find column mappings for foreign key named [FKflgddyesjyik2ro2p501yys8r]

	at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl$ForeignKeyBuilderImpl.build(InformationExtractorJdbcDatabaseMetaDataImpl.java:727)

	at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl$ForeignKeyBuilderImpl.build(InformationExtractorJdbcDatabaseMetaDataImpl.java:708)

	at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getForeignKeys(InformationExtractorJdbcDatabaseMetaDataImpl.java:691)

	at org.hibernate.tool.schema.extract.internal.TableInformationImpl.foreignKeys(TableInformationImpl.java:88)

	at org.hibernate.tool.schema.extract.internal.TableInformationImpl.getForeignKey(TableInformationImpl.java:99)

	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.findMatchingForeignKey(SchemaMigratorImpl.java:530)

	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyForeignKeys(SchemaMigratorImpl.java:506)

	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.performMigration(SchemaMigratorImpl.java:315)

	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:137)

	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:110)

	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)

	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)

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

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

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

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

	at com.liangjing.hibernate.entities.n21.HibernateTest.init(HibernateTest.java:22)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:497)

	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)

	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)

	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)

	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)

	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)

	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)

	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)

	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)

	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)

	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)

	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)

	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)

	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)

	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)

	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)



java.lang.NullPointerException

	at com.liangjing.hibernate.entities.n21.HibernateTest.destroy(HibernateTest.java:29)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:497)

	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)

	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)

	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33)

	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)

	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)

	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)

	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)

	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)

	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)

	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)

	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)

	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)

	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)

	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)

	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)



求各位指点 实在是找不到问题。。
...全文
496 7 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
trnx 2019-04-26
  • 打赏
  • 举报
 回复
引用 4 楼 雄性皮卡丘 的回复:
很不幸我出现了和你一样的问题，这里貌似是一个BUG，Google了一下外国人也在讨论这个问题 例如：http://stackoverflow.com/questions/37676463/attempt-to-resolve-foreign-key-metadata-from-jdbc-metadata-failed-to-find-column 据官方说法在5.2.1给出了修复，参考 https://hibernate.atlassian.net/browse/HHH-10802 目前的建议是把版本更新到5.2.2或者回滚到5.0.x或4.3.x的版本。
非常感谢，采用您的方法，解决了问题
hp961218 2017-12-22
  • 打赏
  • 举报
 回复
hibernate.xml呢，问题出现在这里面,
meteor12138 2017-12-21
  • 打赏
  • 举报
 回复
搞了我好久，终于搞定了。楼主是不是还有其它的多对一注解映射表啊？这个要同时生成才行。 我刚开始生成了两个多对一映射表，并且写入了数据，后面再次生成两个多对一映射表就报错。错误情况跟你这个一样， 添加不了外键。后来我把两个已经生成的表删除了，然后同时生成四个表，成功了！！ 就是注解表一次写完，先两个再两个就会报错，希望能帮到你！
雄性皮卡丘 2016-07-27
  • 打赏
  • 举报
 回复
很不幸我出现了和你一样的问题，这里貌似是一个BUG，Google了一下外国人也在讨论这个问题 例如：http://stackoverflow.com/questions/37676463/attempt-to-resolve-foreign-key-metadata-from-jdbc-metadata-failed-to-find-column 据官方说法在5.2.1给出了修复，参考 https://hibernate.atlassian.net/browse/HHH-10802 目前的建议是把版本更新到5.2.2或者回滚到5.0.x或4.3.x的版本。
liuchunfei 2016-07-22
  • 打赏
  • 举报
 回复
参考：http://blog.csdn.net/yefengzhichen/article/details/51837058
liangjingniu 2016-06-05
  • 打赏
  • 举报
 回复
换了4.2的hibernate包就可以了 但真的不明白这是什么原因啊 有没有大神指点。。。求解答啊！先谢谢了！
liangjingniu 2016-06-05
  • 打赏
  • 举报
 回复
还有一部分错误提示 
六月 05, 2016 12:34:16 下午 org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.2.0.Final}
六月 05, 2016 12:34:16 下午 org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
六月 05, 2016 12:34:16 下午 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
六月 05, 2016 12:34:16 下午 org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
六月 05, 2016 12:34:16 下午 org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-mapping. Use namespace http://www.hibernate.org/dtd/hibernate-mapping instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
六月 05, 2016 12:34:17 下午 org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-mapping. Use namespace http://www.hibernate.org/dtd/hibernate-mapping instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
六月 05, 2016 12:34:17 下午 org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-mapping. Use namespace http://www.hibernate.org/dtd/hibernate-mapping instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
六月 05, 2016 12:34:17 下午 org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-mapping. Use namespace http://www.hibernate.org/dtd/hibernate-mapping instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
六月 05, 2016 12:34:18 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
六月 05, 2016 12:34:18 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/hibernate]
六月 05, 2016 12:34:18 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {user=root, password=****}
六月 05, 2016 12:34:18 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
六月 05, 2016 12:34:18 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001007: JDBC isolation level: READ_COMMITTED
六月 05, 2016 12:34:18 下午 org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
六月 05, 2016 12:34:18 下午 org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
六月 05, 2016 12:34:19 下午 org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl processGetTableResults
INFO: HHH000262: Table not found: customers
求指点啊!!!
hibernate映射关系
one-to-one,many-to-many,many-to-on
Hibernate_test
Hibernate对象关系映射，基本工作原理是将对象数据保存到关系数据库的表中，以及将关系数据库中数据读入到对象中。
Hibernate学习代码示例
示例中包括：基于底层的JDBC对数据库的操作和利用hibernate对数据库操作的对比，其中hibernate的实体关系映射包括（一对多，多对多）还有与Spring的整合例子。
hibernate资料 3.6.6版本
NULL 博文链接：https://bdk82924.iteye.com/blog/1134496
Java EE

67,550

社区成员

225,863

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章