Dear Hibernate experts,

I am on a project near its deadline and I am having an unusual problem with hibernate. Let me describe it as simply as possible. We have two manners of loading our database (Oracle 9i)

1) An automated process which pulls data off of XML, fills it into objects, and then saves those objects with a Session interface. Using this method, our webservice can then operate without any problem.

2) A large file full of insert statements loads up the database. (This is a customer requirement.) Then, our web service can view everything okay, but has nothing but trouble updating data. We get numerous constraint errors, and at strange times. The same operation will throw a constraint error, and then work correctly on a second attempt.

(Oh, and we aren't doing simple deletions, but are rather marking rows as deleted, and then creating new ones.)

Has anybody heard of problems regarding filling databases with insert statements vs. Hibernate?

I am away from the office, or I would provide you with the standard information (SQL statements, etc.)

Thank you for any help.

Do you activate second level cache in hibernate. To do that, you must always use hibernate to modify the database. If you activate second level cache and do insert statement out of hibernate, then hibernate cache may not be synchronized with your database

Are the insert statements going directly into the database? If so, your problem might be solved by letting the hibernate application read the insert file and perform the insert query. It sounds like the sequence generator is getting it from both ends, and I'll let your imagination draw out THAT picture.