hibernate 多对一映射出错

2016-06-05 12:36:04 578 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

logisim实验——通过2个半加器实现1-bit全加器，通过4个一位全加器构成4-bit加法器（详解）一、由异或门和与门所构成的半加器：二、由两个半加器构成的1-bit全加器： .. 阅读详情

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)

求各位指点实在是找不到问题。。

...全文

Grok 3国内怎么用？超详细使用指南+实用指令模板主要是用于快速分析学术论文，提取关键信息，总结研究成果。Analyze the following research paper: [粘贴或上传论文内容]1. Extract key findings, methodologies, and conclusions. (提取主要发现、方法和结论。2. Identify statistical significance and data points. (识别统计显著性和数据点。阅读详情

liangjingniu

Java EE 67,535 成员 225,843 内容

+ 关注 + 加入社区

切换为时间正序

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 多对一 映射出错

相关推荐

hibernate 多对一映射出错