Hibernate OneToMany中批量插入的问题

0 0

Hibernate OneToMany中批量插入的问题5

先描述下问题：在做Hibernate的OneToMany关联时，Hibernate不会进行批量插入，而是根据Set中的记录数做了N次插入。能否有办法做到批量插入？希望各位大侠给分析下，谢谢! 用到的代码如下：

一端的Bean如下：

@Entity
@Table(name = "a_temp_one")
public class OneSide {
	@Column(name="id")
	@Id
	@GeneratedValue(generator="hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	private String id = null;
	
	@Column(name="name")
	private String name = null;

	@OneToMany(cascade={},fetch = FetchType.LAZY)
	@JoinTable(name = "a_temp_onetomany", joinColumns = { @JoinColumn(name = "ONEID") },
                                          inverseJoinColumns = { @JoinColumn(name = "MANYID") })
	private Set<ManySide> manySet = null;

    /**
	 * Getter 和 Setter 方法省略
	 */

}

多端的Bean如下：

@Entity
@Table(name = "a_temp_many")
public class ManySide {

	@Column(name="id")
	@Id
	@GeneratedValue(generator="hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	private String id = null;
	
	@Column(name="name")
	private String name = null;
	/**
	 * Getter 和 Setter 方法省略
	 */
}

TestCase中的代码如下：

public class Test extends TestCase{

	protected Session session;
	protected Transaction tx;

	protected void setUp() throws Exception {
		Configuration cfg = new AnnotationConfiguration().configure();
		session = cfg.buildSessionFactory().openSession();
		tx = session.beginTransaction();
	}

	protected void tearDown() throws Exception {
		tx.commit();
		session.close();
	}

	public void test() {
		OneSide one = (OneSide) session.load(OneSide.class,"4028b2923782ae44013782ae47480000");
		String hql = "From ManySide";
		// 查询所有的Many端对象
		List<ManySide> list = session.createQuery(hql).list();
		// 设置多端到一端并更新
		one.setManySet(new HashSet<ManySide>(list));
		session.update(one);
	}
}

执行后Hibernate生成的代码如下：

Hibernate: select manyside0_.id as id1_, manyside0_.name as name1_ from a_temp_many manyside0_
Hibernate: select oneside0_.id as id0_0_, oneside0_.name as name0_0_ from a_temp_one oneside0_ where oneside0_.id=?
Hibernate: delete from a_temp_onetomany where ONEID=?
Hibernate: insert into a_temp_onetomany (ONEID, MANYID) values (?, ?)
Hibernate: insert into a_temp_onetomany (ONEID, MANYID) values (?, ?)
Hibernate: insert into a_temp_onetomany (ONEID, MANYID) values (?, ?)
Hibernate: insert into a_temp_onetomany (ONEID, MANYID) values (?, ?)

可以看出Hibernate是给关联表做了多次插入去维护一方和多方的关系，这样的话，当数据量上来的时候，一定会影响效率。所以请问有没有办法能把上面的几个Sql做一个批量插入去维护关联表？