Hi,

We have a web app making use of the Hibernate 2.1 for the persistence storage. Its a higly OLTP system. Also there is one piece of advice i would like to ask from all, is that there is one important part of our system that gets the data in excel file(uploaded through the web app) and might have records that can range from # 50 to 1000. Curently we are not using Hibernate for loading that thing, its been acted upon seperately with some utilities and loaded into some temp tables and then acted upon by stored procedure to load them into the main transaction tables. I was thinking would it be good enough if we convert that excel file into an xml file before the client loads that data through our web app and make use of that xml file and let it go through Hibernate (making use of XMLDataBinder) and load in the DB temp tables.

It would be great if somebody throw some piece of advice on this?

Thanks

I would not use Hibernate for this. What you are doing currently sounds fine.

Thanks Gavin!