Hi,
I'm exploring to use Hibernate in our Java batch programs. The quesiton i have is did someone have used this? If YES, was it worth doing it. Did the performance improved or went bad. If anyone can give me answers and other useful info to use Hibernate with java batch progams it will be very useful.

Thanks,
Senthil.

Hi,

Take a look at the StatelessSession. This is a special Hibernate Session which has a lot less overhead at the cost of much reduced functionality. But this is usually functionality which you don't need or can program yourself in a batch operation.

Actually there is a whole chapter in the reference manual:

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#batch

I have been programming batch with Hibernate myself and at that time I dind't know about the stateless session. I had to fall back on JDBC with a session.connection() in order to get the performance I wanted.

Some other tips concering batch operations:
1) Evict objects you don't need from your Session or else you will run into memory problems.
2) Commit in batches. Don't save up you're entier batch up till the end but don't commit after every insert either.[/url]

Hi,
Sorry...i guess i didn't ask my question correctly. What i meant was, I would like to use the Hibernate in the Java Programs which will be invoked using the Unix Shell Scripts. We have Java programs which at the end of the day / week / month does table back-up, report creation, etc., So for these types of work can i use Hibernate.

Senthil.