Hi
I want to know the difference between Hibernate JDBC fetch Size property and JDBC batch Size property.
When to use each one and when not use?
Also

I set the batch size once while the program ran and then removed it.
It now retains the old value that I set
Please help

Sreeks

fetch_size is a JDBC configuration property applied to com.sql.Statement. From the Statement java doc:


Batch size is a hibernate configuration property not a JDBC property. It can be applied to entities or collections. When configured, hibernate will fetch multiple uninitialised proxies in a single statement. This can be used to improve performance.

e.g.
I have a Company object that contains a set of Employees. Employee contains a Person object and a Role object. Lets say I load a company and navigate to its employees. Hibernate creates a proxy for each of the Person objects in the loaded employees. If I have 10 employees and iterate over them to print their names, 10 select statements will be issued to initialise the 10 Person proxies that were created. If I set a batch-size="10" on Person, hibernate will initialise all 10 proxies in one go with a single select statement.

Thank you very much