Has any one used batch to create, read, update and delete large collection of entities. In my application I have to load more than 10000 records at one time. Also in other place, I have insert about 5000 records.
I am thinking to use batch. Does hibernate batch works fine with Oracle 9i?
What is the optimal size for batch update for the property:
Code:
hibernate.jdbc.batch_size
This what I found:
Code:
//set the JDBC batch size (it is fine somewhere between 20-50)
hibernate.jdbc.batch_size 30
//disable second-lavel cache
hibernate.cache.use_second_level_cache false
Second Level Cache is enabled for other entities. So I cann't make it false. So I have to Cache.IGNORE during batch execution.
Please share your experiences using hibernate batch.
Thanks