Hello.

I'm performing a lot of insert and as the reference documentation explain for this case I have set the jdbc.batch_size to X and I flush and clear the session each X insert.

The problem is, when I flush the session how could I get the batch result?

(the array of int that you get when you use the executeBatch method of a JDBC Statement)

I would need this array in order to know if one of the insert was wrong.

Thanks in advanced.

Ok, I've been reading about executeBatch method in JDBC.

It seems there are two possibilities depending of the jdbc driver

1 - JDBC driver throws a BatchUpdateException when a command was wrong.

2 - JDBC driver performs the whole batch and returns the int array.

I'm using the Oracle thin client for JDBC and I think this driver throws a BatchUpdateException when one command can't be executed so in this case I would get and JDBCException from hibernate and using the getSQLException I suppose I would get the BatchUpdateException.

Is this correct?

Thanks in advanced.

Hi

I do have the same problem. Any help!!!!