Wednesday, March 23, 2011

Hibernate JDBC batching

Just made the Hibernate JDBC batching work properly.

Here are essential parts:

1. Make sure "hibernate.temp.use_jdbc_metadata_defaults" setting is not used.
2. Make sure JDBC driver supports JDBC caching.
3. Set "hibernate.jdbc.batch_size" to something reasonable like 50.

Nothing else should be needed.