Hibernate Batch with <join>

[Vignesh Murali Natarajan]

Hi,
I'm facing a problem with getting Hibernate to do batch inserts. I have an Entity (called 'Extract') that has a component class which is mapped to a secondary table using <join> element. It also has a <one-to-many> relationship with a different entity. When I try to do a batch insert of Extract objects, Hibernate does not seem to be batching them. So if there were 10000 Extract records to be inserted, Hibernate generates 10000 inserts and runs batch sizes of 1. I have set my batch_size to 50, enabled order_inserts & order_updates. However if I remove the <join> element from the mapping, Hibernate does the batching correctly. Please correct me if my understanding is incorrect

Here are excerpts from my src

hibernate cfg xml

   
....
....
...
	    
        <property name="hibernate.max_fetch_depth">1</property>
        <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
        
        <!-- batch size for batch updates, inserts and deletes -->
        <property name="hibernate.jdbc.batch_size">50</property>
        <property name="hibernate.jdbc.fetch_size">50</property>
		<property name="hibernate.default_batch_fetch_size">50</property>

        <!-- this next line allows us to use "true" and "false" in bit comparisons in HQL
        	 e.g., "where active = true" -->
		<property name="hibernate.query.substitutions">true 1, false 0</property>
		
		<!-- Activate the query cache for cacheable queries, set this to false to disable all
			 cacheable queries -->
		<property name="hibernate.cache.use_second_level_cache">false</property>
		<property name="hibernate.order_updates">true</property>
		<property name="hibernate.order_inserts">true</property>
		<property name="hibernate.jdbc.batch_versioned_data">true</property>
		

....
...
....

 

The Extract hbm

    

	<class name="Extract" table="T_EXTRACT">

		<id name="extractId" type="java.lang.Integer"
			column="EXTRACT_ID">
			<generator class="hilo">
				<param name="table">hi_value</param>
				<param name="column">next_value</param>
				<param name="max_lo">10</param>
			</generator>
		</id>
...
...
....
		<property name="extractYear"
			type="com.mmm.rvts.persist.util.TrimmedStringType">
			<column name="YEAR" sql-type="char(4)" />
		</property>
		<property name="period"
			type="com.mmm.rvts.persist.util.TrimmedStringType">
			<column name="PERIOD" sql-type="char(3)" />
		</property>
		<many-to-one name="area" class="Area" not-null="true" cascade="all"
			column="AREA_ID" />
		<join table="T_EXTRACTSRCDETAIL" optional="true">
			<key column="EXTRACT_ID" on-delete="cascade" />
			<component name="extractSource" class="ExtractSource">
				<property name="tradingPartnerLocationId" type="string"
					column="SRC_TP_LOC_ID" length="8" />
				<property name="countryCode">
					<column name="SRC_CTRY_CODE" sql-type="CHAR(2)">
					</column>
				</property>
			</component>
		</join>
</class>

The entity classes are just POJOs.

Please help!