Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:2.1.6

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:oracle 9

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Hi,

I have two modules in my application.
The first one is a webservice. (Axis 1.1, spring 1.1.3 and Hibernate 2.1.6 ) This web service is responsible for
accessing the database.

The second one is web application which is consuming this web service. It does not do anything other than presentation.

The problem I am facing now is, when I request Hibernate for records in one table, it is executing so many queries.
It is fetching records from the tables which have foreign-key relation with that table. So when the web application is
using this web service, it is taking lot of time to load the page. ( 20 minutes just to display 5-6 records!!!!). I think this is because Axis is trying to (De)serialize all the objects...

I tried keeping lazy="true" for all the associations. but by the time, the web appliction is accessing those associations, the session is getting closed causing "session closed exception" . I know that this is a very common requirement and i am missing some basic thing...plz help as performance of my application is really very poor and unacceptable.

Thanks,
SSSS.