Hi I am new to Hibernate and have secenario where I have to read a flat file parse it and insert into database. Now the flat file is pretty big that is may contain arround million records. It's taking too long to insert all the records if going through the traditional way so wondering if using hibernate how can I make it faster. But I am not that much familiar with hibernate so wondering if soomeone can help me out here I have used hibernate for simple stuff so far. Can someone provide a small sample or tutorial on this on reading a file and inserting the records into database. Any help is appreciated.

Thanks



Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

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:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

What do you mean by "too long in the traditional way"? Please post the code you used to do the inserts and its performance figures.

Hibernate is not the best tools to do this with. Not saying it cannot be done just not the best. Databases in most cases supply very good fast native loaders. Why don't you use the tools that are supplied with the database? Alternatively, for a more permanent loading situation I would have a look at dbUnit.

In a word ...dont do it .... i d use the "traditional" PS to do that kind of stuff unless you are very fond of OutofMem Kind of exceptions ..