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

Hibernate version:3.0

Full stack trace of any exception that occurs:

From , Method getPatDetails() HibernateException , could not execute query using iterate

Name and version of the database you are using:

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
Microsoft SQL Server 2000 - 8.00.760



Hi ,

To display info in the browser when a link is clicked i have four queries to be exceuted and finally the o/p of the last qry is displayed.My 1st & 3rd Qrrys are for MsSql server ..2nd & 4th query Oracle DB ..

Testing went fine ..
But when i deployed in prod last week , after few hrs iam having above hibernate exception which is occuring randomly..sometimes when we click refresh its gone , but sometimes i have to restart the application in the server (We are using Tibco ...)

When i restart it works fine for a couple of hrs and again same problem..

Mostly the exception is from Oracle Qry..

Going thru the forums , i changed my c3p0 properties to


#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1



###########################
### C3P0 Connection Pool###
###########################

hibernate.c3p0.min_size 5
hibernate.c3p0.max_size 100
hibernate.c3p0.timeout 300
hibernate.c3p0.max_statements 0
hibernate.c3p0.idle_test_period 600



But iam having this problem for evry few hrs..Can any one pls help..
Do i need to update the c3p0 jar file ? or what else may be the problem..

Any suggestions will be highly appreciated..

Thnx