Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
2.1.7

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Oracle

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

If I want to do batch writes to the database all I have to do is set the property in the config file...

<property name="hibernate.jdbc.batch_size">25</property>

I have a few questions about how the batch stuff works.

Does Hibernate store the items you are going to insert/update in the session until it reaches it's batch limit, then write everything?

If the limit is never reached, I assume it does the batch when commit() is called, is that correct?

If I am using the "identity" id generation method and I insert a row with batch enabled, do I have the ability to get the PK from the recently inserted object, even if the batch has not gone off?

Finally, is there a limit to the batch_size or a number that you would suggest not going above?

Thanks

Hibernate executes DML at "flush-time", the meaning of which is clearly defined in the documentation....


....except for inserts with an identity column. In which case batching is dsiabled.

The sensible batch-size depends upon your JDBC driver and environment.