7.Hibernate一對多關係建立與錯誤解決

團長李雲龍發表於2018-12-29

一對多表關係在hibernate中的配置

1.資料庫建表

建立使用者表以及聯絡人表，其中一個使用者對應多個聯絡人，聯絡人外來鍵參照於使用者表的主鍵

建立cst_customer表

CREATE TABLE IF NOT EXISTS cst_customer(
  cst_id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '使用者ID',
  cst_name VARCHAR(32) NOT NULL COMMENT '客戶名稱',
  cst_source VARCHAR(32) DEFAULT NULL COMMENT '客戶資訊來源',
  cst_industry VARCHAR(32) DEFAULT NULL COMMENT '客戶所屬行業',
  cst_level VARCHAR(32) DEFAULT NULL COMMENT '客戶所屬級別',
  cst_phone VARCHAR(64) DEFAULT NULL COMMENT '固定電話',
  cst_mobile VARCHAR(14) DEFAULT NULL COMMENT '行動電話'
);
複製程式碼

建立cst_linkman表

CREATE TABLE IF NOT EXISTS cst_linkman(
  lkm_id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '聯絡人ID',
  lkm_name VARCHAR(32) DEFAULT NULL COMMENT '聯絡人名字',
  lkm_gender VARCHAR(32) DEFAULT NULL COMMENT '聯絡人關係',
  lkm_phone VARCHAR(64) DEFAULT NULL COMMENT '聯絡人固定電話',
  lkm_mobile VARCHAR(14) DEFAULT NULL COMMENT '聯絡人行動電話',
  lkm_email VARCHAR(64) DEFAULT NULL COMMENT '聯絡人郵箱',
  lkm_qq VARCHAR(32) DEFAULT NULL COMMENT '聯絡人qq',
  lkm_position VARCHAR(64) DEFAULT NULL COMMENT '聯絡人地址',
  lkm_memo VARCHAR(32) DEFAULT NULL COMMENT '聯絡人成員',
  lkm_cust_id BIGINT,
  FOREIGN KEY (lkm_cust_id) REFERENCES cst_customer(cst_id) ON UPDATE NO ACTION ON DELETE NO ACTION
);
複製程式碼

建表成功後如下圖所示

2.建立實體

2.1建立cst_customer實體

package com.classes;

import java.util.HashSet;
import java.util.Set;

import javax.persistence.Transient;

public class cst_customer {
	private long cst_id;
	private String cst_name;
	private String cst_source;
	private String cst_industry;
	private String cst_level;
	private String cst_phone;
	private String cst_mobile;
	
	private Set<cst_linkman> linkmans = new HashSet<cst_linkman>();

	public long getCst_id() {
		return cst_id;
	}
	public void setCst_id(long cst_id) {
		this.cst_id = cst_id;
	}
	public String getCst_name() {
		return cst_name;
	}
	public void setCst_name(String cst_name) {
		this.cst_name = cst_name;
	}
	public String getCst_source() {
		return cst_source;
	}
	public void setCst_source(String cst_source) {
		this.cst_source = cst_source;
	}
	public String getCst_industry() {
		return cst_industry;
	}
	public void setCst_industry(String cst_industry) {
		this.cst_industry = cst_industry;
	}
	public String getCst_level() {
		return cst_level;
	}
	public void setCst_level(String cst_level) {
		this.cst_level = cst_level;
	}
	public String getCst_phone() {
		return cst_phone;
	}
	public void setCst_phone(String cst_phone) {
		this.cst_phone = cst_phone;
	}
	public String getCst_mobile() {
		return cst_mobile;
	}
	public void setCst_mobile(String cst_mobile) {
		this.cst_mobile = cst_mobile;
	}
	public Set<cst_linkman> getLinkmans() {
		return linkmans;
	}
	public void setLinkmans(Set<cst_linkman> linkmans) {
		this.linkmans = linkmans;
	}
}
複製程式碼

2.2建立cst_linkman實體

package com.classes;

import javax.persistence.Transient;

public class cst_linkman {
	private long lkm_id;
	private String lkm_name;
	private String lkm_gender;
	private String lkm_phone;
	private String lkm_mobile;
	private String lkm_email;
	private String lkm_qq;
	private String lkm_position;
	private String lkm_memo;
	
