I am using Hibernate 3.5.0-Final with PostGres SQL 8.4.2, JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.4 JDBC3

I am doing something similar to below mentioned code for batching and have set the configurations as

hibernate.order_inserts=true
hibernate.order_updates=true
hibernate.jdbc.batch_size=5
hibernate.jdbc.batch_versioned_data=true

public void doBatch() {

for ( int i=0; i<100000; i++ ) {
Customer customer = new Customer(.....);
session.save(customer);
if ( i % 5 == 0 )
session.flush();
}

The customer entity is associated with another entity say 'Cart'.
So, a single save(customer) generate 2 insert statements.

insert into Customer values (...)
insert into Cart values(...)

Even though the ordering of inserts is enabled, for some reason hibernate is not ordering the inserts and batching them.

the log shows something like:

Executing batch size: 1
2010-06-30 10:35:48,378 [qtp53489605-13] [DEBUG]: insert into Customer(?, ?, ?)
2010-06-30 10:35:48,378 [qtp53489605-13] [DEBUG]: insert into Cart(?, ?)
.
.
Executing batch size: 1
2010-06-30 10:35:48,378 [qtp53489605-13] [DEBUG]: insert into Customer(?, ?, ?)
2010-06-30 10:35:48,378 [qtp53489605-13] [DEBUG]: insert into Cart(?, ?)
.
.
Any help would be greatly appreciated

Thanks,
Vivake

I found the answer,

Hibernate does not batch Joined-SubClass entities. This is the comment from the hibernate source code AbstractEntityPersister.java

// we can't batch joined inserts, *especially* not if it is an identity insert;
// nor can we batch statements where the expectation is based on an output param

Also see the link viewtopic.php?f=1&t=996815