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

Hibernate version: 2.1

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.0 Solaris 8.0

The generated SQL (show_sql=true): None

Debug level Hibernate log excerpt:

Hi, all,
I used Hibernate 2.1 with c3p0-0.8.5-pre9 in my application, most time the application runs smoothly. Sometimes the DB access encounter "Block" phenom because any DB query operation cannot to be done, and no exception thrown. I dump the thread map with "kill -3 <pid>", it presents :

"RMI TCP Connection(6617)-172.19.19.80" daemon prio=5 tid=0xfadb68 nid=0xcc85 waiting for monitor entry [0x2a77f000..0x2a781a00]
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:196)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:210)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:64)
at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:33)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3302)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3282)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
at net.sf.hibernate.loader.Loader.list(Loader.java:946)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:846)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at com.utstarcom.nms.mediaswitch.svrconfig.DBContactor.queryFind(DBContactor.java:155)
at com.utstarcom.nms.mediaswitch.svrconfig.DBContactor.findItem_Server_Ne(DBContactor.java:442)
at com.utstarcom.nms.mediaswitch.svrconfig.InnerContactor.getMdIp_MsId(InnerContactor.java:1181)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.COTopoDataGenerator.getIPByNEMOName(COTopoDataGenerator.java:849)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.COTopoDataGenerator.getMLRTopoData(COTopoDataGenerator.java:818)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.COTopoDataGenerator.getMLRTopoDatFileData(COTopoDataGenerator.java:575)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.netalker.MLRConfDatTalker.getCurrentData(MLRConfDatTalker.java:50)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.netalker.ConfDatNETalker.generateConfDatFile(ConfDatNETalker.java:49)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.COTopoTalker.generateMLRDatFile(COTopoTalker.java:65)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.COTopoTalker.generateCOTopoFile(COTopoTalker.java:41)
at com.utstarcom.nms.mediaswitch.svrconfig.relationman.CORelationConfigHandler.configCOTopoData(CORelationConfigHandler.java:251)
at com.utstarcom.nms.mediaswitch.svrconfig.ServerConfigAPIImpl.configCOTopoData(ServerConfigAPIImpl.java:1026)
at java.lang.reflect.Method.invoke(Native Method)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
at sun.rmi.transport.Transport$1.run(Transport.java:152)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:706)
at java.lang.Thread.run(Thread.java:484)

There exist several other similar section as the above.

So, anyone could tell me what happens and how to handle this case?

Thanks in advance!