	private cst_customer cst_customer;
	
	public cst_customer getCst_customer() {
		return cst_customer;
	}
	public void setCst_customer(cst_customer cst_customer) {
		this.cst_customer = cst_customer;
	}
	public long getLkm_id() {
		return lkm_id;
	}
	public void setLkm_id(long lkm_id) {
		this.lkm_id = lkm_id;
	}
	public String getLkm_name() {
		return lkm_name;
	}
	public void setLkm_name(String lkm_name) {
		this.lkm_name = lkm_name;
	}
	public String getLkm_gender() {
		return lkm_gender;
	}
	public void setLkm_gender(String lkm_gender) {
		this.lkm_gender = lkm_gender;
	}
	public String getLkm_phone() {
		return lkm_phone;
	}
	public void setLkm_phone(String lkm_phone) {
		this.lkm_phone = lkm_phone;
	}
	public String getLkm_mobile() {
		return lkm_mobile;
	}
	public void setLkm_mobile(String lkm_mobile) {
		this.lkm_mobile = lkm_mobile;
	}
	public String getLkm_email() {
		return lkm_email;
	}
	public void setLkm_email(String lkm_email) {
		this.lkm_email = lkm_email;
	}
	public String getLkm_qq() {
		return lkm_qq;
	}
	public void setLkm_qq(String lkm_qq) {
		this.lkm_qq = lkm_qq;
	}
	public String getLkm_position() {
		return lkm_position;
	}
	public void setLkm_position(String lkm_position) {
		this.lkm_position = lkm_position;
	}
	public String getLkm_memo() {
		return lkm_memo;
	}
	public void setLkm_memo(String lkm_memo) {
		this.lkm_memo = lkm_memo;
	}
	
}
複製程式碼

3.建立對映關係

在這裡需要注意的是我使用的是eclipse中預設的那個工具所配置的，在這裡是有一個大坑的，在後面會講到，但是前面還是按照他預設的來進行配置

cst_customer對映表對應生成的程式碼如下

<hibernate-mapping>
    <class name="com.classes.cst_customer" table="CST_CUSTOMER">
        <id name="cst_id" type="long">
            <column name="CST_ID" />
            <generator class="assigned" />
        </id>
        <property name="cst_name" type="java.lang.String">
            <column name="CST_NAME" />
        </property>
        <property name="cst_source" type="java.lang.String">
            <column name="CST_SOURCE" />
        </property>
        <property name="cst_industry" type="java.lang.String">
            <column name="CST_INDUSTRY" />
        </property>
        <property name="cst_level" type="java.lang.String">
            <column name="CST_LEVEL" />
        </property>
        <property name="cst_phone" type="java.lang.String">
            <column name="CST_PHONE" />
        </property>
        <property name="cst_mobile" type="java.lang.String">
            <column name="CST_MOBILE" />
        </property>
        <set name="linkmans" table="CST_LINKMAN" inverse="false" lazy="true">
            <key>
                <column name="CST_ID" />
            </key>
            <one-to-many class="com.classes.cst_linkman" />
        </set>
    </class>
</hibernate-mapping>
複製程式碼

cst_linkman對映表對應生成的程式碼如下

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Mar 5, 2018 2:55:37 PM by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
    <class name="com.classes.cst_linkman" table="CST_LINKMAN">
        <id name="lkm_id" type="long">
            <column name="LKM_ID" />
            <generator class="assigned" />
        </id>
        <property name="lkm_name" type="java.lang.String">
            <column name="LKM_NAME" />
        </property>
        <property name="lkm_gender" type="java.lang.String">
            <column name="LKM_GENDER" />
        </property>
        <property name="lkm_phone" type="java.lang.String">
            <column name="LKM_PHONE" />
        </property>
        <property name="lkm_mobile" type="java.lang.String">
            <column name="LKM_MOBILE" />
        </property>
        <property name="lkm_email" type="java.lang.String">
            <column name="LKM_EMAIL" />
        </property>
        <property name="lkm_qq" type="java.lang.String">
            <column name="LKM_QQ" />
        </property>
        <property name="lkm_position" type="java.lang.String">
            <column name="LKM_POSITION" />
        </property>
        <property name="lkm_memo" type="java.lang.String">
            <column name="LKM_MEMO" />
        </property>
        <many-to-one name="cst_customer" class="com.classes.cst_customer" fetch="join">
            <column name="CST_CUSTOMER" />
        </many-to-one>
    </class>
