Hi All,

I have one application using Hibernate and Spring.When i am deploying in Tomcat and trying to access my application its giving me the result.But the problem is if i ll access the application repeatedly 4th time its not giing me any response.Neither nay error nor any response.


When i i have added one debug point and try to get the problem what i saw: its going to the DAO implementation class and in that i have one method there i have written one HQL to get the result.There only its stuck when i am accessing forth time.

Its not giving me any error.See the code below.

List list = getHibernateTemplate().find(
"from com.ifs.app.model.adaptors.CodeDescConfigAdaptor where entityCode="
+ "'" + entityCode + "'"); if (list.size() > 0)
codeDescConfigAdaptor = (CodeDescConfigAdaptor) list.get(0);
return codeDescConfigAdaptor;


Application is hanging in that point where i have marked as bold.



Can anybody help me on this issue.

Thnx in advance.



Regards
Debapriya

First guess: you are not closing your Session including the underlying jdbc connection and run out of connections.

If this doesn't apply: debugg into the hibernate code to see where it gets stuck.

Actually i am using JNDI connection to connect the database.And that is in spring configuration file.
so where i should close the session.

http://www.hibernate.org/hib_docs/core/ ... on-release

You can configure when the jdbc connection is released
- after each statment
- on commit
- on (hibernate)session close.

So at the very least you should have a session.close() somewhere, and it should actually get executed of course.