Please help to Resolve following scenario.

I have to insert 500 record in database using CMP beans and hibernate.

Some exception happens when their is insertion for 201 record & 203 record.

My Goal is that the system should not rollback the whole transaction but rather should save all the records except 201th and 203rd record.

Well, if each write should be a single unit of work, then each write needs to be placed within a single open and closed transaction. That way, only the failed records will fail.

Sometimes ETL tools are better at large batch updates than programs written with Hibernate. 500 records isn't that huge though. If it got to 5,000, or 50,000, I might change my tune though.

Let us know how it works!