</hibernate-mapping>
複製程式碼

4.將對映檔案新增到配置檔案中，配置檔案所對應的程式碼如下

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
		"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.password">lwhong1017</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/myblog?useSSL=true</property>
        <property name="hibernate.connection.username">root</property>
        <mapping resource="com/classes/cst_customer.hbm.xml"/>
        <mapping resource="com/classes/cst_linkman.hbm.xml"/>
    </session-factory>
</hibernate-configuration>
複製程式碼

5.編寫測試程式碼

DBuitls中程式碼如下

package com.HibernateUtils;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.classes.cst_customer;
import com.classes.cst_linkman;

public class DButils {
	private static SessionFactory sessionFactory;
	private static Session session;
	public static Session getSession() {
		return session;
	}

	public static void setSession(Session session) {
		DButils.session = session;
	}

	static {
		Configuration configuration = new Configuration().configure();
		sessionFactory = configuration.buildSessionFactory();
	}
	static {
		session = sessionFactory.openSession();
	}
	
	public void SaveData() {
		System.out.println("aaaaa----");
		Session session = this.getSession();
		Transaction transaction = session.beginTransaction();
		// 建立一個客戶
		cst_customer cst_customer = new cst_customer();
		cst_customer.setCst_name("趙雲");
		// 建立兩個聯絡人
		cst_linkman cst_linkman1 = new cst_linkman();
		cst_linkman1.setLkm_name("李祕書");
		cst_linkman cst_linkman2 = new cst_linkman();
		cst_linkman2.setLkm_name("王祕書");
		// 建立聯絡s
		cst_customer.getLinkmans().add(cst_linkman1);
		cst_customer.getLinkmans().add(cst_linkman2);
		cst_linkman1.setCst_customer(cst_customer);
		cst_linkman2.setCst_customer(cst_customer);
		session.save(cst_customer);
		session.save(cst_linkman1);
		session.save(cst_linkman2);
		transaction.commit();
		System.out.println("bbbbb----");
	}

}
複製程式碼

在main方法中呼叫

DButils dButils = new DButils();
dButils.SaveData();
複製程式碼

6.錯誤

6.1A different object with the same identifier value was already associated with the session

18/03/05 15:17:55 INFO orm.connections: HHH10001003: Autocommit mode: false
18/03/05 15:17:55 INFO internal.DriverManagerConnectionProviderImpl: HHH000115: Hibernate connection pool size: 20 (min=1)
18/03/05 15:17:55 INFO dialect.Dialect: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
aaaaa----
Exception in thread "main" org.hibernate.NonUniqueObjectException: A different object with the same identifier value was already associated with the session : [com.classes.cst_linkman#0]
	at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:165)
	at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
	at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
	at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
	at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:679)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:671)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:666)
	at com.HibernateUtils.DButils.SaveData(DButils.java:49)
	at com.Test.TestHibMutiTabPro.main(TestHibMutiTabPro.java:10)
複製程式碼

這行程式碼報錯意思是在session中已經存在兩個相同OID的物件在裡面，因此而導致的錯誤，我在這裡一開始也是去谷歌解決方法的，但是其實並沒有什麼好的解決方案，因此我在這裡用排除法，在這裡有相同的OID只能是我那裡新增了兩個聯絡人，所以我決定將cst_linkman2登出看看會出什麼問題

6.2Unknown column in 'field list'

aaaaa----
18/03/05 15:26:28 WARN spi.SqlExceptionHelper: SQL Error: 1054, SQLState: 42S22
18/03/05 15:26:28 ERROR spi.SqlExceptionHelper: Unknown column 'CST_CUSTOMER' in 'field list'
18/03/05 15:26:28 INFO internal.AbstractBatchImpl: HHH000010: On release of batch it still contained JDBC statements
18/03/05 15:26:28 ERROR internal.SessionImpl: HHH000346: Error during managed flush [could not execute statement]
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute statement
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
	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.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2886)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3386)
	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)
	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:465)
	at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2963)
	at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2339)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
	at com.HibernateUtils.DButils.SaveData(DButils.java:50)
	at com.Test.TestHibMutiTabPro.main(TestHibMutiTabPro.java:10)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'CST_CUSTOMER' in 'field list'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2494)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
	... 19 more
