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

Hibernate version: 3.0.5

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:


We are having wierd problems with bulk processing of several million records in our application. We are using Hibernate/SQL Server 2000/Websphere 6.0...the issue is the selects are taking forever and the JDBC Prepared Statement cache is not working. We use HQL for all the Select's, the inserts and updates are lightening fast though. From a SQL Server perspective the profiler shows the Selects to be ligtening fast but my RAD console shows a substantial pause between the Select's. Has anybody come across this issue? MaxStatements is turned on for the data source and I have tried a few different things with no success.

Anybody ? This is a huge problem

Are you selecting as you are inserting your bulk data? If so then your session is probably growing to a massive size and before the select is executing that auto flush is being triggered and the session has to see if anything is dirty which has a big negative impact on your selects.

However, this is all guessing as you ignore every section in the posting reqs ;)

You can try to upgrade, stateless session must perform better in this case or create stored procedure if processing on client side is too slow.