複製程式碼

果然第一個的相同OID的問題沒有了，但是又出現了新的問題，通過查詢資料這個地方意思是CST_CUSTOMER找不到沒有存在這樣的屬性，首先來分析一下這個CST_CUSTOMER可是cst_linkman實體中的成員屬性，cst_linkman所對應資料庫中的表確實是沒有這樣的一個列屬性，只有一個外來鍵的，而資料庫表與實體的對應關係是由hbm配置檔案來決定的，所以可能出現的問題就在配置檔案那個地方,因此我決定將原來的many-to-one這裡將原來的cst_customer修改成lkm_cust_id，這個外來鍵在表中可是實實在在存在的原：

<many-to-one name="cst_customer" class="com.classes.cst_customer" fetch="join">
            <column name="CST_CUSTOMER" />
        </many-to-one>
複製程式碼

現：

<many-to-one name="cst_customer" class="com.classes.cst_customer" fetch="join">
            <column name="lkm_cust_id" />
        </many-to-one>
複製程式碼

再次執行報如下錯誤

6.3Cannot add or update a child row: a foreign key constraint fails

18/03/05 15:39:30 INFO dialect.Dialect: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
aaaaa----
18/03/05 15:39:31 WARN spi.SqlExceptionHelper: SQL Error: 1452, SQLState: 23000
18/03/05 15:39:31 ERROR spi.SqlExceptionHelper: Cannot add or update a child row: a foreign key constraint fails (`myblog`.`cst_linkman`, CONSTRAINT `cst_linkman_ibfk_1` FOREIGN KEY (`lkm_cust_id`) REFERENCES `cst_customer` (`cst_id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
18/03/05 15:39:31 INFO internal.AbstractBatchImpl: HHH000010: On release of batch it still contained JDBC statements
18/03/05 15:39:31 ERROR internal.SessionImpl: HHH000346: Error during managed flush [could not execute statement]
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not execute statement
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)
	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.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2886)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3386)
	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)
	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:465)
	at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2963)
	at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2339)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
	at com.HibernateUtils.DButils.SaveData(DButils.java:50)
	at com.Test.TestHibMutiTabPro.main(TestHibMutiTabPro.java:10)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`myblog`.`cst_linkman`, CONSTRAINT `cst_linkman_ibfk_1` FOREIGN KEY (`lkm_cust_id`) REFERENCES `cst_customer` (`cst_id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2494)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
	... 19 more
複製程式碼

這個問題似乎是因為其他問題導致的問題了，但是需要注意的是導致這個問題的原因是還有上面那個，不過先來排除導致這個問題的主要問題，從網上查詢資料顯示的問題就是

原因：
設定的外來鍵和對應的另一個表的主鍵值不匹配。
解決方法：
找出不匹配的值修改。
或者清空兩表資料。
複製程式碼

這也的幾句話對於新手來說真不懂是怎麼回事，但是其實說的直白一點就是表與表之間值對不上啊，而兩者之間有對應關係的就是那個外來鍵了，在customer中id的主鍵屬性是assign的，將其修改為native

再次報錯

aaaaa----
18/03/05 15:48:57 WARN spi.SqlExceptionHelper: SQL Error: 1054, SQLState: 42S22
18/03/05 15:48:57 ERROR spi.SqlExceptionHelper: Unknown column 'CST_ID' in 'field list'
18/03/05 15:48:57 INFO internal.AbstractBatchImpl: HHH000010: On release of batch it still contained JDBC statements
18/03/05 15:48:57 ERROR internal.SessionImpl: HHH000346: Error during managed flush [could not execute statement]
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute statement
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
	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)
複製程式碼

有了上面6.2的解決方式其實就能明白是cst_customer對映表中column有問題原:

<set name="linkmans" table="CST_LINKMAN" inverse="false" lazy="true">
            <key>
                <column name="CST_ID" />
            </key>
            <one-to-many class="com.classes.cst_linkman" />
        </set>
複製程式碼

這裡所對應的是cst_id去了，但實際上所對應的應該是外來鍵lkm_cust_id，修改後成如下

<set name="linkmans" table="CST_LINKMAN" inverse="false" lazy="true">
            <key>
                <column name="lkm_cust_id" />
            </key>
            <one-to-many class="com.classes.cst_linkman" />
        </set>
複製程式碼

再次執行沒有報錯誤了，但是要知道這裡所除錯的是一個使用者表customer中只新增了一個linkman記錄的，要是一對多的話還需要將linkman2註釋開啟，再次開啟註釋執行是沒有問題的，通過查詢資料庫表資料沒有問題,因此出現6.1所示問題時需要檢查其他配置是不是有問題，特別是主鍵生成策略 WiHongNoteBook

6.Hibernate多對多關係建立
2018-12-29
JPA(3) 表關聯關係(多對一、一對多、多對多、一對一)
2018-11-15
gorm 關係一對一,一對多,多對多查詢
2019-12-30
GoORM
MyBatis加強（1）~myBatis物件關係對映（多對一關係、一對多關係）、延遲/懶載入
2022-02-06
MyBatis物件
Spring Data JPA 之一對一，一對多，多對多關係對映
2018-06-10
Spring
Laravel 中的多對多關係詳解
2019-05-09
Laravel
Spring Boot 入門系列（二十八） JPA 的實體對映關係，一對一，一對多，多對多關係對映！
2021-09-15
Spring Boot
JPA中對映關係詳細說明(一對多，多對一，一對一、多對多）、@JoinColumn、mappedBy說明
2018-06-22
APP
Ocelot錯誤解決
2024-06-23
hibernate中多對多關係的維護
2018-10-17
mORMot2 定義多對多關係
2024-04-25
ORM
Laravel 之多對多的關係模型
2019-05-11
Laravel模型
建立python虛擬環境virtualenv錯誤怎麼解決？
2021-09-11
Python
記錄一次班級與學生修改為多對多關係的過程
2022-01-03
解決 Python UnicodeEncodeError 錯誤
2020-05-06
PythonUnicodeError
一個 ExpressionChangedAfterItHasBeenCheckedError 錯誤的解決過程
2022-03-05
ExpressError
在EFCore中多對多關係的設計資料插入與查詢
2024-08-17
MyBatis表關聯一對多多對一多對多
2018-09-11
MyBatis
解決java“錯誤：編碼GBK的不可對映字元”
2018-03-24
Java字元
tensorflow與python版本對應關係
2024-05-20
Python
dbfread報錯ValueError錯誤解決方法
2019-01-17
Error
使用Aihubmix API 服務中遇到錯誤與解決
2024-03-28
AIAPI
資料庫表中一對多關係怎麼設計？
2018-12-06
資料庫
一對一直播技術中延遲與卡頓的矛盾關係如何解決？
2018-10-26
關於ESLint: Delete `␍`(prettier/prettier) 錯誤解決方案（3種）
2024-04-24
EsLintdelete
雲伺服器composer相關錯誤問題解決
2021-05-09
伺服器
Trinity Protocol與Etheremon建立戰略合作關係
2018-05-06
ProtocolREM
資料庫多對多表關係資料
2020-12-24
資料庫
PbootCMS 404 錯誤解決方法
2024-10-25
boot
Linux下錯誤解決方案
2024-07-17
Linux
latex 錯誤以及解決方案
2020-11-24
幽默：如何建立一個良好的關係？
2022-03-05
HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法
2020-10-18
HTTPServerError
ORM建立表關係
2022-02-28
ORM
在 CSDN 上面看到的一篇關於 Laravel 關聯表模型和多對多關係的文章
2018-10-15
Laravel模型
在Java中，以下有關類的關聯關係描述錯誤的是（）
2020-12-14
Java
海外常見的http錯誤程式碼原因與解決
2022-09-07
HTTP
spring data jpa關聯查詢（一對一、一對多、多對多）
2018-08-17
Spring